040105-数据库连接

1、程序连接数据库。

            using (SqlConnection conn = new SqlConnection("Data Source=数据库服务器; Initial Catalog=数据库名称;

                                                                                     User ID=数据库用户; Password=密码"))
            {
                //打开数据库连接

                conn.Open(); 
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "待执行的SQL语句";
                    int i = (int)cmd.ExecuteScalar(); //返回执行结果的第一行第一列。
                    MessageBox.Show(i.ToString());
                }
            }