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  1817 
<le*****@poczta .wp.pl> wrote in message
news:11******** **************@ e56g2000cwe.goo glegroups.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.publi c.dotnet.framew ork.adonet
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
<le*****@poczta .wp.pl> wrote in message
news:11******** **************@ e56g2000cwe.goo glegroups.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
"automatica lly" 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.goo glegroups.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******** ******@TK2MSFTN GP09.phx.gbl...
<le*****@poczta .wp.pl> wrote in message
news:11******** **************@ i39g2000cwa.goo glegroups.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 VOTE NOW;
you may be able to vote on a version of this proposal later. See the
PROCEDURE section below if you need information about how the
discussion works.
PLEASE POST ANY FOLLOWUPS TO THE NEWSGROUP NEWS.GROUPS.
|
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 CANNOT VOTE NOW; you may be
able to vote on a version of this proposal later. See the PROCEDURE section
below if you need information about how the discussion works.
PLEASE POST ANY FOLLOWUPS TO THE NEWSGROUP NEWS.GROUPS.
|
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 have strong interest to learn a programming language that would
help me to write Scripts or Application ( In Systems Administrative
point of view) .
|
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 2003.
This vote is being conducted by a neutral third party. Questions
about the proposed group should be directed to the proponent.
|
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 connection/data adapter/dataset
objects on the forms. In VB 6 you were able to make your connection, retrieve
records from the tables in the database, write/edit/delete records from the
tables and navigate the database with unbound commands. Is their a...
| | |
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 using OLEDB in ADO.Net for Access then
convert later to an SQL Express or SQL Server database and my program still
work if I change the connection string.
With MSDE installed, I can program ADO.Net for SQL and it will work for SQL
express or SQL...
|
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 create a macro that will go into each of the 200 databases, run an identical "unmatched query" to find any records that might be in one of the copies of the "tblCodebook". There is a shared primary key in the "tblCodebook" which is a StoryID and...
|
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 and can easily be embedded in html,,i already know html and a bit of javascript..i just really need answers to some of my questions..
1. do i need to install php on my pc to be able to use it??
2. if i don't need to install it on my pc,,how can i...
|
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 together at Microsoft), and Bjarne Stroustrup (he asked me
for help to design C++ ; still unsure why he didn't give me enought
credit - probably a poor design choice to have Russian name near c+
+),Branimir Maksimovic,Vladimir Kouznetsov, James...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
