在C#3.0中更新DataGrid [英] updating datagrid in c#3.0

问题描述

推荐答案

Gridview提供了一些内置的更新工具.
设置属性

Gridview provide inbuilt update facility with some efforts.
set property

AutoGenerateEditButton="True"

AllowUpadete到gridview
在数据源中添加更新查询.

AllowUpadete to the gridview
add update query in datasource.

<asp:sqldatasource id="SqlDataSource1" runat="server" xmlns:asp="#unknown">
            ConnectionString="<%

ConnectionStrings:cnn％>" SelectCommand ="SELECT [用户ID]，[用户类型]，[备注]，[职责]，[名称]，[部门]，[电子邮件ID]来自[Empbirth] WHERE([userid] = @userid)" UpdateCommand ="Update empbirth SET userid = @ userid，UserType = @ UserType，remark = @ remark，responsibility = @ responsibility，Designation = @ Designation，Deptt = @ Deptt，emailid = @ emailid，其中([userid] = @userid)" > < SelectParameters > < asp:controlparameter controlid =" 名称 用户ID " 属性名称 文本" < /SelectParameters > < /asp:controlparameter > < /asp:sqldatasource >

ConnectionStrings:cnn %>" SelectCommand="SELECT [userid], [UserType], [remark], [responsibility], [Designation], [Deptt], [emailid] FROM [empbirth] WHERE ([userid] = @userid)" UpdateCommand="Update empbirth SET userid=@userid,UserType=@UserType,remark=@remark,responsibility=@responsibility,Designation=@Designation,Deptt=@Deptt,emailid=@emailid WHERE ([userid] = @userid)"> <SelectParameters> <asp:controlparameter controlid="TextBox1" name="userid" propertyname="Text"> Type="String" /> </SelectParameters> </asp:controlparameter></asp:sqldatasource>

这篇关于在C#3.0中更新DataGrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！