i am trying to implement a timeout on my database querys...so if an operation runs for too long i need to cancel the query and return a timeout message to an asp.net page....
heres the code i was using for the timeout portion....problem is i am sometimes getting partial result sets from the query...
have a complex sql stored procedure which involves several unions.The unions also involveat from views. When the data is returned, it might look like the following.
ProductId Name Amount Buyer Date YearsAsCustomer 1 Jones 234.44 Nichols 1 Jones 3/12/2011 3 2 Melon 333.00 Tripol 2 Melon 3/23/2011 4
This is just a simple example, but notice how the records with the same product Id can be combined?Because one record has some of the data I need and the other record has different data. So essentiallythey should just be in one record together. So the output should look like this:
ProductId Name Amount Buyer Date YearsAsCustomer 1 Jones 234.44 Nichols 3/12/2011 3 2 Melon 333.00 Tripol 3/23/2011 4
How can I combine these records together? In the stored procedure the query is build in a parameter stringnamed @SQL, and then the query is executed by using the EXEC command:EXEC sp_executesql @SQL.Is their anway I can combine all of the outputted records into one record. Where the records I want to combine have the same ProductId (As in the example I illustrated above?)
I have a select statement. I need to get a field value from the first statement. GOAL: Below is what I am trying to accomplish - the code below is not correct - Please modify the statement with the correct SQL Syntax. I want to query a table and based on the results I want to set the "If THE Else"statement to query then table with diffent inner joins.
SELECT * FROM CONTENTITEM CI INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID IF CI.FORMTYPE = 200 OR 300 SELECT * FROM CONTENTITEM CI INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID INNER JOIN CONTENTFORMFIELD CF ON CF.ITEMID = CI.ITEMID WHERE CI.ITEMID = @ITEMID ELSE SELECT * FROM CONTENTITEM CI INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID WHERE CI.ITEMID = @ITEMID
I am wanting to produce and SQL stored procedure that will combine a the CompanyID with the CompanyName I order to display this in a drop down list/This is what i have so far....
Select CompanyID + ' - ' + CompanyName As DisplayName, CompanyID From Company
The error I get says:
"Conversion failed when converting the nvarchar value 'testcompany' to data type smallint."
Now Im presuming this is caused by the CompanyID being an int and the CompanyName being a string.
I have a menu table which has a (mostly) unlimited number of levels/tiers:
[Code]....
I also have a working function which will give the up and down tiers based on a given MainMenuId:
[Code]....
My question is, is there a better way to do this such as combining the two querries? Every attempt I have made results in a "The Statement terminated. The maximum recursion 100 has been exhausted before statement completion"
I am using ajax control toolkits and ajax extentions in my projects. and as you know it overhead some libraries to page. How can I combine them into 1 js file to reduce requests to server ???
I am using JQuery for all of my client side validation and Asp.net validator controls for all of my server side validation. I am using an errorlabelcontainer to store the client side validations in a summary at the top of the page, which is the requirement. All works well. My problem is, I want to display the server side asp.net errors in the same errorlabelcontainer OR display all of the client side errors in the validation summary. Either way, Both errors need to be in the same place/div. Any ideas on how to do this? I thought of maybe using the asp.net validation summary as the errorcontainer in JQuery, but I cannot find the summary. This is what I have right now.
I have a report with several filter parameters. Everything works fine presently. For one parameter, I use the LIKE as follows in my WHERE statement:
WHERE drug LIKE '%' + @drugused + '%'
@drugused is the selection value of a dropdown list. But now I want to change my parameter to allow multi-selection. But I am not sure how to write my WHERE statement for this. Normally I would use IN but I'm not sure how to do this with the LIKE.
where the data param is an array of name/value pairs. To prepare my values for that data param I need to combine the properties of a strongly typed class with the values of a simple 2d array.
Does anybody knows possibilities or approaches to combine ASP.NET with SAP Webdynpro (or to embed/integrate Webdynpro in a ASP.NET (or Silverlight) application) ?
I lied! The commandline fails if the two source files have different bitrates (does samplerate matter?). Also, the source code below succeeds when the two sources are the same bitrate. So, this looks like a bitrate challenge now.
Original question:
result.mp3 (from the commandline, below) is playable in WMP11. The ASP.NET code below serves a file which plays fine in WMP11. But, when I uncomment those two lines, WMP11 won't play the file. Something about the code that merges the two MP3 files isn't to the satisfaction of WMP11. How can I change the ASP.NET code to merge the two MP3s in the HTTP response with the success that the 'copy' commandline gives me?
I have developed some ASP.NET server controls which include their own javascript and css files. A lot of these controls use jQuery extensions which, as you know, often include their own css files.
I'm using Telerik's RadScript manager which combines the javascript like a boss. However, I'm using the AjaxToolkit's ClientCssResource attribute to include the css files in my server controls, and I have noticed that the CSS files are not getting combined at all. My pages have 10-15 WebResource.axd requests for css files for my server controls.
Everything I find only is about combining javascript, and nothing tells me how I can combine the CSS files. Does anyone know if there is a way to combine the CSS dynamically (I don't want to manually combine as each page might use a different subset of the server controls)?
I currently have a Web Application project in VS2010. Each control (in *.ascx files) is contained in it's own separate folder along with the web services used by that control (in *.asmx files) and the javascript object used to manipulate it (in *.js files). So the project layout looks something like:
The project is expanding and I'm looking to upgrade and replace the .js files using Script#. I'd like to maintain this structure but as far as I can tell there's no way to mix Script# and regular C# files in the same project.
I've looked at the Readme PDF on the Script# site and downloaded the PhotoDemo example but I can't find any examples of using Script# along side Web Controls. I've tried adding the 'Script Support' template to the project and then adding both Class and Page templates from the Script# template list but they both get treated as regular C# source code files.
I've used reflector to look into the mscorlib, System.Web, ScriptSharp.Web, ScriptSharp.VisualStudio, ScriptSharp and Script.Windows binaries that are installed by Script# and haven't been able to find anything that would allow this behaviour.
Has anyone implemented something similar or have any further hints?
The only way I've managed to use Script# at the moment is to have a separate Script# project and have the output for the javascript files be inside my Web Application.
i am new in asp.net i dont know to how to combine two asp.net web site into one like domain and subdomain concept. i know the procedure to host one web application in local iis. how to combine two application and how to host in local iis i.e) single url as domain(one web application) and subdomain(another web application).
I have a master/detail web form and i have implement a caching to hold detail data. i am facing problem that when two user login same time and enter data, cache has combined the data and both user ara getting each other data. i want every user gat his own data.
I had to rebuild my development environment after my hard drive crashed. Before the crash I used ScriptManager with CompositeScript tags to combine js files using AjaxControlToolkit, version 3.0.20820.29441. Now I am forced to use AjaxcontrolToolkit version 3.5.40412.0 which insists that I use ToolkitScriptManager which seems to combine ALL Ajax controls instead of the ones I specifiy in CompositeScript. And when I use the attribute CombineScriptsHandlerUrl="~/CombineScriptHandler.ashx" (the latter from SampleWebSitethat comes with AjaxControlToolkit) I see in Fiddler that the ashx file cannot be found.
I have the following authorization rules in my web.config:
[code]....
Except for the path attribute these two rules are the same. Is there a way to combine these two rules into one like path = Register.aspx, ForgotCredentials.aspx.