迁徙5_Mark一个昨天.net实验的小任务_2016-6-4

虽然依然知道自己很菜，但是自己写出来程序，运行成功的感觉实在是太好了  瞬间对自己充满了期望，希望自己以后可以慢慢的摆脱菜鸟这个冠名哈哈哈哈哈哈~~~好了，废话不多说。上代码，及运行结果。

数据库DB1的users表中数据如下：

代码如下：

Main.aspx中代码如下:

 

<formid="form1"runat="server">

    <asp:LabelID="L1"runat="server"Text="分类ID:"></asp:Label>

    <asp:TextBoxID="TB1"runat="server"Width="330px"Text="输入分类ID，只用于修改和删除"></asp:TextBox>

    <br />&nbsp;

    <asp:ButtonID="B1"runat="server"Text="显示全部"onclick="B1_Click"/>&nbsp;

    <asp:ButtonID="B2"runat="server"Text="模糊查找"onclick="B2_Click"/>&nbsp;

    <asp:ButtonID="B3"runat="server"Text="插入"onclick="B3_Click"/>&nbsp;

    <asp:ButtonID="B4"runat="server" Text="修改"onclick="B4_Click"/>&nbsp;

    <asp:ButtonID="B5"runat="server"Text="删除"onclick="B5_Click"/>

    <asp:GridViewID="gv1"runat="server">

    </asp:GridView>

    </form>

 

Main.aspx.cs中代码如下:

------------------------------------删除在本页面中实现

 

using System.Data.SqlClient;

 

protectedvoid B1_Click(objectsender,EventArgs e)

    {

        SqlConnection conn =newSqlConnection();

        conn.ConnectionString ="DataSource=PC-20160404TYJJ;Initial Catalog=DB1;Integrated Security=True";

        SqlCommand cmd =newSqlCommand("select* from users",conn);

        conn.Open();

        SqlDataReader dr = cmd.ExecuteReader();

        gv1.DataSource = dr;

        gv1.DataBind();

        dr.Close();

        conn.Close();

    }

    protected voidB3_Click(object sender,EventArgs e)

    {

       Response.Redirect("insert.aspx");

    }

    protected voidB4_Click(object sender,EventArgs e)

    {

       Response.Redirect("update.aspx?id="+TB1.Text);

    }

    protected voidB5_Click(object sender,EventArgs e)

    {

       SqlConnection conn =newSqlConnection();

       conn.ConnectionString ="DataSource=PC-20160404TYJJ;Initial Catalog=DB1;Integrated Security=True";

       SqlCommand cmd =newSqlCommand("deletefrom users where id="+TB1.Text+";",conn);

       conn.Open();

       cmd.ExecuteNonQuery();

       conn.Close();

       Response.Write("<scriptlanguage='javascript'>alert('删除成功，点击显示查看');</script>");

    }

    protected voidB2_Click(object sender,EventArgs e)

    {

       Response.Redirect("search.aspx");

    }

search.aspx中代码如下:

 

<formid="form1"runat="server">

    <asp:LabelID="L1"runat="server"Text="分类名:"></asp:Label>

    <asp:TextBoxID="TB1"runat="server"></asp:TextBox>

    <asp:ButtonID="sou"runat="server"Text="搜索"onclick="sou_Click"/>

    <asp:ButtonID="back"runat="server"Text="返回"onclick="back_Click"/>

    <asp:GridViewID="gv1"runat="server">

    </asp:GridView>

</form>

 

Search.aspx.cs中代码如下：

 

protectedvoid sou_Click(objectsender,EventArgs e)

    {

       SqlConnection conn =newSqlConnection();

       conn.ConnectionString ="DataSource=PC-20160404TYJJ;Initial Catalog=DB1;Integrated Security=True";

       SqlCommand cmd =newSqlCommand("select* from users where name like '%"+TB1.Text+"%'",conn);

       conn.Open();

       SqlDataReader dr = cmd.ExecuteReader();

       gv1.DataSource = dr;

       gv1.DataBind();

       dr.Close();

        conn.Close();

 

    }

    protected voidback_Click(object sender,EventArgs e)

    {

       Response.Redirect("main.aspx");

    }

 

Insert.aspx中代码如下:

 

<formid="form1"runat="server">

    <asp:LabelID="L1"runat="server"Text="用户名："></asp:Label>

    <asp:TextBoxID="name"runat="server"></asp:TextBox>

    <br />

    <asp:LabelID="L2"runat="server"Text="密&nbsp;码："></asp:Label>

    <asp:TextBoxID="password"runat="server"></asp:TextBox>

    <br />

    <asp:ButtonID="add"runat="server"Text="插入"onclick="add_Click"/>&nbsp;

    <asp:ButtonID="back"runat="server"Text="返回"onclick="back_Click"/>

    </form>

 

Insert.aspx.cs中代码如下:

 

protectedvoid add_Click(objectsender,EventArgs e)

    {

       SqlConnection conn =newSqlConnection();

       conn.ConnectionString ="DataSource=PC-20160404TYJJ;Initial Catalog=DB1;Integrated Security=True";

       SqlCommand cmd =newSqlCommand("insertinto users (name,password) values ('"+name.Text+"','"+password.Text+"')",conn);

       conn.Open();

       cmd.ExecuteNonQuery();

       conn.Close();

       Response.Write("<scriptlanguage='javascript'>alert('添加成功，点击返回查看');</script>");

    }

    protected voidback_Click(object sender,EventArgs e)

    {

       Response.Redirect("main.aspx");

    }

 

Update.aspx中代码如下:

 

<formid="form1"runat="server">

    <asp:LabelID="l1"runat="server"Text="ID:"Width="70px"></asp:Label>

    <asp:TextBoxID="ID"runat="server"></asp:TextBox>

    <br />

    <asp:LabelID="l2"runat="server"Text="用户名："Width="70px"></asp:Label>

    <asp:TextBoxID="name"runat="server"></asp:TextBox>

    <br />

    <asp:LabelID="l3"runat="server"Text="密码："Width="70px"></asp:Label>

    <asp:TextBoxID="password"runat="server"></asp:TextBox>

    <br />

    <asp:ButtonID="gai"runat="server"Text="修改"onclick="gai_Click"/>&nbsp;

    <asp:ButtonID="back"runat="server"Text="返回"onclick="back_Click"/>

    </form>

 

Update.aspx.cs中代码如下:

 

protectedvoid Page_Load(objectsender,EventArgs e)

    {

       string id = Request.QueryString["id"];

       ID.Text = id;

    }

    protected voidgai_Click(object sender,EventArgs e)

    {

       SqlConnection conn =newSqlConnection();

        conn.ConnectionString ="Data Source=PC-20160404TYJJ;InitialCatalog=DB1;Integrated Security=True";

       SqlCommand cmd =newSqlCommand("updateusers set name='"+name.Text+"',password='"+password.Text+"' where id="+ID.Text+";",conn);

       conn.Open();

       cmd.ExecuteNonQuery();

       conn.Close();

       Response.Write("<scriptlanguage='javascript'>alert('修改成功，点击返回查看');</script>");

    }

    protected voidback_Click(object sender,EventArgs e)

    {

       Response.Redirect("main.aspx");

    }

 

 

运行结果如下：

 

Main.aspx

 

删除成功后

Search.aspx

Insert.aspx

添加成功后

Update.aspx

更新成功后