Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 26, 2012 08:22 AM by Young Yang - MSFT
0 Points
38 Posts
Nov 19, 2012 09:19 PM|LINK
The Tools Used: Microsoft SQL Server Compact 4.0, Visual Studio 2012
The table "ColorTable" with the column "ColorName" is created.
ColorName -------------- green
EDIT: With which functions can the SQL statement (SELECT ColorName FROM ColorTable) be executed?
Contributor
3970 Points
1096 Posts
Nov 19, 2012 09:47 PM|LINK
I've heard good things about the book, Teach Yourself SQL in 10 Minutes.
All-Star
18712 Points
2900 Posts
Nov 19, 2012 10:01 PM|LINK
You can follow the tutorials hee.
http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc
Nov 20, 2012 07:13 AM|LINK
I edited the question, the question I am basically asking is: With which functions can the SQL statement (SELECT ColorName FROM ColorTable) be executed?
137716 Points
22159 Posts
Moderator
MVP
Nov 20, 2012 07:56 AM|LINK
search for ADO.NET SqlCommand.
21739 Points
1825 Posts
Microsoft
Nov 26, 2012 08:22 AM|LINK
string sql = "SELECT ColorName FROM ColorTable"; DataTable results = YourDatabase.ExecuteCommand(new SqlCommand(sql));
Hope this helpful Regards
zevian
0 Points
38 Posts
SQL Select in VB.NET 2012 MVC 4
Nov 19, 2012 09:19 PM|LINK
The Tools Used: Microsoft SQL Server Compact 4.0, Visual Studio 2012
The table "ColorTable" with the column "ColorName" is created.
EDIT: With which functions can the SQL statement (SELECT ColorName FROM ColorTable) be executed?
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: SQL Select in VB.NET 2012 MVC 4
Nov 19, 2012 09:47 PM|LINK
I've heard good things about the book, Teach Yourself SQL in 10 Minutes.
CPrakash82
All-Star
18712 Points
2900 Posts
Re: SQL Select in VB.NET 2012 MVC 4
Nov 19, 2012 10:01 PM|LINK
You can follow the tutorials hee.
http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc
zevian
0 Points
38 Posts
Re: SQL Select in VB.NET 2012 MVC 4
Nov 20, 2012 07:13 AM|LINK
I edited the question, the question I am basically asking is: With which functions can the SQL statement (SELECT ColorName FROM ColorTable) be executed?
ignatandrei
All-Star
137716 Points
22159 Posts
Moderator
MVP
Re: SQL Select in VB.NET 2012 MVC 4
Nov 20, 2012 07:56 AM|LINK
search for ADO.NET SqlCommand.
Young Yang -...
All-Star
21739 Points
1825 Posts
Microsoft
Re: SQL Select in VB.NET 2012 MVC 4
Nov 26, 2012 08:22 AM|LINK
Hope this helpful
Regards
Feedback to us
Develop and promote your apps in Windows Store