badnewfish

  private string getColumnRemark(string tableName, string ColumnName, string connectionString)
        {
            try
             {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    SqlCommand cmd = new SqlCommand();
                    cmd.CommandText = "select   (select   value   from   sys.extended_properties   where   name='MS_Description'   and   major_id=id   and   minor_id=colorder)   from   syscolumns   where   id=object_id('"+tableName+"')   and   name='"+ColumnName+"'";
                    //本来要搞参数化查询的，但是实在是找不到各个存储过程的参数类型说明信息，诶······望高人指点

                    //cmd.Parameters.Add("@tablName",SqlDbType.NVarChar);
                    //cmd.Parameters.Add("@ColumnName", SqlDbType.NVarChar);
                    //cmd.Parameters[0].Value = tableName;
                    //cmd.Parameters[1].Value = ColumnName;

                    cmd.Connection = conn;
                    conn.Open();

                    return (string)cmd.ExecuteScalar();
                }
            }
            catch (Exception ex)
            {
                return "失败" + ex.ToString();
            }