主题:c#+sql查询
各位帮我看看,为什么运行后,DataGridView1 不显示数据啊?
private void Form1_Load(object sender, EventArgs e)
{
string sqlstr;
try
{
//Initialize SqlConnection string.
SqlConnection conn = new SqlConnection("server=.;uid=sa;password=sa;database=vis");
sqlstr = "select * from company";
conn.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(sqlstr, conn);
DataSet dataset = new DataSet();
dataGridView1.DataSource = dataset;
myDataAdapter.Fill(dataset);
//MessageBox.Show("Dispaly data seccuss.", "提示");
}
catch {
MessageBox.Show("Dispaly data error.","提示");
}
}
private void Form1_Load(object sender, EventArgs e)
{
string sqlstr;
try
{
//Initialize SqlConnection string.
SqlConnection conn = new SqlConnection("server=.;uid=sa;password=sa;database=vis");
sqlstr = "select * from company";
conn.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(sqlstr, conn);
DataSet dataset = new DataSet();
dataGridView1.DataSource = dataset;
myDataAdapter.Fill(dataset);
//MessageBox.Show("Dispaly data seccuss.", "提示");
}
catch {
MessageBox.Show("Dispaly data error.","提示");
}
}