在winform中datagrid更新怎么用

Question

我想直接在datagrid上某一列直接改数据后点一个button按钮后库中数据直接更改如何实现，谢谢

Answer 1

SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(updateString,conn);
SqlCommandBuilder cb = new SqlCommandBuilder(da); da.DeleteCommand = cb.GetDeleteCommand();
da.InsertCommand = cb.GetInsertCommand();
da.UpdateCommand = cb.GetUpdateCommand();
//ds.AcceptChanges(); SqlTransaction trans = null;// conn.Open();
try
{ conn.Open(); trans = conn.BeginTransaction(); da.DeleteCommand.Transaction = trans; da.InsertCommand.Transaction = trans; da.UpdateCommand.Transaction = trans;
da.Update(ds.Tables[0].Select("","",DataViewRowState.Added));
da.Update(ds.Tables[0].Select("","",DataViewRowState.ModifiedCurrent));
da.Update(ds.Tables[0].Select("","",DataViewRowState.Deleted)); trans.Commit();

Answer 2

适配器sq 
dataset ds = datagrid.dataset.getchanges();
sq.update(ds)

Answer 3

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim mydb As New MyDBopt.DataBaseClass
        Dim ds1 As New Data.DataSet
        Dim ds2 As New Data.DataSet
        Dim ds3 As New Data.DataSet
        Dim ts As Data.SqlClient.SqlTransaction        mydb.GetMyDBInfo()
        Me.SqlConnection1.ConnectionString = mydb.ConnString        ds1 = Nothing
        ds2 = Nothing
        ds3 = Nothing        ds1 = Me.MyToolbar1.DS.GetChanges(DataRowState.Added)
        ds2 = Me.MyToolbar1.DS.GetChanges(DataRowState.Deleted)
        ds3 = Me.MyToolbar1.DS.GetChanges(DataRowState.Modified)
        Try
            Me.SqlConnection1.Open()
            ts = Me.SqlConnection1.BeginTransaction(IsolationLevel.Serializable)
            Me.SqlInsertCommand1.Transaction = ts
            Me.SqlDeleteCommand1.Transaction = ts
            Me.SqlUpdateCommand1.Transaction = ts
            Me.SqlSelectCommand1.Transaction = ts
            If Not (ds1 Is Nothing) Then
                'ds1.Tables("AA_User").Rows(0)("UserID") = Me.MyToolbar1.DS.Tables("AA_User").Rows.Count
                'ds1.Tables("AA_User").Rows(0)("UserLB") = 1
                ds1.Tables("AA_User").Rows(0)("sUserName") = Me.FlatTextBox1.Text.ToString()
                ds1.Tables("AA_User").Rows(0)("sPassWord") = Me.FlatTextBox2.Text.ToString()
                Me.SqlDataAdapter1.Update(ds1)
                ds1.AcceptChanges()
            End If            If Not (ds2 Is Nothing) Then
                'ds2.Tables("AA_User").Rows(0)("sUserName") = Me.FlatTextBox1.Text.ToString()
                'ds2.Tables("AA_User").Rows(0)("sPassWord") = Me.FlatTextBox2.Text.ToString()
                Me.SqlDataAdapter1.Update(ds2)
                ds2.AcceptChanges()
            End If            If Not (ds3 Is Nothing) Then
                ds3.Tables("AA_User").Rows(0)("sUserName") = Me.FlatTextBox1.Text.ToString()
                ds3.Tables("AA_User").Rows(0)("sPassWord") = Me.FlatTextBox2.Text.ToString()
                Me.SqlDataAdapter1.Update(ds3)
                ds3.AcceptChanges()
            End If
            ts.Commit()
        Catch ex As Exception
            ts.Rollback()
            MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error)
        Finally
            ts.Dispose()
            Me.SqlConnection1.Close()
            mydb = Nothing
        End Try
    End Sub不仅有更新，还有删除等！

Answer 4

http://www.syncfusion.com/FAQ/WindowsForms/Default.aspx#44

Answer 5

使用例子，
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx

Answer 6

关于ing
有完整点的c#代码吗？帮你顶一下先！！！！！同时自己也学习一下这方面的知识