VS2008C#连接SQLserver2008示例

上面，SQL server 2008，下面，VS2008，
插入添加：
            SqlConnection SqlConn = new SqlConnection(@"Server=.\SQLEXPRESS;Database=sqlservertest1;user id=sa; password=sa");
            //name:LBX-WIN7-64\SQLEXPRESS
            string str="insert into data(id,data) values('123','UHF')";/*注意中间的单双引号*/
            SqlCommand SqlCmd = new SqlCommand(str, SqlConn);
            SqlConn.Open();
            SqlCmd.ExecuteNonQuery();
            SqlConn.Close();
            textBox3.Text = "插入成功!";