try
{
sql="SELECT 字段 FROM 表";
conn.ExcuteNonQuery();
}
catch(sqlException exp)
{
//没有字段就会出异常的
}
解决方案 »
- 如何获取ListView控件中被选中项的index值
- 正则表达式的问题,
- 数组问题(送分了)
- 望高手指教:unicode编码转换出错??
- 路过的朋友帮忙看下:用C#.asp建立WEB页面,点击按钮后会弹出一个提示小窗口,如何在关闭窗口的同时刷新页面?
- C#WinForm中System.Net.Mail如何带用户名及密码连接服务器,解决即给分
- 请问确如何在C#中实现类似QQ窗体自动隐藏的效果??
- C#界面怎样产生类似于excel表的输入文本格式
- 跪求关于提取html代码里面的隐藏id和string
- 急需Google Web APIs license key
- 关于捕捉扫描枪事件
- 初学C#望高手指点一下如何学习 Windows forms。
select name,object_name(id) from syscolumns
{
......
}
Create view v_fielddesc
as
SELECT
d.name N'表名',
a.colorder N'字段序号',
a.name N'字段名',
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) N'标识',
(case when (SELECT count(*)
FROM sysobjects
WHERE (name in
(SELECT name
FROM sysindexes
WHERE (id = a.id) AND (indid in
(SELECT indid
FROM sysindexkeys
WHERE (id = a.id) AND (colid in
(SELECT colid
FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = 'PK'))>0 then '√' else '' end) N'主键',
b.name N'类型',
a.length N'占用字节数',
COLUMNPROPERTY(a.id,a.name,'PRECISION') as N'长度',
isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as N'小数位数',
(case when a.isnullable=1 then '√'else '' end) N'允许空',
isnull(e.text,'') N'默认值',
isnull(g.[value],'') AS N'字段说明'
--into ##txFROM syscolumns a left join systypes b
on a.xtype=b.xusertype
inner join sysobjects d
on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
left join syscomments e
on a.cdefault=e.id
left join sysproperties g
on a.id=g.id AND a.colid = g.smallid
--order by object_name(a.id),a.colorder
if EXISTS(select * from syscolumns where id=object_id('表名') and[name]='字段名')
true
else
false