试图从datagridview获取数据到组合框 [英] Trying to get data from datagridview into combobox
本文介绍了试图从datagridview获取数据到组合框的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图从通过访问我的组合框连接的表中获取数据。我先键入id,然后点击get,那个id中的5个值必须出现在5个组合框下面。但我的代码似乎不起作用。任何人都可以帮助我显示我做错了哪个部分及其解决方案?非常感谢你的帮助:D
公共 Sub Get_Data()
con.Open()
Dim dt < span class =code-keyword>作为 新 DataTable( table1)
Dim rs As 新 OleDb.OleDbDataAdapter( select * from table1 where id =' & TextBox1.Text& ',con)
rs.Fill(dt)
DataGridView1.DataSource = dt
DataGridView1.Refresh()
rs.Dispose()
con.Close()
如果 Val(Label7.T ext)= 1 然后
Dim i 作为 整数
i = DataGridView1.CurrentRow.Index
ComboBox1.Text = DataGridView1.Item( 1 ,i).Value.ToString()
ComboBox2.Text = DataGridView1.Item( 2 ,i).Value.ToString()
ComboBox3.Text = DataGridView1.Item( 3 ,i)。 Value.ToString()
ComboBox4.Text = DataGridView1.Item( 4 ,i).Value.ToString()
ComboBox5.Text = DataGridView1 .Item( 5 ,i).Value.ToString()
End 如果
结束 Sub < /跨度>
私人 Sub Button3_Click(发件人作为 对象 ,e As EventArgs)句柄 Button4.Click
Get_Data()
结束 Sub
解决方案
使用Combobox.Items.add将它分配给.Text。
ComboBox1.Items.clear
ComboBox1.Items.add(DataGridView1.Item( 1 ,i).Value.ToString)
ComboBox1.Items.add(DataGridView1.Item( 2 ,i).Value.ToString)
ComboBox1.Items.add(DataGridView1.Item( 3 ,i)。Value.ToString)
ComboBox1.Items.add(DataGridView1.Item( 4) ,i).Value.ToString)
ComboBox1.Items.add(DataGridView1.Item( 5 ,i).Value.ToString)
hey there.
im trying to get data from a table connected through access into my combobox. i'll key in the id first then click get then 5 values from that id will have to appear at the 5 combobox under. but my code seem not working. can anybody help me to show which part did i made wrong and its solution? thank you very much for ur help :D
Public Sub Get_Data()
con.Open()
Dim dt As New DataTable("table1")
Dim rs As New OleDb.OleDbDataAdapter("select * from table1 where id= '" & TextBox1.Text & "' ", con)
rs.Fill(dt)
DataGridView1.DataSource = dt
DataGridView1.Refresh()
rs.Dispose()
con.Close()
If Val(Label7.Text) = 1 Then
Dim i As Integer
i = DataGridView1.CurrentRow.Index
ComboBox1.Text = DataGridView1.Item(1, i).Value.ToString()
ComboBox2.Text = DataGridView1.Item(2, i).Value.ToString()
ComboBox3.Text = DataGridView1.Item(3, i).Value.ToString()
ComboBox4.Text = DataGridView1.Item(4, i).Value.ToString()
ComboBox5.Text = DataGridView1.Item(5, i).Value.ToString()
End If
End Sub
Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button4.Click
Get_Data()
End Sub
解决方案
Use Combobox.Items.add intead of assigning it to .Text.
ComboBox1.Items.clear ComboBox1.Items.add( DataGridView1.Item(1, i).Value.ToString) ComboBox1.Items.add( DataGridView1.Item(2, i).Value.ToString) ComboBox1.Items.add( DataGridView1.Item(3, i).Value.ToString) ComboBox1.Items.add( DataGridView1.Item(4, i).Value.ToString) ComboBox1.Items.add( DataGridView1.Item(5, i).Value.ToString)
这篇关于试图从datagridview获取数据到组合框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文