ASP.NET

ASP.NET RSS

Inserting values into the database using a asp.net button click

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2008

Posts: 37

Reputation: kodingkarthik is an unknown quantity at this point

Solved Threads: 0

kodingkarthik kodingkarthik is offline

Offline

Light Poster

Inserting values into the database using a asp.net button click

Dec 15th, 2008

Hi all,

I am new to asp.net programming and i have to design a website which should accept values from the user and store it in the databse on a button click event.

I am not able to do it In fact i have written a code for button click the code is as follows:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Dim conn As New SqlConnection
        conn.ConnectionString = "data source=.\\SQLEXPRESS;initial catalog=HRDATA;integrated security=true"
        Dim cmd As New SqlCommand
        cmd.CommandText = "INSERT INTO Employee Data values ('" & txt_name.Text & "')"
        cmd.Connection = conn
        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()
Dim conn As New SqlConnection
        conn.ConnectionString = "data source=.\\SQLEXPRESS;initial catalog=HRDATA;integrated security=true"
        Dim cmd As New SqlCommand
        cmd.CommandText = "INSERT INTO Employee Data values ('" & txt_name.Text & "')"
        cmd.Connection = conn
        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()

the problem that i am facing is at
cmd.ExecuteNonQuery()
the error message i am getting is tht the ExecuteNonQuery is not initialized..

Thanks in advance ...
Karthik.

•

Join Date: Nov 2008

Posts: 63

Reputation: 4advanced is an unknown quantity at this point

Solved Threads: 10

4advanced

Offline

Junior Poster in Training

Re: Inserting values into the database using a asp.net button click

Dec 15th, 2008

Maybe cmd.CommandType needs to be stated as text.

•

Join Date: Dec 2006

Posts: 645

Reputation: binoj_daniel is an unknown quantity at this point

Solved Threads: 17

binoj_daniel binoj_daniel is offline

Offline

DaniWeb Expert

Re: Inserting values into the database using a asp.net button click

Dec 16th, 2008

try cmd.CommandType = CommandType.Text before

cmd.CommandText = "INSERT ...

Binoj Daniel
Best Place to hunt for Code | Quality Web Designing | Custom Software

•

Join Date: Dec 2008

Posts: 37

Reputation: kodingkarthik is an unknown quantity at this point

Solved Threads: 0

kodingkarthik kodingkarthik is offline

Offline

Light Poster

Re: Inserting values into the database using a asp.net button click

Dec 18th, 2008

Hi Dani,

Thanks for your reply and i have a new problem with the insert command that iam using please help me out

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
myCommand = New SqlCommand("Insert into Employee Data values(ddlid.selectedItem,'" & txtname.Text & "',ddldesig.selectedItem,'" & txtcontno & "')", "myConnection")
myCommand = New SqlCommand("Insert into Employee Data values(ddlid.selectedItem,'" & txtname.Text & "',ddldesig.selectedItem,'" & txtcontno & "')", "myConnection")

Whats wrong with my insert command that i am using in my code...

Thanks in advance
Karthik.

•

Join Date: Dec 2008

Posts: 104

Reputation: Aneesh_Argent is an unknown quantity at this point

Solved Threads: 18

Aneesh_Argent Aneesh_Argent is offline

Offline

Junior Poster

Re: Inserting values into the database using a asp.net button click

Dec 18th, 2008

Try this :
DdlId.SelectedItem.Text;

•

Join Date: Aug 2007

Posts: 173

Reputation: Kusno is an unknown quantity at this point

Solved Threads: 13

Kusno

Offline

Junior Poster

Re: Inserting values into the database using a asp.net button click

Dec 19th, 2008

Hi, you still forgot for DropDownList

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
myCommand = New SqlCommand("Insert into Employee Data values('" & ddlid.selectedItem & "','" & txtname.Text & "','" & ddldesig.selectedItem & "','" & txtcontno.Text & "')", "myConnection")
myCommand = New SqlCommand("Insert into Employee Data values('" & ddlid.selectedItem & "','" & txtname.Text & "','" & ddldesig.selectedItem & "','" & txtcontno.Text & "')", "myConnection")

Last edited by peter_budo; Dec 21st, 2008 at 4:55 am. Reason: Please, either use [code] or [code=asp.net] (or other langiage as necessary). DO NOT USE [QUOTE]

NEVER NEVER NEVER GIVE UP