You searched for the word(s): userid:643251

More Search Options

RSS Available

• Re: SqlDataReader Weird Locking.

  Am I the only one who has this issue?

  Posted to Data Access and ObjectDataSource Control (Forum) by net_prog on 1/5/2009

• Re: SqlDataReader Weird Locking.

  Thank you for your help. I found out that this situation does not relate to any stored procedures or views, I have updated the initial post message - I tried to use the simple SELECT statements querying different tables. And the same locking occurs. During the DataReader run, Activity Monitor displays only one active process - the DataReader process, and another connection which is idle. So seems the second page cannot even reach the SQL Server while the DataReader runs. That probably means that

  Posted to Data Access and ObjectDataSource Control (Forum) by net_prog on 12/30/2008

• Re: SqlDataReader Weird Locking.

  I think running the queries in Management Studio will not discover anything, since the problem here in ASP.NET data provider as it seems. Furthermore, how can I simulate the Thread.Sleep() in T-SQL? I use SQL Server 2005 Developer Edition. This is not a cause though, since on the remote host where my web-site is - the same situation occurs, so this is not the SQL Server which causes this. I think this is a sort of ASP.NET issue and hard to explain why it happens. viewActiveProducts (nothing complex

  Posted to Data Access and ObjectDataSource Control (Forum) by net_prog on 12/29/2008

• Re: SqlDataReader Weird Locking.

  The stored procedure: ALTER PROCEDURE [admin].[OpenReader_AmazonFeed] @selectChangedOnly BIT AS BEGIN SELECT id, pName, pImage, pPrice, barcode, productType, partNo, placement, fitment, yearFrom, yearTo, isLHD, pDescription, techText, instructions, modelName, stockStatus, sections.sectionName AS brandName FROM viewActiveProducts (NOLOCK) INNER JOIN sections (NOLOCK) ON viewActiveProducts.pSection = sections.sectionID WHERE barcode IS NOT NULL AND isOutOfStock = 0 AND stockStatus >= 0 AND ( @selectChangedOnly

  Posted to Data Access and ObjectDataSource Control (Forum) by net_prog on 12/29/2008

• SqlDataReader Weird Locking (ASP.NET Issue?)

  Hello. I have a problem using SqlDataReader . It does lock every and each other page when running . I have one web-page with a long-running SqlDataReader. When I try to load another page at the same time which queries data from the database - that other page waits until SqlDataReader on the first page finishes working. That is very weird since the pages use separate connections . The code of the page-1: public partial class misc_dbtest : System.Web.UI.Page { protected void Page_Load( object sender

  Posted to Data Access and ObjectDataSource Control (Forum) by net_prog on 12/29/2008
  Filed under: sqldatareader

• Re: UpdateMode Conditional updates always

  Hello, this didn't help. Do I need to set "Conditional" update mode to the panels? Also, TargetControlID, not TargetPanelID I suppose, right?

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by net_prog on 10/1/2007

• Re: SliderExtender advertised Value property does not exist

  Yes, that works, just found out myself.

  Posted to ASP.NET AJAX Control Toolkit (Forum) by net_prog on 9/24/2006

• SliderExtender advertised Value property does not exist

  Hello. Does anybody know how to preset a SliderExtender value? The demo site http://atlas.asp.net/atlastoolkit/Slider/Slider.aspx shows a property named Value, but there is no such found. No way to preset a default value.

  Posted to ASP.NET AJAX Control Toolkit (Forum) by net_prog on 9/23/2006

• Atlas partial rendering BUG which occurs only in Firefox browser

  When designing user controls, there is no way to use CSS style sheet, other than using a direct statement of type <link href="styles.css" rel="stylesheet" type="text/css" /> In opposite to pages included into MasterPages, where the CSS attached to the MasterPage works on the page too. Now the bug reproduction, simple (use Firefox). Create a page and put Atlas UpdatePanel and Script Manager there, and enable PartialRendering. Create a UserControl and put a CSS link

  Posted to ASP.NET AJAX UI (Forum) by net_prog on 9/22/2006

• Re: [Newbie]Logon Failure in Crystal Report

  Hello. The sample code provided Report1 myReport = new Report1(); Viewer1.ReportSource = myReport; Viewer1.DataBind(); Report1 is used as a class, but how to make it availabe? I created a report with the name "CrystalReport1" and can't just write CrystalReport1 rep = new CrystalReport1(); How to get a reference to that report?

  Posted to Crystal Reports (Forum) by net_prog on 9/14/2006