开发平台:vs2005 数据库sql server 2000先贴出代码aspx:
<%@ Page Language="C#" MasterPageFile="~/MasterPage/AllMasterPage.master" AutoEventWireup="true" CodeFile="Type.aspx.cs" Inherits="manager_Type" Title="Untitled Page" %><%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPageMain" Runat="Server">
<h4>
大类管理
</h4>
<hr />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<DIV><asp:Label id="MsgLabel" runat="server"></asp:Label> <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ValidationGroup="ForAddAndMod" ErrorMessage="* 名称不能空!" Display="Dynamic" ControlToValidate="TypeNameTxb"></asp:RequiredFieldValidator> <asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" ValidationGroup="ForAddAndMod" ErrorMessage="* 排序不能为空,数字越小越靠前!" Display="Dynamic" ControlToValidate="OrderNumTxb"></asp:RequiredFieldValidator> <asp:RegularExpressionValidator id="RegularExpressionValidator1" runat="server" ValidationGroup="ForAddAndMod" ErrorMessage="排序应为数字!" Display="Dynamic" ControlToValidate="OrderNumTxb" ValidationExpression="(\d){1,2}"></asp:RegularExpressionValidator> </DIV><TABLE style="WIDTH: 64%"><THEAD><TR><TD style="WIDTH: 50%">名称 </TD><TD>排序 </TD><TD style="WIDTH: 30%">操作 </TD></TR></THEAD><TBODY><TR><TD class="centers"><asp:HiddenField id="TypeIdHdf" runat="server"></asp:HiddenField> <asp:TextBox style="WIDTH: 200px; TEXT-ALIGN: center" id="TypeNameTxb" runat="server" Wrap="False" MaxLength="15"></asp:TextBox> </TD><TD class="centers"><asp:TextBox style="WIDTH: 60px; TEXT-ALIGN: center" id="OrderNumTxb" runat="server" Wrap="False" MaxLength="2" Text="0"></asp:TextBox> </TD><TD class="centers"><asp:Button id="AddBtn" onclick="AddBtn_Click" runat="server" ValidationGroup="ForAddAndMod" Text=" 添加 "></asp:Button> <asp:Button id="ModBtn" onclick="ModBtn_Click" runat="server" ValidationGroup="ForAddAndMod" Text=" 修改 " Visible="false"></asp:Button> <INPUT id="Reset1" type=button value=" 重置 " runat="server" OnServerClick="Reset1_ServerClick" /> </TD></TR><asp:Repeater id="TypeRepeaterList" runat="server" OnItemDataBound="TypeRepeaterList_ItemDataBound">
<ItemTemplate>
<tr>
<td class="centers">
<%# DataBinder.Eval(Container.DataItem, "TypeName")%>
</td>
<td class="centers">
<%# DataBinder.Eval(Container.DataItem, "OrderNum")%>
</td>
<td class="centers">
<asp:Button ID="ModBtn1" runat="server" CommandArgument=' <%# DataBinder.Eval(Container.DataItem, "TypeId")%>' OnClick="ModBtn1_Click" Text=" 修改 " />
<asp:Button ID="DelBtn" runat="server" CommandArgument=' <%# DataBinder.Eval(Container.DataItem, "TypeId")%>' OnClick="DelBtn_Click" Text=" 删除 " />
</td>
</tr>
</ItemTemplate>
</asp:Repeater></TBODY></TABLE>
</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>
CS:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class manager_Type : BasePage
{
SqlConnection conn; string dns = ConfigurationManager.AppSettings["connStr"]; protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "大类管理"; if (!IsPostBack)
{
RepeaterListBind();
}
} //数据绑定
private void RepeaterListBind()
{
conn = new SqlConnection(dns);
string sql = "select * from Type";
conn.Open();
SqlDataAdapter dp = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
dp.Fill(ds,"大类列表");
TypeRepeaterList.DataSource = new DataView(ds.Tables[0]);
TypeRepeaterList.DataBind();
} //绑定按钮
protected void TypeRepeaterList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
Button modBtnTmp = (Button)e.Item.Controls[0].FindControl("ModBtn1");
Button delBtnTmp = (Button)e.Item.Controls[0].FindControl("DelBtn");
delBtnTmp.Attributes.Add("onclick", "return confirm('确定进行删除操作吗?');");
} //初始化控件
protected void InitControls()
{
TypeIdHdf.Value = "";
TypeNameTxb.Text = ""; ModBtn.Visible = false;
AddBtn.Visible = true;
} //添加分类
protected void AddBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
conn = new SqlConnection(dns);
string sql = "insert into Type (TypeName,OrderNum) values( '" + TypeNameTxb.Text.ToString() + "', '" + OrderNumTxb.Text.ToString() + "') ";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close(); MsgLabel.Text = "添加成功!";
MsgLabel.CssClass = "";
RepeaterListBind();
InitControls(); ;
}
} //修改分类
protected void ModBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
conn = new SqlConnection(dns);
string sql = "update Type set TypeName='" + TypeNameTxb.Text + "' , OrderNum='" + OrderNumTxb.Text + "' where TypeId=" + Convert.ToInt32(TypeIdHdf.Value) + "";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close(); MsgLabel.Text = "修改成功!";
MsgLabel.CssClass = "";
RepeaterListBind();
InitControls();
}
} //选择修改
protected void ModBtn1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Button modBtnTmp = (Button)sender;
string typeId = modBtnTmp.CommandArgument; conn = new SqlConnection(dns);
string sql = "select * from Type where TypeId = '" + typeId + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
TypeIdHdf.Value = read["TypeId"].ToString();
TypeNameTxb.Text = read["TypeName"].ToString();
OrderNumTxb.Text = read["OrderNum"].ToString();
}
read.Close();
conn.Close(); RepeaterListBind(); ModBtn.Visible = true;
AddBtn.Visible = false;
}
} //删除
protected void DelBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Button delBtnTmp = (Button)sender;
string typeId = delBtnTmp.CommandArgument; conn = new SqlConnection(dns);
string sql = "delete from Type where TypeId='" + typeId + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close(); MsgLabel.Text = "删除成功!";
MsgLabel.CssClass = "";
RepeaterListBind();
InitControls();
}
}
protected void Reset1_ServerClick(object sender, EventArgs e)
{
TypeNameTxb.Text = "";
OrderNumTxb.Text = "";
ModBtn.Visible = false;
AddBtn.Visible = true;
}
}以前也没出现过这样的问题啊,请高人协助解决下,谢谢!
<%@ Page Language="C#" MasterPageFile="~/MasterPage/AllMasterPage.master" AutoEventWireup="true" CodeFile="Type.aspx.cs" Inherits="manager_Type" Title="Untitled Page" %><%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPageMain" Runat="Server">
<h4>
大类管理
</h4>
<hr />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<DIV><asp:Label id="MsgLabel" runat="server"></asp:Label> <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ValidationGroup="ForAddAndMod" ErrorMessage="* 名称不能空!" Display="Dynamic" ControlToValidate="TypeNameTxb"></asp:RequiredFieldValidator> <asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" ValidationGroup="ForAddAndMod" ErrorMessage="* 排序不能为空,数字越小越靠前!" Display="Dynamic" ControlToValidate="OrderNumTxb"></asp:RequiredFieldValidator> <asp:RegularExpressionValidator id="RegularExpressionValidator1" runat="server" ValidationGroup="ForAddAndMod" ErrorMessage="排序应为数字!" Display="Dynamic" ControlToValidate="OrderNumTxb" ValidationExpression="(\d){1,2}"></asp:RegularExpressionValidator> </DIV><TABLE style="WIDTH: 64%"><THEAD><TR><TD style="WIDTH: 50%">名称 </TD><TD>排序 </TD><TD style="WIDTH: 30%">操作 </TD></TR></THEAD><TBODY><TR><TD class="centers"><asp:HiddenField id="TypeIdHdf" runat="server"></asp:HiddenField> <asp:TextBox style="WIDTH: 200px; TEXT-ALIGN: center" id="TypeNameTxb" runat="server" Wrap="False" MaxLength="15"></asp:TextBox> </TD><TD class="centers"><asp:TextBox style="WIDTH: 60px; TEXT-ALIGN: center" id="OrderNumTxb" runat="server" Wrap="False" MaxLength="2" Text="0"></asp:TextBox> </TD><TD class="centers"><asp:Button id="AddBtn" onclick="AddBtn_Click" runat="server" ValidationGroup="ForAddAndMod" Text=" 添加 "></asp:Button> <asp:Button id="ModBtn" onclick="ModBtn_Click" runat="server" ValidationGroup="ForAddAndMod" Text=" 修改 " Visible="false"></asp:Button> <INPUT id="Reset1" type=button value=" 重置 " runat="server" OnServerClick="Reset1_ServerClick" /> </TD></TR><asp:Repeater id="TypeRepeaterList" runat="server" OnItemDataBound="TypeRepeaterList_ItemDataBound">
<ItemTemplate>
<tr>
<td class="centers">
<%# DataBinder.Eval(Container.DataItem, "TypeName")%>
</td>
<td class="centers">
<%# DataBinder.Eval(Container.DataItem, "OrderNum")%>
</td>
<td class="centers">
<asp:Button ID="ModBtn1" runat="server" CommandArgument=' <%# DataBinder.Eval(Container.DataItem, "TypeId")%>' OnClick="ModBtn1_Click" Text=" 修改 " />
<asp:Button ID="DelBtn" runat="server" CommandArgument=' <%# DataBinder.Eval(Container.DataItem, "TypeId")%>' OnClick="DelBtn_Click" Text=" 删除 " />
</td>
</tr>
</ItemTemplate>
</asp:Repeater></TBODY></TABLE>
</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>
CS:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class manager_Type : BasePage
{
SqlConnection conn; string dns = ConfigurationManager.AppSettings["connStr"]; protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "大类管理"; if (!IsPostBack)
{
RepeaterListBind();
}
} //数据绑定
private void RepeaterListBind()
{
conn = new SqlConnection(dns);
string sql = "select * from Type";
conn.Open();
SqlDataAdapter dp = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
dp.Fill(ds,"大类列表");
TypeRepeaterList.DataSource = new DataView(ds.Tables[0]);
TypeRepeaterList.DataBind();
} //绑定按钮
protected void TypeRepeaterList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
Button modBtnTmp = (Button)e.Item.Controls[0].FindControl("ModBtn1");
Button delBtnTmp = (Button)e.Item.Controls[0].FindControl("DelBtn");
delBtnTmp.Attributes.Add("onclick", "return confirm('确定进行删除操作吗?');");
} //初始化控件
protected void InitControls()
{
TypeIdHdf.Value = "";
TypeNameTxb.Text = ""; ModBtn.Visible = false;
AddBtn.Visible = true;
} //添加分类
protected void AddBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
conn = new SqlConnection(dns);
string sql = "insert into Type (TypeName,OrderNum) values( '" + TypeNameTxb.Text.ToString() + "', '" + OrderNumTxb.Text.ToString() + "') ";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close(); MsgLabel.Text = "添加成功!";
MsgLabel.CssClass = "";
RepeaterListBind();
InitControls(); ;
}
} //修改分类
protected void ModBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
conn = new SqlConnection(dns);
string sql = "update Type set TypeName='" + TypeNameTxb.Text + "' , OrderNum='" + OrderNumTxb.Text + "' where TypeId=" + Convert.ToInt32(TypeIdHdf.Value) + "";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close(); MsgLabel.Text = "修改成功!";
MsgLabel.CssClass = "";
RepeaterListBind();
InitControls();
}
} //选择修改
protected void ModBtn1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Button modBtnTmp = (Button)sender;
string typeId = modBtnTmp.CommandArgument; conn = new SqlConnection(dns);
string sql = "select * from Type where TypeId = '" + typeId + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
TypeIdHdf.Value = read["TypeId"].ToString();
TypeNameTxb.Text = read["TypeName"].ToString();
OrderNumTxb.Text = read["OrderNum"].ToString();
}
read.Close();
conn.Close(); RepeaterListBind(); ModBtn.Visible = true;
AddBtn.Visible = false;
}
} //删除
protected void DelBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Button delBtnTmp = (Button)sender;
string typeId = delBtnTmp.CommandArgument; conn = new SqlConnection(dns);
string sql = "delete from Type where TypeId='" + typeId + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close(); MsgLabel.Text = "删除成功!";
MsgLabel.CssClass = "";
RepeaterListBind();
InitControls();
}
}
protected void Reset1_ServerClick(object sender, EventArgs e)
{
TypeNameTxb.Text = "";
OrderNumTxb.Text = "";
ModBtn.Visible = false;
AddBtn.Visible = true;
}
}以前也没出现过这样的问题啊,请高人协助解决下,谢谢!
解决方案 »
- C#下UrlReWrite 有什么好方案啊?
- asp网页向access数据库插入 日期类型问题(高手进)
- 在线等待,“已有打开的与此命令相关联的 DataReader,必须首先将它关闭。”
- 集成Windows验证,在什么情况下为输入用户名密码页面就能显示?
- 需要一个跨服务器单点登陆的原理以及例子
- 自动识别URL的表达式怎么写的呢?
- c# winform中的numericUpDown 在asp.net中有和它功能一样的控件吗?asp.net怎么调用c# WINFORM做的控件?
- 运行时为什么有的控件能显示,有的却不能?在线等
- 急--如何判断某请求的类别是在"IE的地址栏输入"的还是"通过页面link(a href="")或 Response.Redirect发出的??
- 我想动态产生报表,是不是要用Push模式,怎样使用
- DropDownList值得不到...?
- 404問題
语言集的编码
是不是Unicode