blocks|key|1330521|text|永远不要通过mind...configured数据源的参数来获取另一个控件的值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1330522|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Never mind...configured the datasource's parameter to take the value of another control..

blocks|key|930360|text|让它工作的诀窍是在添加参数之前删除您正在尝试使用的参数。您的代码的以下改编版本应该可以工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|930361|'+NOTE+that+there+is+no+"@"+sign+when+you+use+your+parameters+in+the+code
Parameter+p+=+strCommandSqlDataSource2.SelectParameters["ClientID"]
strCommandSqlDataSource2.SelectParameters.Remove(p)
strCommandSqlDataSource2.SelectParameters.Add("ClientID",+iClientID)|code-block|syntax|javascript|930362|在使用代码部分命名参数时，不应使用"@“符号。您应该只在SQLCOMMAND字符串中使用它。|930363|希望能有所帮助。|930364|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The trick to make it work is to remove the paremeter you are trying to use before adding it. The following adapted version of your code should work:

<pre><code>' NOTE that there is no "@" sign when you use your parameters in the code
Parameter p = strCommandSqlDataSource2.SelectParameters["ClientID"]
strCommandSqlDataSource2.SelectParameters.Remove(p)
strCommandSqlDataSource2.SelectParameters.Add("ClientID", iClientID)
</code></pre>

You should not use "@" sign when naming parameters in the code portion of its usage. You should use it only in the SQLCOMMAND string.

Hope it helps.

blocks|key|4146702|text|您可以像这样设置参数的值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4146703|SqlParameter+parameter1+=+new+SqlParameter("@ClientID",+SqlDbType.BigInt);
parameter1.Value+=+32;
SqlDataSource2.SelectParameters.Add(parameter1);|code-block|syntax|javascript|4146704|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can set your parameter's value like that : 

<pre><code>SqlParameter parameter1 = new SqlParameter("@ClientID", SqlDbType.BigInt);
parameter1.Value = 32;
SqlDataSource2.SelectParameters.Add(parameter1);
</code></pre>

blocks|key|1327998|text|如果您已使用WYSWIG编辑器创建数据源，并且希望以编程方式更新SQL参数，则需要执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1327999|Dim+strCommand+=+"SELECT+caller_id,+phone,+name,+email+FROM+callers+WHERE+client_id=@ClientID"

SqlDataSource2.SelectCommand+=+strCommand

**SqlDataSource2.SelectParameters.Clear();**

SqlDataSource2.SelectParameters.Add("@ClientID",+iClientID)|code-block|syntax|javascript|1328000|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you've used the WYSWIG editor to create your data source and you want to update the SQL parameters programmatically, then you need to do the following:

<pre><code>Dim strCommand = "SELECT caller_id, phone, name, email FROM callers WHERE client_id=@ClientID"

SqlDataSource2.SelectCommand = strCommand

**SqlDataSource2.SelectParameters.Clear();**

SqlDataSource2.SelectParameters.Add("@ClientID", iClientID)
</code></pre>

blocks|key|1328011|text|我有从GET到SelectCommand的参数变量的解决方案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1328012|Protected+Sub+Page_Load(sender+As+Object,+e+As+EventArgs)+Handles+Me.Load
+++Dim+p+As+Parameter+=+SQLDataSource.SelectParameters("Order_id")
+++If+IsNothing(p)+Then
++++++++SQLDataSource.SelectParameters.Add("Order_id",+Server.HtmlEncode(Request.QueryString("Order_id")).ToString())
+++End+If
End+Sub|code-block|syntax|javascript|1328013|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I have solution for variable from GET to parameter for SelectCommand

<pre><code>Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
 Dim p As Parameter = SQLDataSource.SelectParameters("Order_id")
 If IsNothing(p) Then
 SQLDataSource.SelectParameters.Add("Order_id", Server.HtmlEncode(Request.QueryString("Order_id")).ToString())
 End If
End Sub
</code></pre>

blocks|key|4146872|text|protected+void+Page_Load(object+sender,+EventArgs+e)
{
++++if+(!IsPostBack)
++++{
++++++++SqlDataSource+SqlDataSource1+=+new+SqlDataSource();
++++++++SqlDataSource1.ID+=+"SqlDataSource1";
++++++++this.Page.Controls.Add(SqlDataSource1);
++++++++SqlDataSource1.ConnectionString+=+System.Configuration.ConfigurationManager.ConnectionStrings["ConID"].ConnectionString;
++++++++SqlDataSource1.SelectCommand+=+"SELECT+caller_id,+phone,+name,+email+FROM+callers+WHERE+client_id=@ClientID";
++++++++SqlDataSource1.SelectParameters.Add("ClientID",ClientID);
++++++++GridView1.DataSource+=+SqlDataSource1;
++++++++GridView1.DataBind();
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4146873|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>protected void Page_Load(object sender, EventArgs e)
{
 if (!IsPostBack)
 {
 SqlDataSource SqlDataSource1 = new SqlDataSource();
 SqlDataSource1.ID = "SqlDataSource1";
 this.Page.Controls.Add(SqlDataSource1);
 SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConID"].ConnectionString;
 SqlDataSource1.SelectCommand = "SELECT caller_id, phone, name, email FROM callers WHERE client_id=@ClientID";
 SqlDataSource1.SelectParameters.Add("ClientID",ClientID);
 GridView1.DataSource = SqlDataSource1;
 GridView1.DataBind();
 }
}
</code></pre>

blocks|key|4146744|text|你可以通过SqlDataSource上的Selecting事件来解决这个问题，我现在知道在这种控件中限制是多么困难了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4146745|另一种方法是在表单中添加一个HiddenField，然后SqlDataSource就可以从那里获取它的值。|4146746|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You can workaround it by the Selecting event on the SqlDataSource, i now how frustraiting is to be restricted in this kind of controls !!!

Another alternative would be to add a HiddenField to your form, and the SqlDataSource could take its value from there.

blocks|key|930388|text|这是VB版本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|930389|Dim+parameter+As+New+System.Web.UI.WebControls.Parameter("ClientID",+Data.DbType.Int32)
parameter.DefaultValue+=+45
sqlTicketInfo.SelectParameters.Add(parameter)|code-block|syntax|javascript|930390|在VB.NET版本中，无法实际设置该值，因此我改为设置默认值。如果值未初始化，则使用默认值，因此由于我们无法设置该值，因此无论如何它都会自动使用默认值。|930391|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here's the VB version:

<pre><code>Dim parameter As New System.Web.UI.WebControls.Parameter("ClientID", Data.DbType.Int32)
parameter.DefaultValue = 45
sqlTicketInfo.SelectParameters.Add(parameter)
</code></pre>

With the VB.NET version, there wasn't a way to actually set the value, so I set the default value instead. The default value gets used if the value isn't initialized, so since we can't set the value, it'll automatically use the default value anyways.

I'm trying to set the value of the <code>sqldatasource</code>'s <code>selectcommand</code> parameter <code>@ClientID</code> as in the code below, but it's not working out.
<h3>My code:</h3>
<pre><code>Dim strCommand = &quot;SELECT caller_id, phone, name, email FROM callers WHERE client_id=@ClientID&quot;

SqlDataSource2.SelectCommand = strCommand

SqlDataSource2.SelectParameters.Add(&quot;@ClientID&quot;, iClientID) 
</code></pre>
What am I doing wrong?

How can I set the sqldatasource parameter's value?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我尝试设置sqldatasource的selectcommand参数@ClientID的值，如下面的代码所示，但它不起作用。我的代码：Dim strCommand = "SELECT caller_id, phone, name, email FROM callers WHERE client_id=@ClientID"SqlDataSource2.SelectCommand = strComma

问如何设置sqldatasource参数的值？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何设置sqldatasource参数的值？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何设置sqldatasource参数的值？
EN