How do I display result in Sql server

Question

I am using Sql server 2008 and want to display result in Asp.net Front End.

I am a fresher.Please help.Thanks in advance.

CREATE TABLE dbo.TestInsertState

(

Id INT,

AppliedFor INT,

EntryDateTime DATETIME,

bUpdate BIT

)

INSERT INTO dbo.TestInsertState(Id,AppliedFor,EntryDateTime,bUpdate) VALUES(1,7,'10/06/2014',0)

INSERT INTO dbo.TestInsertState(Id,AppliedFor,EntryDateTime,bUpdate) VALUES(2,5,'10/28/2014',0)

INSERT INTO dbo.TestInsertState(Id,AppliedFor,EntryDateTime,bUpdate) VALUES(3,6,'10/28/2014',0)

INSERT INTO dbo.TestInsertState(Id,AppliedFor,EntryDateTime,bUpdate) VALUES(4,7,'11/01/2014',0)

Condition : if AppliedFor=7 and bUpdate=0 and DaysBeyond>21 working days(means Monday to Friday) that should be displayed.

if AppliedFor <>7 and bUpdate=0 and DaysBeyond>7 working days(means Monday to Friday) that should be displayed.

Result Expected:

Joginder Banger · Answer

try this link i hope your problem have been solve. http://www.tutorialspoint.com/asp.net/asp.net_data_binding.htm

Sibeesh Venu · Answer

You can do it by using a grid control with SQL data source  see here http://www.vkinfotek.com/gridview/bind-gridview-sqldatasource-control.html