Tagged Questions
0
votes
3answers
943 views
Using C# SQL Parameterization on Column Names
I'm having a problem. I want this to work, but it doesn't:
SqlDataSource.SelectCommand = "SELECT blah1, blah2 FROM myTable WHERE @ColumnName = @Value";
...
1
vote
3answers
9k views
GridView RowUpdating SqlDataSource.Update from CodeBehind
So I am having an issue with doing an update in a Gridview during an OnRowUpdating event.
What I am trying to do is set the UpdateCommand in an SqlDataSource then update using that command. The ...
0
votes
1answer
131 views
Can I use connection pooling with SQLDatasource?
After reading documentation about Connection Pooling, I learned that ADO.NET uses Connection pooling by default. But the application that I am working with using SQLDatasource and I wonder if I can ...
0
votes
3answers
1k views
SqlDataSource Timeout. OK in Management Studio
In code that I inherited, I have a SqlDataSource that has a fairly complex select statement that for certain SelectParameters, always times out ("Timeout expired. The timeout period elapsed prior to ...
