请问高手们：我要把GRID中修改的数据保存到SQLSERVER服务器上去，应该怎么做呀？

Question

好象只是保存在窗体界面中了，怎么也没保存到服务器啊..........

Answer 1

参考
http://singlepine.cnblogs.com/articles/266538.htmlprotected void Update(object sender,DataGridCommandEventArgs e)
{
            if(e.Item.ItemType==ListItemType.EditItem)
            {
                SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
                SqlCommand comm=new SqlCommand("update testgrid set UserName=@UserName where UserID=@UserID",conn);
                SqlParameter parm1=new SqlParameter("@UserName",SqlDbType.NVarChar,50);
                parm1.Value=((TextBox)e.Item.FindControl("UserName")).Text;
                                                
                SqlParameter parm6=new SqlParameter("@UserID",SqlDbType.Int);
                parm6.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];                comm.Parameters.Add(parm1);
               comm.Parameters.Add(parm6);
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
                this.DataGrid1.EditItemIndex=-1;
                DataBind();
            }
}

Answer 2

是winform吗，参考
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx