Update Sql database via editing Textbox C#

Question

I've got a Winform that update a SQL database by editing the two TextBox Product Name and Product cost, However it doesn't update the database, here is my sample code

     private void simpleButton5_Click(object sender, EventArgs e)
    {
        string id = comboBox2.Items[comboBox2.SelectedIndex].ToString();
        string name = txtProdName.Text;
        string cost = txtProductCost.Text;
        cn.Open();

        string query = "UPDATE [Product1] SET [Product_Name]= @Product_Name,[Product_Cost]= @Product_Cost where [Product_ID]= @Product_ID";
        SqlCommand cmd = new SqlCommand(query, cn);
        cmd.Parameters.AddWithValue("@Product_ID", id);
        cmd.Parameters.AddWithValue("@Product_Name", name);
        cmd.Parameters.AddWithValue("@Product_Price", cost);
        try
        {
            cmd.ExecuteNonQuery();
            MessageBox.Show("Update Succesfully");
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
        cn.Close();

    }

The datatype of id is char, Product_Name is nvarchar(50), Porduct_Cost is bigint. Any thoughts I would appreciated

what's the error msg u r getting and your cost in database is having double or int datatype. — Rahul
– Rahul, Commented Apr 25, 2013 at 11:50
put your senstive code inside Try, if u r not getting any error then there must be conversion error because your conversion part is outside the try,put it in inside try block for exect exception plz. — Rahul
– Rahul, Commented Apr 25, 2013 at 12:04

Rahul · Accepted Answer · 2013-04-25 12:01:06Z

1

It seems that you have a error in conversion, If your cost field in database is bigint then convert

string cost = txtProductCost.Text

to

Int64 cost = Convert.Toint64(txtProductCost.Text);

Int64 maps directly to BigInt.

Or if it is Double then convert

string cost = txtProductCost.Text

to

Double cost = Convert.ToDouble(txtProductCost.Text);

Hope it works for you.

edited Apr 25, 2013 at 12:01

answered Apr 25, 2013 at 11:55

Rahul

5,6556 gold badges38 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rahul Over a year ago

if u r using Bigint then use Convert.Toint64 instead of Convert.Toint32

Linga · Accepted Answer · 2013-04-25 11:47:29Z

0

First, Convert the string value into int

string cost = txtProductCost.Text;
costval=int.Parse(cost)// costval is integer

Next, update the database

cmd.Parameters.AddWithValue("@Product_Price", costval);

answered Apr 25, 2013 at 11:47

Linga

10.6k10 gold badges57 silver badges109 bronze badges

3 Comments

user2102572 Over a year ago

it gives me an Exception "Input string was not in a correct format."

user2102572 Over a year ago

I think cause it's bigInteger not int

user3221822 Over a year ago

In fact if you are using AddWithValue, you don't exclipitly convert that to an int value, because it will automatically be converted and inserted as well;)

Collectives™ on Stack Overflow

Update Sql database via editing Textbox C#

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related