I'm using ASPxPageControl and in each page I have a couple of grids. When Im using Sql Server Profiler each time I change Tab there is a query for each grid in each tab sent to the database. Is it possible not to load data for each grid while changing tabs ?
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 have a webpage with 6 drop down lists. User can start with selecting any drop down list first, and then proceed in any order. 1. Assume when the 1st dropdown is selected first, rest 5 drop downs (except 1st) are filtered/updated based on the selected value in the 1st dropdown.2. Assume user selects the 4th dropdown second, rest 5 drop downs (except 4th) will be filtered/updated but the condition would be based on both 1st drop down and 4th drop down. But while filtering the first drop down, only the 4th drop down is used as filter (self-filter will be ignored).
The code works fine but I see a very bad performance hit in time when the user selects the fourth dropdown after selecting three drop downs. I tried using both SQLDataAdapter and SQLDataReader but neither used to solve the issue. The code takes a lot of time on one line in either of the code (which is highlighted below). When I run the query in SQLServer Mgmt Studio, the query completes in a few seconds.
Im trying to get gridview to update always when changing to different value in dropdownlist. I get my dropdownlist values from database, so for example I have 3 choices there (name1,name2,name3)The problem is that I need to get results for that gridview from 3 different tables. I know how to query those in behind-code file and bind it to a gridview for example..but I dont know how to get it work if I have it also binded on dropdownlist where it should get the name* valuebefore being able to print the results from 3 different tables to the gridview depending of the name* value..And I can't have both DataSource and DataSourceId defined on just 1 gridview..I am using Sqlserver database, asp.net 3.5 with c#
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
I am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
--This column is the issue ,Governing_Class=( case when exists (select top 1 tqc.class_code from t_quote_class tqc inner join t_quote_class_premium tqcm on tqc.class_code =tqcm. class_code where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380') order by tqcm.premium_amt desc ) then ( select top 1 tqc.class_code from t_quote_class tqc inner join t_quote_class_premium tqcm on tqc.class_code =tqcm. class_code where tqc.appid=pi. appid order by tqcm.premium_amt desc ) ......... From tables
I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT LEVEL LVL, SCH.NSCHEDULE_SL, SCH.NSCHEDULE_SL_FM, SCH.CSHED_CNAME FROM FA_SCHEDULES SCH WHERE LEVEL = 1 AND NSCHEDULE_SL_FM IS NULL AND NBRANCH_SL = 2 CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL AND NBRANCH_SL = 2
In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
[URL]UserFiles/ArticlesFiles/633574997433655321_Raja_images.jpg when I click any of secure page like (user page , admin or user ) and I am not login then it will show me in url like this http://localhost:59847/FormsAuthenticationAdvanced/login.aspx?ReturnUrl=/FormsAuthenticationAdvanced/secure/securepage.aspx & displays login form. After login it will redirect me to that respective page which I clicked ( like if secure page is clicked before login then after login it will redirect me to secure page ).
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);
I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.
Currently I run 2 separate queries to update + retrieve a tickent number. What happens if there're 2 users clicking on the same button at the same time? Could somehow two updates being run first and then both users get back the same ticket number?
string mySql = "UPDATE TicketCounter SET TicketNumber = (TicketNumber + 1)"; OleDbConnection myConnection = new OleDbConnection(accessConnStr); OleDbCommand myCmd = new OleDbCommand(mySql, myConnection); myCmd.Connection.Open(); myCmd.ExecuteNonQuery(); mySql = "SELECT TicketNumber FROM TicketCounter" myCmd.CommandText = mySql; OleDbDataReader myReader = myCmd.ExecuteReader();
I am using dataset which contains some records I want to query with dataset to get every time next 20 records. I don't want to do it throught loop is there any way that I can get next 20 records everytime.
I have a datetime column in my table. It has a value like this for example: 4/27/2010 7:34:00 PM. I would like to display the time part of the column in military time. So this datetime column would appear as: 4/27/2010 19:34