Thursday, 8 August 2013

select multiple table in asp.net

Introduction:

I will explain  select multiple table in asp.net.

Example:

selectSQL = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES";
cmd = new SqlCommand(selectSQL, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
     comboBox1.Items.Add(reader.GetString(0).ToString());
}
reader.Close();


No comments:

Post a Comment