How to add columns to datatable in ASP.NET C# - with string or int type

 DataTable dt = new DataAccess().Read(procName, param).Tables[0];

            dt.Columns.Add("cadrename", typeof(String));

            dt.Columns.Add("cadreID", typeof(int));

            foreach (DataRow item in dt.Rows)

            {

                item["cadrename"] = ddlCadreType.SelectedItem.Text;

                item["cadreID"] = ddlCadreType.SelectedValue;

            }

How to add row to datatable or how to add row to grid row ASP.NET C#

//datarow and datatable

  protected void grdOpenVacancy_RowDeleting(object sender, GridViewDeleteEventArgs e)

        {

            int id = (int)grdOpenVacancy.DataKeys[e.RowIndex].Value;

            DataTable dtOpenVacancy = ViewState["vwOpenVacancy"] as DataTable;

            DataRow dr= dtOpenVacancy.AsEnumerable().Where(a=>a.Field<int>("ID") == id).FirstOrDefault();

            //GridViewRow grdrow = grdOpenVacancy.Rows[e.RowIndex];

            bool i = Repository.DeleteOpenVacancy(id);

            //            ddlCadreType_SelectedIndexChanged(null, null);

            

            if (ViewState["dt2"] != null)

            {

                DataTable dt3 = (DataTable)ViewState["dt2"];

                DataRow workRow = dt3.NewRow();

                // workRow["Institute"] = grdrow.Cells[0].Text;

                workRow["Institute"] = dr["InstituteName"];

                workRow["Discipline"] = dr["disciplineName"];

                workRow["cadrename"] = dr["cadreName"];

                workRow["cadreID"] = dr["cadreID"];

                workRow["SS"] = dr["SanctionedStrength"];

                workRow["IP"] = dr["inposition"];

                workRow["Vacancy"] = dr["vacancy"];

                dt3.Rows.Add(workRow);

                ViewState["dt2"] = dt3;

// grid row and grid view

//GridViewRow grdrow = grdOpenVacancy.Rows[e.RowIndex];

// workRow["Institute"] = grdrow.Cells[0].Text;

but in this case, grid column should have item template field.

IIS server port range minimum and maximum

 From 1 to 65535

> Open IIS server

> Click on website

> Click on Bindings and change port number

reference:- https://serverfault.com/questions/747835/valid-ranges-for-web-site-ports-in-iis

Session Object reference not set to an instance of an object - ASP.NET C#

 Change Request.QueryString["ii"].ToString() to groupList = (string)(Session["UserGroups"])

Remove ToString() to (string)

refernce:- https://stackoverflow.com/questions/8670020/asp-c-sharp-session-variable-object-reference-not-set-to-an-instance-of-an-o

SQL Server Line numbers

 >Open SQL Server Management Studio.

> Click on Text editor.

> Click on Transact-SQL

> Check on line numbers