index > .NET Framework Data Access and Storage > Data Insertion Updation Deletion in Multiple DBs

Data Insertion Updation Deletion in Multiple DBs

Hi,

I am developing an application in VS.net 2002 or 2003 using VB.net that will have the facility of connecting to Access, SQL Server or MySql depending on criteria.

What will be the best way to connect to DBs?

I am making few generic functions that will return me Connection and Adapter objects of relevant database.

What is the best way to Inert , Update and Delete data? Should I populate Datasets? or should I use Command object for data manipulation?

is something like ds("") = value (old ADO style code) is still in use?

Any code suggestion or link to some example will be ppreciated.

Thanks

Regards, Fahad Habib

Fahad Habib

Hi,

You would to look here:

DataLayer.Primitives
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=170&SiteID=1

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

Indigo: Ports, Messages, Channels and more...

Javier Luna

Some other links that might be helpful:

Database-independent ADO.Net 2.0 features discussed:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/vsgenerics.asp

Modifying data in ADO.Net 2.0:
http://msdn2.microsoft.com/en-us/library/ms254950.aspx

General ADO.Net resources:
http://msdn2.microsoft.com/en-us/library/ms254505.aspx

Alazel Acheson / ADO.Net Developer / Microsoft Corp.

alazela

reply 3

You can use google to search for other answers

More Articles

• UniqueIdentifier as PK and TableAdapter Update/Insert SQL

• Error in UPDATE statement Syntax with VB.NET and MS ACCESS

• stored procedure Parameter information

• Data Access Layer design

• parameter Array in Stored Procedure

• help: I need to view all the tables in a SQL Server Dataset

• suggestion for data manipulation code optimization..

• Interesting behavior causing: "There are no primary or candi...

• Walkthrough: Creating a Master-Detail Windows Form

• SQLPrepare(): Debug vs Release

Welcome to Bokebb New Update

New Articles

• Error with Select statement with multilp
• Master Detail Records
• Problem inserting sql query into databas
• Trying to insert non-latin characters in
• Connection pooling
• Same Problems
• Adding shortcut key to TabControl
• Add new Record in VB 2005
• data extraction from PBXs
• Dropdownlist Binding
• Using VB2005 Express to add new rows to
• Connect to a Sybase Adaptive Server Anyw
• Replace a Select Statement
• bool true, false values with SqlData
• Navigating Large Database

Hot Articles

• What am I doing wrong?
• Help C# SQLTABLES
• Desiging Data Access
• Connection String
• Connecting SqlExpress from .net 1.1
• Access to SQL Database via TCP/IP
• Visual Studio 2005
• How to call a aspx page from a exe file
• Mapping Xsd element attributes to DataSet
• Can I open an Access database from vb .n
• faster way of accessing CSV files
• SqlDbType enumeration value invalid
• Walkthrough: Creating a Master-Detail Wi
• Linked tables from ASP.NET problem: OleD
• Dataset Update

Recommend Articles

• OdbcConnection problem
• How to make http connections to an MS SQ
• How to create a script for creation of u
• Data Access Page
• How to force a single line per data in a
• Synchronize Replicated Access Database u
• What is the maximum number of tables in
• Obtain dimension in byte of a record
• Where to store SQL server connection str
• DISPLAYING TABLES OF AN ACCESS DATABASE
• What is the List<OdbcParameter>.En
• Unable to Update/Insert a new row into t
• Master Detail Records
• Embarrassing Problem with inserting reco
• Update issue vb.net2005 express - SQLSer