|
Hi everyone
I am facing very wiered problem ..I am getting time out expired ..while executing procedure through .net... though query runs very fine from SQL
and it doesn't appear all time .. after some time .. say few hours .. time out expired starts coming for specific query only
I am using the following query
----------------------------------------
select tblDirListings.ListingId,tblDirListings.ListingName,tblDirListings.ListingDiscount,tblDirListings.ListingType,tblDirListings.ListingEmailAddress,tblDirListings.ListingPhone,
(select ListingTypeName from tblMSTDirListingType where tblDirListings.ListingType=tblMSTDirListingType.ListingTypeId) as ListingTypeName
from tblDirListings WITH (NOLOCK)
WHERE tblDirListings.TownId=@TownId and (tblDirListings.AgentId=1 or tblDirListings.AgentId=@AgentId)
and tblDirListings.ListingId in(select top 20 ListingId from tblDirListingCategories WITH (NOLOCK) where TownId=@TownId and CategoryId=@CategoryId)
---------------------------------
and calling the store procedure with .net by following coe
----------------------------
sqlCmd = new SqlCommand();
sqladp = new SqlDataAdapter();
sqlds = new DataSet();
sqlCmd.Connection = con;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = procname;
//sqlCmd.CommandTimeout = 1000;
IDictionaryEnumerator ObjEnumerator = Htab.GetEnumerator();
while (ObjEnumerator.MoveNext())
{
sqlCmd.Parameters.Add(new SqlParameter("@" + (ObjEnumerator.Key).ToString(), ObjEnumerator.Value));
}
sqladp.SelectCommand = sqlCmd;
sqladp.Fill(sqlds);
Not sure why it starts appearing after few hours ..then i need to reupload published dll's of app_code and it starts working fine..
Can any one help?
|
|
|
|
|
I would try rewriting the query to use joins instead of running 3 queries in one, that being said, it doesn't seem like the sql query would be that slow.
Also, you are not opening the con object anywhere are you? Because if the connection is already open the dataAdapter will not close it.
I suggest you bust out SQL Profiler on the server and take a look at what is going on. Filter the trace down to your database and see how often this stored proc is getting called. Check to see if any db connections are left open.
Also, view the current activity on the sql server. See if any locks are occuring. I did notice your one query is missing the with (no lock).
select ListingTypeName from tblMSTDirListingType where tblDirListings.ListingType=tblMSTDirListingType.ListingTypeId
I've never used the with no lock in a query (never needed to) but I guess you are doing that for a reason.
I didn't get any requirements for the signature
|
|
|
|
|
Hi Friends,
I need to export PDF Data to excel sheet by using .Net
Is it possible to export???????
Its very urgent
plz reply me...................
|
|
|
|
|
mohanchandra wrote: I need to export PDF Data to excel sheet by using .Net
Is it possible to export???????
yes it is possible [^]
mohanchandra wrote: Its very urgent
who cares
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Can u say the solution?In which way can we solve?????Plz send the code
|
|
|
|
|
He sent you this link[^] to all the information you'll ever need to develop a solution.
Are you asking for code because (a) You're not capable of developing a solution, or (b) you're too lazy, or (c) you left this task until the last possible minute and your arse is about to be trashed, metaphorically speaking?
10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011
|
|
|
|
|
mohanchandra wrote: Can u say the solution?
the solution. Any thing else you want me to say?
mohanchandra wrote: In which way can we solve?????
that way --->
mohanchandra wrote: Plz send the code
Plz send $1500.00 
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
mohanchandra wrote: I need to export PDF Data to excel sheet by using .Net
What does this have to do with ASP.NET ?
mohanchandra wrote: s it possible to export???????
Of course it is. But, only when done by real programmers, who know how to use google and otherwise do basic research
mohanchandra wrote: Its very urgent
No, it turns out that it isn't. At least, not to us.
mohanchandra wrote: plz reply me...................
OK - people like you are the reason I don't post here much anymore. Morons who think they can take Western jobs by asking people online to do the work they have no idea how to do. If you're capable, I don't care where you live. But, you're not, you're totally clueless. So, go away.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I make a online dictionary and I want to add it on firefox browse
Can you help me?
|
|
|
|
|
Need to read Mozilla Developer documentations[^]
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
I'm trying to populate the Server attribute of a very simple MsRdpClient implementation from values in a query string but I'm having trouble.
Ideally the intent here is to simply have my application call this one page for RDP connections to all windows servers.
Sample URL: http://localhost/rdp.aspx?svr=192.168.1.112
<html>
<title>RDP Session</title>
<head>
<script language="vbscript">
sub BtnConnect
Dim goToServer
goToServer = Request.QueryString("svr")
connectedTo.innerhtml=goToServer
MsRdpClient.server = goToServer
MsRdpClient.FullScreen = FALSE
MsRdpClient.Width = "800"
MsRdpClient.Height = "600"
'These 2 do not work from the activeX control
'MsRdpClient.AdvancedSettings2.DisplayConnectionBar = FALSE
'MsRdpClient.AdvancedSettings2.PinConnectionBar = TRUE
'Device redirection options
MsRdpClient.AdvancedSettings2.RedirectDrives = TRUE
MsRdpClient.AdvancedSettings2.RedirectPrinters = TRUE
MsRdpClient.AdvancedSettings2.RedirectPorts = FALSE
MsRdpClient.AdvancedSettings2.RedirectSmartCards = FALSE
'Connect
MsRdpClient.Connect
end sub
sub MsRdpClient_OnDisconnected(disconnectCode)
'goback to the page that called this one
history.go(-1)
end sub
</script>
</head>
<body>
...
<object language="vbscript" id="MsRdpClient" onreadystatechange="BtnConnect">
codebase="msrdp.cab#version=5,1,2600,1050"
classid="CLSID:9059f30f-4eb1-4bd2-9fdc-36f43a218f4a">
</object>
...
</body>
</html>
Basically if there is anything in the query string its ignored and the page won't load. Here's a sample screencap - http://img408.imageshack.us/img408/8278/tsclient.png If I remove the query string and just call rdp.aspx directly, it opens an RDP session to my webserver just fine -- so I know the OCX is working correctly.
|
|
|
|
|
Hi, I've created a datagridview with the wizard in VS2005 (C#) and I would like to know how to add a new column and populate it at run time.
Thanks
|
|
|
|
|
How to create instance of following class ?
public class abc
{
private int _abcID;
private string _xyz;
public int abcID
{
get
{
return _abcID;
}
}
public string xyz
{
get
{
return _xyz;
}
}
public def(int abcID, string xyz)
{
_abc= abcID;
_xyz= xyz;
}
}
abc dd = new abc(WHAT PARAMETER TO ENTER ?);
so that i can access -
if (dd.abcID != 200)
thank you
|
|
|
|
|
You need to add constructor methods to the class. E.G. Public
public class abc
{
private int _abcID;
private string _xyz;
public int abcID
{
get
{
return _abcID;
}
}
public string xyz
{
get
{
return _xyz;
}
}
public def(int abcID, string xyz)
{
_abc= abcID;
_xyz= xyz;
}
public abc (int abcID, string xyz)
{
_abc= abcID;
_xyz= xyz;
}
}
I didn't get any requirements for the signature
|
|
|
|
|
yeh that is what i am asking.
I can do like this i think
abc dd = new abc(2, asd)
but here i am giving new value myself whereas i dont want to add any value. i should get value from _abc and _xyz. So in this case what parameters should i add to get this instance thing working. And so that i can do something like this
if (dd.abcID != 200)
do this
thank you
|
|
|
|
|
You can make a constructor with any or no paramaters.
You can also have multiple constructors.
You can set the value of abcID in the contructor (via passing it as a variable). Or you could set it later by updating a public property. It is for you to decide.
I didn't get any requirements for the signature
|
|
|
|
|
hi everybody
here are the steps of explaining my question.
master page
contentplaceholder
Table with 2 rows 2 cols
in first row first colum i have dragged Tree view. On clicking tree view's sub link different pages come up with different size in contentplace holder. if page size is samll than Tree view doesnt move down. if page size increases tree view control moves into the middle.
my question is that how can i make it not to change its position whatsoever size of the other page is.
help would be appreciated.
regards
learner
|
|
|
|
|
Set a width to the Table E.G. 1000px. Set a width to each TD 200px, 800px.
<table style="width:100%">
<tr>
<td style="width:20%;"></td>
<td style="width:80%;"></td>
</tr>
</table>
I didn't get any requirements for the signature
|
|
|
|
|
I used 2 tab panels in this tab container...In each panel i am using separate user controls .
Named the tab panel as A and B
In Each user control i used edit button..while clicking the edit button, the user control page switch to edit mode with update and cancel button...
Without clicking the cancel button of edit mode in page B, if i switched to tabpanel A of this tab container and come back to previous tab panel B..
the edit mode is existing with update and cancel button in tab panel B..
it should be reloaded once again as in normal mode....which event should used to reload the user control
|
|
|
|
|
try the website asp.net and sample of ajax
|
|
|
|
|
Hi,
how to assign "null" to an Integer Field.. Help me..
|
|
|
|
|
You cannot.
However, you could create a nullable int
If a type is not already nullable, you can create a nullable version by adding a question mark onto the end of the name of the type.
int? myNullableInt = null;
|
|
|
|
|
HI,
Im using the gridview control.I tried to add Records and press enter before completing
Edit item Template becomes Enabled Can any one help me..
|
|
|
|
|
Am used html editor in asp.net. But while i click any item like Bold, or Italic and drag it will paste inside the editor. To avoid this i used FreeTextBox. But it is not Wkg in Safari browsers. Pls anyone help me!!!!!! 
modified on Monday, April 20, 2009 9:41 AM
|
|
|
|
|
I have a grid view control that is defined by data binding.
One of the columns has a really long value so i want to set that the value inside it will jump a line after something like 30 letters. I tried to use the event DataBound to change the column style after the data binding but for some reason it looks like it didn't enter the event and nothing changed.
Does anyone have an idea on how to do what I need or can tell me what went wrong with the way I tried to do it?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
