Passing value from textbox to crystalreportviewer (parameterized query)

[Member 4413283]

for this u can use crystalreport and file and add parameter field and create ParameterFields myParams = new ParameterFields(); ParameterField myParamGuestName = new ParameterField(); ParameterDiscreteValue myDiscreteValue = new ParameterDiscreteValue(); myParamGuestName.ParameterFieldName = "guestname"; myParams.Add(myParamGuestName); crystalReportViewer.ParameterFieldInfo = myParams; enjoy this code diwaker sharma

[nt_virus]

sorry dude, i cant understand .. i have crystal report in my file ... where i write these code ? Do i need to fill dataset ? My existing code is like this ..

private void button1_Click(object sender, EventArgs e)
{
sqlDataAdapter1.Fill(dataSet11);
crystalReport11.SetDataSource(dataSet11);
crystalReportViewer1.ReportSource = crystalReport11;

    }

[nt_virus]

If you don't mind, can you please do the changes .. i will be very grateful to you ... http://www.mediafire.com/?sharekey=fe96050cdc6b5507d2db6fb9a8902bda[^] just few kbs.

[Tom Deketelaere]

First you need to add a parameter to your report. Then (still in the report) add a select query (from memory: right click report - set select - choice your ID column and set equal to parameter) Then in code you do: private void button1_Click(object sender, EventArgs e) { sqlDataAdapter1.Fill(dataSet11); crystalReport11.SetDataSource(dataSet11); crystalreport11.setparameter("parametername",value); crystalReportViewer1.ReportSource = crystalReport11; } This is all from memory so you might have to search a bit O and nobody is going to just write the code for you. But this should help you on your way.

[nt_virus]

System.Data.SqlClient.SqlException was unhandled
Message="Parameterized Query '(@A varchar(50))SELECT DS.*\r\nFROM DS\r\nWHERE (A =' expects parameter @A, which was not supplied."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060

I get this error in this line ---- sqlDataAdapter1.Fill(dataSet11); What I did is ... Added a textbox1, button1, crystalreportviewer1 and crystalreport11, crystalreport.rpt.. in crystalreport.rpt, I added a Parameter Field , named "AAAA" and in Set Select Editor, I set equal to parameter and added A=@A in formula editor.. Then i write this code and error happens..

sqlDataAdapter1.Fill(dataSet11);
        crystalReport11.SetDataSource(dataSet11);
        crystalReport11.SetParameterValue("AAAA", textBox1.Text);
        crystalReportViewer1.ReportSource = crystalReport11;

[nt_virus]

hey .. just worked tom .. thanks a lot my friend ... can i have your messenger id if you dont mind ...

[Tom Deketelaere]

It looks like you are trying to fill your dataset with an select query that requires an variable (@A) Wich is missing. (that is what the error says) first off all this isn't needed. You have 2 options: You select the complete table and do the filtering on the report (that is the way I explained it in earlyer post) OR You do the filtering in the select command and NOT on the report (in this case you don't need the parameter on the report) Both are possible and acceptable, you can do both but that's not needed. If you choice the second option you need to provide a sqlparameter something like:

sqldataadapter1.selectcommand.commandtext = "SELECT * FROM table WHERE id=@A";
sqldataadapter1.selectcommand.parameters.addwithvalue("@A",textbox1.text);
sqldataadapter1.fill(dataset11);
crystalReport11.SetDataSource(dataSet11);
crystalReportViewer1.ReportSource = crystalReport11;

and then your report doesn't need the parameter nor needs to filer it (the set select from last post) since you already filterd the data. (once again this if from memory)

[Tom Deketelaere]

nt_virus wrote:

can i have your messenger id if you dont mind ...

Messenger :confused: what's that :) I don't use it sorry, got bored off the viruses sending messages and the constant 20 boxes flashing :laugh:

[nt_virus]

Another problem, suppose there are two AgentID ... If i enters one agent Id and search for it , it works fine, but when i changes the value in textbox and enters 3nd agent id, it throws an error The SelectCommand property has not been initialized before calling 'Fill'. I have to search agentid and my search changes frequently .. so its not happing now.. Please suggest something.

[Tom Deketelaere]

Did you set the selectcommand? sorry without your code I can't really say what's wrong with it post your code that you use to fill the dataset

[nt_virus]

Hello Sir, actually I use SqlDataAdapter and generate dataset not by coding .. should i do by coding ? I did everything from wizard ..

sqlDataAdapter1.Fill(dataSet11);
crystalReport11.SetDataSource(dataSet11);
crystalReport11.SetParameterValue("AAAA", textBox1.Text);
crystalReportViewer1.ReportSource = crystalReport11;

[Tom Deketelaere]

Is this all your code? Where is your SQL string? The error message you get suggests that the selectcommand from your sqldataadapter isn't set wich from what I can see it isn't. to set the selectcommand: sqldataadapter.selectcommand.commandtext= "SELECT [insert your column names here] FROM [insert table name] WHERE [productid]= @id" sqldataadapter.selectcommand.parameters.addwithvalue("@id",textbox1.text) sqlDataAdapter1.Fill(dataSet11); crystalReport11.SetDataSource(dataSet11); crystalReportViewer1.ReportSource = crystalReport11;