how can update textbox values in database

Question

0.00/5 (No votes)

See more:

i retrieving database values in textbox in page load

C#

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("select * from Employee", cn);
DataSet ds = new DataSet();
da.Fill(ds);
TextBox1.Text = ds.Tables[0].Rows[0][1].ToString();
TextBox2.Text = ds.Tables[0].Rows[0][2].ToString();
TextBox3.Text = ds.Tables[0].Rows[1][1].ToString();
TextBox4.Text = ds.Tables[0].Rows[1][2].ToString();
TextBox5.Text = ds.Tables[0].Rows[2][1].ToString();

it will show the database values in textbox. now i want to edit textbox text and after click the update button databsae table should be update .
please help me

Posted 2-Sep-13 8:33am

jitendra kachhi

Updated 2-Sep-13 10:27am

ridoy

v3

Add a Solution

Comments

OriginalGriff 2-Sep-13 14:54pm

And what part of this is giving you problems? What have you tried? Where are you stuck?
What help do you need?

[no name] 2-Sep-13 15:01pm

If your goal is to update the database why don't you show us that code instead of this code that has nothing to do with what you are trying to accomplish?

4 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)

cocis48 · Answer 1 · 2013-09-02T08:56:00

Please use Data binding for a better approach, or create a new SQL command for update, and pass all your textboxes values to the command and call execute update like this:

C#

public bool ExecuteCommand ()
{
   using (sqlConnection)
   {
      try
      {
         sqlConnection.Open();
         using (var sqlCommand = new SqlCommand(CommandText, sqlConnection))
         {
             sqlCommand.CommandText = 'your update cmd';
             
             sqlCommand.ExecuteNonQuery()
         }
      }
      catch (Exception)
      {
         //Handle Exception Here
      }

   }
}

ridoy · Answer 2 · 2013-09-02T10:31:00

Solution 2

Follow question ans answer of this thread carefully:
How to display data from database into textbox, and update it[^]

Posted 2-Sep-13 10:31am

ridoy

Member 10186638 · Answer 3 · 2013-09-02T17:18:00

Write Update function for your textbox value like

C#

public int update_Record()
       {
           DB_Connection();
           int i;
           string QRY = "UPDATE personalInfo_Master SET village='" + Village + "', taluka='" + Taluka + "',dist='" + District + "',state='" + State + "'WHERE name='" + Name + "'";
           SqlCommand CMD = new SqlCommand(QRY, con);
           i = CMD.ExecuteNonQuery();
           return i;
       }

Rakesh Meel · Answer 4 · 2013-09-02T19:49:00

Solution 4

you can visit on belowing page for More Details of your question on code project. That one also ask same as you

Save data from textbox to database[^]

Posted 2-Sep-13 19:49pm

Rakesh Meel

how can update textbox values in database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0