Binding a single column multiple times to the gridview through database horizontally

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

I am working on a project which is on college.In this project am creating a page for attendance and attendance report.In the attendance report page i need to bind the date column three times to the gridview by keeping the name column constant for it.Please suggest me some code ....quickly.

Posted 30-Nov-14 23:48pm

Member 10486850

Add a Solution

Comments

King Fisher 1-Dec-14 6:02am

what have you tried so far?

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)

Shweta N Mishra · Answer 1 · 2014-11-30T23:54:00

Solution 1

select your columns from SQL by naming as date1, date2 and Date3 and in front end for gridview change their caption have the name as date only.

add something like this in your gridview columns section for adding single column multiple times.

C#

<asp :BoundField HeaderText="Date 1" DataField="Date" />
<asp :BoundField HeaderText="Date 2" DataField="Date" />
<asp :BoundField HeaderText="Date 3" DataField="Date" />

Posted 30-Nov-14 23:54pm

Shweta N Mishra

Updated 1-Dec-14 0:28am

v4

Comments

Member 10486850 1-Dec-14 6:13am

Actually m having a single column i.e date which i need to bind multiple times to the gridview ....

Shweta N Mishra 1-Dec-14 6:18am

you can do that in gridview. To do that first bind your gridview from dataset returned from SQL and then add columns to Gridview and give the column value to have the Date column value.

check this

http://www.c-sharpcorner.com/uploadfile/61b832/adding-bound-columns-to-gridview-in-Asp-Net/

Member 10486850 1-Dec-14 6:19am

Please can you suggest the code for the above issue....as earlier...

Shweta N Mishra 1-Dec-14 6:21am

add something like this in your gridview columns section

<asp datafield="Date" headertext="Date 1" :boundfield="Date">

<asp datafield="Date" headertext="Date 2" :boundfield="Date">
<asp datafield="Date" headertext="Date 3" :boundfield="Date">

Member 10486850 2-Dec-14 2:07am

Your suggested solution is not able to vieww...m nt able to see anythg

Member 10486850 1-Dec-14 6:22am

its kk...but i need to bind the date column in the boundfield not for a single time but for multiple timess....

Member 10486850 1-Dec-14 6:25am

please some one suggest mee..

Shweta N Mishra 1-Dec-14 6:27am

solution updated.

Praveen Kumar Upadhyay 1-Dec-14 8:01am

Solution will work buddy. Try this and mark the solution as accepted as the experts are trying hard to investigate into your problem and giving their valuable time.

Member 10486850 2-Dec-14 2:08am

For tryg the solution m not able to see the suggested solution....

Member 10486850 2-Dec-14 2:04am

kk

Shweta N Mishra 2-Dec-14 3:25am

its their in solution with the code look up in existing solution.