C# 与数据库连接相关脚本

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page 
{
    static string strsql = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=LogisticsDB;Data Source=.";
    SqlConnection con = new SqlConnection(strsql);
    SqlCommand com;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Panel1.Visible = false;
        this.Panel2.Visible = false  ;
        this.Panel3.Visible = false ;
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        con.Open();
        string strinsert = "insert into Logistics_Company(Company_ID,Company_Name,Company_City,Company_Phone,Company_Fax,Company_Adress,Company_Remark) values('" + TextBox2.Text.Trim() + "','" + TextBox3.Text.Trim() + "','" + TextBox4.Text.Trim() + "','" + TextBox5.Text.Trim() + "','" + TextBox6.Text.Trim() + "','" + TextBox7.Text.Trim() + "','" + TextBox8.Text + "')";
        com = new SqlCommand(strinsert, con);
        int i = 0;
        try
        {


            i = com.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('添加失败成功！');</script>");
        }
        con.Close();


        if (i > 0)
        {
            Response.Write("<script>alert('添加成功！');</script>");
            TextBox1.Text = "";
            TextBox2.Text = "";
            TextBox3.Text = "";
            TextBox4.Text = "";
            TextBox5.Text = "";
            TextBox6.Text = "";
            TextBox7.Text = "";
        }
        else
        {
            Response.Write("<script>alert('添加失败成功！');</script>");
            TextBox1.Text = "";
            TextBox2.Text = "";
            TextBox3.Text = "";
            TextBox4.Text = "";
            TextBox5.Text = "";
            TextBox6.Text = "";
            TextBox7.Text = "";
        }
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        this.Panel1.Visible = true;
        this.Panel2.Visible = false;
        this.Panel3.Visible = true;
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
        TextBox7.Text = "";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.Panel1.Visible = true;
        this.Panel2.Visible = false;
        this.Panel3.Visible = true;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        con.Open();
        try
        {
            string strseer = "select * from Logistics_Company where Company_Name='" + TextBox1.Text.Trim() + "'";
            com = new SqlCommand(strseer, con);
            SqlDataAdapter sda = new SqlDataAdapter(com);
            sda.SelectCommand = com;


            int i = com.ExecuteNonQuery();
            con.Close();
            if (i > 0)
            {
                Response.Write("<script>alert('找到公司信息！');</script>");
                Panel1.Visible = true;
                Panel3.Visible = false;
                Panel2.Visible = true;
            }
            else
            {
                Response.Write("<script>alert('没有找到您想查找的公司信息！');</script>");
            }


        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('asdf');</script>");
        }
    }
    protected void Button5_Click(object sender, EventArgs e)
    {
        this.Panel1.Visible = true;
    }
    protected void Button6_Click(object sender, EventArgs e)
    {
        this.Panel2.Visible =true ;
        this.Panel1.Visible = true;
    }
}