C#

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            bool isHandheld = false;

            var pdv1 = isHandheld == true ? new PDVHH() : new PDV();

            txtCaseID.Text = pdv1.CaseID;
            txtPDV.Text = isHandheld == true ? pdv1.PDVString : string.Empty;
            txtPDVHH.Text = isHandheld == true ? pdv1.PDVHHString : string.Empty;

        }
    }

    class basePDV
    {
        public string CaseID { get; set; }
    }

    class PDV : basePDV
    {
        public string PDVString { get; set; }
    }

    class PDVHH : basePDV
    {
        public string PDVHHString { get; set; }
    }

XmlDataDocument xmlDoc = new XmlDataDocument();
string str = "http://www.w3schools.com/xml/note.xml"

            WebRequest request = WebRequest.Create(str);
            request.Timeout = 30 * 60 * 1000;
            request.UseDefaultCredentials = true;
            request.Proxy.Credentials = request.Credentials;
            WebResponse response = (WebResponse)request.GetResponse();
            using (Stream fs = response.GetResponseStream())
            
            xmlDoc.Load(fs);

using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Drawing;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls.WebParts;

namespace HIMSLA.InternalAudit
{
    public partial class InternalAuditUserControl : UserControl
    {
        public SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString);
        SqlCommand cmd = new SqlCommand();
        protected void Page_Load(object sender, EventArgs e)
        {
            lblMsg.Text = "";
            if (!Page.IsPostBack)
            {
                BindSubjectData();
            }
        }
       
        //call to bind gridview
        protected void BindSubjectData()
        {
            using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = "SELECT * FROM InternalAudit  order by Requirement";
                    cmd.Connection = sqlCon;
                    sqlCon.Open();
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    if (dt.Rows.Count > 0)
                    {
                        gvInternalAudit.DataSource = dt;
                        gvInternalAudit.DataBind();
                    }
                    else
                    {
                        DataRow dr = dt.NewRow();
                        dt.Rows.Add(dr);
                        gvInternalAudit.DataSource = dt;
                        gvInternalAudit.DataBind();
                        gvInternalAudit.Rows[0].Visible = false;
                    }
                    sqlCon.Close();
                }
            }
        }
        protected void gvInternalAudit_RowDataBound(object sender, GridViewRowEventArgs e)
        {

            if (e.Row.RowType == DataControlRowType.DataRow)
            {

                Label Qtr1 = (Label)e.Row.FindControl("lblQtr1");
                Label Q1IntProc = (Label)e.Row.FindControl("lblQ1IntProc");
                Label Q1IntProj = (Label)e.Row.FindControl("lblQ1IntProj");
                Label Q1ExtBSI = (Label)e.Row.FindControl("lblQ1ExtBSI");
                Label Q1ExtCMMI = (Label)e.Row.FindControl("lblQ1ExtCMMI");


                int lblQtr1 = int.Parse(Q1IntProc.Text) + int.Parse(Q1IntProj.Text) + int.Parse(Q1ExtBSI.Text) + int.Parse(Q1ExtCMMI.Text);

                Qtr1.Text = lblQtr1.ToString();

            }

        }

        //called on row edit command
        protected void gvInternalAudit_RowEditing(object sender, GridViewEditEventArgs e)
        {
            gvInternalAudit.EditIndex = e.NewEditIndex;
            BindSubjectData();
        }

        //called when cancel edit mode
        protected void gvInternalAudit_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gvInternalAudit.EditIndex = -1;
            BindSubjectData();
        }
       
        //called on row add new command
        protected void gvInternalAudit_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Add")
            {
                bool IsAdded = false;
                TextBox newRequirement =
                (TextBox)gvInternalAudit.FooterRow.FindControl("newRequirement");
                 TextBox newYear = (TextBox)gvInternalAudit.FooterRow.FindControl("newYear");
                 TextBox newQtr1 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr1");
                 TextBox newQ1IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1IntProc");
                 TextBox newQ1IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1IntProj");
                 TextBox newQ1ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1ExtBSI");
                 TextBox newQ1ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1ExtCMMI");
                 TextBox newQtr2 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr2");
                 TextBox newQ2IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2IntProc");
                 TextBox newQ2IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2IntProj");
                 TextBox newQ2ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2ExtBSI");
                 TextBox newQ2ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2ExtCMMI");
                 TextBox newQtr3 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr3");
                 TextBox newQ3IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3IntProc");
                 TextBox newQ3IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3IntProj");
                 TextBox newQ3ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3ExtBSI");
                 TextBox newQ3ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3ExtCMMI");
                 TextBox newQtr4 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr4");
                 TextBox newQ4IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4IntProc");
                 TextBox newQ4IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4IntProj");
                 TextBox newQ4ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4ExtBSI");
                 TextBox newQ4ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4ExtCMMI");
                 TextBox newYearTotals = (TextBox)gvInternalAudit.FooterRow.FindControl("newYearTotals");
                 
                

             //   TextBox Grade = (TextBox)gvSubDetails.FooterRow.FindControl("newGrade");
                using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
                {
                    using (SqlCommand cmd = new SqlCommand())
                    {
                        //here i'd added "@" for continuous string in new line
                        cmd.CommandText = @"INSERT INTO InternalAudit(Requirement, Year, Qtr1, Q1IntProc, Q1IntProj,Q1ExtBSI,Q1ExtCMMI,Qtr2,Q2IntProc,Q2IntProj,Q2ExtBSI,Q2ExtCMMI, Qtr3, Q3IntProc, Q3IntProj,Q3ExtBSI,Q3ExtCMMI,Qtr4, Q4IntProc, Q4IntProj,Q4ExtBSI,Q4ExtCMMI,YearTotals)
                                   VALUES(@Requirement,@Year,@Qtr1,@Q1IntProc,@Q1IntProj,@Q1ExtBSI,@Q1ExtCMMI,@Qtr2,@Q2IntProc,@Q2IntProj,@Q2ExtBSI,@Q2ExtCMMI,@Qtr3,@Q3IntProc,@Q3IntProj,@Q3ExtBSI,@Q3ExtCMMI,@Qtr4,@Q4IntProc,@Q4IntProj,@Q4ExtBSI,@Q4ExtCMMI,@YearTotals)";

                        cmd.Parameters.AddWithValue("@Requirement", newRequirement.Text);
                        cmd.Parameters.AddWithValue("@Year", newYear.Text);
                        cmd.Parameters.AddWithValue("@Qtr1", newQtr1.Text);
                        cmd.Parameters.AddWithValue("@Q1IntProc", newQ1IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q1IntProj", newQ1IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q1ExtBSI", newQ1ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q1ExtCMMI", newQ1ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@Qtr2", newQtr2.Text);
                        cmd.Parameters.AddWithValue("@Q2IntProc", newQ2IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q2IntProj", newQ2IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q2ExtBSI", newQ2ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q2ExtCMMI", newQ2ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@Qtr3", newQtr3.Text);
                        cmd.Parameters.AddWithValue("@Q3IntProc", newQ3IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q3IntProj", newQ3IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q3ExtBSI", newQ3ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q3ExtCMMI", newQ3ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@Qtr4", newQtr4.Text);
                        cmd.Parameters.AddWithValue("@Q4IntProc", newQ4IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q4IntProj", newQ4IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q4ExtBSI", newQ4ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q4ExtCMMI", newQ4ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@YearTotals", newYearTotals.Text);
                     
                        cmd.Connection = sqlCon;
                        sqlCon.Open();
                        IsAdded = cmd.ExecuteNonQuery() > 0;
                        sqlCon.Close();
                    }
                }
                if (IsAdded)
                {
                    lblMsg.Text = "'" + newRequirement.Text + "' InternalAudit added successfully!";
                   lblMsg.ForeColor = System.Drawing.Color.Green;

                    BindSubjectData();
                }
                else
                {
                    lblMsg.Text = "Error while adding '" + newRequirement.Text + "' subject details";
                    lblMsg.ForeColor = System.Drawing.Color.Red;
                }
            }
        }
        //called on row update command
        
        protected void gvInternalAudit_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            bool IsUpdated = false;
            //getting key value, row id
            int ID =
            Convert.ToInt32(gvInternalAudit.DataKeys[e.RowIndex].Value.ToString());
            //getting row field details
            TextBox Requirement =
            (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtRequirement");
            TextBox Year = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtYear");
            TextBox Qtr1 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr1");
            TextBox Q1IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1IntProc");
            TextBox Q1IntProj  = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1IntProj");
            TextBox Q1ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1ExtBSI");
            TextBox Q1ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1ExtCMMI");
            TextBox Qtr2 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr2");
            TextBox Q2IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2IntProc");
            TextBox Q2IntProj  = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2IntProj");
            TextBox Q2ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2ExtBSI");
            TextBox Q2ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2ExtCMMI");
            TextBox Qtr3 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr3");
            TextBox Q3IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3IntProc");
            TextBox Q3IntProj  = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3IntProj");
            TextBox Q3ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3ExtBSI");
            TextBox Q3ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3ExtCMMI");
            TextBox Qtr4 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr4");
            TextBox Q4IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4IntProc");
            TextBox Q4IntProj  = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4IntProj");
            TextBox Q4ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4ExtBSI");
            TextBox Q4ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4ExtCMMI");
            TextBox YearTotals = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtYearTotals");

         //   TextBox Grade = (TextBox)gvSubDetails.Rows[e.RowIndex].FindControl("txtGrade");
            using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    //here i'd added "@" for continuous string in new line
                    cmd.CommandText = @"UPDATE InternalAudit SET Requirement=@Requirement,Year=@Year,Qtr1=@Qtr1,Q1IntProc=@Q1IntProc,Q1IntProj=@Q1IntProj,Q1ExtBSI=@Q1ExtBSI,Q1ExtCMMI=@Q1ExtCMMI, Qtr2=@Qtr2, Q2IntProc=@Q2IntProc, Q2IntProj=@Q2IntProj,Q2ExtBSI=@Q2ExtBSI, Q2ExtCMMI=@Q2ExtCMMI, Qtr3=@Qtr3, Q3IntProc=@Q3IntProc, Q3IntProj=@Q3IntProj,Q3ExtBSI=@Q3ExtBSI, Q3ExtCMMI=@Q3ExtCMMI,Qtr4=@Qtr4, Q4IntProc=@Q4IntProc, Q4IntProj=@Q4IntProj,Q4ExtBSI=@Q4ExtBSI, Q4ExtCMMI=@Q4ExtCMMI WHERE ID=@Id";
                    cmd.Parameters.AddWithValue("@Id", ID);
                    cmd.Parameters.AddWithValue("@Requirement", Requirement.Text);
                        cmd.Parameters.AddWithValue("@Year", Year.Text);
                        cmd.Parameters.AddWithValue("@Qtr1", Qtr1.Text);
                        cmd.Parameters.AddWithValue("@Q1IntProc", Q1IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q1IntProj", Q1IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q1ExtBSI", Q1ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q1ExtCMMI", Q1ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@Qtr2", Qtr2.Text);
                        cmd.Parameters.AddWithValue("@Q2IntProc", Q2IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q2IntProj", Q2IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q2ExtBSI", Q2ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q2ExtCMMI", Q2ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@Qtr3", Qtr3.Text);
                        cmd.Parameters.AddWithValue("@Q3IntProc", Q3IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q3IntProj", Q3IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q3ExtBSI", Q3ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q3ExtCMMI", Q3ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@Qtr4", Qtr4.Text);
                        cmd.Parameters.AddWithValue("@Q4IntProc", Q4IntProc.Text);
                        cmd.Parameters.AddWithValue("@Q4IntProj", Q4IntProj.Text);
                        cmd.Parameters.AddWithValue("@Q4ExtBSI", Q4ExtBSI.Text);
                        cmd.Parameters.AddWithValue("@Q4ExtCMMI", Q4ExtCMMI.Text);
                        cmd.Parameters.AddWithValue("@YearTotals", YearTotals.Text);
               
                    cmd.Connection = sqlCon;
                    sqlCon.Open();
                    IsUpdated = cmd.ExecuteNonQuery() > 0;
                    sqlCon.Close();
                }
            }
            if (IsUpdated)
            {
                lblMsg.Text = "'" + Requirement.Text + "' InternalAudit updated successfully!";
                lblMsg.ForeColor = System.Drawing.Color.Green;
            }
            else
            {
                lblMsg.Text = "Error while updating '" + Requirement.Text + "' subject details";
                lblMsg.ForeColor = System.Drawing.Color.Red;
            }
            gvInternalAudit.EditIndex = -1;
            BindSubjectData();
        }

        //called on row delete command
        protected void gvInternalAudit_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            bool IsDeleted = false;
            //getting key value, row id
            int ID = Convert.ToInt32(gvInternalAudit.DataKeys[e.RowIndex].Value.ToString());
            //getting row field subjectname
            Label Requirement = (Label)gvInternalAudit.Rows[e.RowIndex].FindControl("lblRequirement");
            using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = "DELETE FROM InternalAudit WHERE Id=@ID";
                    cmd.Parameters.AddWithValue("@ID", ID);
                    cmd.Connection = sqlCon;
                    sqlCon.Open();
                    IsDeleted = cmd.ExecuteNonQuery() > 0;
                    sqlCon.Close();
                }
            }
            if (IsDeleted)
            {
                lblMsg.Text = "'" + Requirement.Text + "' InternalAudit has been deleted successfully!";
                lblMsg.ForeColor = System.Drawing.Color.Green;
                BindSubjectData();
            }
            else
            {
                lblMsg.Text = "Error while deleting '" + Requirement.Text + "' subject details";
                lblMsg.ForeColor = System.Drawing.Color.Red;
            }
        }

    }
}