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 userInfo : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["adminId"] == "adminID")
{
Response.Redirect("login.aspx");
}
else
{
this.Label1.Text = Convert.ToString(Session["adminId"]);
}
//在此处放置用户代码以初始化页面
if (!IsPostBack)
{
SetBind();
}
} protected void SetBind()
{
try
{
SqlConnection con = DB.createrDB();
if (con.State.ToString() == "Closed") con.Open();
SqlCommand cmd = new SqlCommand("select * from student ", con);
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
if (con.State.ToString() == "Open") con.Close();
}
finally
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = DB.createrDB();
if (con.State.ToString() == "Closed") con.Open();
SqlCommand comm = new SqlCommand("insert into student (stuID,stuName,stuPwd,stuEmail) values (@stuID,@stuName,@stuPwd,@stuEmail)", con);
SqlParameter parm1 = new SqlParameter("@stuID", SqlDbType.VarChar, 15);
parm1.Value = this.ID.Text;
SqlParameter parm2 = new SqlParameter("@stuName", SqlDbType.VarChar, 10);
parm2.Value = this.Name.Text;
SqlParameter parm3 = new SqlParameter("@stuPwd", SqlDbType.VarChar, 10);
parm3.Value = this.Pwd.Text;
SqlParameter parm4 = new SqlParameter("@stuEmail", SqlDbType.NVarChar, 50);
parm4.Value = this.Email.Text;
comm.Parameters.Add(parm1);
comm.Parameters.Add(parm2);
comm.Parameters.Add(parm3);
comm.Parameters.Add(parm4); comm.ExecuteNonQuery();
if (con.State.ToString() == "Open") con.Close();
SetBind();
} protected void GridView1_OnRowCommand(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
SetBind();
}
protected void GridView1_OnCancelCommand(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex =-1;
SetBind();
}
protected void GridView1_OnUpdateCommand(object sender, GridViewUpdateEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
GridViewRow gvr = GridView1.Rows[e.RowIndex];
string strstuID = ((TextBox)gvr.FindControl("txtstuID")).Text;
string strstuName = ((TextBox)gvr.FindControl("txtstuName")).Text;
string strstuPwd = ((TextBox)gvr.FindControl("txtstuPwd")).Text;
string strstuEmail = ((TextBox)gvr.FindControl("txtstuEmail")).Text;
try
{
SqlConnection conn = DB.createrDB();
if (conn.State.ToString() == "Closed") conn.Open();
SqlCommand comm = new SqlCommand("update student set stuID='" + strstuID + "',stuName='" + strstuName + "',stuPwd='" + strstuPwd + "',stuEmail='" + strstuEmail + "' where id='" + id + "'", conn);
comm.ExecuteNonQuery();
conn.Close();
if (conn.State.ToString() == "Open") conn.Close();
this.GridView1.EditIndex = -1;
Alert("记录成功更新");
SetBind();
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
//private void GridView1_OnDeleteCommand(object sender, GridViewDeleteEventArgs e)
//{ //}
private void Alert(string strMessage)
{
Response.Write("<script>alert('" + strMessage + "');</script>");
} protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
try
{
SqlConnection conn = DB.createrDB();
if (conn.State.ToString() == "Closed") conn.Open();
SqlCommand comm = new SqlCommand("delete from student where id='" + id + "'", conn);
comm.ExecuteNonQuery();
conn.Close();
if (conn.State.ToString() == "Open") conn.Close();
this.GridView1.EditIndex = -1;
SetBind();
} catch (Exception ex)
{
Alert(ex.Message);
}
}
}源码区: <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="id" OnRowEditing="GridView1_OnRowCommand" OnRowCancelingEdit="GridView1_OnCancelCommand" OnRowUpdating="GridView1_OnUpdateCommand" OnRowDeleting="GridView1_RowDeleting" BorderStyle="Dotted" >
<Columns>
<asp:TemplateField HeaderText="序号">
<ItemTemplate>
<%# Eval("id") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="学号">
<ItemTemplate>
<%# Eval("stuID") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuID" runat="server" Text=' <%# Eval("stuID") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<%# Eval("stuName") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuName" runat="server" Text='<%# Eval("stuName") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="密码">
<ItemTemplate>
<%# Eval("stuPwd") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuPwd" runat="server" Text='<%# Eval("stuPwd") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="邮箱">
<ItemTemplate>
<%# Eval("stuEmail") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuEmail" runat="server" Text='<%# Eval("stuEmail") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="编辑">
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" CommandName="Edit" ImageUrl="images/bianji.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
</ItemTemplate>
<EditItemTemplate>
<asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="images/updata.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
<asp:ImageButton ID="ImageButton4" runat="server" CommandName="Cancel" ImageUrl="images/cancel.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<asp:ImageButton ID="ImageButton2" runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id")%>' CommandName="Delete" ImageUrl="images/shanchu.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
数据库:
id int
stuID varhcar(15) primary key,
stuName varchar(10),
stuPwd varchar(10),
stuEmail nvarchar(50)
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 userInfo : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["adminId"] == "adminID")
{
Response.Redirect("login.aspx");
}
else
{
this.Label1.Text = Convert.ToString(Session["adminId"]);
}
//在此处放置用户代码以初始化页面
if (!IsPostBack)
{
SetBind();
}
} protected void SetBind()
{
try
{
SqlConnection con = DB.createrDB();
if (con.State.ToString() == "Closed") con.Open();
SqlCommand cmd = new SqlCommand("select * from student ", con);
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
if (con.State.ToString() == "Open") con.Close();
}
finally
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = DB.createrDB();
if (con.State.ToString() == "Closed") con.Open();
SqlCommand comm = new SqlCommand("insert into student (stuID,stuName,stuPwd,stuEmail) values (@stuID,@stuName,@stuPwd,@stuEmail)", con);
SqlParameter parm1 = new SqlParameter("@stuID", SqlDbType.VarChar, 15);
parm1.Value = this.ID.Text;
SqlParameter parm2 = new SqlParameter("@stuName", SqlDbType.VarChar, 10);
parm2.Value = this.Name.Text;
SqlParameter parm3 = new SqlParameter("@stuPwd", SqlDbType.VarChar, 10);
parm3.Value = this.Pwd.Text;
SqlParameter parm4 = new SqlParameter("@stuEmail", SqlDbType.NVarChar, 50);
parm4.Value = this.Email.Text;
comm.Parameters.Add(parm1);
comm.Parameters.Add(parm2);
comm.Parameters.Add(parm3);
comm.Parameters.Add(parm4); comm.ExecuteNonQuery();
if (con.State.ToString() == "Open") con.Close();
SetBind();
} protected void GridView1_OnRowCommand(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
SetBind();
}
protected void GridView1_OnCancelCommand(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex =-1;
SetBind();
}
protected void GridView1_OnUpdateCommand(object sender, GridViewUpdateEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
GridViewRow gvr = GridView1.Rows[e.RowIndex];
string strstuID = ((TextBox)gvr.FindControl("txtstuID")).Text;
string strstuName = ((TextBox)gvr.FindControl("txtstuName")).Text;
string strstuPwd = ((TextBox)gvr.FindControl("txtstuPwd")).Text;
string strstuEmail = ((TextBox)gvr.FindControl("txtstuEmail")).Text;
try
{
SqlConnection conn = DB.createrDB();
if (conn.State.ToString() == "Closed") conn.Open();
SqlCommand comm = new SqlCommand("update student set stuID='" + strstuID + "',stuName='" + strstuName + "',stuPwd='" + strstuPwd + "',stuEmail='" + strstuEmail + "' where id='" + id + "'", conn);
comm.ExecuteNonQuery();
conn.Close();
if (conn.State.ToString() == "Open") conn.Close();
this.GridView1.EditIndex = -1;
Alert("记录成功更新");
SetBind();
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
//private void GridView1_OnDeleteCommand(object sender, GridViewDeleteEventArgs e)
//{ //}
private void Alert(string strMessage)
{
Response.Write("<script>alert('" + strMessage + "');</script>");
} protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
try
{
SqlConnection conn = DB.createrDB();
if (conn.State.ToString() == "Closed") conn.Open();
SqlCommand comm = new SqlCommand("delete from student where id='" + id + "'", conn);
comm.ExecuteNonQuery();
conn.Close();
if (conn.State.ToString() == "Open") conn.Close();
this.GridView1.EditIndex = -1;
SetBind();
} catch (Exception ex)
{
Alert(ex.Message);
}
}
}源码区: <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="id" OnRowEditing="GridView1_OnRowCommand" OnRowCancelingEdit="GridView1_OnCancelCommand" OnRowUpdating="GridView1_OnUpdateCommand" OnRowDeleting="GridView1_RowDeleting" BorderStyle="Dotted" >
<Columns>
<asp:TemplateField HeaderText="序号">
<ItemTemplate>
<%# Eval("id") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="学号">
<ItemTemplate>
<%# Eval("stuID") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuID" runat="server" Text=' <%# Eval("stuID") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<%# Eval("stuName") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuName" runat="server" Text='<%# Eval("stuName") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="密码">
<ItemTemplate>
<%# Eval("stuPwd") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuPwd" runat="server" Text='<%# Eval("stuPwd") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="邮箱">
<ItemTemplate>
<%# Eval("stuEmail") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstuEmail" runat="server" Text='<%# Eval("stuEmail") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="编辑">
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" CommandName="Edit" ImageUrl="images/bianji.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
</ItemTemplate>
<EditItemTemplate>
<asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="images/updata.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
<asp:ImageButton ID="ImageButton4" runat="server" CommandName="Cancel" ImageUrl="images/cancel.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<asp:ImageButton ID="ImageButton2" runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id")%>' CommandName="Delete" ImageUrl="images/shanchu.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
数据库:
id int
stuID varhcar(15) primary key,
stuName varchar(10),
stuPwd varchar(10),
stuEmail nvarchar(50)
解决方案 »
- 用IIS发布之后,点击连接之后说HTTP400错误的请求。谁帮忙进来解决一下!在线等。
- 大哥大姐们,小弟我跪求解决方案
- 分页控件有问。。。
- 我们开发WEB程序,如果使用Sql Server 2005 的话,什么样的版本就足够了。
- 问下如何根据条件播放一个wav声音文件?
- 还是调用存储过 程的问题
- 我用了Membership,可不知道如何注销当前用户?!
- OracleParameter传参错误
- 创建项目,但是无法启动DEBUGING!
- ashx页面如何设置ValidateRequest="false"
- 子控件事件获值删除grigview 数据行........
- 有关Request.QueryString传递问题
看下这个事件执行不