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

More Search Options

RSS Available

• Re: Interesting problem with getting OUTPUT parameters from SQL Server using C#

  There's a simple but ugly workaround. Rather than use output parameters, select a second result set that contains one row with one column for each output variable you need. You will then have two result sets. SELECT * FROM SomeTable --This is your normal select result SELECT @Foo AS Foo, @Bar AS Bar, @Zap AS Zap --These are your "output parameters" Of course, you would remove the actual output parameters from the stored procedure if doing this, and just use local variables. If using

  Posted to Microsoft Application Blocks (Forum) by ToddMoon on 7/24/2009

• TFS Merge Conflict Resolution Issue

  I'm new to TFS. I'm evaluating it for the company I'm consulting for. I'm specifically evaluating source control. I found an issue with conflict resolution and I'm hoping there's a process that developers can follow to mitigate the issue. Issue: When merging a branch to the trunk, accidentally closing the conflict resolution dialog assumes you want to keep the trunk version of all remaining conflicting files. Setup: Created a test solution. Created a simple class library project

  Posted to Visual Studio 2008 (Forum) by ToddMoon on 6/13/2008

• Re: Interesting problem with getting OUTPUT parameters from SQL Server using C#

  [quote user="szyder"] try to use return @test [/quote] I am having the exact same problem. This reply is not helpful because the stored procedure may have multiple output parameters. When using return, you will only be able to return one value. EDIT: To clarify my problem, and to contradict the original post, the value of that output parameter is not NULL (DbNull.Value), it's null (good old-fashioned C# null). Which implies that the framework is not assigning any value at all to the

  Posted to Microsoft Application Blocks (Forum) by ToddMoon on 4/30/2008

• Re: Manually check user's access to specified url / path?

  I knew it had to be in there somewhere. Thanks!

  Posted to Security (Forum) by ToddMoon on 2/26/2008

• Manually check user's access to specified url / path?

  I have a user who is logged in through forms authentication with one or more assigned roles. Is there framework method I can call to check his access to a specified url? I have my config file all set up with location nodes specifying which roles can access which paths. I want to leverage that authorization data when building a menu. I know about the security trimming feature of the SiteMapProvider, but I'm actually using a third-party control and I'm doing some manual handling of the databinding

  Posted to Security (Forum) by ToddMoon on 2/25/2008
  Filed under: url, Authorization, manual, path

• Re: Bizarre SQL Server 2000 Timeout Issue

  I don't know about your issue. Maybe you should post a new thread and not piggy-back on this one. Keeps things neat, and if I mark the thread as 'Answered' people might not view your question. As for my issue. I made the command into a stored procedure and the problem seems to have gone away. I did not use WITH RECOMPILE either. Still no real answer to why it ever happened like it did.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ToddMoon on 2/12/2008

• Re: Bizarre SQL Server 2000 Timeout Issue

  I'm not using a SqlDataSource, nor doing any sort of data binding. Like I said in my original post, I have already tried increasing the command timeout, and the query will eventually succeed (in about 60 seconds), but that's not a good solution to the problem. This query should take less than one second to run. The timeouts should not be occurring. Also, your recommended command timeout is kind of ridiculous! Ten minutes!?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ToddMoon on 1/24/2008

• Re: Bizarre SQL Server 2000 Timeout Issue

  No, nothing like that. It's like: Select Count(*) From MyTable Where Serial = @Serial ...plus two more parameters, and joining five tables.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ToddMoon on 1/23/2008

• Re: Bizarre SQL Server 2000 Timeout Issue

  [quote user="TATWORTH"] Can you confirm the problem by running the business layer from NUnit [/quote] For my testing, I am running the code from a console app I wrote for the purpose. This at least eliminates Asp.Net from the equation. I'm not sure why you would only suggest posting the problem to the TSQL forum if I confirm it in NUnit. I don't believe the problem can be reduced to a simple test. It's probably a combination of our data structure, the data itself, the query

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ToddMoon on 1/23/2008

• Bizarre SQL Server 2000 Timeout Issue

  Background: We have an Asp.Net page where you enter a serial number (for a part my company manufactures), and it performs some updates to the data. Before it does, it does some simple selects for validation. Problem: Testers reported that the page will work fine for a while (5 minutes?), but then suddenly start throwing command timeout exceptions. I discovered that the timeouts always occur at the same validation query. Other queries are executed before this one, and they never timeout. The query

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ToddMoon on 1/22/2008
  Filed under: SQL timeout