如何从vb.net 2008中的Datagridview保存，搜索，删除和更新sql server 2008数据库 [英] how to save,Search,delete and update sql server 2008 database from Datagridview in vb.net 2008

问题描述

我有一个例子..搜索，但是我不知道未绑定的datagridview的值是什么，因此我在Msgbox中输入数据库的结果，请在datagridview例子textbox1.tex t中帮助我获取行的值----- Text的值是如何解除datagridview的绑定...

I have example.. Search but i don''t know if what the value of unbound datagridview therefore i''m input in Msgbox the result of database please help me of value of row in the datagridview example textbox1.text-----Text is the value how about unbound of datagridview...

Call main()
        Con.Open()
    
        Dim command As SqlCommand
        Dim adapter As New SqlDataAdapter
        Dim ds As New DataSet
        Dim dv As DataView
        Dim sql As String

        sql = "Select  * from DOrecieve_inventory"
        ''connection = New SqlConnection(connetionString)
        Try
            ''connection.Open()
            command = New SqlCommand(sql, Con)
            adapter.SelectCommand = command
            adapter.Fill(ds, "Find Row DataView")
            adapter.Dispose()
            command.Dispose()
            Con.Close()
            Dim I As Integer

            dv = New DataView(ds.Tables(0))
            dv.Sort = "type"
            ''Dim index As Integer = dv.Find(grid1.Item(0, I).Value())
            Dim index As Integer = dv.Find("y")
            If index = -1 Then
                MsgBox("Item Not Found")

            Else
               


        

                MsgBox(dv(index)("lot").ToString() & "  " & dv(index)("reference").ToString() & "  " & dv(index)("location").ToString() & "  " & dv(index)("meas").ToString() & "  " & dv(index)("units").ToString() & "  " & dv(index)("pounds").ToString() & "  " & dv(index)("type").ToString())

            End If

        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try

推荐答案

尝试
使用DataGridView插入，更新和删除C#中的控件 [ ^ ]
DataGridView-插入，更新，删除和检索记录 [ ^ ]

Try
Insert, Update, Delete with DataGridView Control in C# [^]
DataGridView - Insert, Update, Delete and Retrieve records[^]

这篇关于如何从vb.net 2008中的Datagridview保存，搜索，删除和更新sql server 2008数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！