用update更新的时候,把那个字段弄成null
看看有没有sqlexception咯
看看有没有sqlexception咯
解决方案 »
- 关于datagridview问题?
- Asp.net
- 有人在吗,myGridTextBoxColumn.Format = "D";D是什么意思?
- C#如何实现另存为
- 关于REMOTING的问题!!为什么事件不能被处理?报错为由于安全问题??
- 代码中的变量附值给SQL的WHERE条件的判断中怎么做?
- C#中使用SoundRecord()录音,如何实时显示录音的波形
- DataGrid (winForm)自动换行问题。
- 关于ADO.NET里的一个问题!请指教
- 如何在c#中调用另一个使用#c写的exe文件,送100分
- 请教有关类的问题(50')
- 用system.codedom类怎么写foreach的语句?
去查联机丛书
SQLDMO组件具体怎么用?请详细指教,或发Email:[email protected]
SELECT syscolumns.name AS 'FieldName',
syscolumns.colid AS 'FieldOrder',
CASE A.INDID WHEN 1 THEN 1 ELSE 0 END AS 'FieldKey',
syscolumns.colstat AS 'FieldIdentity',
systypes.name AS 'FieldType',
syscolumns.length AS 'FieldLength',
syscolumns.isnullable AS 'FiledIsNull',
sysproperties.value AS 'FieldDescription'
FROM ((((sysobjects
INNER JOIN syscolumns ON syscolumns.id = sysobjects.id)
INNER JOIN systypes ON systypes.xtype = syscolumns.xtype)
LEFT JOIN
(
SELECT sysindexkeys.* FROM sysindexkeys
INNER JOIN sysobjects
ON sysobjects.id = sysindexkeys.id
WHERE sysindexkeys.indid = 1
) A
ON A.id = sysobjects.id AND A.colid = syscolumns.colid)
LEFT JOIN sysproperties ON sysproperties.smallid = syscolumns.colid AND sysproperties.id = sysobjects.id)
WHERE sysobjects.type='U'
AND sysobjects.name <> 'dtproperties'
AND syscolumns.id = sysobjects.id
AND sysobjects.name = @TableName
ORDER BY syscolumns.colid
[email protected]
如果是强类型DataSet就更直观。