Passing Parameters for SqlDataSource from code behind

Question

whats the diffrence btw this two SqlDataSource1?

<SelectParameters>
                <asp:Parameter Name="user"  />

</SelectParameters>

SqlDataSource1.SelectParameters("user").DefaultValue = "some value";

SqlDataSource1.SelectParameters("@param",user);

When i use

SqlDataSource1.SelectParameters("user").DefaultValue = "some value";

it works but SqlDataSource1.SelectParameters("@param",user); doesn't:

@ninjacoder - you're mixing vb syntax with that of C#, tag your question with either of the language along with the current tag — Mubarek
– Mubarek, Commented Feb 9, 2012 at 8:48

Mubarek · Accepted Answer · 2012-02-09 12:51:25Z

3

In the selecting event of the SqlDataSource control pass the value to the to the parameter:

 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
  {
   e.Command.Parameters["@user"].Value="value";
  }

edited Feb 9, 2012 at 12:51

answered Feb 9, 2012 at 8:43

Mubarek

2,6891 gold badge17 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

naijacoder Over a year ago

Thanks nuux do i need to add this too <SelectParameters> <asp:Parameter Name="user" /> </SelectParameters>

Mubarek Over a year ago

ofcourse yes, you need it to add to the SqlDataSource control as you did it already I think

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

I think you should use smth. like this:
SqlDataSource1.SelectParameters.Add("@param",user);

that has some overloads.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 9, 2012 at 8:13

Dana Addler

9838 silver badges4 bronze badges

Collectives™ on Stack Overflow

Passing Parameters for SqlDataSource from code behind

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related