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

More Search Options

RSS Available

• Split a string into sunstrings using a string not char

  I need to split a file into substrings each beginning with --<LINKEDSERVER>. I'm trying to use the string.split method but it seems to only accept char[]. I want to use --<LINKEDSERVER> to delimit the file. See example text below. I would like a collection of substrings that all begin with --<LINKEDSERVER>. --<LINKEDSERVER> IF OBJECT_ID('FN_CHECKSECURITY') IS NOT NULL DROP FUNCTION FN_CHECKSECURITY GO --<LINKEDSERVER> CREATE FUNCTION FN_CHECKSECURITY ( @sItemGUID

  Posted to Getting Started (Forum) by InsanePaul on 7/2/2009

• Am I catching errors properly from a SP?

  I have the following stored procedure and command to call the SP but wondered if I am catching the error correctl BEGIN TRANSACTION --1. strCellFormulae DELETE FROM strcellformulae WHERE stoolguid = @stoolguid IF @@ERROR <> 0 Begin ROLLBACK RAISERROR('Error in deleting tool from strcellformulae.',16,1) RETURN END // Use SP to Delete Tool // eg. EXEC Pilot1_UAT2.UAT2.dbo.sp_DeleteTool '{6400e25f-5401-4961-91d6-2059c08da1f4}' sqlString = "EXEC " + sb.ToString() + "sp_DeleteTool

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by InsanePaul on 6/10/2009

• Re: Timeout problem have checked session state

  [quote user="aditya1986"] to solve your problem set session time out in web config else you set time out in iis i hope it helps you [/quote] Like I already said both timeouts have been set at 20mins but mine times out after 10-15 mins of idle time

  Posted to State Management (Forum) by InsanePaul on 6/4/2009

• Re: LoginStatus on masterpage does not display 'logged in'

  [quote user="Dave Sussman"] It's definitely not master page per se, because this is exactly what I do. So on the production server you click the login link and it takes you to the login page; you then login successfully and it stills shows login? Is the login box within an UpdatePanel? Are you redirecting to another page after the login? Essentially you have to refresh the page, which is usually handled my directing users back to the home page, or the login will do it automatically

  Posted to Master Pages, Themes and Navigation Controls (Forum) by InsanePaul on 6/4/2009

• Timeout problem have checked session state

  The website times out between 10 - 15 minutes of idle time. The webconfig says: The Global.asax file has no timeout constraints The IIS for this particular website doesnt use the default application pool instead a new one was created called DOTNETAPPPOOL application pool. I've chaecked the settings: shutdown worker processes after being idle for 20mins enable session state session timeout 20 minutes. So something else is overriding the timeout of 20 mins. Can someone explain what it is and what

  Posted to State Management (Forum) by InsanePaul on 6/4/2009

• Multiple users see a different set of results

  Not sure if this problem is a session problem or a sitepath problem or something else. The scenario: 2 users can navigate to a page (lets say page 2) whose data will be different for each user depending on the previous pages selections which is sent in the query string. The 1st user goes to page 3 then returns to page 2 but sees the 2nd users page (or I guess the last person to be logged in). If the 2nd user navigated to page 3 then back again to page 2 it shows the correct data. So it looks like

  Posted to State Management (Forum) by InsanePaul on 6/4/2009

• LoginStatus on masterpage does not display 'logged in'

  Not sure if this is a masterpage issue or loginstatus issue but when a user successfully logs in the loginstatus control on my environment displays 'log out' but on the production server it displays as 'login'. Any idea what to do?

  Posted to Master Pages, Themes and Navigation Controls (Forum) by InsanePaul on 6/4/2009

• Re: Restrict Label text in Gridview column

  With a bit of digging I found out the answer from this forum http://forums.asp.net/p/1080197/1596008.aspx#1596008 I used: Text =' <%# Helper.Truncate(Eval("Name").ToString()) %> ' The helper class Truncate is: public string Truncate( object longTitle) { String shortTitle = string .Empty; if (Convert.ToString(longTitle).Length > 20) { shortTitle = Convert.ToString(longTitle).Substring(0, 20) + "..."; } else if (longTitle is DBNull) { shortTitle = string .Empty;

  Posted to Data Presentation Controls (Forum) by InsanePaul on 3/26/2009

• Re: Restrict Label text in Gridview column

  [quote user="Qin Dian Tang - MSFT"] Hi InsanePaul, I am using this way: <asp:TemplateField HeaderText="Content"> <ItemTemplate> <asp:Label ID="ContentLB" Text='<%# Eval("Content").ToString().Substring(0, 20) + "..." %>' runat="server" /> </ItemTemplate> </asp:TemplateField> Thanks, [/quote] Hi, this was very useful however there may be instances where there isn't any data therefore I get the

  Posted to Data Presentation Controls (Forum) by InsanePaul on 3/26/2009

• Re: Restrict Label text in Gridview column

  [quote user="JeanT"] Hi InsanePaul , If your situation allows it, why not cut it at the source via SQL? SELECT LEFT( sHelp , 10 ) FROM YourTable Jean [/quote] Although this will truncate the output when I go to edit the cell I would want to see all the text so unfortunately this doesn't work for me

  Posted to Data Presentation Controls (Forum) by InsanePaul on 3/26/2009