Private Sub DataGridView1_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick Dim i As Int16 For i = 0 To DataGridView1.ColumnCount - 1 textbox1.text &= DataGridView1.Item(i, e.RowIndex) Next End Sub
Dim i As Int16
For i = 0 To DataGridView1.ColumnCount - 1
textbox1.text &= DataGridView1.Item(i, e.RowIndex)
Next
End Sub
bs.DataSoruce = dt;
textBox1.DataBindings.Add("Text", bs, "职员编号");
dataGridView1.DataSource = bs;
{
SqlConnection con = new SqlConnection("server=.;database=student;uid=sa;pwd=0421");
SqlDataAdapter sda = new SqlDataAdapter("select * from studentDetails", con);
sda.Fill(ds, "student");
//数据绑定
this.dataGridView1.DataSource = ds.Tables["student"];
this.textBox1.DataBindings.Add("Text", ds.Tables["student"], "sno");
this.textBox2.DataBindings.Add("Text", ds.Tables["student"], "sname");
this.textBox3.DataBindings.Add("Text", ds.Tables["student"], "sage");
}
{
dataGridView1.AllowUserToAddRows = false;
da = new SqlDataAdapter("SELECT * FROM 职员基本信息表", conn);
da.Fill(dtable);
bindingSource1.DataSource = dtable;
dataGridView1.DataSource = bindingSource1;
DataBindingsFunction();
}
private void DataBindingsFunction()
{
this.textBox1.DataBindings.Add("Text", btable, "职员编号");
this.textBox2.DataBindings.Add("Text", btable, "姓名");
.......
}
this.textBox1.DataBindings.Add("Text", bindingSource1, "职员编号");
this.textBox2.DataBindings.Add("Text", bindingSource1, "姓名");
......
this.textbox1.DataBindings.Add("Text", dt.DefaultView, "职员编号");