修改网格上数据并保存！

1、先从数据库查出数据集在网格上显示.
2、然后修改网格上数据，然后再把修改后网格数据保存到数据库
高手们希望提供有参考价值的源码！谢谢！

解决方案 »

  1.   

    http://blog.csdn.net/21aspnet/archive/2007/03/20/1534374.aspx
      

  2.   

    WinForm参考 Asp.Net搜索论坛下载中心去
      

  3.   

    <%@Page  Language="C#" %>
    <%@Import Namespace="System.Web.Mail" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><SCRIPT runat="server">
     private void OnDSUpdatedHandler(Object source, SqlDataSourceStatusEventArgs e) {
        if (e.AffectedRows > 0) {
            // Perform any additional processing, 
            // such as setting a status label after the operation.
            Label1.Text = Request.LogonUserIdentity.Name +
                " changed user information successfully!";    
        }
        else {
            Label1.Text = "No data updated!";
        }
     }
    </SCRIPT><HTML>
      <BODY>
        <FORM runat="server">      <asp:SqlDataSource
              id="SqlDataSource1"
              runat="server"
              DataSourceMode="DataSet"
              ConnectionString="<%$ ConnectionStrings:MyNorthwind%>"
              SelectCommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees"
              UpdateCommand="Update Employees SET FirstName=@FirstName,LastName=@LastName,Title=@Title WHERE EmployeeID=@EmployeeID"
              OnUpdated="OnDSUpdatedHandler">
          </asp:SqlDataSource>      <asp:GridView
              id="GridView1"
              runat="server"
              AutoGenerateColumns="False"
              DataKeyNames="EmployeeID"
              AutoGenerateEditButton="True"    /////////////////////自动生成编辑键
              DataSourceID="SqlDataSource1">
              <columns>
                  <asp:BoundField HeaderText="First Name" DataField="FirstName" />
                  <asp:BoundField HeaderText="Last Name" DataField="LastName" />
                  <asp:BoundField HeaderText="Title" DataField="Title" />
              </columns>
          </asp:GridView>      <asp:Label
              id="Label1"
              runat="server">
          </asp:Label>    </FORM>
      </BODY>
    </HTML>
      

  4.   

      string table = "Free";
      string tabletemp = "tempFree";
    string ls_sql = "sql语句;
    SqlDataAdapter da = new SqlDataAdapter(ls_sql,conn);
    SqlConnection conn = new SqlConnection(constring);
     private void Form1_Load(object sender, EventArgs e)
            {DataSet ds = new DataSet();
    da.Fill(ds,tabletemp);
    dgvFree.DataSource = ds;
    dgvFree.DataMember = tabletemp;        }  private void btnSave_Click(object sender, EventArgs e)
    {
                       DataRow[] drs = ds.Tables[tabletemp];
                        if (drs.Length > 0)
                        {
                            foreach (DataRow dr in drs)
                            {
                               //指定要更新的表
                                DataRow drn = ds.Tables[table].NewRow();
                                ds.Tables[table].Rows.Add(drn);
                                drn["HID"] = id;
                                drn["machineNUM"] = dr["machineNUM"];
                                drn["goodscode"] = dr["goodscode"];
                                drn["custcode"] = dr["custcode"];
                                drn["freedate"] = dr["freedate"];
                                drn["startdate"] = dr["startdate"];
                                drn["enddate"] = dr["enddate"];
                            }
                        }
                         da.Fill(ds,table); ;      }
      

  5.   

    是ASP.NET的界面问题吗？如果是：ASP.NET界面网格显示控件上有这么连个事件：updated和updataing这连个前一个是在修改后执行的，后一个是在修改时执行的。可以根据这连个事件在里面写代码：得到网格上数据插入数据库。