how to update database contents through text boxes in asp.net

Question

0.00/5 (No votes)

See more:

ASP.NET

Posted 17-Oct-12 20:58pm

WebMaster

Updated 17-Oct-12 21:30pm

MT_

v4

Add a Solution

Comments

OriginalGriff 18-Oct-12 3:03am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Somewhere in your code you are using a variable that contains a null - without the relevant code fragment, we can't even begin to guess. If you look at the error message, it should give you a file and a line number - we would need to see the line and some small amount of code round it for context.
Use the "Improve question" widget to edit your question and provide better information.

manak chand 18-Oct-12 3:44am

please elborate the scenario..

Anele Ngqandu 18-Oct-12 4:06am

What database you using?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mukesh_Chauhan · Answer 1 · 2012-10-17T21:00:00

Solution 1

you need to use new keyword while declaring object.

Posted 17-Oct-12 21:00pm

Mukesh_Chauhan

Comments

MT_ 18-Oct-12 3:21am

Can you please elaborate your answer a bit more?

WebMaster · Answer 2 · 2012-10-17T21:03:00

C#

SqlConnection myconn;
            //SqlConnection mycomm;
            myconn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + Server.MapPath("~\\App_Data\\bhaddal.mdf") + " ;Integrated Security=True;User Instance=True");
            myconn.Open();
            //string q;

            SqlConnection myConn = new SqlConnection(myconn.ConnectionString);

            s= WebConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;

          myconn = new SqlConnection(s);
            myconn.Open();
            cmd = new SqlCommand("update Employee set first='" + TextBox1.Text+ "', secound='" + TextBox2 + "', third='" + TextBox3.Text + "', fourth='" + TextBox5.Text + "', fifth='"  + "' rollno='" + TextBox1.Text + "'", myconn);
            cmd.ExecuteNonQuery();
            //Label1.Text = " Record Updated successfully";
         clearData();

Mukesh_Chauhan · Answer 3 · 2012-10-17T21:25:00

Solution 3

Dim object As New MyClass()

example:

VB

Dim cmd As SqlCommand
            cmd = New SqlCommand(sSql, Conn, transaction)

Posted 17-Oct-12 21:25pm

Mukesh_Chauhan

how to update database contents through text boxes in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us