C#连接SQL数据库 字符串

 

C#连接SQL字条串

 

1：

 string str = "server=localhost;Initial Catalog=QQ;Integrated Security=SSPI;uid=sa;pwd=yh";
            SqlConnection con = new SqlConnection(str);
        try
        {
            con.Open();
        }
        catch (Exception ex)
        {
            throw ex;
       
        }

2： string str = "server=（local）;Initial Catalog=QQ;Integrated Security=SSPI;uid=sa;pwd=yh";
            SqlConnection con = new SqlConnection(str);
        try
        {
            con.Open();
        }
        catch (Exception ex)
        {
            throw ex;
       
        }

 

3：连接数据库  与界面调用代码

 public partial class QQLoad : Form
    {
       
        public QQLoad()
        {
            InitializeComponent();
            //ConnectionSQL();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (ConnectionSQL())
            {
                DialogResult = DialogResult.OK;

                this.Close();
              //不在同一类中 调用
                //  Process.Start(@"D:\Users\yuhong\Documents\visual studio 2010\Projects\QQclient\QQLoad\bin\Debug\QQLoad.exe");
            }
        }
        public bool ConnectionSQL()
        {
            string str = "server=localhost;Initial Catalog=QQ;Integrated Security=SSPI;uid=sa;pwd=yh";

            using (SqlConnection con = new SqlConnection(str))
            {
                try
                {
                    con.Open();
                    SqlCommand sqlcom = new SqlCommand();
                    sqlcom.CommandType = CommandType.StoredProcedure;
                    sqlcom.CommandText = "LoadByQQNumberAndQQkey";

                    SqlParameter qqnumber = new SqlParameter("@qqnumber", SqlDbType.VarChar, 20);
                    qqnumber.Value = txtqqnumber.Text.ToString();
                    sqlcom.Parameters.Add(qqnumber);

                    SqlParameter qqKey = new SqlParameter("@QQKEY", SqlDbType.VarChar, 10);
                    qqKey.Value = txtqqkey.Text.ToString();
                    sqlcom.Parameters.Add(qqKey);
                    sqlcom.Connection = con;
                    SqlDataReader reader = sqlcom.ExecuteReader();
                    if (reader.HasRows)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
                catch (Exception ex)
                {
                    throw ex;

                }
               
            }
       
        }

 

被调用界面代码

    static class Program
    {
        /// <summary>
        /// 应用程序的主入口点。
        /// </summary>
        [STAThread]
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);

            QQLoad load = new QQLoad();
            Application.Run(load);
            if (load.DialogResult == DialogResult.OK)
            {
                Application.Run(new QQclient());
            }
        }
    }