How Do I Display Result In Sql Server

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

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.

SQL

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:

Id	AppliedFor	EntryDateTime	  bUpdate	DaysBeyond
1	   7	        06-Oct-2014	    No	           27
2	   5	        28- Oct -2014	    No	            9
3	   6	        28- Oct -2014	    No	            9

Posted 9-Nov-14 4:38am

bubai banerjee

Updated 9-Nov-14 10:00am

Maciej Los

v4

Add a Solution

Comments

Maciej Los 9-Nov-14 16:02pm

And what's the issue?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-11-09T05:04:00

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

Maciej Los · Answer 2 · 2014-11-09T10:15:00

All you need is called stored procedure[^] with proper WHERE[^] statement, for example:

SQL

CREATE PROCEDURE DataToDisplay
AS
BEGIN

    SELECT <Field_list>
    FROM TableName
    WHERE AppliedFor=7 and bUpdate=0 and DaysBeyond>21 
    UNION ALL
    --note: second Field_list must equal to the first one 
    SELECT <Field_list>
    FROM TableName
    WHERE AppliedFor<>7 and bUpdate=0 and DaysBeyond>7 

END

How to call it from code behind? Please, see:
How to: Execute a Stored Procedure that Returns Rows[^]
Walkthrough: Using Only Stored Procedures (C#)[^]
How to call SQL Server stored procedures in ASP.NET by using Visual Basic .NET[^]

How Do I Display Result In Sql Server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0