GridView编辑、删除
来源:互联网 发布:网页广告过滤软件 编辑:程序博客网 时间:2024/05/21 04:01
前台:
<asp:GridView ID="GridView1" runat="server" DataKeyNames="ID"
OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_CancelingEdit"
OnRowDeleting="GridView1_RowDeleting" PageSize="15" AllowPaging="true" OnPageIndexChanging="GridView1_PageIndexChanging"
ShowHeader="true">
<Columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label runat="server" Text="ID"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label runat="server" Text=‘<%#Bind("ID") %>‘ ID="Label0"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label runat="server" Text="姓名"></asp:Label></HeaderTemplate>
<ItemTemplate>
<asp:Label runat="server" Text=‘<%#Bind("UserName") %>‘ ID="Label2"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox Text=‘<%#Bind("UserName") %>‘ runat="server" ID="UserName"></asp:TextBox><asp:RequiredFieldValidator
runat="server" ErrorMessage="不能为空" ControlToValidate="UserName" Display="Dynamic">*</asp:RequiredFieldValidator>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label runat="server" Text="金额"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label runat="server" Text=‘<%#Bind("Money") %>‘ ID="Label33"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox Text=‘<%#Bind("Money")%>‘ runat="server" ID="Money"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="不能为空"
ControlToValidate="Money" Display="Dynamic">*</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="整数或浮点数"
ValidationExpression="^/d*$|[1-9]/d*/./d*|0/./d*[1-9]/d*$" ControlToValidate="Money"
Display="Dynamic">*</asp:RegularExpressionValidator>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" HeaderText="操作" />
</Columns>
<HeaderStyle BackColor="blue" ForeColor="white" />
</asp:GridView>
后台代码:
string myConnectionString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
SqlConnection myConnection = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
myConnection.ConnectionString = myConnectionString;
if (!IsPostBack)
{
T();
}
}
public void T()
{
myConnection.Open();
string sql = "Select * From Test";
SqlDataAdapter da = new SqlDataAdapter(sql, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "Test");
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "ID" };
GridView1.DataBind();
myConnection.Close();
}
public void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
myConnection.Open();
GridViewRow row = GridView1.Rows[e.RowIndex];
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
string userName = ((TextBox)row.FindControl("UserName")).Text.ToString();
double Money = Convert.ToDouble(((TextBox)row.FindControl("Money")).Text.ToString());
SqlDataReader dr;
string sql = "Update Test Set UserName=‘" + userName + "‘,Money=" + Money + " Where ID=" + ID + "";
SqlCommand myCommand = new SqlCommand(sql, myConnection);
dr = myCommand.ExecuteReader();
GridView1.EditIndex = -1;
myConnection.Close();
T();
}
public void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
myConnection.Open();
GridViewRow row = GridView1.Rows[e.RowIndex];
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
SqlDataReader dr;
string sql = "Delete From Test Where ID=" + ID + "";
SqlCommand myCommand = new SqlCommand(sql, myConnection);
dr = myCommand.ExecuteReader();
GridView1.EditIndex = -1;
myConnection.Close();
T();
}
public void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
T();
}
public void GridView1_CancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
T();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
T();
}
转自 http://blog.sina.com.cn/s/blog_58de85690100cncf.html
- GridView删除,编辑应用
- GridView自定义编辑、删除
- GridView自定义编辑、删除
- GridView 的编辑删除
- GridView更新,编辑,删除
- gridview 编辑删除:
- GridView编辑、删除
- GridView编辑删除操作
- GridView编辑、删除
- Gridview删除选中,编辑
- Gridview编辑,修改,删除
- GridView的编辑、新增、删除
- GridView中的编辑、删除、排序
- GridView选中,编辑,取消,删除:
- GridView编辑删除方式1
- GridView编辑删除方式2
- GridView的编辑删除代码
- 自定义GRIDVIEW 之编辑删除
- ASM管理DG过程
- ASP.NET连接非默认MSSQL数据库实例
- Linux进程间通信之管道通信
- Dll的显式和隐式调用
- 磁盘阵列使用心得
- GridView编辑、删除
- 关于LCD黑屏问题解决方案
- Array
- 关于Git学习和其图形化合并工具
- 从技术走向管理3
- 泪奔的试题
- 09 specical Team( Win or Out小组)
- 关于主机多路径软件
- C++之路该怎么走?