1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class Addshdw : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void Button1_Click(object sender, EventArgs e)
20    ...{
21        if (kong())
22        ...{
23            //定义变量
24            string aa, bb, cc, dd, ee;
25            aa = this.TextBox1.Text;
26            bb = this.TextBox2.Text;
27            cc = this.TextBox3.Text;
28            dd = this.TextBox4.Text;
29            ee = this.TextBox5.Text;
30            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
31            scon.Open();
32            SqlCommand scmd = new SqlCommand("insert into shdw(Bianma,Name,Address,tel,person) values ('" + aa + "','" + bb + "','" + cc + "','" + dd + "','" + ee + "')", scon);
33            scmd.ExecuteNonQuery();
34            scmd.Dispose();
35            scon.Close();
36            Response.Write("<script language='javascript'>alert('添加成功！');</script>");
37            Server.Transfer("manageshdw.aspx");
38        }
39    }
40    private bool kong()
41    ...{
42        if (this.TextBox1.Text == "")
43        ...{
44            Response.Write("<script language='javascript'>alert('编码不能为空！');</script>");
45            return false;
46        }
47        else
48        ...{
49            if (this.TextBox2.Text == "")
50            ...{
51                Response.Write("<script language='javascript'>alert('名称不能为空！');</script>");
52                return false;
53            }
54            else
55            ...{
56                return true;
57            }
58        }
59    }
60    protected void Button2_Click(object sender, EventArgs e)
61    ...{
62        Server.Transfer("manageshdw.aspx");
63    }
64}
65
66
67