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

More Search Options

RSS Available

• Problem following the video

  Hi, I've decided to take a look at http://www.asp.net/learn/mvc-videos/video-395.aspx I don't have MVC template in VS 2008, so I decided to try it with VS 2010 Beta 2. I followed the video precisely up to the creation of the new controller class. However, when I was trying to create a new private MoviesDBEntities _entities = new MoviesDBEntities(); it didn't give me an option to include the reference and I don't know where this class is supposed to come from. Is it something wrong

  Posted to ASP.NET 4 Beta 2 (Forum) by Naom on 11/25/2009

• Re: How To Use A Querystring In A Select Statement

  Immediate problem that I see in your code is that you're trying to use string concatenation instead of using parameters approach. First step would be to switch to parameters. Second step would be to switch to SP and test it standalone first.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: How To Use A Querystring In A Select Statement

  [quote user="Schwimms"] Naom, I don't know what you mean by parameters approach. Also what is SP... :| [/quote] Check http://forums.asp.net/t/777624.aspx in its whole to understand about parameters approach. By SP I meant Stored Procedure.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: SQL question

  The usual practice is to write code like this SELECT PartNo, [Length], [Width], [Height] FROM PartSpecs WHERE (@Param1 IS NULL or [Length] =@Param1 ) AND (@Param2 IS NULL or [Width] = @Param2) AND (@Param3 IS NULL or[Height] BETWEEN @Param3 - 5 AND @Param3 + 5)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: TSQL ID/Bucketing by Sum (no CURSOR!)

  I'm sorry, I am busy today to try to go to implementation details, but I believe that your problem is very close to the problem I described in recursive CTE blog I gave a reference to you. The first problem looks like you can adapt it for your case.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: TSQL ID/Bucketing by Sum (no CURSOR!)

  I see, Jeff Moden's Running Total blog. I'm glad and you can post your solution for a reference. You can also mark the helpful responses as an answer.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: SQL question

  If you pass 2 parameters, then this query will return only records matching two parameters. You may put a check at the top of SP to check for at least 2 non null parameters.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: Why did my post get deleted

  You may try asking your question in the Free for All forum.

  Posted to Feedback on this website (Forum) by Naom on 11/25/2009

• Re: Drop Down List - Searching with stored procedure

  I would probably just write 3 separate queries with 3 IF ELSE IF statements. It may be easier. Alternative solution would be where myConditions and ((@Country ='US' and US = 'Y') or (@Country = 'UK' and UK = 'Y') or (@Country = 'Other' and US = 'N' and UK = 'N'))

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009

• Re: Drop Down List - stored procedure

  [quote user="limno"] If you use a SEX column instead of male and female columns in your table, you would be more happy to write queries for this table. [/quote] I agree 100%. I never saw a BR when we need the structure like you have.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Naom on 11/25/2009