CommandText = "'"+ sql3 +"'"; sql3来自存储过程 nvarchar
--------------------编程问答-------------------- 看看Request.QueryString["zdLX"].ToString()是什么 --------------------编程问答-------------------- SqlConnection Cooon = new SqlConnection();Cooon.ConnectionString = "Data Source=KANG-PC;Initial Catalog=TJ;Persist Security Info=True;User ID=TJ;Password=sql2005";
Cooon.Open();
SqlCommand ccc = new SqlCommand();
ccc.CommandText = "'"+ sql3 +"'";
ccc.Connection = Cooon;
int rows = ccc.ExecuteNonQuery();
Cooon.Close();
Cooon.Dispose();
sql3是从存储过程中获得的值: insert into TJ_YYYXJBJCZB ( zdLX,zdZB,zd2010N,zd2011N,zd2012N ) values ( '" + Request.QueryString["zdLX"].ToString() + "','" + Request.QueryString["zdZB"].ToString() + "','" + Request.QueryString["zd2010N"].ToString() + "','" + Request.QueryString["zd2011N"].ToString() + "','" + Request.QueryString["zd2012N"].ToString() + "' )
后面红色的部分没有运行成功! --------------------编程问答-------------------- 断点调试看Request.QueryString里面有值没有,然后就是值是否跟数据库字段对应
或者把生成sql拿到数据库执行看是否有问题 --------------------编程问答-------------------- declare @sqlad nvarchar(4000),@sqlzd nvarchar(4000),@sqlbl nvarchar(4000)
select @sqlad='',@sqlzd='',@sqlbl=''
select @sqlzd=@sqlzd+',' +zdmc
from TJ_BBZDK where bbmc=(select mcid from TJ_BBMCK where bbmc=@bmc)
select @sqlzd=stuff(@sqlzd,1,1,'')
select @sqlbl=@sqlbl+',''" + Request.QueryString["' +zdmc+'"].ToString() + "'''
from TJ_BBZDK where bbmc=(select mcid from TJ_BBMCK where bbmc=@bmc)
select @sqlbl=stuff(@sqlbl,1,1,'')
select @sqlad=' insert into '+@bmc+' ( '+@sqlzd+' ) '+' values ( '+@sqlbl+' ) '
SELECT @sqlad --------------------编程问答-------------------- 我是在SQL存储过程中拼凑了一条语句 ,但是这条语句中有C#的Request.QueryString,我怀疑输出的语句没有执行Request.QueryString,我不知道该怎么解决了。。ASP.NET才接触 --------------------编程问答-------------------- SqlConnection Cooon = new SqlConnection();
Cooon.ConnectionString = "Data Source=KANG-PC;Initial Catalog=TJ;Persist Security Info=True;User ID=TJ;Password=sql2005";
Cooon.Open();
SqlCommand ccc = new SqlCommand();
ccc.CommandText = "insert into TJ_YYYXJBJCZB ( zdLX,zdZB,zd2010N,zd2011N,zd2012N ) values ( '" + Request.QueryString["zdLX"].ToString() + "','" + Request.QueryString["zdZB"].ToString() + "','" + Request.QueryString["zd2010N"].ToString() + "','" + Request.QueryString["zd2011N"].ToString() + "','" + Request.QueryString["zd2012N"].ToString() + "' )
";
ccc.Connection = Cooon;
int rows = ccc.ExecuteNonQuery();
Cooon.Close();
Cooon.Dispose();
我把sql3直接换掉就成功了 --------------------编程问答-------------------- 那么放不会当成一个字符串去执行么? --------------------编程问答-------------------- --------------------编程问答-------------------- 申明一个变量 变量名为getdata[name].ToString() 怎么实现啊 --------------------编程问答--------------------
运行报错 '" + Request.QueryString["zdLX"].ToString()
说明,Request.QueryString["zdLX"]没有接收到值,Request.QueryString["zdLX"]是NULL,所以没法tostring(),所以报错
补充:.NET技术 , ASP.NET