Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:778197
More Search Options
RSS Available
Matching Posts
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
Page 1 of 649 (6484 items) 1
2
3
4
5
Next >
...
Last »
ASP.NET:
Silverlight and RIA Services: Implementing Search
Channel 9:
C9 Lectures: Brian Beckman - Covariance and Contravariance in Physics 1 of 1
Channel 9:
Set Your Data Free
Channel 9:
Implementing a Silverlight SharePoint WebPart with Visual Studio 2010
WindowsClient:
New WPF Showcase Addition: Enterprise
Channel 9:
Reactive Extensions API in depth: Contract
WindowsClient:
Concluding "New WPF Features" Series
WindowsClient:
Introduction to TestApi – Part 5: Managed Code Fault Injection APIs
ASP.NET:
T4MVC now has a real home and a dedicated forum!
TechNet Edge:
Windows Server 2008 R2 : New Power Management Features
ASP.NET:
Web Deployment Painkillers: VS 2010 & MS Deploy
WindowsClient:
Application Accessibility Testing
WindowsClient:
Prism & WCF RIA Services
Channel 9:
Sharepoint 2010 and Claims-Based Identity
WindowsClient:
IRhetoric Ported To BlogEngine.NET
WindowsClient:
PDC Recap and More
Channel 9:
Reactive Extensions API in depth: Primitives
WindowsClient:
New WPF Features: MultiTouch
WindowsClient:
codeplex.com/testapi v 0.4 available
Channel 9:
The Visual Studio Documentary - Alan Cooper, the Father of Visual Basic
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online