Click here to Skip to main content
15,897,187 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionsecurity trimmin enabled! Pin
Learner52020-Apr-09 17:03
Learner52020-Apr-09 17:03 
Questionset as start page ignored Pin
hassanmohamed20-Apr-09 9:45
hassanmohamed20-Apr-09 9:45 
AnswerRe: set as start page ignored Pin
Colin Angus Mackay20-Apr-09 10:36
Colin Angus Mackay20-Apr-09 10:36 
QuestionSending email with link from localhost Pin
Shahdat Hosain20-Apr-09 8:59
Shahdat Hosain20-Apr-09 8:59 
AnswerRe: Sending email with link from localhost Pin
Yusuf20-Apr-09 9:12
Yusuf20-Apr-09 9:12 
JokeRe: Sending email with link from localhost Pin
N a v a n e e t h20-Apr-09 16:59
N a v a n e e t h20-Apr-09 16:59 
AnswerRe: Sending email with link from localhost Pin
Perry Holman20-Apr-09 19:02
Perry Holman20-Apr-09 19:02 
Questiontime out Expired Pin
sachinasp20-Apr-09 7:48
sachinasp20-Apr-09 7:48 
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?
AnswerRe: time out Expired Pin
ToddHileHoffer20-Apr-09 8:32
ToddHileHoffer20-Apr-09 8:32 
QuestionHow to export PDF Data to excel sheet by using .Net Pin
mohanchandra20-Apr-09 7:46
mohanchandra20-Apr-09 7:46 
AnswerRe: How to export PDF Data to excel sheet by using .Net Pin
Yusuf20-Apr-09 7:54
Yusuf20-Apr-09 7:54 
GeneralRe: How to export PDF Data to excel sheet by using .Net Pin
mohanchandra20-Apr-09 8:27
mohanchandra20-Apr-09 8:27 
GeneralRe: How to export PDF Data to excel sheet by using .Net Pin
MidwestLimey20-Apr-09 8:39
professionalMidwestLimey20-Apr-09 8:39 
GeneralRe: How to export PDF Data to excel sheet by using .Net Pin
Yusuf20-Apr-09 9:14
Yusuf20-Apr-09 9:14 
AnswerRe: How to export PDF Data to excel sheet by using .Net Pin
Christian Graus20-Apr-09 11:21
protectorChristian Graus20-Apr-09 11:21 
QuestionAdd on firefox Pin
ngvhia20-Apr-09 7:40
ngvhia20-Apr-09 7:40 
AnswerRe: Add on firefox Pin
Yusuf20-Apr-09 7:55
Yusuf20-Apr-09 7:55 
QuestionPass Server attribute to MsRdpClient from query String? Pin
cknight72520-Apr-09 7:12
cknight72520-Apr-09 7:12 
QuestionAdding new column and fill with computed data to an EXISTING datagriview Pin
Massoud1234520-Apr-09 6:40
Massoud1234520-Apr-09 6:40 
Questioncreating instance Pin
AndyInUK20-Apr-09 6:05
AndyInUK20-Apr-09 6:05 
AnswerRe: creating instance Pin
ToddHileHoffer20-Apr-09 6:35
ToddHileHoffer20-Apr-09 6:35 
GeneralRe: creating instance Pin
AndyInUK20-Apr-09 23:32
AndyInUK20-Apr-09 23:32 
GeneralRe: creating instance Pin
ToddHileHoffer21-Apr-09 3:13
ToddHileHoffer21-Apr-09 3:13 
Questiontree View! vs 2008 c# Pin
Learner52020-Apr-09 4:44
Learner52020-Apr-09 4:44 
AnswerRe: tree View! vs 2008 c# Pin
ToddHileHoffer20-Apr-09 6:38
ToddHileHoffer20-Apr-09 6:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.