a = DataGridView1.CurrentRow.Cells(0).Value.ToString(); b = DataGridView1.CurrentRow.Cells(1).Value.ToString();
c = DataGridView1.CurrentRow.Cells(4).Value.ToString(); d = DataGridView1.CurrentRow.Cells(5).Value.ToString(); f = DataGridView1.CurrentRow.Cells(6).Value.ToString();
Private Sub BindGrid() Dim strWhre As String = " select top 1000 * from I_CustomOrder order by WRRDTE desc" Dim conn As New SqlConnection(ConfigurationManager.AppSettings("cnn")) Dim adt As New SqlDataAdapter(strWhre, conn) Dim dataset As New DataSet adt.Fill(dataset, "jobs") BindingSource1.DataSource = dataset.Tables(0) DataGridView1.DataSource = BindingSource1 BindingNavigator1.BindingSource = BindingSource1
是这样吗?
private void DataGridView1_SelectionChanged(object sender, System.Windows.Forms.DataGridViewCellEventArgs e)
{
//獲取當前行數據
a = DataGridView1.CurrentRow.Cells(0).Value.ToString();
b = DataGridView1.CurrentRow.Cells(1).Value.ToString();
c = DataGridView1.CurrentRow.Cells(4).Value.ToString();
d = DataGridView1.CurrentRow.Cells(5).Value.ToString();
f = DataGridView1.CurrentRow.Cells(6).Value.ToString();
}
大家帮我改改,这段代码提示什么为空未处理
private void dataGridView1_CurrentCellChanged(object sender, EventArgs e)
{
TextBox1.Text = DataGridView1.CurrentRow.Cells(5).Value;
}
根本就触发不了CurrentCellChanged事件
private void dataGridView1_CurrentCellChanged(object sender, EventArgs e)
{
if (this.DataGridView1.RowCount > 0) {
TextBox1.Text = DataGridView1.CurrentRow.Cells(0).Value;
}
}
private void dataGridView1_CellValueChanged(object sender, EventArgs e)
{
TextBox1.Text = DataGridView1.rows[e.rowindex].Cells(5).Value;
}
没有选择行 ,即CurrentRow=null
改为:privatevoiddataGridView1_CurrentCellChanged(objectsender, EventArgs e)
{
if(DataGridView1.CurrentRow!=null) TextBox1.Text=DataGridView1.CurrentRow.Cells(5).Value;
}
Dim strWhre As String = " select top 1000 * from I_CustomOrder order by WRRDTE desc"
Dim conn As New SqlConnection(ConfigurationManager.AppSettings("cnn"))
Dim adt As New SqlDataAdapter(strWhre, conn)
Dim dataset As New DataSet
adt.Fill(dataset, "jobs") BindingSource1.DataSource = dataset.Tables(0) DataGridView1.DataSource = BindingSource1
BindingNavigator1.BindingSource = BindingSource1
Me.TextBox1.DataBindings.Add(New Binding("Text", BindingSource1, "wrfac", True))
Me.TextBox2.DataBindings.Add(New Binding("Text", BindingSource1, "wrloc", True))
Me.TextBox3.DataBindings.Add(New Binding("Text", BindingSource1, "wrprod", True))
Me.TextBox4.DataBindings.Add(New Binding("Text", BindingSource1, "wrtool", True))
Me.TextBox5.DataBindings.Add(New Binding("Text", BindingSource1, "wrrdte", True))
Me.TextBox6.DataBindings.Add(New Binding("Text", BindingSource1, "wrqty", True))
Label1.Text = "共" + dataset.Tables(0).DefaultView.Count.ToString() + "條記錄"
'TextBox1.DataBindings.Add(New System.Windows.Forms.Binding("Text", dataset, "jobs.wrtool", True)) End Sub
dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value.ToString();
取得相应行列的值