how can update multiple textbook values

Question

1.00/5 (1 vote)

See more:

i am retrieving that value in from load i want to update by click the update button

C#

SqlConnection cn;
     SqlDataAdapter da;
     cn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
     da = new SqlDataAdapter("select * from home", 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();
     TextBox6.Text = ds.Tables[0].Rows[2][2].ToString();
     TextBox7.Text = ds.Tables[0].Rows[3][1].ToString();
     TextBox8.Text = ds.Tables[0].Rows[3][2].ToString();

Posted 1-Sep-13 21:22pm

jitendra kachhi

Updated 2-Sep-13 18:59pm

Sushil Mate

v2

Add a Solution

Comments

abbaspirmoradi 2-Sep-13 3:33am

you should explain your problem. we can't Guess what you want!

jitendra kachhi 2-Sep-13 3:51am

i m displaying data in textbox through this code
SqlConnection cn;
SqlDataAdapter da;
cn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
da = new SqlDataAdapter("select * from home", 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();
TextBox6.Text = ds.Tables[0].Rows[2][2].ToString();
TextBox7.Text = ds.Tables[0].Rows[3][1].ToString();
TextBox8.Text = ds.Tables[0].Rows[3][2].ToString();

now i want to update all textbox values after click the button

Thomas ktg 2-Sep-13 3:34am

If you could give your question little more explained that would be well answered

syed shanu 2-Sep-13 3:38am

What is ur problem.As for now ur displaying all the data from database to ur textbox in formload can you paste your update button click code here so that we can help you.

jitendra kachhi 2-Sep-13 3:45am

i m displaying data in textbox through this code
SqlConnection cn;
SqlDataAdapter da;
cn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
da = new SqlDataAdapter("select * from home", 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();
TextBox6.Text = ds.Tables[0].Rows[2][2].ToString();
TextBox7.Text = ds.Tables[0].Rows[3][1].ToString();
TextBox8.Text = ds.Tables[0].Rows[3][2].ToString();

now i want to update all textbox values after click the button

abbaspirmoradi 2-Sep-13 3:55am

not clear! Are you want put this code into Button_click event?

jitendra kachhi 2-Sep-13 3:59am

i want to edit textbox values then update it

syed shanu 2-Sep-13 4:03am

whats ur problem in update same like select u write ur update query and match ur all textbox to column name and if there any where condition then use where condition
for ex update table1 set col1=textbox1.text,col2=textbox2.text and etc where
ur condition.

3 solutions

Solution 2

hi..
this is the sample code for update

C#

protected void Update_Click(object sender, EventArgs e)//TO UPDATE THE EDITED RECORD
       {
 SqlCommand cmd = new SqlCommand();
              con.Open();
 string strQuery = "UPDATE Country_master SET  [CountryCode]='" + txt_countrycode.Text + "', [CountryName]='" + txt_countryname.Text + "',[IsActive]=" + active + " WHERE CountryId=" + txt_countryid.Text + " ";
                cmd = new SqlCommand(strQuery, con);
                cmd.ExecuteNonQuery();

}

hope this helps you
Happy Coding :)

Posted 1-Sep-13 23:29pm

Priyanka Bhagwat

Comments

Herbisaurus 2-Sep-13 10:29am

5+!

Solution 3

Post the code that you posted in you question in a button click event..like

C#

protected void Update_Click(object sender, EventArgs e)
       {
        SqlConnection cn;
        SqlDataAdapter da;
        cn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
        da = new SqlDataAdapter("select * from home", 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();
        TextBox6.Text = ds.Tables[0].Rows[2][2].ToString();
        TextBox7.Text = ds.Tables[0].Rows[3][1].ToString();
        TextBox8.Text = ds.Tables[0].Rows[3][2].ToString()
       }

Posted 1-Sep-13 23:35pm

Sadique KT

Comments

jitendra kachhi 2-Sep-13 11:08am

i am displaying all values in textbox in my asp.page from my database.. now i want to some change on textbox values it should be update on database

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)

Thomas ktg · Accepted Answer · 2013-09-01T22:11:00

Write the update query to get the updated text from the textbox control
and pass the query to this method provided below. The method returns 1 when the command executes query successfully else it returns 0.

string query = "update tablename set col1=textname1,..... where condition";

C#

        public int ExecuteCommand(string query)
        {
            int RowsAffected = 0;
            cn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
            SqlCommand Command = null;
            try
            {
                Command = new SqlCommand(query, cn );
                RowsAffected = Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw new Exception(e.Message + "<br>" + query);
            }
            finally
            {
                Command.Dispose();
                Command = null;
                cn.Close();
                cn.Dispose();
            }
            return RowsAffected;
        }
</br>

how can update multiple textbook values

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us