sql的基本操作

--读取数据库表，返回该表的说明

Select  sys.columns.name as 'colname', 
		                    sys.types.name as 'coltype', 
		                    sys.columns.max_length, 
		                    sys.columns.is_nullable, 
                            (select value 
                            from sys.extended_properties 
                            where sys.extended_properties.major_id = sys.columns.object_id 
                            and sys.extended_properties.minor_id = sys.columns.column_id) as description
                    From sys.columns, sys.tables, sys.types 
                    Where sys.columns.object_id = sys.tables.object_id 
                      And sys.columns.system_type_id=sys.types.system_type_id 
                      And sys.tables.name= 'vmi_customers'
                    Order by sys.columns.column_id

---用事务执行多条sql

 /// <summary>
        /// 执行多条SQL语句，实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList">多条SQL语句</param>		
        public static int ExecuteSqlTran(List<String> SQLStringList)
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                SqlTransaction tx = conn.BeginTransaction();
                cmd.Transaction = tx;
                try
                {
                    int count = 0;
                    for (int n = 0; n < SQLStringList.Count; n++)
                    {
                        string strsql = SQLStringList[n];
                        if (strsql.Trim().Length > 1)
                        {
                            cmd.CommandText = strsql;
                            count += cmd.ExecuteNonQuery();
                        }
                    }
                    tx.Commit();
                    return count;
                }
                catch (Exception e)
                {

                    tx.Rollback();
                    throw e;
                }
            }
        }

---判断重复数据

 DataView dv = new DataView(id_Grid1);
            if (dv.Count != dv.ToTable(true, "C_Code").Rows.Count)
            {
                MessageBox.Show("客户编码不能重复！", gGlobal.Msg_Err, MessageBoxButtons.OK, MessageBoxIcon.Error);
                return "-1";
            }

---执行sql查询返回dataset

 /// <summary>
        /// 执行查询语句，返回DataSet
        /// </summary>
        /// <param name="SQLString">查询语句</param>
        /// <returns>DataSet</returns>
        public static DataSet Query(string SQLString)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
                    command.Fill(ds, "ds");
                }
                catch (System.Data.SqlClient.SqlException ex)
                {
                     throw new Exception(ex.Message);
                }
                return ds;
            } 
        }