Click here to Skip to main content
15,885,309 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: 403(The website declined to show this webpage) Error - WebConfig Authorization - Need to redirect to login Pin
De_Novice28-Mar-11 12:10
De_Novice28-Mar-11 12:10 
GeneralRe: 403(The website declined to show this webpage) Error - WebConfig Authorization - Need to redirect to login Pin
De_Novice28-Mar-11 12:16
De_Novice28-Mar-11 12:16 
GeneralRe: 403(The website declined to show this webpage) Error - WebConfig Authorization - Need to redirect to login Pin
Not Active28-Mar-11 18:05
mentorNot Active28-Mar-11 18:05 
QuestionInvalid column Pin
Paresh146228-Mar-11 6:03
Paresh146228-Mar-11 6:03 
AnswerRe: Invalid column Pin
Not Active28-Mar-11 6:25
mentorNot Active28-Mar-11 6:25 
AnswerRe: Invalid column Pin
GenJerDan28-Mar-11 6:29
GenJerDan28-Mar-11 6:29 
AnswerRe: Invalid column Pin
Pete O'Hanlon28-Mar-11 6:41
mvePete O'Hanlon28-Mar-11 6:41 
AnswerRe: Invalid column Pin
Wendelius28-Mar-11 11:38
mentorWendelius28-Mar-11 11:38 
As already pointed out, use parameters: SqlParameter[^].

But if you still for some reason want to use literals in SQL statements, add apostrophes when you're adding texts to the statement:
chk1 = "select Sno from Student where SID = '"+ @smemno.Text.ToString() + "'";

The need to optimize rises from a bad design.My articles[^]

QuestionHow Gridview Data Export in Excel File in ADO.Net C# on Button Event. Pin
Mohit327-Mar-11 20:58
Mohit327-Mar-11 20:58 
AnswerRe: How Gridview Data Export in Excel File in ADO.Net C# on Button Event. Pin
Keith Barrow28-Mar-11 2:38
professionalKeith Barrow28-Mar-11 2:38 
AnswerRe: How Gridview Data Export in Excel File in ADO.Net C# on Button Event. Pin
thatraja28-Mar-11 20:38
professionalthatraja28-Mar-11 20:38 
Question[SOLVED] How can i do this? Pin
msqar27-Mar-11 14:14
msqar27-Mar-11 14:14 
AnswerRe: How can i do this? Pin
Expert Coming27-Mar-11 19:24
Expert Coming27-Mar-11 19:24 
GeneralRe: How can i do this? Pin
msqar28-Mar-11 1:14
msqar28-Mar-11 1:14 
AnswerRe: How can i do this? Pin
Not Active28-Mar-11 1:22
mentorNot Active28-Mar-11 1:22 
GeneralRe: How can i do this? Pin
msqar28-Mar-11 1:28
msqar28-Mar-11 1:28 
GeneralRe: How can i do this? Pin
Not Active28-Mar-11 2:19
mentorNot Active28-Mar-11 2:19 
GeneralRe: How can i do this? Pin
msqar28-Mar-11 2:37
msqar28-Mar-11 2:37 
Question[SOLVED] navigation takes too long Pin
msqar27-Mar-11 10:22
msqar27-Mar-11 10:22 
AnswerRe: navigation takes too long Pin
Expert Coming27-Mar-11 19:28
Expert Coming27-Mar-11 19:28 
GeneralRe: navigation takes too long Pin
msqar28-Mar-11 8:55
msqar28-Mar-11 8:55 
GeneralRe: navigation takes too long Pin
msqar28-Mar-11 9:27
msqar28-Mar-11 9:27 
GeneralRe: navigation takes too long Pin
gavindon28-Mar-11 10:00
gavindon28-Mar-11 10:00 
GeneralRe: navigation takes too long Pin
msqar28-Mar-11 10:06
msqar28-Mar-11 10:06 
GeneralRe: navigation takes too long Pin
gavindon28-Mar-11 10:14
gavindon28-Mar-11 10:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.