views:

28

answers:

0

Hi Using webservice method I wanted to insert multiple row in database table. Though I am passing more than one row its inserting only one row. Could somebody please help me how can do this. And one more after inserting the records I wanted clear the datagrid cell but that is also not working… Here is my code:

        // Create a sales backorder line to specify the backordered item
        SalesBackorderLine salesBackorderLine = new SalesBackorderLine();

         // Create an item key
        ItemKey itemKey = new ItemKey();           

        itemKey.Id = itemnumber;          

        // Populate the item key property of the sales invoice line object
        salesBackorderLine.ItemKey = itemKey;

        // Create a sales backorder quantity object
        Quantity backorderCount = new Quantity();
        backorderCount.Value =Convert.ToDecimal(quantity);

        // Populate the quantity of the sales backorder line object
        salesBackorderLine.Quantity = backorderCount;


        // Create an array of sales backorder objects
        // Initialize the array with the sales backorder line object
        SalesBackorderLine[] backorderLines = { salesBackorderLine };
        // Add the sales backorder line array to the sales backorder object
        salesBackorder.Lines = backorderLines;

        try
        {
            // Get the create policy for sales backorder objects
            salesBackorderCreatePolicy = wsDynamicsGP.GetPolicyByOperation("CreateSalesBackorder", context);

            // Create the sales backorder
            wsDynamicsGP.CreateSalesBackorder(salesBackorder, context, salesBackorderCreatePolicy);
            txtBatchId.Text = string.Empty;
            txtCustId.Text = string.Empty;           


   //this code not clearing the datagrid also…..
            for (int i = 0; i <= CreateSalesBackOrderGrid.Rows.Count - 1; i++)   
            {
                CreateSalesBackOrderGrid.Rows[i].Cells.Clear();
            }

        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message.ToString());
        }

    }