数据库SQL语句 [英] Database SQL Statement
问题描述
我刚刚下载了这个VB Express。我需要一些帮助来理解数据库数据的请求
，这是与SQL语句相比的格式/语法。
在我的SQL中我会使用select语句...例子
从成员中选择LastName，其中月份（生日）=月份（现在）
这将是怎样的用VB Express编码？
伯爵
I just downloaded this VB Express. I need a little help in understanding the request
for database data, that is the format/syntax compared to an SQL statement.
In my SQL I would use a select statement... example
select LastName from Members where month(Birthday) = month(now)
How would this be coded in VB Express?
Earl
推荐答案
你可以完全相同方式或者您可以查看存储
过程/ SQL函数。你甚至可以走LINQ的路线。
就像你做的那样，你需要
SQLConnection ，SQLCommand和SQLDataReader对象。
或
您可以选择数据集的路径。
总共有吨从
数据库中检索数据的不同方法只需选择适合您的风格和应用程序的数据和
享受。
You can do it the exact same way or you can look into Stored
Procedures/SQL Functions. You could even go the route of LINQ.
As far as doing it the same way you''re doing it you''ll need the
SQLConnection, SQLCommand, and SQLDataReader objects.
or
You could go the route of datasets.
All in all there are tons of different ways to retrieve data from a
database just pick which one suits your style and application and
enjoy.
我想坚持我熟悉的东西，但每次我尝试
做一个
"从会员中选择xName其中FName =Dan我收到回复
认为我正在尝试做一个精选案例。
Earl
" cfps。基督教QUOT; < ge ******* @ otc.eduwrote in message
news：8b *********************** *********** @ t63g2000 hsf.googlegroups.com ...
I would like to stick with what I''m familiar with, but every time I try to
do a
"select xName from member where FName = "Dan" I get the response that
thinks I''m trying to do a Select Case.
Earl
"cfps.Christian" <ge*******@otc.eduwrote in message
news:8b**********************************@t63g2000 hsf.googlegroups.com...
您可以采用相同的方式完成，也可以查看存储
过程/ SQL函数。你甚至可以走LINQ的路线。
就像你做的那样，你需要
SQLConnection ，SQLCommand和SQLDataReader对象。
或
您可以选择数据集的路径。
总共有吨从
数据库中检索数据的不同方法只需选择适合您的风格和应用程序的数据和
享受。
You can do it the exact same way or you can look into Stored
Procedures/SQL Functions. You could even go the route of LINQ.
As far as doing it the same way you''re doing it you''ll need the
SQLConnection, SQLCommand, and SQLDataReader objects.
or
You could go the route of datasets.
All in all there are tons of different ways to retrieve data from a
database just pick which one suits your style and application and
enjoy.
" Earl Partridge" < ea ***** @ pearnet.comschrieb
"Earl Partridge" <ea*****@pearnet.comschrieb
我刚刚下载了这个VB Express。我需要一点帮助
了解数据库数据的请求
，这是与SQL
语句相比的格式/语法。 br />
在我的SQL中我会使用一个select语句...例子
从成员中选择LastName，其中月份（生日）=月份（现在）
如何在VB Express中编码？
I just downloaded this VB Express. I need a little help in
understanding the request
for database data, that is the format/syntax compared to an SQL
statement.
In my SQL I would use a select statement... example
select LastName from Members where month(Birthday) = month(now)
How would this be coded in VB Express?
你在哪一点上卡？ SQL语句将是相同的。
一般文档：
http://msdn2.microsoft.com/en-us/library/wzabh8c4.aspx
Armin
At which point are you stuck? The SQL statement will be the same.
General docs:
http://msdn2.microsoft.com/en-us/library/wzabh8c4.aspx
Armin
这篇关于数据库SQL语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
