数据从datagridview保存在数据库中 [英] data save in database from datagridview

问题描述

从datagridview数据保存在数据库中

data save in database from datagridview

推荐答案

尝试这些链接如何到刀片式数据使用，datagridview的功能于vbnet -windows-form

vb- net-insert-datagridview-contents-into-database

如何将数据从DatagridView保存到Vb.NEt中的Sql Server

如何节省从DatagridView到Vb.NEt中的Sql Server 2008的数据

以及更多这里

：）

Try these Links how-to-insert-data-using-datagridview-in-vbnet-windows-form
vb-net-insert-datagridview-contents-into-database
How To Save Data From DatagridView To Sql Server In Vb.NEt
How To Save Data From DatagridView To Sql Server 2008 In Vb.NEt
And More Here
:)

试试这个家伙：

try this dude:

''Declare this to your class
 Public Const CONNECTION_STRING As String = "Data Source=YOUR_HOSTNAME;Initial Catalog=DATABASE_NAME; Integrated Security=True"
    Dim dbConnection As SqlConnection = New SqlConnection(CONNECTION_STRING)
Dim ds As DataSet = New DataSet
Dim da As SqlDataAdapter
''//Declare this to your class

 Private Sub updateDGV() 
        Dim SQLText As String = "SELECT Field1,Field2,Field3,Field4,Field5 FROM TEST"
 
        Try
            If dbConnection.State = ConnectionState.Open Then dbConnection.Close()
            dbConnection.Open()
            da= New SqlDataAdapter(SQLText, dbConnection)
            da.Fill(ds, "TEST")
            dbConnection.Close()
 
        Dim cb As SqlCommandBuilder = New SqlCommandBuilder(da)
        da.Update(ds, "TEST")
     
       Catch ex As Exception
            MessageBox.Show(ex.ToString)
       End Try
  
  End Sub

将updateDGV方法调用到Save按钮并确保datagrid数据源是ds声明的。希望这对你有帮助。

Call the updateDGV method to your Save button and make sure your datagrid datasource is the ds declared . Hope this will help you.

这篇关于数据从datagridview保存在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！