|
Hi,
I really don`t know whether it`s the right place to post this question.
I am using SSRS 2008 and I have a report which has two datasets among which one is a query and other is a stored procedure. The stored procedure is basically used to prepare data and insert it in a physical table from where the other dataset would query and generate the report.
My problem is how do i configure the execution of the report so that the procedure executes first and the query executes after the completion of the execution of the stored procedure ?
Any help would be appreciated.
When you fail to plan, you are planning to fail.
|
|
|
|
|
www.Developerof.NET wrote: My problem is how do i configure the execution of the report so that the procedure executes first and the query executes after the completion of the execution of the stored procedure ?
Keep only one dataset - Stored Procedure one. In your SP, apart from preparing data and inserting it in a table, have a select query (which actually right now is in other dataset of yours). Select query result of the SP would return the needed data. Use it!
|
|
|
|
|
How can use a font in my website and make sure it's showing properly on all PCs even if the font is not installed on the local PC? is it possible to copy the font on host and refer to it?
|
|
|
|
|
Well.... no, you can't install fonts on client machines (thank god), but if you really really have to do something like it, then you may want to look at sIFR[^] or Cufon[^] - but neither is exactly straightforward or wothout issues of their own...
|
|
|
|
|
If you can guarantee that all your users use IE, you can link to an embedded font. Here's a link[^] that demonstrates this.
Alternatively, some sites use Flash to embed the font in place - that's a clunky hack, but it is possible.
|
|
|
|
|
I have the following code to populate data into data grid from DevExpress:
sql_connection.Open();
sql_command = new SqlCommand("sp_populate_project_status_by_id", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.Parameters.Add("@website_app_id", SqlDbType.Int).Value = website_app_id;
sql_adapter = new SqlDataAdapter(sql_command);
sql_adapter.Fill(data_table);
gridProject.DataSource = data_table;
gridProject.DataBind();
In the same SELECT sql statemet, I have a website_app field which should be the title for the asp.net page..
how can I get it display there?
|
|
|
|
|
hi,
I need to know some thing.If your sql statement returns 5 records, then each record will have same website_app field that you want to use as your page title? If so its not a better way to do so, anyway if same value for all 5 records for website_app field is same then you can do this
this.Page.Title=data_table.Rows[0]["website_app"].ToString();
Hope this will help
|
|
|
|
|
you are right but anyway to avoid this? I mean to I have to run two queries here, one to get the website_app value once only and the other one to populate the daraGrid? because you are correct, the value of website_app will be the same in all columns and I am hiding that column because I don't want it! I just had to include it to set the page title only!
|
|
|
|
|
how can I draw a vertical line in ASP.NET betwwn two as:TableCell to occupy 100% height?
|
|
|
|
|
|
Hi,
I want to know how can I refer to a label control placed in m y aspx from an ascx included and registered in the same aspx file?
and vise-versa
Thanks
|
|
|
|
|
Hi,
Try this
Label labelName=this.Page.FindControl("labelName") as Label;
|
|
|
|
|
You can expose your Label as property and access it from page.
But its better pass data to control/page instead of accessing controls.
|
|
|
|
|
Hi..
I use Iframe to display PDF document and then with modelpopup extender to display this iframe.
This works fine if I browse it through Mozilla, but dont work If I go for IE-7.
In IE-7 only Iframe displayed and not the PDF.
Could you guide me, what could be the issue.
thanks,
Hemant
By:
Hemant Thaker
|
|
|
|
|
hi all,
MS SQL server compact edition comes with VS 2008. I made database in that . Now i want to use the same database in MS SQL Server 2008 Express edition
Thanks
|
|
|
|
|
Better if you ask this in Databse forum
|
|
|
|
|
i need to load all countries,states in a drop down, can any one suggest me a good link .
|
|
|
|
|
sathimailin1 wrote: i need to load all countries,states in a drop down
Where from you want to load? from Database or XML file?? specify your question.
|
|
|
|
|
i need to load through sql but for that i need country,city,state data, from where i can get the list to bulk insert.
|
|
|
|
|
|
Good Morning,
I am using the ClientScriptManager class to call a java alert from Code Behind when a condition is not met. This is being done from a page that is already a JavaScript pop up. When the alert is responded to, I want the script to close both the alert AND the page that generated the alert. Everything works as designed until I close the alert window...THEN the user is also forced to close a second page (the original generating page for the alert) to return to the starting point. This seems cumbersome and unprofessional. I Googled a bunch of stuff but cannot seem to come up with just the right one. What I have currently is below. I appreciate any assistance...Thank You, Pat
if (RadioButtonSelect.Checked == false)
{
string msg = "The SORT request is only compatible with the SELECT command";
ClientScriptManager script = Page.ClientScript;
if (!script.IsClientScriptBlockRegistered(this.GetType(), "Alert"))
{
script.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('" + msg + "')", true);
}
ScriptManager.RegisterClientScriptBlock(this.Page, GetType(), "Alert",
"window.close();", true);
return;
}
|
|
|
|
|
I think you need to:
a) give different names to the two Key properties of each script you're registering - adn don't use names that are language keywords (such as "Alert")...
b) add a semi-colon after each javascript statement. Otherwise the two will run into each other (concatenate) on the rendered page and cause an error.
c) I am not an expert in C#, but why is your second RegisterClientScriptBlock statement a different format from the first?
d) Don't know why, but I always prefer self.close(), rather than window.close().
Thus, try:
script.RegisterClientScriptBlock(this.GetType(), "jsAlert", "alert('" + msg + "');", true);
and:
script.RegisterClientScriptBlock(this.GetType(), "jsClose", "self.close();", true);
|
|
|
|
|
PDTUM wrote: script.RegisterClientScriptBlock
script.RegisterStartupScript(...)
RegisterStartupScript is the one you have to use.
|
|
|
|
|
Who says you *have* to use RegisterStartupScript ? It works just fine with RegisterClientScriptBlock ...
|
|
|
|
|
Dear all,
I need your advice in this.
The admin of my site can make some articles with images with the html editor and saves the html into the database.
now i want to show the list of articles with the date added, sender, and a short part of the article(depending on the saved html, this can be text with maybe a image). ofter clicking a article, the user can see the entire article.
my question is, what is the best way to do this? wich control to use to list the articles, and how can i show only a part of the article that can also contain a image in that list ?
Thanks in advance.
|
|
|
|