i have a complex MSSQL query in my ASP.NET page with rows showing in GridView control.
I want to know what is the best solution for stopping the query if it takes more than X seconds to show in GridView.
I'm executing one stored procedure from the '.net' code. Since there is a lot of data, it is taking too much time to execute. Is there any way to stop this execution from the c# code?
In other words, if we execute the query from database itself, there is a option to stop its execution but in the code is it possible?
(I believe that this applies to both normal ASP.NET web parts and SharePoint hosted web parts)
The web part has an 'export' button that renders the output as csv and sets the appropriate headers so its opened in Excel.
Hooking in the buttons click event, clearing the response, adding the appropriate headers and content types is trivial - example
However I've noticed that if this code added to a web part and a debugger attached then if there are multiple instances of this (or any other) web part on the page then neither HTTPApplication.CompleteRequest or Response.End stop the processing/page lifecycle and all the events for all the page controls still fire.
This is wasteful in this example as the other web parts don't need to run - nothing they do will get to the response.
How to stop the execution and redirect to the login page. I tried FormsAuthentication.Signout but seens it doesn't stop the execution and let the code continue.
View 1 RepliesI am having a base class which implements some basic authentication for all the pages in the application.
public class BasePage : Page
{
public void Page_PreLoad(object sender, EventArgs e)
{
if (!IsUserValid())
{
Response.Redirect("default.aspx");
[Code]....
How to stop page life cycle for AuthenticatedUser, if the user is invalid?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT * FROM Table1 WHERE Date =" & TextBox1.Text & "'", SQLData)
SQLData.Open()
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
While dtrReader.Read()
For j As Integer = 1 To 31
Dim s As String = "s" & j
If dtrReader(s.ToString()).ToString() = "b" Then
Dim img As ImageButton = DirectCast(Panel1.FindControl(s.ToString()), ImageButton)
img.ImageUrl = "~/Images/booked.gif"
img.Enabled = False
End If
Next
End While
dtrReader.Close()
SQLData.Close()
End Sub
Error:
Unclosed quotation mark after the character string ''.
I have a query:
Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
When I am executing this query, it is taking 1-2 seconds to execute, but when I am using the same query in stored procedure, the below query is taking more than 5 minute:
If(Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12))
BEGIN
-- CREATE TEMPORARY TABLE [Say: #temp1]
#temp1 => Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
inserting the same value in the temp table
drop #temp1
END
what could be the reason of this? and how can I resolve this? I am running the SP from asp.net
I need to find out the query execution time from the front end .Where should I insert the code for that.
I am using the bleow query:
OracleConnection con = new
OracleConnection(ConnStr);
con.Open();
OracleCommand cmd =
new
OracleCommand("Stored_Proc",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add();
....................
................
OracleDataAdapter
oda = new
OracleDataAdapter
(cmd);
when i am executing a simple query it is takeing 47 sec .... that is only for one table.. other then that remaing table perfromance is good... Help me out... and is there chance to get good perfomance through .net coding..
View 3 RepliesCan any one please provide link for flow of query exection in sql
For eg.
FROM, [JOIN CONDITION, JOIN TABLE ...], WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, TOP
Suppose when we write query, how that query will get execute behind. I would like to know about that.
Can you please provide ariticles or link related to this
can anyone explain me how below query will execute internally ??
select sal from emp e1 where 3>(select count(*) ct from emp e2 where e1.sal < e2.sal)
i am using the transaction-per-request (session-in-view) pattern for an asp.net web application. I have a couple of points in the application where i want to Save an NHibernate managed entity and then do a couple of more inserts and updates using common sql. These inserts/updates depend on the ID that the NH saved entity will take.
The problem is that the generated id does not exist in the transactions' scope. If i force a flush/commit the id is persisted but if the inserts/updates fail i have to rollback but the flushed/committed entity will not. Currently I'm doing a manual insert for these cases but that is something i want to change. So, is there a way to execute the SQL statement (inside the already open transaction) after the Save() but without forcing a flush/commit?
EDIT: I'm adding a semi-pseudocode example, i got 4 wrong answers so i think people don't understand (how NHibernate works)
At the Begin request i issue a
nhsession.BeginTransaction()
then at some point i do
FooClass fc = new FooClass("value");
nhsession.Save(fc);
ITransaction trans = nhsession.Transaction;
SqlCommand sc = new SqlCommand("some insert/update query that depends on fc's id", (SqlConnection)nhsession.Connection);
sc.Parameters.Add("id", fc.Id); //NHibernate generates the id, note i'm using assigned/hi-lo so no round trip to the db takes place
transaction.Enlist(sc);
try {
sc.ExecuteNonQuery();
}
catch (SqlException ex){
transaction.RollBack();
nhsession.Close();
}
and at the end of the Request i issue a CommitTransaction() and nhsession.Close()
Now this will do absolutely nothing: the FooClass (fc) has not been flushed/commited to the database. The Save() operation that NH has done is up to that point in-memory. That means no sql command has been issued by nhibernate and that means that the SqlCommand (sc) that i fire afterwards will fail miserably as the id does not exist.
If i do a flush/commit between Save() and the SqlCommand the FooClass(fc) _cannot_be_rolled_back_ and that is a bad bad thing.Currently, for this to work i make vanila sql insert using an SqlCommand, and i want to change that. (Why? because i don't want to make vanilla inserts they are susceptible to errors due to schema/model changes, and i got the OR/M for that)
How? i want to notify NHibernate somehow to execute the SqlCommand to corresponds to the Save() insert (hell, it can do all the SqlCommands it has gathered) but without it commiting or flushing!.
Currently i'm also searching for the prepared sql statement that nhibernate produces when flushing/commiting a saved object. Maybe i can just take that string and run it in my SqlCommand that is enlisted in the Transaction.
I'm building an ASP.NET MVC site that uses LINQ to SQL. In my search method that has some required and some optional parameters, I want to build a LINQ query while testing for the existence of those optional parameters.
Here's what I'm currently thinking:
using(var db = new DBDataContext())
{
IQueryable<Listing> query = null;
//Handle required parameter
query = db.Listings.Where(l => l.Lat >= form.bounds.extent1.latitude && l.Lat <= form.bounds.extent2.latitude);
//Handle optional parameter
if (numStars != null)
query = query.Where(l => l.Stars == (int)numStars);
//Other parameters...
//Execute query (does this happen here?)
var result = query.ToList();
//Process query...
Will this implementation "bundle" the where clauses and then execute the bundled query? If not, how should I implement this feature?
I have a big query that it execute in 4 minutes. (for example an important trigger)
I want to show situation of query or count of records that is affected in every 10 second in to a web page.
what should I do? (complete explain)
I have a class that being used to connect with the DB. Now I want to count how many times each web request executes the queries, but I've no idea where to store the counted value. I mean, Session wont, ViewState wont work as site also have webservices. What else I can use?
View 12 Repliesi am new at reporting service things when i try to create a report i got this error and idea how to fix it
An error occured during local report processing.
An error has occured during report processing.
Qery execution failed for dataset 'ds_testtablosu'
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MMDB"
I notice whenever I try to build my asp.net website that I have been working on it compiles as a dll rather than as an actual web site. I don't know why but it seems to happen with all my asp.net project for the past couple of days. I might have accidentally change the output settings. However, I output type select that is set to "Class Library" but the selection to greyed out so I can not change it. How do I change the settings?
View 5 Repliesi used a jQuery plugin who try to call three or four method because some of them not implemented in some browser. code is working fine for me and it's work in all browser.when i try to debug the application in visual studio and internet explorer then i found the same errror everytime Microsoft JScript runtime error: Object doesn't support this property or method i see the same error every time. are it is not really so weird that they give me error every time even i put refresh and see error first then see the page in IE. i am trying to disable the script debugging for other and IE in IE but after that they never forget to give me error.well i am not want to go in the depth of this but someone tell if i can stop showing this window in my visual studio 2010.
View 2 RepliesWhen viewing an asp.net page in visual studio 2008, the asp.net development server icon shows up in the system tray. It can be stopped by right clicking on it and select "stop". In Visual Studio 2010, I do not see the icon any more. where the asp.net development server is? How to stop it?
View 3 RepliesI have to manually edit a bunch of HTML and ASP.NET pages that contain primarily content in <p> tags. In VS2010, when I open such a page in the designer it insists on highilighting all the paragraphs; surrounding them with dotted blue rectangles and shading all other paragraphs.
I find this annoying, can I turn these behaviours off?
EDIT
I managed to change the colours by going to Tools, Options, HTML Designer, View and editing the colours for "Layout UI activated border" and "Style application overlay".
I have a code like the following:
Code:
<table>
<col width="50%" />
<col width="50%" />
<tr>
<td>
</td>
<td>
blah blah
</td>
</tr>
</table>
When i switch to design and get back to source view it added the colgroup so my code looks like this:
Code:
<table>
<colgroup>
<col width="50%" />
<col width="50%" />
<tr>
<td>
</td>
<td>
blah blah
</td>
</tr>
</colgroup>
</table>
how to make the IDE stop adding these extra elements? i changed the Target Schema to all possible combination and it didn't help.
I have a Gridview which is populated from an ObjectDataSource. Data Source has a control parameter hooked up to the SelectedDataKey value of the GridView. My Gridview has rows which may not have a DataKey. I am receiving an error when a GridView row without a DataKey is selected.
View 5 RepliesI am debugging an ASP.Net C# application in Visual Studio 2010, the application is running and execution is currently stopped at a breakpoint. How can I stop the page execution without "Terminate All" or killing the debugging process altogether, similar to what would happen if an unhandled exception was thrown? The "Break All Cntl+Alt+Break" option is grayed out in the Debug menu.
I want to stop the app from running but not have to go through a compile/start again. EDIT: I want execution to stop, not break, so that the page finishes loading and I don't continue running the application from the breakpoint forward. I've looked through the Breakpoints panel, the Debug menu and have right clicked all over but still haven't found the right option.
I am about to get my sites hosted with a local host company. They are offering me their lowest cost MSSQL server, which is the web edition. So my question is what is the difference between that and 2008 express edition? Can express edition be used for a full fledge in production website? And does Web implies that I will be interacting with it via the web correct. Lastly, if the web version is not chosen what is the typical protocol for uploading and maintaining a site when you have a dedicated server. Do you normally have to go to the data center or is there like a web portal that can be used. I will be asking the guys at the company these questions as well, but I want to make sure I get another opinion on the issue.
View 1 Repliesi am using sql server inbuilt mail system for sending mail.and i made SP to call dbmail sp
now my problem is when i call sp it get executed fine but in last suppose 1000 mails queued then 1000 times i get mail queued.and that my connection time out .i extend connection time out limit but i get error msg like
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Mail queued."
my mail get queued well proper but due to 1000 or 100000 mail queued its lost of msg make problem.