All Questions
Tagged with sqldatasource sql-server-2005
6 questions
0
votes
1
answer
103
views
How to stop Visual Studio Query Builder from re-writing SQL (VS2005)
I simply paste this SQL code that I've carefully crafted in SQL Server Management Studio and it works.
SELECT v.StudentID, v.StudentName, s.StudentHomeEmailAddress, s.StudentStudyYear, s....
- 4,937
0
votes
1
answer
61
views
whats wrong in this update statement :?
whats wrong in this update statement :
declare @s1from datetime
UPDATE Table1 SET Product = @Product , fare = @fare, s1from = convert(datetime,convert(datetime,@s1from,103),120)
- 1
3
votes
2
answers
2k
views
String data getting truncated when fetching through sql datareader
I am using a datareader to fetch a table's record values through a stored proc.
but while using datareader.getstring(2) to fetch the value of the particular column, the string returned is truncated ( ...
- 41
0
votes
1
answer
756
views
Problem with ASP Repeater and SQL Data Source
Here's my data table in my SQL DB, and below that is the code for my Repeater control:
ArticleID int NOT NULL,
ArticleTitle varchar(100) NOT NULL,
ArticleCategory int NOT NULL,
ArticleDate datetime ...
- 8,266
0
votes
2
answers
2k
views
Getting the parameter values being passed to SQL database via SQLDataSource control
I am debugging code written by a previous developer :-)
I have a SQLDataSource control that is calling a database stored procedure, and passing quite a large number of paramaters, and the stored ...
- 4,807
1
vote
1
answer
2k
views
SQLDatasource CommandTimeout not working
Good day,
I'm using a SQLDataSource with a dynamic query generated c#, based on user choices in many fields. However, since our tables are very large, sometimes, I get a command timeout exception.
...
- 355