用dtagridview直接修改的数据怎么更新到SQL数据库
用dtagridview直接点击修改的数据后，怎么更新到SQL数据库
[解决办法]
又一个被微软例子搞晕的孩子

gridview你绑定的是datatable数据吧。跟句这个datatable生成sql语句，然后用ado.net执行。
[解决办法]

 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 表 set 字段1='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',字段2='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',字段3='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where id='"
            + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom=new SqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();//重新绑定
    }

http://blog.csdn.net/21aspnet/article/details/1540301 看了这些文章你就会了

[解决办法]

引用:

你给的是c#的 我要的是vb.net c#我不会用啊

http://msdn.microsoft.com/zh-tw/library/system.web.ui.webcontrols.gridview.rowupdating.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-3
[解决办法]
update 表 set 字段='"& me.dtagridview.rows(i).cell(i).value &"'
[解决办法]
用这个。
TableName 是 你数据库里数据表的名称。
SaveTable 是 你绑定在datagridview上面的Talbe
CnStr 是你连接数据库的连接字符串。

   Public Shared Function Save(ByVal TableName As String, ByVal SaveTable As DataTable, ByVal Cnstr As String) As Boolean
        Try
            Using da As New SqlDataAdapter("select * from " & TableName & " where 1 =2 ", Cnstr)
                Dim scb As SqlCommandBuilder = New SqlCommandBuilder(da)
                da.Update(SaveTable)
                SaveTable.AcceptChanges()
                Return True
            End Using
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
            Return False
        End Try
    End Function

[解决办法]
我也是这样问,如果绑定了数据库到DGV后,我对DGV删除了,添加了,修改了后,再想把现在的数据库写回去,怎么做的?
[解决办法]

引用:

用这个。
TableName 是 你数据库里数据表的名称。
SaveTable 是 你绑定在datagridview上面的Talbe
CnStr 是你连接数据库的连接字符串。

   Public Shared Function Save(ByVal TableName As String, ByVal SaveTable As DataTable, ByVal Cnstr As String) As Boolean
        Try
            Using da As New SqlDataAdapter("select * from " & TableName & " where 1 =2 ", Cnstr)
                Dim scb As SqlCommandBuilder = New SqlCommandBuilder(da)
                da.Update(SaveTable)
                SaveTable.AcceptChanges()
                Return True
            End Using
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
            Return False 
 
        End Try
    End Function

我是用DATASET 绑定到DGV的,请问如何更新到源数据库?没有用DATATABLE对象哦
[解决办法]
datset 是 Datatable的集合。
你的打他table就是dataset.table(0)
[解决办法]
UPDATA 表要有主键就好弄 不然无法使用UPDATA
[解决办法]
Sub bluksqlcopy()
Dim yeah As String
Dim ah As String
Dim av As Object
If Tab1.SelectedTab.Name = "T1" Then
yeah = "ZL"
ah = ""
av = DG3
ElseIf Tab1.SelectedTab.Name = "T3" Then
yeah = "BBS"
ah = ""
av = DG1
ElseIf Tab1.SelectedTab.Name = "T2" Then
yeah = "ZHG"
ah = "合"
av = DG2
End If
Dim i = MsgBox("是否更新" & ah & "表 ", MsgBoxStyle.Question + MsgBoxStyle.YesNo + MsgBoxStyle.DefaultButton2, "操作是(Y)")
If i = vbYes Then
Dim connectionString As String = GetConnectionString()
Using destinationConnection As SqlConnection = New SqlConnection(connectionString)
destinationConnection.Open()
Dim strsql1 = "delete from " & yeah & ""
bmd1.CommandText = strsql1
bmd1.Connection = destinationConnection
bmd1.ExecuteNonQuery()
Using bulkCopy As SqlBulkCopy = New SqlBulkCopy(destinationConnection)
bulkCopy.DestinationTableName = "" & yeah & ""
Dim reader As New DataTable
reader = av.DataSource
Try
bulkCopy.WriteToServer(reader)
Catch ex As Exception
Console.WriteLine(ex.Message)
Finally
destinationConnection.Close()
MsgBox("更新成功", MsgBoxStyle.OkOnly, "系提示")
End Try
End Using
End Using
Else
MsgBox("操作取消")
End If
End Sub
表结构不是数据表 只是关联表的话而且数据量不是很大（而且没有主键）就用上面代码