private void displayDataInListBox()
{
try
{
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbDataAdapter da = new OleDbDataAdapter();
connection.Open();
OleDbDataReader Dr;
OleDbCommand command1 = new OleDbCommand("SELECT departmentName FROM Department", connection);
command1.ExecuteNonQuery();
Dr = command1.ExecuteReader();
listBox1.Items.Clear();
while (Dr.Read())
{
listBox1.Items.Add(Dr.GetString(0).ToString());
}
Dr.Close();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
}
No comments:
Post a Comment