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();
}