当前文件： HotelSuppliesMarket/links/insertlink.aspx.cs[1K，2009-6-12 11:44:29]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Data.SqlClient;
 4using System.Configuration;
 5using System.Collections;
 6using System.Web;
 7using System.Web.Security;
 8using System.Web.UI;
 9using System.Web.UI.WebControls;
10using System.Web.UI.WebControls.WebParts;
11using System.Web.UI.HtmlControls;
12
13public partial class links_insertlink : 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        string name = txtName.Text;
22        string url = txtURL.Text;
23        SqlConnection conn = db.createconn();
24        conn.Open();
25        if (name != "")
26        ...{
27            
28            SqlCommand cmd = new SqlCommand("select count(*) from links where name ='" + name + "'", conn);
29            int count = Convert.ToInt32(cmd.ExecuteScalar());
30            if (count > 0)
31            ...{
32                Response.Write("<script language='javascript'>alert('该友情单位已经存在');history.go(-1);</script>");
33            }
34            else
35            ...{
36                SqlCommand cmd1 = new SqlCommand("insert into links(name,url) values('" + name + "','" + url + "')", conn);
37                cmd1.ExecuteNonQuery();
38                Response.Write("<script language='javascript'>alert('该友情单位添加成功');history.go(-1);</script>");
39               
40            }
41        }
42        else
43        ...{
44           
45            Response.Write("<script language='javascript'>alert('还没输入友情单位的名字');history.go(-1);</script>");
46            txtName.Focus();
47        }
48    }
49}
50