62,067
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="TDetailID" onrowdeleting="GridView1_RowDeleting"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"
onrowcancelingedit="GridView1_RowCancelingEdit">
<Columns>
<asp:BoundField DataField="TDetailID" HeaderText="ID" />
<asp:BoundField DataField="TFileName" HeaderText="TFileName" />
<asp:BoundField DataField="TFileNo" HeaderText="TFileNo" />
<asp:BoundField DataField="TRemark" HeaderText="TRemark" />
<asp:TemplateField>
<EditItemTemplate>
<asp:TextBox ID="txt_FileName" Text='<%# Bind("TFileName") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbl_FileName" runat="server" Text='<%# Bind("TFileName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<EditItemTemplate>
<asp:TextBox ID="txt_FileNo" Text='<%# Bind("TFileNo") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbl_FileNo" runat="server" Text='<%# Bind("TFileNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<EditItemTemplate>
<asp:TextBox ID="txt_FileDetail" Text='<%# Bind("TRemark") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbl_FileDetail" runat="server" Text='<%# Bind("TRemark") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="编辑" ShowEditButton="True" ShowHeader="True" />
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Delete">删除</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//GridViewRow myRow = GridView1.Rows[e.RowIndex];
//string id = myRow.Cells[0].Text;
//TextBox name = myRow.Cells[1].FindControl("txt_FileName") as TextBox;
//TextBox no = myRow.Cells[2].FindControl("txt_FileNo") as TextBox;
//TextBox detail = myRow.Cells[3].FindControl("txt_FileDetail") as TextBox;
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
//string name = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].FindControl("txt_FileName")).Text;
//string no = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].FindControl("txt_FileNo")).Text;
//string detail = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].FindControl("txt_FileDetail")).Text;
string name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
string no = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string detail = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();//((TextBox)(GridView.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()
string updateSQL = "update TechnicsDetail set TFileName='" + name + "',TFileNo='" + no + "' where TDetailID=" + id;
int num = DbHelperSQL.ExecuteSql(updateSQL);
GridView1.EditIndex = -1;
NewDataBind1();
}