从修改后的数据表更新SQL数据库

问题描述：

我有一个应用程序，我使用以下函数填充了几个DataGridviews。从修改后的数据表更新SQL数据库

dgvMyStats.DataSource = GetDataTable("Select * from MyMonthlySalesStats") 

Protected Friend Function GetDataTable(ByVal sqlCommand As String) As DataTable 

    Dim connectionString As String = ConfigurationManager.ConnectionStrings("iView.My.MySettings.iViewConnectionString").ConnectionString 
    Dim iViewConnection As SqlConnection = New SqlConnection(connectionString) 
    Dim command As New SqlCommand(sqlCommand, iViewConnection) 
    Dim adapter As SqlDataAdapter = New SqlDataAdapter() 
    Dim table As New DataTable 

    adapter.SelectCommand = command 

    table.Locale = System.Globalization.CultureInfo.InvariantCulture 
    adapter.Fill(table) 

    ' Close Connection 
    iViewConnection.Close() 

    Return table 

End Function

这工作就像一个魅力。但是，现在我需要从我的一个datagridviews中更新我的数据库。我已经改变了datagridview的属性以允许创建新的行。但现在我需要知道如何将这个更新的datagridview数据返回到我的SQL数据库。任何帮助非常appricated。在此先感谢...

你可以在Google上单独输入这篇文章的标题，并找到一些有关如何做到这一点的有据可查的指南。也许你应该提供你尝试过的代码，但有问题？ – Malk 2012-02-24 02:40:23

答

我想通了。我不得不建立另一个功能

Protected Friend Function SQLDirect(ByVal sqlCommand As String) 

    Dim connectionString As String = ConfigurationManager.ConnectionStrings("iView.My.MySettings.iViewConnectionString").ConnectionString 
    Dim iViewConnection As SqlConnection = New SqlConnection(connectionString) 
    Dim command As New SqlCommand(sqlCommand, iViewConnection) 
    Dim returnValue As String 

    ' Open Connection 
    iViewConnection.Open() 

    ' Execute SQL Command 
    returnValue = Convert.ToInt32(command.ExecuteScalar()) 

    ' Close Connection 
    iViewConnection.Close() 

    ' Return Value back to calling procedure 
    Return returnValue 

End Function

我用这个函数来提交我的UPDATES和INSERTS。我希望这可以帮助别人。谢谢...

从修改后的数据表更新SQL数据库

相关推荐