insertlink.aspx.cs

大中型酒店管理系统

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class links_insertlink : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string name = txtName.Text;
        string url = txtURL.Text;
        SqlConnection conn = db.createconn();
        conn.Open();
        if (name != "")
        {
            
            SqlCommand cmd = new SqlCommand("select count(*) from links where name ='" + name + "'", conn);
            int count = Convert.ToInt32(cmd.ExecuteScalar());
            if (count > 0)
            {
                Response.Write("<script language='javascript'>alert('该友情单位已经存在');history.go(-1);</script>");
            }
            else
            {
                SqlCommand cmd1 = new SqlCommand("insert into links(name,url) values('" + name + "','" + url + "')", conn);
                cmd1.ExecuteNonQuery();
                Response.Write("<script language='javascript'>alert('该友情单位添加成功');history.go(-1);</script>");
               
            }
        }
        else
        {
           
            Response.Write("<script language='javascript'>alert('还没输入友情单位的名字');history.go(-1);</script>");
            txtName.Focus();
        }
    }
}