关于选择命令的问题 [英] question about select command
本文介绍了关于选择命令的问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<br /> <pre lang="sql">sqlConnection3.Open();<br /> sqlDataAdapter3.SelectCommand.Parameters["@u"] = user;<br /> sqlDataAdapter3.SelectCommand.Parameters["@pass"] = pass ;<br /> sqlDataAdapter3.SelectCommand.ExecuteNonQuery();<br /> sqlConnection3.Close();</pre><br /> <br /> <br />
但有这样的错误:
Error 1 Cannot implicitly convert type ''string'' to ''System.Data.SqlClient.SqlParameter''
我该怎么办?
解决方案
在哪里指定了select命令?连接到SQL适配器的位置在哪里?为什么有3个连接和3个适配器?为什么不使代码可读?
您需要将参数和类型一起添加.看看示例 [ ^ ]来实施正确.
使用此:
adapter.SelectCommand.Parameters.Add(new SqlParameter("@ userid",userid));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@ username",用户名));
希望此链接能解决您的问题:
http://devpinoy.org/blogs/keithrull/archive/2006/06/19/HowTo_3A00_-Use-SqlParameters-to-pass-parameters-to-queries-and-stored-procedures.aspx [ sqlDataAdapter3.SelectCommand.Parameters["@u"] = user;<br /> sqlDataAdapter3.SelectCommand.Parameters["@pass"] = pass ;<br /> sqlDataAdapter3.SelectCommand.ExecuteNonQuery();<br /> sqlConnection3.Close();</pre><br /> <br /> <br />
but have error like this:
Error 1 Cannot implicitly convert type ''string'' to ''System.Data.SqlClient.SqlParameter''
what i have to do???解决方案Where is the select command specified ? Where is the connection tied to the SQL adapter ? Why do you have 3 connections and 3 adapters ? Why not make your code readable ?
You need to add the parameters along with the type. Have a look at the example[^] on msdn to implement this correctly.
Use this:
adapter.SelectCommand.Parameters.Add(new SqlParameter("@userid", userid));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@username", username));
Hope this link would solve your problem:
http://devpinoy.org/blogs/keithrull/archive/2006/06/19/HowTo_3A00_-Use-SqlParameters-to-pass-parameters-to-queries-and-stored-procedures.aspx[^]
这篇关于关于选择命令的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文