{"Input string was not in a correct format."}

Question

protected void UpdateCustomer(object sender, GridViewUpdateEventArgs e)
{
    string CustomerID = ((Label)GridView1.Rows[e.RowIndex]
                        .FindControl("lblCustomerID")).Text;
    string Name = ((TextBox)GridView1.Rows[e.RowIndex]
                        .FindControl("txtContactName")).Text;
    string Company = ((TextBox)GridView1.Rows[e.RowIndex]
                        .FindControl("txtCompany")).Text;
    MySqlConnection con = new MySqlConnection();
    string Connection = "Server=localhost;" +
    "DATABASE=northwind2007;" + "username=;" +
    "PASSWORD=;";
    con.ConnectionString = Connection;
    MySqlCommand cmd = new MySqlCommand();
    cmd = new MySqlCommand(cmd.CommandText, con);
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "update Customers set FirstName=@ContactName," +
     "Company=@CompanyName where ID=@CustomerID;" + "select ID,FirstName,Company from Customers";
    cmd.Parameters.AddWithValue("@CustomerID", MySqlDbType.VarChar).Value = CustomerID;
    cmd.Parameters.AddWithValue("@ContactName", MySqlDbType.VarChar).Value = Name;
    cmd.Parameters.AddWithValue("@CompanyName", MySqlDbType.VarChar).Value = Company;
    GridView1.EditIndex = -1;
    MySqlDataAdapter da = new MySqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

i have tried everything but its now working out , everytime i try to update a record from my grid it throws this error.

On which line exactly? Your question is unclear. – Soner Gönül Sep 12 '14 at 10:46 — Soner Gönül, Sep 12 '14 at 10:46
@SonerGönül at da.Fill(dt); – Zeeshan Rizvi Sep 12 '14 at 10:58 — Zeeshan Rizvi, Sep 12 '14 at 10:58
@RowlandShaw No I just named it that one. – Zeeshan Rizvi Sep 12 '14 at 10:59 — Zeeshan Rizvi, Sep 12 '14 at 10:59

Tim Schmelter · Accepted Answer · 2014-09-12T12:23:54.660

3

Don't use AddWithValue but Add:

cmd.Parameters.Add("@CustomerID", MySqlDbType.VarChar).Value = CustomerID;

otherwise MySqlDbType.VarChar is treated as the value.

You should also execute the update-command and you need to Open the connection:

con.Open();
int updatedRecords = cmd.ExecuteNonQuery();

If you want to fill the table afterwards you could use the DataAdapter:

using(var da = new MySqlDataAdapter("select ID,FirstName,Company from Customers", con))
    da.Fill(dt);

Note that you should always use the using-statement to ensure that any unmanaged resource will be disposed and the connection gets closed (even on error). For example:

using(var con = new MySqlConnection())
using(var cmd =  new MySqlCommand("UPDATE ...", con))
{
    con.Open();
    cmd.ExecuteNonQuery();
}

edited Sep 12 '14 at 12:23

answered Sep 12 '14 at 10:48

Tim Schmelter

450,073
74
686
939

now it's not throwing any error but it is not updating the record. – Zeeshan Rizvi Sep 12 '14 at 10:59
@ZeeshanRizvi:i have edited my answer. But please include a more explanatory description of your problem. – Tim Schmelter Sep 12 '14 at 11:00
I've Dont That Too , Not Updating The Records Still – Zeeshan Rizvi Sep 12 '14 at 12:20
@ZeeshanRizvi: you have to open the connection, edited my answer again. Use the debugger next time to see which exceptions are thrown. – Tim Schmelter Sep 12 '14 at 12:24
It is throwing an exception that parameter key cannot be null. – Zeeshan Rizvi Sep 13 '14 at 06:26

{"Input string was not in a correct format."}

1 Answers1