generate gridview without tabel field

Question

1.00/5 (2 votes)

See more:

i have two table.1)userinfo
fields:
userid (primarykey)
name

2)checkinout
fields:
userid
checktime
checktype

data in userinfo

userid name
--------------
1         abc

data in checkinout

userid checktime checktype
----------------------------------
1 1/1/2013 10am 0
1 1/1/2013 5pm    1
1 2/1/2013 10am 0
1 2/1/2013 5pm    1

o is indicate intime,1 indicate outtime

now i have to display data in gridview like this way...

userid name    Intime         outtime          intype outtype
-------------------------------------------------------------------
1        abc 1/1/2013 10am 1/1/2013 5pm 0        1

one condition is that ,i have to not change the table field.

how to do this?

Posted 28-Jan-13 6:58am

Member 9511889

Updated 28-Jan-13 7:13am

v5

Add a Solution

Comments

Member 9511889 29-Jan-13 0:58am

ALTER PROCEDURE dbo.Biometrics_Select_Data
@Userid numeric(18,0)

AS

--- select Checkinout.Userid,Checkinout.CheckTime,Checkinout.CheckType,
--- Checkinout.Sensorid,Checkinout.Logid,Checkinout.Checked,Checkinout.WorkType,
--- Checkinout.AttFlag,Userinfo.[Name] from Checkinout left join Userinfo
--- On Checkinout.Userid=Userinfo.Userid where Userid=@Userid

SELECT Checkinout.*,Userinfo.Name
FROM Checkinout LEFT JOIN Userinfo
pivot(CheckType IN(0)) as Intime --, pivot(checktype in (1)) as outtime
ON (Checkinout.Userid = Userinfo.Userid)
where (Checkinout.Userid = @Userid)

RETURN

i have try this ,but it gives error like...incorect syntex near in

1 solution

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)

Dave Kreskowiak · Answer 1 · 2013-01-28T09:37:00

Solution 1

This is called a "pivot". Read up on a good example here[^].

Posted 28-Jan-13 9:37am

Dave Kreskowiak