|
- string cmdText = string.Empty;
- if (string.IsNullOrEmpty(current))
- cmdText = string.Format("sys.sp_addextendedproperty @name=N'YF_Description', @value=N'{0}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'{1}'",
- type, tableName);
- else
- cmdText = string.Format("sys.sp_updateextendedproperty @name=N'YF_Description', @value=N'{0}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'{1}'",
- type, tableName);
- TABLESTableAdapter adapter = new TABLESTableAdapter();
- SqlCommand cmd = new SqlCommand(cmdText, adapter.Connection);
- cmd.Connection.Open();
- cmd.ExecuteNonQuery();
- cmd.Connection.Close();
复制代码
|
|