如何在窗口c#Page中的表格中插入以下文本? [英] How to Insert Following Text In Table From Window c# Page?
本文介绍了如何在窗口c#Page中的表格中插入以下文本?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
insert into VersionLog_Details(Ref_UserID,Server_Name,Database_Name,Object_Type ,Object_Name,Comment,Changes_Date,Object_Code) values (' 4',' VOI_05\SQLEXPRESS',' abc',' Procedure ',' ra',' sczcszcfsdfsdfsd,mksdgmklldsfgkjfgkjkf' Hii你如何' ,' 2015年1月30日下午2:12:31 ' ,' CREATE procedure ra
(
@EmpID int
)
as
begin
插入 进入 MyEmployees 值(' s',' s',' ',' < span class =code-string>',' ',' ')
end
选择 * 来自 MyEmployees ' )
试试..
将插入 VersionLog_Details(Ref_UserID,Server_Name,Database_Name,Object_Type,Object_Name,Comment,Changes_Date,Object_Code)值(
@Ref_UserID,
@Server_Name,
@Database_Name,
@Object_Type,
@Object_Name,
@Comment,
@Changes_Date,
@Object_Code
)
command.Parameters.AddWithValue( @ Ref_UserID,' 4 跨度>);
command.Parameters.AddWithValue( @ Server_Name,' VOI_05 \ SQLEXPRESS');
。
。
。
。
string strCmnts = Hii你好! 跨度>;
command.Parameters.AddWithValue( @ Comment,strCmnts);
command.Parameters.AddWithValue( @ Changes_Date,' 1/30/2015 2:12:31 PM');
srtring strSp = @ 创建程序ra
(
@ EmpID int
)
as
begin
Insert into MyEmployees values('s','s','','','','')
结束
从MyEmployees选择*);
command.Parameters.AddWithValue( @ Object_Code,strSp);
ref。
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters(v = VS。 110).aspx [ ^ ]
insert into VersionLog_Details( Ref_UserID, Server_Name, Database_Name, Object_Type, Object_Name, Comment, Changes_Date,Object_Code)values('4','VOI_05\SQLEXPRESS','abc','Procedure','ra','sczcszcfsdfsdfsd, mksdgmklldsfgkjfgkjkf 'Hii How are You','1/30/2015 2:12:31 PM','CREATE procedure ra
(
@EmpID int
)
as
begin
Insert Into MyEmployees values('s','s','','','','')
end
select * from MyEmployees')
解决方案
try..
insert into VersionLog_Details( Ref_UserID, Server_Name, Database_Name, Object_Type, Object_Name, Comment, Changes_Date,Object_Code) values( @Ref_UserID, @Server_Name, @Database_Name, @Object_Type, @Object_Name, @Comment, @Changes_Date, @Object_Code ) command.Parameters.AddWithValue("@Ref_UserID", '4'); command.Parameters.AddWithValue("@Server_Name", 'VOI_05\SQLEXPRESS'); . . . . string strCmnts="Hii How are You"; command.Parameters.AddWithValue("@Comment", strCmnts); command.Parameters.AddWithValue("@Changes_Date", '1/30/2015 2:12:31 PM'); srtring strSp=@"CREATE procedure ra ( @EmpID int ) as begin Insert Into MyEmployees values('s','s','','','','') end select * from MyEmployees')"; command.Parameters.AddWithValue("@Object_Code", strSp);
ref.
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters(v=vs.110).aspx[^]
这篇关于如何在窗口c#Page中的表格中插入以下文本?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文