Click here to Skip to main content
15,920,438 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: JavaScript function in onload event Pin
Kschuler23-Mar-07 4:28
Kschuler23-Mar-07 4:28 
Questioni need name of the month Pin
sooreeagt22-Mar-07 20:44
sooreeagt22-Mar-07 20:44 
AnswerRe: i need name of the month Pin
Kunal P22-Mar-07 21:15
Kunal P22-Mar-07 21:15 
AnswerRe: i need name of the month Pin
Sandeep Akhare22-Mar-07 22:00
Sandeep Akhare22-Mar-07 22:00 
AnswerRe: i need name of the month Pin
joon vh.23-Mar-07 3:47
joon vh.23-Mar-07 3:47 
QuestionPositioning data from sql database on multiple pages Pin
Dragoslav Zaric22-Mar-07 20:30
Dragoslav Zaric22-Mar-07 20:30 
AnswerRe: Positioning data from sql database on multiple pages Pin
Naveed Kamboh26-Mar-07 4:40
Naveed Kamboh26-Mar-07 4:40 
Questionhelp debug pls i dont see anything wrong wit my sql statement Pin
neodeaths22-Mar-07 20:28
neodeaths22-Mar-07 20:28 
hi guys below is the code i have in a button that i am trying to make it create a new record in the targeted table

so far it keep givin me this error

Incorrect syntax near 'Name'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'Name'.



 string cs = WebConfigurationManager.ConnectionStrings["HASDBConnectionString1"].ConnectionString;<br />
        string insertbidder = "INSERT Bidder " + "(NRIC, First Name, Last Name, "<br />
        + "Company, Address, ContactNumber, Comments)"<br />
        + "VALUES(@NRIC, @First_Name, @Last_Name, @Company, @Address, @ContactNumber, @Comment)";<br />
<br />
        SqlConnection con = new SqlConnection(cs);<br />
        SqlCommand cmd = new SqlCommand(insertbidder, con);<br />
<br />
         <br />
        cmd.Parameters.AddWithValue("NRIC",txtnric.Text);<br />
        cmd.Parameters.AddWithValue("First_Name",txtFirstname.Text);<br />
        cmd.Parameters.AddWithValue("Last_Name", txtlastname.Text);<br />
        cmd.Parameters.AddWithValue("Company",txtcompany.Text);<br />
        cmd.Parameters.AddWithValue("Address",txtaddress.Text);<br />
        cmd.Parameters.AddWithValue("ContactNumber", txtcontactnumber.Text);<br />
        cmd.Parameters.AddWithValue("Comment", txtcomment.Text);<br />
        con.Open();<br />
        cmd.ExecuteNonQuery();

AnswerRe: help debug pls i dont see anything wrong wit my sql statement Pin
jithbiz003322-Mar-07 22:37
jithbiz003322-Mar-07 22:37 
GeneralRe: help debug pls i dont see anything wrong wit my sql statement [modified] Pin
GaryWoodfine 23-Mar-07 1:45
professionalGaryWoodfine 23-Mar-07 1:45 
Questionhow to make Select One Option bydefault in dropdownlistbox programmatically Pin
mohd imran abdul aziz22-Mar-07 19:19
mohd imran abdul aziz22-Mar-07 19:19 
AnswerRe: how to make Select One Option bydefault in dropdownlistbox programmatically Pin
Sandeep Akhare22-Mar-07 20:49
Sandeep Akhare22-Mar-07 20:49 
Questionhelp to retrieve values from an Xml Node. Pin
samR922-Mar-07 19:07
samR922-Mar-07 19:07 
AnswerRe: help to retrieve values from an Xml Node. Pin
Sandeep Akhare22-Mar-07 21:48
Sandeep Akhare22-Mar-07 21:48 
Questionupdate gridview checkbox when popup window close Pin
szewanng22-Mar-07 17:37
szewanng22-Mar-07 17:37 
AnswerRe: update gridview checkbox when popup window close Pin
N a v a n e e t h22-Mar-07 18:15
N a v a n e e t h22-Mar-07 18:15 
GeneralRe: update gridview checkbox when popup window close Pin
szewanng22-Mar-07 18:17
szewanng22-Mar-07 18:17 
QuestionASP.Net ReportViewer set width to reportviewer control width?? Pin
PhrankBooth22-Mar-07 13:15
PhrankBooth22-Mar-07 13:15 
AnswerRe: ASP.Net ReportViewer set width to reportviewer control width?? Pin
Frank Kerrigan23-Mar-07 8:36
Frank Kerrigan23-Mar-07 8:36 
GeneralRe: ASP.Net ReportViewer set width to reportviewer control width?? Pin
PhrankBooth23-Mar-07 15:50
PhrankBooth23-Mar-07 15:50 
AnswerRe: ASP.Net ReportViewer set width to reportviewer control width?? Pin
PhrankBooth24-Mar-07 2:47
PhrankBooth24-Mar-07 2:47 
QuestionDatalist default message Pin
GaryWoodfine 22-Mar-07 8:22
professionalGaryWoodfine 22-Mar-07 8:22 
AnswerRe: Datalist default message Pin
RichardGrimmer23-Mar-07 6:36
RichardGrimmer23-Mar-07 6:36 
Questionprint button. Pin
Kunal P22-Mar-07 7:17
Kunal P22-Mar-07 7:17 
AnswerRe: print button. Pin
kubben22-Mar-07 13:02
kubben22-Mar-07 13:02 

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.