این کد برای نمایش اطلاعاد در ListView هست.
public void fill_lst()
{
try
{
MyDbConnection.Open();
MyDbCommand = MyDbConnection.CreateCommand();
MyDbCommand.CommandText = "SELECT f1,f2,f3,f4,f5 FROM T1 WHERE f1 = 1";
OleDbDataReader oleReader = MyDbCommand.ExecuteReader();
list_T1.Items.Clear();
/// fill the list box
ListViewItem lvItem;
object[] objArray = new object[ 5 ];
int nColumn = 0;
while( oleReader.Read() == true )
{
nColumn = 0;
oleReader.GetValues( objArray );
lvItem = list_T1.Items.Add( objArray.GetValue( nColumn++ ).ToString() );
for( ; nColumn < 5; nColumn++ )
{
lvItem.SubItems.Add( oleReader.GetValue( nColumn ).ToString() );
}
}
MyDbConnection.Close();
}
catch( OleDbException exp )
{
string strError = exp.Message;
MessageBox.Show( this, strError, "Exception thrown" );
MyDbConnection.Close();
}
}