table border all td and tr border

<table style='width:100%; border-collapse:collapse; font-size: 14px; background-color: #ffffff;  border-color:black;' border='1px' cellpadding='5' cellspacing='5'>

<tr>

<th>Id</th>

<th>Name</th>

<th>DOB</th>

<th>Mobile</th>

</tr>

<tr>

<td>1</td>

<td>Microsoft</td>

<td>4 April 1975</td>

<td>910998989</td> 

</tr>

<tr>

<td>2</td>

<td>IBM</td>

<td>4 April 1975</td>

<td>910998989</td> 

</tr>

<tr>

<td>3</td>

<td>Accenture</td>

<td>4 April 1975</td>

<td>910998989</td> 

</tr>

<tr>

<td>4</td>

<td>Pabitra Microsoft</td>

<td>4 April 1975</td>

<td>910998989</td> 

</tr>

</table>

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   

generate max id

DECLARE @MAXID INT
SET @MAXID=5
DECLARE @TBL TABLE
(
ID INT  ,
NAME VARCHAR(56)
)
INSERT INTO @TBL VALUES (NULL,'A')
INSERT INTO @TBL VALUES (NULL,'A')
INSERT INTO @TBL VALUES (NULL,'A')

UPDATE @TBL SET @MAXID = ID = @MAXID+1
SELECT * FROM @TBL

SQL : Add non cluster index in SQL table by query

create table tblSample2008
(
id int primary key not null identity(1,1),
name varchar(100),
city varchar(50)
)

CREATE NONCLUSTERED INDEX city_MyCustom_NonclusterIndex
ON tblSample2008 (city asc)



CREATE TABLE [dbo].[tblSample2008](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](100) NULL,
[city] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

generate next number

DECLARE @MAXID INT

SELECT  @MAXID=ID_MAX FROM SDMIS_STUDENT_MASTER_18_19_Mapping_with_dist WHERE Dist_code='2105'

UPDATE SDMIS_STUDENT_MASTER_18_19_SUNDERGARH_2105

 SET @MAXID = ID = @MAXID+1 

where ID is null and assesment_status='N' AND TC_Status IS NULL;

 

DECLARE @MAXXXX INT

SELECT @MAXXXX =MAX(ID) FROM SDMIS_STUDENT_MASTER_18_19_SUNDERGARH_2105

WHERE  assesment_status='N' AND TC_Status IS NULL;

--PRINT @MAXXXX

UPDATE SDMIS_STUDENT_MASTER_18_19_Mapping_with_dist SET ID_MAX=@MAXXXX

WHERE Dist_code='2105'