ADO.NET DATAGRIDVIEW UPDATE

Bineesh Viswanath

Sir, I am doing a Program of ADO.NET SAVE, UPDATE and DELETE

My form's name is frmProduct.

I want your help in the update process.

here is my form;

I did the coding for functioning Save and View.

the data passes from gridView to textBox when I double click in gridView and text of button Save change to "Update".

and I need your help from here.

I am getting error"

here is the code I wrote in the SP class;

public void productEdit(productInfo infoProduct)
        {
            try
            {
                if (sqlCon.State == ConnectionState.Closed)
                {
                    sqlCon.Open();
                }
                SqlCommand sqlCmd = new SqlCommand("productEdit", sqlCon);
                sqlCmd.CommandType = CommandType.StoredProcedure;
                sqlCmd.Parameters.Add("@productId", SqlDbType.Decimal).Value = infoProduct.productId;
                sqlCmd.Parameters.Add("@productName", SqlDbType.NVarChar).Value = infoProduct.productName;
                sqlCmd.Parameters.Add("@purchaseRate", SqlDbType.Decimal).Value = infoProduct.purchaseRate;
                sqlCmd.Parameters.Add("@salesRate", SqlDbType.Decimal).Value = infoProduct.salesRate;
                int incount = sqlCmd.ExecuteNonQuery();
                if (incount > 0)
                {
                    MessageBox.Show("Update Successfully");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("PrSP04" + ex.Message);
            }
            finally
            {
                sqlCon.Close();
            }

        }

here the code I wrote in the button_click event

   private void btnSave_Click(object sender, EventArgs e)
        {
            productInfo infoproduct=new productInfo();
            productSP SpProduct=new productSP();
            infoproduct.productId = decProduct;
            infoproduct.productName = txtProductName.Text.ToString();
            infoproduct.purchaseRate = decimal.Parse(txtpurchaseRate.Text);
            infoproduct.salesRate = decimal.Parse(txtsalesReport.Text);
            if (btnSave.Text == "Save")
            {
             SpProduct.productAdd(infoproduct);

            }
            else
            {
             SpProduct.productEdit(infoproduct);

            }
            ProductgridFill();
            clearAll();

        }

please help me in this error

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
you need to assign the value of product id, how you are updating the product details?

Regards,
Iftikar
Bineesh Viswanath13y ago
This is the way I declared decProduct.

public partial class frmProduct : Form
    {
        decimal decProduct;
        public frmProduct()
        {
            InitializeComponent();
        }
Iftikar Hussain13y ago
how you are assigning the value of product id to decProduct Please share the code

Regards,
Iftikar
Bineesh Viswanath13y ago
I declared decProduct as decimal and assigned productId into it.

If you have any other method to update this form, please send me immediately
Iftikar Hussain13y ago
that means you are not passing the correct product id. From where you are assign the value

infoproduct.productId = decProduct;

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir, I still getting neither result or error.

I found that the value of productId is 0 when breakpoint came in it. see the form;

Please help me to get the result
Iftikar Hussain13y ago
I think you are not passing the correct product id. put the break point in below line and check the value

sqlCmd.Parameters.AddWithValue("@productId", infoProduct.productId);

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir,

I tried as per your suggestion.

see the code's value during execution of ProductEdit Function ;

The breakpoint not enterring to the messagebox as the value is Zero.
Iftikar Hussain13y ago
put the break point in below line and check the value

int incount = sqlCmd.ExecuteNonQuery();
                if (incount > 0)
                {
                    MessageBox.Show("Update Successfully");
                }

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir, I tried the code you gave, but either result not error.
Iftikar Hussain13y ago
your code is correct, try like this

SqlCommand sqlCmd = new SqlCommand("productEdit", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@productId", infoProduct.productId);
sqlCmd.Parameters.AddWithValue("@productName", infoProduct.productName);
sqlCmd.Parameters.AddWithValue("@purchaseRate", infoProduct.purchaseRate);
sqlCmd.Parameters.AddWithValue("@salesRate", infoProduct.salesRate);

Regards,
Iftikar
Bineesh Viswanath13y ago
Here the Stored procedure of productEdit

ALTER PROCEDURE productEdit
@productId numeric(18,0),
@productName nvarchar(20),
@purchaseRate numeric(18,0),
@salesRate numeric(18,0)

AS


UPDATE    tbl_Product
SET       productName =@productName, purchaseRate =@purchaseRate, salesRate =@salesRate where productId=@productId
Iftikar Hussain13y ago
I am asking database SP details

Regards,
Iftikar
Iftikar Hussain13y ago
Hi,
Please provide the SP details of productEdit

Regards,
Iftikar