•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 423,340 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 5,172 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 410 | Replies: 1
 |
•
•
Join Date: Jun 2008
Posts: 25
Reputation: 
Rep Power: 1
Solved Threads: 0
Light Poster
Hi,
Im using ASP.NET with back end as SQL Server. Im using VB language coding. here if in insert button im writing coding like this...
[ com = new SqlCommand("insert into emp values(" & Textbox1.Text & ", ' " & Textbox2.Text & " ', " & Textbox3.Text & " ", con) ]
[ con.Open() ]
[ com.ExecuteNonQuery() ]
[ Response.write " One record inserted " ]
here textbox1 and 3 contains onlu numeric values. and textbox2 has string value.
con is Sqlconnection. and com is SqlCommand declared in page load. i donno whats wrong with this?
Im using ASP.NET with back end as SQL Server. Im using VB language coding. here if in insert button im writing coding like this...
[ com = new SqlCommand("insert into emp values(" & Textbox1.Text & ", ' " & Textbox2.Text & " ', " & Textbox3.Text & " ", con) ]
[ con.Open() ]
[ com.ExecuteNonQuery() ]
[ Response.write " One record inserted " ]
here textbox1 and 3 contains onlu numeric values. and textbox2 has string value.
con is Sqlconnection. and com is SqlCommand declared in page load. i donno whats wrong with this?
•
•
Join Date: Oct 2006
Location: India
Posts: 125
Reputation:
Rep Power: 2
Solved Threads: 11
Junior Poster
The statement
has to come before
This got to make it work.
•
•
•
•
con.Open()
•
•
•
•
com = new SqlCommand("insert into emp values(" & Textbox1.Text & ", ' " & Textbox2.Text & " ', " & Textbox3.Text & " ", con)
This got to make it work.
Michelangelo
"The best place to find a helping hand is at the end of your own arm"
"The best place to find a helping hand is at the end of your own arm"
|
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Other Threads in the ASP.NET Forum
- Previous Thread: Updated : Simple ASP.Net Login Page
- Next Thread: pop up window or msg box in asp.net2.0 with c#
