110,532
社区成员
发帖
与我相关
我的任务
分享
SqlConnection GridViewconn = new SqlConnection(class_sql.sqlconstring);
GridViewconn.Open();
string GridViewstr = "select * from worker_info ";
SqlCommand GridViewcmd = new SqlCommand(GridViewstr, GridViewconn);
SqlDataAdapter datapda = new SqlDataAdapter(GridViewcmd);
DataSet Ds = new DataSet();
Ds.Clear();
datapda.Fill(Ds, "worker_info");
dataGridView1.DataSource = Ds;
dataGridView1.DataMember = "worker_info";
dataGridView1.Columns[0].HeaderText = "ID";
dataGridView1.Columns[1].HeaderText = "姓名";
dataGridView1.Columns[2].HeaderText = "电话";
dataGridView1.Columns[3].HeaderText = "地址";
dataGridView1.Columns[4].HeaderText = "备份";
dataGridView1.Columns[4].Width = 150;
dataGridView1.Columns[0].DataPropertyName = "id";
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
textBox1.Text =dataGridView1.Rows[dataGridView1.CurrentRow.Index ].Cells["id"].Value.ToString() ;
textBox2.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["name"].Value.ToString();
textBox3.Text=dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["password"].Value.ToString();
}
//用这个支持上下键
private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells["列名"].Value.ToString();
}
/*查询的话就是又从数据库里查询一遍 然后重新绑定 */