|
Hi all,i am having a problem populating data using reportviewer.i want to populate the data at runtime dynamically.on my button click event i want to populate the data corresponding to the dropdownlist value.for some reason my button click event gives me an error at ReportViewer1.LocalReport.setparameters(... ).it says "An attempt was made to set a report parameter 'parameter1' that is not defined in this report."below is my code for the button click......i m running a stored proc to populate the reportviewer....i am working on the visual webdeveloper 2005.and sql server 2000.any help would be greatly appreciated...
protected void Button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string connstrA = ConfigurationManager.AppSettings["SQLConnectionString"];
SqlConnection myconnectionA = new SqlConnection(connstrA);
SqlCommand mycommandA = new SqlCommand("dbo.up_campus_test", myconnectionA);
mycommandA.CommandType = CommandType.StoredProcedure;
mycommandA.Parameters.Add("@campus", SqlDbType.VarChar, 2).Value = DropDownList1.SelectedItem.Value.ToString();
SqlDataAdapter da = new SqlDataAdapter(mycommandA);
da.Fill(ds);
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
LocalReport report = ReportViewer1.LocalReport;
ReportViewer1.LocalReport.ReportPath = @"C:\Documents and Settings\gradasst\My Documents\My Web Sites\recent\Report\Report.rdlc";
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet2_up_campus_test", ds.Tables[0]));
ReportViewer1.LocalReport.DataSources.Clear();
ReportParameter param = new ReportParameter();
param.Name = "parameter1";
param.Values.Add(DropDownList1.SelectedValue.ToString());
ReportParameter[] myReportParams = new ReportParameter[] { param };
ReportViewer1.LocalReport.SetParameters(myReportParams);
ReportViewer1.LocalReport.Refresh();
}
}
Thanks in advance...
hi
|
|
|
|
|
Hello All!
I'm working in VS 2005/VB.NET. There seems to be alot of ways to this. I'm just looking to open up a pdf file from a server. I don't have to modify or save it. I just need to view it in the web page. Can somebody show me or point me to a quick of doing this.
Thanks!
Rudy
|
|
|
|
|
if you are doing it server side code use response.redirect(pathWithFilename.pdf)
and on clicent you can just give a link/button and open the pdf file like a href='http:\\url\file.pdf'
-----
|
|
|
|
|
Hello Sabhatti!
Thank you for the quick response. That worked great, but I didn't realize it would open adobe. Is there a way to open a pdf file, while still in the webpage?
Thanks!
Rudy
|
|
|
|
|
hi
you can try this : convert the file into byte array,set the Response.ContentType to application/pdf and do a binary write
Sample code:
string filePath=Request.MapPath("a.pdf");
System.IO.FileInfo ofile=new FileInfo(filePath);
System.IO.FileStream fs = ofile.OpenRead();
int filelen=(int)fs.Length;
byte[] b=new byte[filelen];
fs.Read(b,0,filelen);
Response.ClearHeaders();
Response.ClearContent();
Response.ContentType="application/pdf";
Response.BinaryWrite(b);
Response.End();
Response.Flush();
|
|
|
|
|
Hi,
What is the advantage of this way over SABhatti's statement? Please explain me.
Regards,
Jay 
|
|
|
|
|
Hi A.R.!
What do you mean by converting the file into a byte array?
Thanks!
Rudy
|
|
|
|
|
Hi,
I have a GridView with a TemplateField. The one control in the TemplateField is an ImageButton. It's a "Delete" button. The TemplateField and it's ImageButton are defined in the aspx page. However, there are some columns within the GridView that are being dynamically added, but not the TemplateField. It seems to bind and load fine on initial load of the page. Once the Delete button is clicked, though, the page does post back, but the ImageButton disappears and neither the GridView_RowCommand or ImageButton_Click events are triggered. In debugging I find the ImageButton is found on initial load during GridView_RowDataBound, but is not found (null), during the same event during PostBack. It also doesn't seem to matter whether, or not, I'm binding the GridView only during the initial load (!IsPostBack) or all the time. Is adding the other columns dynamically causing this? If so, how do I get around it? What am I missing?
Thanks
-- modified at 16:03 Tuesday 27th March, 2007
Rob
|
|
|
|
|
Usually, when I button is there initially and then disappears it is because it is defauled to visible = false in the UI / html. Then someplace in the page load probably in a
!IsPostBack the visible is set to true. That is usually where I have had my trouble with these things.
Hope that helps.
Ben
|
|
|
|
|
Afraid that's not the case here. The ImageButton is not set to Visible=false in the aspx and the visibility is not changed at all anywhere in the code-behind.
Rob
|
|
|
|
|
Hello,
I have a gridview that i want to make editable.
So i link it with a datasource, where I defined the updatecommand
In the edititemtemplate of my datagrid I have this dropdownlist
< asp:DropDownList ID="Field1" runat="server" ><br />
< asp:ListItem Value="OTH" Text="OTH">< /asp:ListItem><br />
< asp:ListItem Value="SGA" Text="SGA">< /asp:ListItem><br />
< asp:ListItem Value="COS" Text="COS">< /asp:ListItem><br />
< asp:ListItem Value="NA" Text="NA">< /asp:ListItem><br />
</a sp:DropDownList><br />
I tried to define the update command like that
<br />
< asp:SqlDataSource ID="SqlDataSource1" Runat="server"<br />
UpdateCommand = "UPDATE blabla SET Field1=@Field1<br />
WHERE Id_MAP =@original_M_IdMAP" .... ></pre><br />
<br />
But asp throws me this error during the executtion<br />
<br />
Must declare the scalar variable "@Field1 "<br />
<br />
What I need to do to resolve this problem ?<br />
<br />
thank you very much for your help<br />
<code>
Yoni Alhadeff
|
|
|
|
|
Hi,
If I create a new web page (aspx)/ web service (asmx) in VS 2005, there is no namespace for the codebehind class.
I am trying to understand:
1. What is the intention behind this behavior?
2. Can I put my namespace myself, or rather SHOULD I ?
Thanks,
Atul
|
|
|
|
|
Yes you can and you should. I still haven't figured out why there is no namespace. I guess they figure you will add it if you want to.
Ben
|
|
|
|
|
Once compiled the full page class (aspx plus code behind partial class) gets put in the ASP namespace so the final class name is: ASP.path_to_page_PageName. Never tried putting my own namespace in, generally I don't see the need to for presentational code (I do keep UserControls inside a directory structure).
|
|
|
|
|
Hi, I want to build a custom text editor that anybody could use in their Asp.net 2.0. That allows text to be bold, indented, hightlight in Asp.Net2.0. I am not sure where to take a start from. Could somebody gives me an idea and how to go about it. Any input will be highly appreciated.
Thanks
|
|
|
|
|
That is quite an endeavor and could be very complex. Start with researching how to build server controls and do something a little more simple to begin with.
only two letters away from being an asset
|
|
|
|
|
I think you can go with HTML Editor. but texteditor means a good research to be carried out.
if you have completed it with Text Editor means let me know it .
But this is for Html Editor.
Get It[^]
Regards,
Satips.
|
|
|
|
|
Can I ask why? This control has already been built. There are free controls and 3rd party controls you have to pay for. The RadEditor from Telerik is really good.
|
|
|
|
|
Except that all the Telerik controls are incredibly verbose and cost money. Two of the best free WYSIWIG editors out there are FCKEditor (has an ASP.NET control already) and TinyMCE. I'd seriously recommend you look at one of these before embarking on your own - they've already overcome any number of problems you'll come up against!
|
|
|
|
|
Well, i want to build something that could also polish my skills apart from that i wanted to reinvent the wheel. How it's done and where do they get the required information to build one.
I appreciate and thank you all for leaving your responses.
|
|
|
|
|
I want to use the tabcontainer control that is within the Ajax toolkit but but the problem is when I debug my application the following error is displayed
The control with ID 'TabContainer1' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.
please help
karabo mekgwe
Ecom Institute
|
|
|
|
|
Seems rather obvious.  Place a ScriptManager control on the form before any other controls.
only two letters away from being an asset
|
|
|
|
|
|
may be u r placing the script manager after the tab control.. make sure.. it is placed on top.. place it on top of the page.. that ways u`ll avoid this error... do this for every ajax control..
Kunal
|
|
|
|
|
hi friends
i upload the picture i got the error like this
An unhandled exeption occured.Access to the path "c:\inetpub\wwwroot\lgateway\images\logos\country\LGO2.gif" is denied. Try again.
plz tell me the solution
regards
saravanan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
