Working With Tables, Please Help!

[Guest]

I'm a Vb.net 2005 newbie, but an Older VB6 programmer.
With a ADO I work very comfortably (many years!), with ADO Is possible to
work DIRECTLY with all the records in a Table WITHOUT the need to write ANY
sql command.
I try to make the same with ADO.NET (.Net 2.0) using sqlserver express, but
ALL the samples and documentation tell me than I NEED to refer to an SQL
statement.
My question is... Can I retrieve ALL the records in a table WITHOUT use SQL?
For Instance, some of my tables only have a few records...In ADO, for this
task I just use the table name for the commandtype.
Can I Do this? How?
Thanks

 

[PvdG42]

I'm a Vb.net 2005 newbie, but an Older VB6 programmer.
With a ADO I work very comfortably (many years!), with ADO Is possible to
work DIRECTLY with all the records in a Table WITHOUT the need to write
ANY
sql command.
I try to make the same with ADO.NET (.Net 2.0) using sqlserver express,
but
ALL the samples and documentation tell me than I NEED to refer to an SQL
statement.
My question is... Can I retrieve ALL the records in a table WITHOUT use
SQL?
For Instance, some of my tables only have a few records...In ADO, for this
task I just use the table name for the commandtype.
Can I Do this? How?
Thanks

You really need to do some reading on ADO.NET and the data facilities in VS
2005. The ADO world you knew is gone.
Check out the .NET Framework DataAdapter class and the fill() method:

http://msdn2.microsoft.com/en-us/library/system.data.common.dataadapter_members(vs.80).aspx

Also, check out automated form creation from a DataSource in VS 2005.

http://msdn2.microsoft.com/en-us/library/aa502374.aspx

 

[Guest]

I really appreciate for your time, believe me, I carefully read documentation
about this. I know that the "old days" are gone... It's a constant in our
profession, but...
Every new version of development tools has "methods" to simplify things.
thanks

 

[William \(Bill\) Vaughn]

ADO classic is not really "gone" as you can still use it, but with any
service-style DBMS engine, you're going to have to communicate with it via
SQL commands. Visual Studio (Visual Basic.NET) can help generate much of the
code for you as long as your application is fairly simple. Eventually,
you're going to want to perform more sophisticated operations so you really
need to learn how to code SQL. Perhaps you need to use the Recordset object
created by SQL Server Compact. It does not require use of SQL to make
changes.

I think my book "Hitchhiker's Guide to Visual Studio and SQL Server (7th
Edition)" will help you quite a bit.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Guest]

Appreciate your help, I ever dislike (from VB4 to today) the wizards that
make the things for me (I'm are a "old fashion" programmer).
The wizards didn't work for me because I develop for very eterogeneous
customers, some have many servers, other one, others none...
Thus, I need to learn the "new way" to make things.
I try to buy your book...
From Uruguay, Fernando Giacoia, MMGR Soft. CEO