UC知道C#连接数据库的问题 加20分!!
来源：百度知道 编辑：UC知道 时间：2024/06/24 05:15:56
我想把服务器上的数据显示在 dataGridView1上
下面的代码有身问题
请指教!!
private void button1_Click(object sender, EventArgs e)
{
string connstr ="Data Source=192.168.0.28;Initial Catalog=pubs;User ID=sa";
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand("select * from jiangjun");
SqlDataAdapter sda = new SqlDataAdapter(cmd,conn);
conn.Open();
DataSet ds = new DataSet();
dataGridView1.DataSource=sda.Fill(ds);
conn.Close();
}
下面的代码有身问题
请指教!!
private void button1_Click(object sender, EventArgs e)
{
string connstr ="Data Source=192.168.0.28;Initial Catalog=pubs;User ID=sa";
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand("select * from jiangjun");
SqlDataAdapter sda = new SqlDataAdapter(cmd,conn);
conn.Open();
DataSet ds = new DataSet();
dataGridView1.DataSource=sda.Fill(ds);
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string connstr ="Data Source=192.168.0.28;Initial Catalog=pubs;User ID=sa";
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand("select * from jiangjun");
SqlDataAdapter sda = new SqlDataAdapter(cmd,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
sda.Fill(ds,"jiangjun");
dataGridView1.DataSource=ds;
//winform程序不需要下面这行
//dataGridView1.DataBind();
}
string connstr ="Data Source=192.168.0.28;Initial Catalog=pubs;uid=sa;pwd=;"
SqlConnection conn = new SqlConnection(connstr);
后面就要
conn.Open();
dataGridView1.DataSource=sda.Fill(ds);
后面加
dataGridView1.DataBind();
最后
conn.close();