Retriving data from grid in a different manner pls help me

Question

0.00/5 (No votes)

See more:

Sql database ,asp.net(c#)

I have two table

1 Session1

ItemName Quantity Price Date
..................................
Onion 22 30 12/06/2012
salt 2 15 12/06/2012
egg 13 43 12/06/2012
chilly 12 88 12/06/2012
maida 6 77 13/06/2012
oil 7 227 12/06/2012
nuts 1 300 13/06/2012

2 Product

Product Quantity Price Date
...........................................
Puffs 22 120 12/06/2012
porotta 35 350 13/06/2012

I want to retrieve this data to my datagridview like in a different manner just see below

ITEMNAME QUANTITY PRICE DATE PRODUCT QUANTITY PRICE DATE
..............................................................................
Onion 22 30 12/06/2012 Puffs 22 120 12/06/2012
salt 2 15 12/06/2012
egg 13 43 12/06/2012
chilly 12 88 12/06/2012
oil 7 227 12/06/2012
...............................................................................
maida 6 77 13/06/2012 porotta 35 350 13/06/2012
nuts 1 300 13/06/2012

Posted 5-Dec-12 17:53pm

ravuravu

Updated 5-Dec-12 17:59pm

v2

Add a Solution

Comments

choudhary.sumit 6-Dec-12 0:00am

gimme your "select" query, which u r using to fetch data.

ravuravu 6-Dec-12 0:03am

Sorry i Have no idea I am fresher Am just using some queries but its not working like this manner

ravuravu 6-Dec-12 0:05am

string date = Calendar1.SelectedDate.ToShortDateString();
DateTime dt1 = DateTime.Parse(date.ToString());
string dt = dt1.ToString("MM/dd/yyyy");
string ss = "SELECT Session1.ItemName,Session1.Quantity,Session1.Price,Session1.Date,Product.Product,Product.Quantity,Product.Price,Product.Date from Session1,Product where Date='"+dt+"' ";
SqlDataAdapter madp4 = new SqlDataAdapter(ss, DbConnection.mCon);
DataSet mds4 = new DataSet();
madp4.Fill(mds4);
GridView3.DataSource = mds4;
GridView3.DataBind();

choudhary.sumit 6-Dec-12 0:05am

ok suppose you are using this query "select itemname,quantity,.... from mytable" just change your query with "select itemname as [ITEM NAME], quantity as [QUANTITY],... & so on from mytable"

choudhary.sumit 6-Dec-12 0:06am

just use aliasing with every column you retrieved

ravuravu 6-Dec-12 0:08am

no sir that's not a problem in it. i just want to retrieve the data to grid in a manner that i showed above,i just want to know how to retrive it like that manner

ravuravu 6-Dec-12 0:11am

sir how it used

choudhary.sumit 6-Dec-12 0:14am

ok ok.. i got you. so why u have two diffrent datatables for this. use only one containing all 8 columns.

ravuravu 6-Dec-12 0:28am

sir it could not possible because my project has covered too many portions so it could not possible

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)

Quentin in SA · Answer 1 · 2012-12-05T18:05:00

Solution 1

I see you are using ASP.Net? Can you not set the headings to caps using a style sheet?
Something like this in your stylesheet:

table thead th {
text-transform: uppercase;
}

A nice table designer here: http://tablestyler.com/[^]

Posted 5-Dec-12 18:05pm

Quentin in SA

Comments

ravuravu 6-Dec-12 0:15am

sir i need that i want to take data to grid in the order of date
and the remaining field should be blank thats am asking sir, sorry for confusing

ravuravu 6-Dec-12 0:16am

i just showed that manner in my question u can find it at the end portion

RahulRana723 · Answer 2 · 2012-12-05T18:39:00

Solution 2

First Convert Your Datatable To list and Then Perform Select Query On This List......
then bind this list to your GridView

http://stackoverflow.com/questions/441023/fastest-way-to-convert-datatable-to-generic-list[^]
http://forums.asp.net/t/1720459.aspx/1[^]
http://www.devcurry.com/2010/01/convert-datatable-to-list-using-c-or.html[^]

Posted 5-Dec-12 18:39pm

RahulRana723

Comments

ravuravu 6-Dec-12 1:34am

sorry sir