i need monthwise Report using Grid View?

Question

1.00/5 (2 votes)

See more:

i need monthwise Report using Grid View?

Example

AUGUST '13 1 2 3 5 6 7 9 up to 31
DW XXL 20 10 365 25 155 790 20

My Table name

deliveryOrdef Name

Marking Date qty
DWXXl 01/08/2013 20
Dwxxl 02/08/2013 10

Please help me

Posted 30-Aug-13 19:16pm

manikjeyam

Updated 30-Aug-13 19:50pm

v3

Add a Solution

Comments

Sadique KT 31-Aug-13 1:27am

what report ? where is your table ? what you tried?

manikjeyam 31-Aug-13 1:53am

deliveryOrdef Name

This is my table format
Marking Date qty
DWXXl 01/08/2013 20
Dwxxl 02/08/2013 10

CodeBlack 31-Aug-13 1:30am

sorry we can not read your mind :(

manikjeyam 31-Aug-13 1:53am

deliveryOrdef Name

this is my table format
Marking Date qty
DWXXl 01/08/2013 20
Dwxxl 02/08/2013 10

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)

Sadique KT · Answer 1 · 2013-08-30T20:03:00

Solution 1

Create Stored Procedure or simply write query

SQL

SELECT * FROM deliveryOrdefName where DatePart(MM,Date)=@Month AND DatePart(YYYY,Date)=@year

Assign the result to your grid

Posted 30-Aug-13 20:03pm

Sadique KT

Comments

manikjeyam 31-Aug-13 2:10am

how to display gird
like
name 1 2 3 4
dwxxl 10 20

Sadique KT 31-Aug-13 2:15am

what is 1 2 3 4?

Sadique KT 31-Aug-13 2:16am

Do you want all records of one user to be shown in single row?? do you have multiple records for a person in same date?
Your requirement is not clear!!!

manikjeyam 31-Aug-13 2:18am

date sir
example
Markinname date Qty
dwxxl 01/08/2013 20
Dwxxl 02/08/2013 30

it will display grid like
marking name 1 2
Dwxxl 20 30

Sadique KT 31-Aug-13 2:22am

You can do it from SQL using Pivot else can create table dynamically in c# with table header as 1,2,3..

manikjeyam 31-Aug-13 2:24am

send query for that
just send sample query i will modify that

manikjeyam 31-Aug-13 2:23am

Please help me sir