private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{ using (SqlConnection con = new SqlConnection(@"Data Source =.\SQLEXPRESS;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\DB_DataBase.mdf;Integrated Security=True; User Instance=true;"))
{
string table=comboBox1.Text;
string sql = string.Format("SELECT * FROM {0}",table);
con.Open();
SqlDataAdapter ada = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
ada.Fill(ds,"table");
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
}
总是出现,对象名 'System.Data.DataRowView' 无效。
怎么改代码,按照COMBOBOX的选定项查找数据表并显示在GRIDVIEW控件里
{ using (SqlConnection con = new SqlConnection(@"Data Source =.\SQLEXPRESS;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\DB_DataBase.mdf;Integrated Security=True; User Instance=true;"))
{
string table=comboBox1.Text;
string sql = string.Format("SELECT * FROM {0}",table);
con.Open();
SqlDataAdapter ada = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
ada.Fill(ds,"table");
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
}
总是出现,对象名 'System.Data.DataRowView' 无效。
怎么改代码,按照COMBOBOX的选定项查找数据表并显示在GRIDVIEW控件里