How to populate a drop down box from a DataTable object using C#

 bind dropdownlist from datatable c#

void LoadSubject()

    { 

        DataTable  dt=new DataTable();

        dt = getDataTable(SPName: "USP_Utkarsh_Subject", objParams: new string[] { "@action" }, objValues: new object[] { "get_subject" });

        if (dt != null && dt.Rows.Count > 0)

        {

            ddlSubject.DataSource = dt;

            ddlSubject.DataValueField = dt.Columns[0].ToString();

            ddlSubject.DataValueField = dt.Columns[1].ToString();

            ddlSubject.DataBind();

            ddlSubject.Items.Insert(0, "Seelct Subject");

        }

    }

SQL query : SELECT SubjectId, SubjectName  from Utkarsh_Subject with(nolock) order by SubjectId

create proc USP_Utkarsh_Subject

 (@action varchar(20)

 )

 AS BEGIN

 IF(@action='get_subject')

 BEGIN

 SELECT SubjectId,SubjectName  from Utkarsh_Subject with(nolock) order by SubjectId

 END

 END

 

MS SQL Inserting multiple rows in a single SQL query? [duplicate]

create table Utkarsh_Subject

(

SubjectId int primary key

,SubjectName varchar(20)

)

insert into Utkarsh_Subject(SubjectId,SubjectName)

VALUES(1,'SCIENCE'),(2,'MATHEMATICS'),(3,'ODIA'),(4,'ENGLISH')

check the values comes or not 

select * from Utkarsh_Subject

C# get url host name, domain name dns name 

Out put 

i.e. for 

// out put will like : AS2

 1. DNS Name: System.Net.Dns.GetHostName()   

// out put will like : https://pabitrams.in/landingPage.aspx2. AbsoluteUri  : System.Web.HttpContext.Current.Request.Url.AbsoluteUri 

//out put will like :pabitrams.in 

3.Host  System.Web.HttpContext.Current.Request.Url.Host