110,537
社区成员
发帖
与我相关
我的任务
分享
declare @columnName varchar(10)
declare @sql nvarchar(4000)
set @columnName ='字段名'
set @sql='select top 1 '+@columnName +' from 表'
exec (@sql)
"insert into table_name" + colStr + " " + valStr;
生成textbox的时候,把列名添加到textbox.tag
然后遍历textbox
code:
string colStr = "("
string valStr = "(";
foreach(control c in controls)
{
if(c is textbox)
{
if(colStr.length == 1)
{
colStr += c.tag.tostring();
valStr += (c as textbox).text;
}
else
{
colStr += "," + c.tag.tostring();
valStr += "," + (c as textbox).text;
}
}
}
colStr += ")";
valStr += ")";
string sqlStr = "insert into table_name" + colStr + valStr;
....
--获得表的所有字段名称
select * from dbo.syscolumns
where id in (select id from dbo.sysobjects where [name] ='表名称')