C# 串連SQL Server 2000 資料庫核心代碼

 SqlConnection c = new SqlConnection("User ID=sa;Initial Catalog=Admin;Data Source=799BE7EF4229458");
            c.Open();

            MessageBox.Show(c.State.ToString());//顯示資料連線狀態
           
            string sql="insert into t1(Name,Pwd) values (@a,@b)";
            SqlParameter p1 = new SqlParameter("@a", textBox1.Text);
            SqlParameter p2 = new SqlParameter("@b", textBox2.Text);

            SqlCommand com = new SqlCommand(sql, c);
            com.Parameters.Add(p1);
            com.Parameters.Add(p2);
            com.ExecuteNonQuery();
            MessageBox.Show("Register is successful !");