can you please help me to create a report by writing stored Procedure and passing parameter

Question

0.00/5 (No votes)

See more:

can you please help me to create a report by writing stored Procedure means upto a particular date
this is my code below but in database expert what i have to do..

C#

ReportDocument cryRpt = new ReportDocument();
Connection obj = new Connection();
obj.getconn();
SqlCommand cmd3 = new SqlCommand();
cmd3.Connection = obj.con;
cmd3.CommandText = "SELQuotationbtdates";
cmd3.CommandType = CommandType.StoredProcedure;
DateTime dte = new DateTime();
dte = Convert.ToDateTime(dateTimePicker1.Text);
string formatted1 = dte.ToString("dd-MM-yyyy");
cmd3.Parameters.AddWithValue("@todate", formatted1);
SqlDataAdapter ds3 = new SqlDataAdapter(cmd3);
ds3.Fill(dst); 
cryRpt.Load("C:/Users/User/Desktop/test1/WindowsFormsApplication1/CrystalReport1.rpt");
cryRpt.SetDataSource(dst);
crystalReportViewer1.ReportSource = cryRpt;

Posted 15-Apr-13 20:34pm

Sharon 2

Updated 15-Apr-13 21:22pm

Malli_S

v2

Add a Solution

Comments

Malli_S 16-Apr-13 3:39am

If possible, please indent and restructure the code.

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)

Maciej Los · Answer 1 · 2013-04-15T21:48:00

Solution 1

Your question is not clear, so i can only suggest you to follow the below links:
Create procedure[^]
Using stored procedures in a command[^]

Example procedure:

SQL

CREATE PROCEDURE SELQuotationbtdates
    @toDate DATETIME
AS
BEGIN
    SELECT *
    FROM Table1
    WHERE DateField <=@toDate
END

Posted 15-Apr-13 21:48pm

Maciej Los

Comments

Sharon 2 16-Apr-13 4:11am

actully my doubt is what i have to take from field explorer after writing code

Sharon 2 16-Apr-13 4:13am

means from databaseexpert whether i have to take table and place it in the design part of report