构造函数: static DataBase() { connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; } static DataBase() { //初始化数据库连接串 connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; } 执行sql语句 public static void ExecSQL(string sql) { SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); try { connection.Open(); cmd.CommandText = sql; cmd.Connection = connection; cmd.ExecuteNonQuery(); } finally { connection.Close(); } } 填充dataset public static void FillDataSet(DataSet dataSet, string tableName, string sql, bool fillSchema) { SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter dataAdapter = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = sql; dataAdapter.SelectCommand = cmd; dataAdapter.Fill(dataSet, tableName); if (fillSchema) { dataAdapter.FillSchema(dataSet, SchemaType.Mapped, tableName); } } 执行一个获取表的id的存储过程 public static int GetCode(int codeID) { int code = -1; SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandType=CommandType.StoredProcedure; cmd.CommandText="[GetCode]"; cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Code", System.Data.SqlDbType.Int, 4)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NewCode", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters["@Code"].Value = codeID; try { connection.Open(); cmd.ExecuteNonQuery(); code = Convert.ToInt32(cmd.Parameters["@NewCode"].Value); } finally { connection.Close(); } return code; }