how can use store procedure to print with dataset

Question

3.00/5 (2 votes)

See more:

i need to use username and password in crystal report and
i pass value from dataGridView to the store procedure

the store procedure is:

SQL

Create proc [dbo].[PrintCatCustomersTbl]
@catId int
as
select catId,catName,catNote from CatCustomersTbl where catId=@catId

and this is my code to print from dataGridView:

C#

Report.ReportCatProductsSingle reportcustomer = new Report.ReportCatProductsSingle();
 reportcustomer.SetParameterValue("@catId",this.dataGridView1.CurrentRow.Cells[0]
.Value.ToString());
            Report.FormCatProducts fmct = new Report.FormCatProducts();
          
            fmct.crystalReportViewer1.ReportSource = reportcustomer;
            fmct.ShowDialog();

Can i use the dataset to use the UserName and Password and Print from dataGridView
Like This:

C#

string DatabaseServer = ConfigurationManager.AppSettings["Server"];
            string userId = ConfigurationManager.AppSettings["Userid"];
            string Password = ConfigurationManager.AppSettings["Password"];
            string DataBaseName = ConfigurationManager.AppSettings["DataBase"];

Posted 27-Mar-15 9:23am

Member 11280947

Updated 27-Mar-15 10:27am

Arkadeep De

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 28-Mar-15 2:14am

What is the issue here? You just need to build the connection string and then connect to the database and get the records and bind.

Maciej Los 28-Mar-15 13:49pm

You did not provide enough information about your issue, but...

On the first look, you pass wrong data into SP, because SP expects integer data ¹⁾, but you pass string ²⁾.

¹⁾ @catId int
²⁾ "@catId",this.dataGridView1.CurrentRow.Cells[0].Value.ToString()

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sherif Barakat · Answer 1 · 2015-03-30T00:14:00

You can try this way:

DataTable dt = new DataTable();

for (int i=0;i<yourgridviewname.rows.count;i++)
{
//To get the Paramater of the stored procedure from Grid view
string catId = YourGridViewName.Items[i].Text;

SqlCommand cmd = new SqlCommand("PrintCatCustomersTbl", conn);
cmd.Parameters.Add("@catId", SqlDbType.int).Value =catId;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
///// you can also here get your the data row by row/////
}
// to display the list of data returned from the stored procedure
AnyControlName.DataSource = dt;
AnyControlName.DataBind();

how can use store procedure to print with dataset

1 solution

Solution 1

Add your solution here

Preview 0

how can use store procedure to print with dataset

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us