生科院

vs链接sql server

add 前

 1  <form id="form1" runat="server">
 2         <table style="width: 100%">
 3             <tr>
 4                 <td style="width:150px">姓名：</td>
 5                 <td>
 6                     <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
 7                 </td>
 8             </tr>
 9             <tr>
10                 <td>年龄：</td>
11                 <td>
12                     <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
13                 </td>
14             </tr>
15             <tr>
16                 <td class="auto-style1">兴趣：</td>
17                 <td class="auto-style1">
18                     <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
19                 </td>
20             </tr>
21             <tr>
22                 <td>性别：</td>
23                 <td>
24                     <asp:TextBox ID="TextBox5" runat="server" />
25                 </td>
26             </tr>
27             <tr>
28                 <td></td>
29                 <td>
30                     <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Add" Width="113px" />
31 
32                 </td>
33                 </tr>
34         </table>
35     </form>
View Code
后
 1 using System.Web.UI.WebControls;
 2 using System.Data.SqlClient;
 3 
 4 
 5 
 6 int id = 0;
 7     protected void Page_Load(object sender, EventArgs e)
 8     {
 9 
10         if (!string.IsNullOrEmpty(Request.QueryString["id"]))
11         {
12             id = Convert.ToInt32(Request.QueryString["id"]);
13         }
14         if (!Page.IsPostBack)
15         {
16             if (id != 0)
17             {                
18                 SqlConnection conn = new SqlConnection(@"server=127.0.0.1;database=db_hoan;uid=sa;pwd=sa");//i//根据ID取出本条数据sql = "select id  from tb_person"              
19                 string sql = "select * from tb_person where [id]=@id";//  string sql = "select * from tb_person where [id]=" + id;
20                 SqlCommand cmd = new SqlCommand(sql, conn);
21                 conn.Open();
22                 cmd.Parameters.AddWithValue("@id", id);                              
23                 SqlDataReader dr = cmd.ExecuteReader();
24                 while (dr.Read())//把数据显示在页面的控件上GridView ， DataList ，Repeater ， ListView
25                 {
26                     TextBox1.Text = dr["per_name"].ToString();
27                     TextBox2.Text = dr["per_age"].ToString();
28                     TextBox3.Text = dr["per_hobby"].ToString();
29                     TextBox5.Text = dr["per_sex"].ToString();
30                 }
31                 dr.Close();
32                 conn.Close();
33             }
34         }
35 }
36 
37     protected void Button2_Click(object sender, EventArgs e)
38     {
39         SqlConnection conn = new SqlConnection(@"server=127.0.0.1;database=db_hoan;uid=sa;pwd=sa");
40         
41         if(id==0)
42         {
43             string sql = "insert into tb_person (per_name,per_age,per_hobby,per_sex) values ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox5.Text + "')";
44             SqlCommand cmd = new SqlCommand(sql, conn);
45             conn.Open();
46             try
47             {
48                 cmd.ExecuteNonQuery();
49                 Response.Write("<script>alert('添加！')</script>");//Response.Write(cc.MessageBox("添加成功!",""));
50                 Server.Execute("list.aspx");
51             }
52             catch (Exception ex)
53             {
54                 Response.Write(ex.Message);
55             }
56             finally
57             {
58                 conn.Close();
59             }
60         }
61         else
62         {
63             string sql = "updata tb_person set per_name='" + TextBox1.Text + "',per_age='" + TextBox2.Text + "',per_hobby='" + TextBox3.Text + "',per_sex='" + TextBox5.Text + "'";
64             SqlCommand cmd = new SqlCommand(sql, conn);
65             conn.Open();
66             try
67             {
68                 cmd.ExecuteNonQuery();
69                 Response.Write("<script>alert('编辑！')</script>");//Response.Write(cc.MessageBox("添加成功!",""));
70                 Server.Execute("list.aspx");
71             }
72             catch (Exception ex)
73             {
74                 Response.Write(ex.Message);
75             }
76             finally
77             {
78                 conn.Close();
79             }
80         }      
81     }
View Code

scan前

 1 using System.Data.SqlClient;
 2 using System.Data;
 3 
 4 
 5 
 6 
 7 int id = 0;
 8     protected void Page_Load(object sender, EventArgs e)
 9     {
10        SqlConnection conn = new SqlConnection(@"server=127.0.0.1;database=db_hoan;uid=sa;pwd=sa");//i//根据ID取出本条数据sql = "select id  from tb_person" 
11         if (!string.IsNullOrEmpty(Request.QueryString["id"]))
12         {
13             id = Convert.ToInt32(Request.QueryString["id"]);
14         }
15         string sql = "select * from tb_person where [id]=@id";
16         SqlCommand cmd = new SqlCommand(sql, conn);
17         conn.Open();
18         cmd.Parameters.AddWithValue("@id", id);//cmd中添加参数string str = null 是不给它分配内存空间，而 string str = "" 给它分配长度为空字符串的内存空间
19 
20         try
21         {
22             SqlDataReader dr = cmd.ExecuteReader();//得到的dr就是一个SqlDataReader对象呀。通过这个对象，就可以对各个记录进行枚举，并且获取每个记录的字段信息的
23 
24             while (dr.Read())//逐条记录读取的。每读取一条， DataReader中定义的一个索引器方法，意思是查询i所对应的列的信息
25             {
26                 TextBox1.Text = dr["per_name"].ToString().Trim();//sdr[“字段名”],I是指你查询数据的第i列
27                 TextBox2.Text = dr["per_age"].ToString().Trim();
28                 TextBox3.Text = dr["per_hobby"].ToString().Trim();
29                 TextBox4.Text = dr["per_sex"].ToString().Trim();
30             }
31         }
32         catch (Exception ex)
33         {
34             Response.Write(ex.Message);
35         }
36         finally
37         {
38             conn.Close();
39         }        
40     }
View Code

后

 1 <form id="form1" runat="server">
 2     <div>
 3     
 4         <asp:Label ID="Label2" runat="server" Text="姓名"></asp:Label>
 5         <asp:TextBox ID="TextBox1" runat="server" OnDataBinding="Page_Load"></asp:TextBox>
 6         <br />
 7         <asp:Label ID="Label3" runat="server" Text="年龄"></asp:Label>
 8         <asp:TextBox ID="TextBox2" runat="server" OnDataBinding="Page_Load"></asp:TextBox>
 9         <br />
10         <asp:Label ID="Label4" runat="server" Text="兴趣"></asp:Label>
11         <asp:TextBox ID="TextBox3" runat="server" OnDataBinding="Page_Load"></asp:TextBox>
12         <br />
13         <asp:Label ID="Label5" runat="server" Text="性别"></asp:Label>
14         <asp:TextBox ID="TextBox4" runat="server" OnDataBinding="Page_Load"></asp:TextBox>
15     
16     </div>
17     </form>
View Code

list前

 1 <form id="form1" runat="server">
 2         <div>
 3 
 4             <br />
 5             <asp:GridView ID="GridView1" runat="server" DataKeyNames="id" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
 6                 Width="500px" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize="5" AutoGenerateColumns="false" OnRowDeleting="GridView1_RowDeleting"
 7                 OnRowEditing="GridView1_RowEditing" OnRowDataBound="GridView1_RowDataBound">
 8                 <Columns>
 9                     <asp:CommandField ShowDeleteButton="true"  HeaderText="删除"/>
10                     <asp:BoundField DataField="per_name" HeaderText="姓名" />
11                     <asp:BoundField DataField="per_age"  HeaderText="年龄" />
12                     <asp:BoundField DataField="per_hobby" HeaderText="兴趣" />
13                   
14                    <asp:TemplateField HeaderText="性别">
15                     <EditItemTemplate>
16                         <asp:DropDownList ID="ddlSex" runat="server" Width="151px">
17                         </asp:DropDownList>
18                     </EditItemTemplate>
19                     <ItemTemplate>
20                         <asp:Label ID="lblSex" runat="server" Text='<%# Eval("per_sex") %>'></asp:Label>
21                     </ItemTemplate>
22                 </asp:TemplateField>
23                     
24                      <asp:TemplateField>
25                         <HeaderTemplate> 操作 </HeaderTemplate>
26                         <ItemTemplate>
27                             <a href="add.aspx?id=<%#Eval("id") %>">修改</a>
28                             <a href="detail.aspx?id=<%#Eval("id") %>">详细</a>
29                         </ItemTemplate>
30                        </asp:TemplateField>
31                     
32                 </Columns>
33           </asp:GridView>
34 
35         </div>
36     </form>
View Code

后

 1 using System.Data.SqlClient;
 2 using System.Data;
 3 
 4 
 5 
 6 
 7 
 8 
 9 
10 
11 protected void Page_Load(object sender, EventArgs e)
12     {
13         SqlConnection conn = new SqlConnection(@"server=127.0.0.1;database=db_hoan;uid=sa;pwd=sa");
14 
15         SqlDataAdapter myda = new SqlDataAdapter("select * from tb_person", conn);//建适配器对象和读表
16         conn.Open();
17         DataSet myds = new DataSet();//建数据集对象
18         myda.Fill(myds, "tb_person");//填
19         GridView1.DataSource = myds;//指定数据源
20         GridView1.DataBind();//绑数据
21     }
22 
23     protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
24     {
25         //string sql = "select * from tb_person where [id]=" + id;
26         Response.Redirect("detail.aspx");
27     }
28     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
29     {
30         GridView1.PageIndex = e.NewPageIndex;//获取选择页的索引
31         GridView1.DataBind();//数据绑定
32     }
33     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
34     {
35         SqlConnection conn = new SqlConnection(@"server=127.0.0.1;database=db_hoan;uid=sa;pwd=sa");
36         string sqlstr = "delete from tb_person where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
37 
38         SqlCommand cmd = new SqlCommand(sqlstr, conn);
39         conn.Open();
40         cmd.ExecuteNonQuery();
41         conn.Close();
42         GridView1.DataBind();//数据绑定
43     }
44     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
45     {
46         Response.Redirect("add.aspx?id=" + GridView1.DataKeys[e.NewEditIndex].Value);
47         // Response.Redirect("add.aspx");
48     }
49     //数据绑定后触发
50     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
51     {
52 
53         if (e.Row.RowType == DataControlRowType.DataRow)//如果行的类型是数据绑定行
54         {
55             if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) //行的状态是：正常状行态 或者 交替
56             {
57                 Label lblSex = e.Row.FindControl("lblSex") as Label;
58                 if (lblSex != null)
59                 {
60                     if (lblSex.Text == "0")
61                     {
62                         lblSex.Text = "女";
63                     }
64                     else
65                     {
66                         lblSex.Text = "男";
67                     }
68                 }
69             }
70             if (e.Row.RowState == DataControlRowState.Edit || e.Row.RowState == (DataControlRowState.Alternate | DataControlRowState.Edit)) //行的状态是： 编辑状态 或者 （交替行且是编辑状态）
71             {
72                 DropDownList ddlSex = e.Row.FindControl("ddlSex") as DropDownList;
73                 if (ddlSex != null)
74                 {
75                     ListItem item1 = new ListItem();
76                     item1.Value = "0";
77                     item1.Text = "女";
78                     ddlSex.Items.Add(item1);
79 
80                     ListItem item2 = new ListItem();
81                     item2.Value = "1";
82                     item2.Text = "男";
83                     ddlSex.Items.Add(item2);
84                 }
85             }
86         }
87     }
View Code

 

数据库

 

 

模板点：

 

 

 

posted on 2015-06-15 16:45  生科院  阅读(286)  评论(0)    收藏  举报