Link C# SqlCommand to the SelectCommand of SqlDataSource on aspx page

Question

Since I want to include a session variable in MySql select statement, I want to be able to write a sql string select statement in .cs page and reference it in the SelectCommand property in the SqlDataSource on the .aspx page.

How do I achieve that?

Anthony Pegram · Accepted Answer · 2011-12-20 21:56:52Z

2

SqlDataSource accepts Session parameters: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sessionparameter.aspx. Use it instead.

edited Dec 20, 2011 at 21:56

Anthony Pegram

128k28 gold badges229 silver badges252 bronze badges

answered Dec 2, 2011 at 20:58

IUnknown

22.5k4 gold badges41 silver badges71 bronze badges

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

4 Comments

IUnknown Over a year ago

@JonH, just check his questions one by one. Specially for you I'm renew my remark.

JonH Over a year ago

@YuriyRozhovetskiy - my mistake - the new user page as has been discussed in meta is confusing by all means. It is busy and chock full of text it is hard to understand what all the 0's were. The 0's were for votes, you have to actually click the questions tab to see they were answered. I really like the old design better, everything at one glance. Too much going on in the new page.

user47589 Over a year ago

@JonH, incorrect. All of his previous questions have answers. If you click the 'View More' link in the profile summary it takes you to the full listing. See here

JonH Over a year ago

@Inuyasha - please read my comment Inuyasha that was posted 3 hours before yours...please see that it says "My mistake...". Please read before you post.

Collectives™ on Stack Overflow

Link C# SqlCommand to the SelectCommand of SqlDataSource on aspx page

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related