Insert multiple rows data from gridview to database

See more:

C#

Hello Sir,
I want to insert multiple rows data from gridview to database for this I m using xml table please help me in my code

protected void btnSaved_Click(object sender, EventArgs e)
    {
        try
        {
            string strXml = String.Empty;
            DelayworkReport Dwr = new DelayworkReport();
            //DataTable _dtFinalCh = new DataTable();
            DataTable _dtFinal = new DataTable();
            acceptchangesonVirtualtableBeforeInsert();
            _dtFinal = (DataTable)ViewState["dt"];
           // DataTable _dtfinaldata = _dtFinal.AsEnumerable().Distinct().CopyToDataTable();
            if (_dtFinal != null && _dtFinal.Rows.Count > 0)
            {
                DataSet ds = new DataSet();
                ds.DataSetName = "DWR";
                ds.Tables.Add(_dtFinal);
                ds.Tables[0].TableName = "Insertxml";
                strXml = ds.GetXml();
            }
           
            grdNewDaily.DataSource = dt;
            grdNewDaily.DataBind();
        }
        catch { }

    }

private void acceptchangesonVirtualtableBeforeInsert()
    {
        try
        {
            DataTable dt = new DataTable();
            dt = (DataTable)ViewState["dtfinal"];
            int count = 0;
            foreach (GridViewRow gr in grdDaily.Rows)
            {
                //string bindProjectCost = gr.Cells[4].Text;

                TextBox txtStartTime = (TextBox)gr.FindControl("txtStartTime");
                TextBox txtEndTime = (TextBox)gr.FindControl("txtEndTime");
                DropDownList ddlProject = (DropDownList)gr.FindControl("ddlProject");
                DropDownList ddlModule = (DropDownList)gr.FindControl("ddlModule");
                DropDownList ddlForm = (DropDownList)gr.FindControl("ddlForm");
                TextBox txtWorkType = (TextBox)gr.FindControl("txtWorkType");
                DropDownList ddlStatus = (DropDownList)gr.FindControl("ddlStatus");
                TextBox txtRemarks = (TextBox)gr.FindControl("txtRemarks");

                dt.Rows[count]["StartTime"] = Convert.ToString(txtStartTime.Text);
                dt.Rows[count]["EndTime"] = Convert.ToString(txtEndTime.Text);
                dt.Rows[count]["ProjectName"] = Convert.ToInt32(ddlProject.SelectedItem.Text);
                dt.Rows[count]["ModuleName"] = Convert.ToInt32(ddlModule.SelectedItem.Text);
                dt.Rows[count]["EntityName"] = Convert.ToInt32(ddlForm.SelectedItem.Text);
                dt.Rows[count]["WorkType"] = Convert.ToString(txtWorkType.Text);
                dt.Rows[count]["Status"] = Convert.ToInt32(ddlStatus.SelectedItem.Text);
                dt.Rows[count]["Remarks"] = Convert.ToString(txtRemarks.Text);
                //dt.Rows[count]["ProposedCost"] = Math.Round((Convert.ToDecimal(bindProjectCost) + Convert.ToDecimal(txtProjData.Text) + Convert.ToDecimal(txtBuildingVyay.Text)), 2).ToString();
                
               
                count++;
            }
            
            ViewState["dtfinal"] = dt;
        }
        catch { }

[edit]Subject only: "Please help me in my code" is not helpful, try to use a subject which gives us a good idea about your problem. That way we do not waste time looking if we can't help! - OriginalGriff[/edit]