data updated twice in web service

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gopichandran
    New Member
    • Dec 2011
    • 1

    data updated twice in web service

    data updated twice in web service


    [WebMethod]
    public string updateMQuantity Sales(string ProductCode, int Quantity)
    {
    con.Open();
    cmd=new SqlCommand ("update tblInventory set Quantity = (Quantity + @Quantity) where ProductCode = @ProductCode",c on);
    cmd.Parameters. AddWithValue("@ ProductCode", ProductCode);
    cmd.Parameters. AddWithValue("@ Quantity",Quant ity);
    sda = new SqlDataAdapter( cmd);
    DataSet ds = new DataSet();
    sda.Fill(ds);
    return ds.GetXml();

    }
Working...