VS＋SQL数据库连接

public Form1() { InitializeComponent(); string strConn = "Integrated Security=SSPI;Initial Catalog=MyDatabase;Data Source=(local) "; //string strConn = "data source = (local);initial catalog =MyDatabase; user id = sa;password = 123123"; SqlConnection myConnection = new SqlConnection(strConn); myConnection.Open(); string strcmd; strcmd = "select * from base"; SqlDataAdapter MydataDataApter; DataSet mydataset =new DataSet() ; MydataDataApter = new SqlDataAdapter(strcmd, strConn); MydataDataApter.Fill(mydataset, "base"); dataGridView1.DataSource = mydataset.Tables["base"]; } private void Form1_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“myDatabaseDataSet2._base”中。您可以根据需要移动或移除它。 this.baseTableAdapter.Fill(this.myDatabaseDataSet2._base); } private void button2_Click(object sender, EventArgs e) { this.Close(); } private void button1_Click(object sender, EventArgs e) { string strConn = "data source = (local);initial catalog =MyDatabase; user id = sa;password = 123123"; SqlConnection myConnection = new SqlConnection(strConn); myConnection.Open(); string strcheck1; string text1=this.comboBox1.Text; string text2=this.textBox1.Text; text1 = text1.Trim(); text2 = text2.Trim(); strcheck1 = "select 姓名 from base where 姓名＝text1 and 密码＝text2"; SqlDataAdapter mydata1; DataSet mydataset1 = new DataSet(); mydata1 = new SqlDataAdapter(strcheck1, strConn); if (mydataset1.Tables.Count == 0) MessageBox.Show("你输入的密码不正确,请确认用用户为:"+text1, "信息提示"); else MessageBox.Show(text1+"用户欢迎使用","信息提示"); // num = num + 1; // if (num>3) // MessageBox.Show("你输入的密码不正确且重试次数太多!系统将退出!", "信息提示"); }