insert into a DATABASE

Expand Post »

hi i am using visual studio 2008 express edition. i have created a database in sql ( add new item > sql database). the db has 2 fields uname and upwd.
have also created a web page in asp.net that has 2 text boxes (textbox1,textbox2) and a command button (cmdbutton1). i want to insert the values entered by the user into the database that ive created on the click event of the button..Please provide me the code to do thye above mentioned..

Regards,
Bharat Shivram

Similar Threads

insert values to mysql database in JSP
MSSql 2000 Unable to insert into database in MS SQL
database update using excell in Windows NT / 2000 / XP
Please help(Problem in insertion data to database) in JSP
insert database in ColdFusion

bharatshivram

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

35 posts
since Mar 2007

Permalink

Oct 20th, 2008

Re: insert into a DATABASE

using System;
using System.Data;
using System.Data.SqlClient;

string sConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost;";

SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();

string sSQL = "INSERT INTO Users (uname,upwd) VALUES ('" + textbox1.Text + "','" + textbox2.Text + "')";
SqlCommand objCmd = new SqlCommand(sSQL,objConn);
objCmd.ExecuteNonQuery();

reena12

Reputation Points: 12

Solved Threads: 4

Light Poster

Offline

32 posts
since Oct 2008

Permalink

Oct 20th, 2008

Re: insert into a DATABASE

thanx a lot.. worked fine..

bharatshivram

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

35 posts
since Mar 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Update/Insert/Delete records based on user one or more selections in list box control

Next Thread in ASP.NET Forum Timeline: Defalut page for website not getting accessed

DaniWeb Message

Cancel Changes

User Name
Password