Hi, I have already started learning .NET and I have a question. If I
want to do anything - Display Data, Navigate, Update - with database
(SQL Server) in Visual Studio 2005, do I have to use all this objects :
- DATASET
- sqlDataAdapter
- BindingSource
- sqlConnection
I usually write database applications in Delphi, but now I want to
learn Dot Net platform ant it's quite diffrent than programming
databases in Delphi. Besides I want to make sure that the code I write
is correct.
Please help me. If you know some good links or discussion group about
programming databases in .NET please give me some.
Thanks
Jethroelp 6 1803
<le*****@poczta.wp.pl> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com... Hi, I have already started learning .NET and I have a question. If I want to do anything - Display Data, Navigate, Update - with database (SQL Server) in Visual Studio 2005, do I have to use all this objects : - DATASET - sqlDataAdapter - BindingSource - sqlConnection
I usually write database applications in Delphi, but now I want to learn Dot Net platform ant it's quite diffrent than programming databases in Delphi. Besides I want to make sure that the code I write is correct.
Please help me. If you know some good links or discussion group about programming databases in .NET please give me some.
Thanks Jethroelp
Here are a couple of links to get you started... http://www.codeproject.com/script/co...p?forumid=1725 http://msdn.microsoft.com/data/dataaccess/whidbey/ http://msdn.microsoft.com/vbasic/pre...a/default.aspx
There is also a public newsgroup:
microsoft.public.dotnet.framework.adonet
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
<le*****@poczta.wp.pl> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com... Hi, I have already started learning .NET and I have a question. If I want to do anything - Display Data, Navigate, Update - with database (SQL Server) in Visual Studio 2005, do I have to use all this objects : - DATASET - sqlDataAdapter - BindingSource - sqlConnection
You will need to connect to your database, get the data records, put these
data records in some form of "container" and then display this container.
SqlConnection is what you use to connect to your SQL Server database. If you
might use different databases down the road then program against the
IDbConnection interface rather than the concrete SqlConnection class.
You get the data via a data adpater or a data reader. Data adapters are used
with a dataset, datareaders are generally used with a collection of objects.
For a simple CRUD application (create, read, update, display) then datasets
are popular. If you want to build a business object model then you will use
business classes and collections and populate these collections via the data
reader. Again program against the interfaces not the concrete classes if you
might support different databases, i.e. IDbReader
All list type controls pretty much work with datasets. Collection support is
generally based on vendor supporting certain interfaces like IList. My
experience is that vendors fully support datasets in terms of their "data
awareness" but that collections may require you to implement additonal
interfaces in order to be fully "data aware", e.g. ITypedList. One example
is that adding an item to a collection may require you to tell the list
control to "refresh" in order to see the item but with datasets adding a
datarow to a datatable is all that is needed for the new row to be
"automatically" displayed.
I usually write database applications in Delphi, but now I want to learn Dot Net platform ant it's quite diffrent than programming databases in Delphi. Besides I want to make sure that the code I write is correct.
The most important decision I believe is datasets versus collections. I
myself always use collections and I feel they work with the OO model better.
HTH
SP
Please help me. If you know some good links or discussion group about programming databases in .NET please give me some.
Thanks Jethroelp
Thank you very much for this post - it's very interesting. Well, I must
admit that collection is something new for me, but I know what it is
and how use it, but i I've never used it in my work while programming
in Delphi. Can you give some more advices about started programming
databases in .NET ? I'm going to use C#.
Jethroelp
<le*****@poczta.wp.pl> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com... Thank you very much for this post - it's very interesting. Well, I must admit that collection is something new for me, but I know what it is and how use it, but i I've never used it in my work while programming in Delphi. Can you give some more advices about started programming databases in .NET ? I'm going to use C#.
As you are starting something new then I would like at using a persistence
framework / OR mapper. These tools handle a lot of the mundane and
repetitive coding that deals with the creation of objects from data in your
database and the persistence of your objects to your database.
Also I would move away from thinking about your application as database
programming. Most applications persist data but I wouldn't call them
database applications.
SP
I think the best starting place is the QuickStarts [1] which provide initial
insight into the syntax and grammar of ASP.NET while being able to visually
observe the results. The C# language is best learned from a textbook [2].
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
[1] http://www.asp.net/QuickStart/aspnet/Default.aspx
[2] http://www.deitel.com/
"SP" <ec***********@hotmail.com> wrote in message
news:uj**************@TK2MSFTNGP09.phx.gbl... <le*****@poczta.wp.pl> wrote in message news:11**********************@i39g2000cwa.googlegr oups.com... Thank you very much for this post - it's very interesting. Well, I must admit that collection is something new for me, but I know what it is and how use it, but i I've never used it in my work while programming in Delphi. Can you give some more advices about started programming databases in .NET ? I'm going to use C#.
As you are starting something new then I would like at using a persistence framework / OR mapper. These tools handle a lot of the mundane and repetitive coding that deals with the creation of objects from data in your database and the persistence of your objects to your database.
Also I would move away from thinking about your application as database programming. Most applications persist data but I wouldn't call them database applications.
SP
i don't think that a coders couldn't user the google.
hi,boy,just input 'ado.net' and submit it at google's homepage.
good luck This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Gary L. Burnore |
last post by:
REQUEST FOR DISCUSSION (RFD)
unmoderated group comp.databases.mysql
This is an invitation to discuss the following proposal to create
newsgroup comp.databases.mysql. Please note that YOU CANNOT...
|
by: William Drew |
last post by:
REQUEST FOR DISCUSSION (RFD)
unmoderated group comp.databases.mysql
This is an invitation to discuss the following proposal to create newsgroup
comp.databases.mysql. Please note that YOU...
|
by: Kanthi Kiran Narisetti |
last post by:
Hi All,
I am Windows Systems Administrator(planning to migrate to Linux
administration in near future), I have occassionally written few batch
files and Vbscripts to automate my tasks.
Now I...
|
by: Cara |
last post by:
LAST CALL FOR VOTES (of 2)
unmoderated group comp.databases.etl
Newsgroups line:
comp.databases.etl Extraction, transformation, loading issues.
Votes must be received by 23:59:59 UTC, 12 Dec...
|
by: molemoore |
last post by:
I just started programming VB.NET with databases. Im using Access 2003
databases in my projects. My question is: I've been able to find plenty of
info on using bound controls with the odbda...
|
by: Dennis |
last post by:
I am totally confused between Access, SQL Express, and SQL Server and MSDE
and OLEDB vs SQL in .net. Please someone tell me if I"m correct in the
following:
With MSDE installed, I can program...
|
by: rfranzl |
last post by:
Hello,
I need some help, I have about 200 databases that are copies of an original database that has a similiar table in all of the databases, called "tblCodebook".
What I am trying to do is to...
|
by: yvettedejesus |
last post by:
i really don't have any idea on how to use php on the website that i'm planning to develop..i'm trying to develop a site that handles a database,,like FRIENDSTER..i've read that php is easy to use...
|
by: Andrey Hristoliubov |
last post by:
I am confident that I am one of the best c++ programmer in the world.
And now I am going to prove it to you.
My reference is Victor Bazarov,Valentin Samko, Alf P.Steinbach( Me and
Alf intern...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |