473,372 Members | 1,246 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Need a suggestion for ADO please

Hello All!

I use visual basic .net 2003 and develop database application based on MS
ACCESS.
Since I started develop my application till now I use the same way to handle
the data flow:
1. I create a dataset that contains no records (by SQL select statement that
brings no records).
2. I create new record/s by the .NewRow method of the dataset object and
fill the key field/s with values.
3. I fill-in the rest of the fields by the datarow("field_name")=... method
of the dataset.
4. I save the changes to the database by the .update method of the
dataadapter.

First, I know that I probably use long and inefficient way to handle the
data, and that's why I want to change it...
Can someone suggest me a different way to handle data issues?
Does controls' data binding is a better way?
Any other idea?

Thanks!
Tom Rahav.
Jul 26 '05 #1
2 1120
Tom,
Does controls' data binding is a better way?


Normally Yes.

It is to much to explain all of course. However, know that there are

Simple controls, for which you use
Textbox1.DataBindings.Add("Text", MyDataTable,"MyDataColumn")
'where "Text" is the normal property from the textbox and can be any
property of that while you can add as well (more) other properties of that

Complex dataControls as the datagrid that have a "datasource" for which it
is very easy
Mydatagrid.DataSource = MyDataTable

Complex normal controls as the listview, for which you will normally have to
build your own extra classes to databind.

(For C# you have to set a ";" after the samples above).

I hope this gives an idea

Cor
Jul 26 '05 #2
Jan
Hey Tom,

Try opening the Server Explorer and dragging a table out of your Access
DB onto the design surface, This will automaticlly create:

A strongly typed DataSet
A configured DataAdapter
and a connention to your database.

It should speed things along for you

Jan

Jul 26 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: John Wellesz | last post by:
Hello, It would be great if there was an option to tell PHP to let the user manage all the HTTP headers instead of sending what it thinks is good for the programmer... For example when you...
0
by: Brian van den Broek | last post by:
Hi all, There have been a few posts over the last month or so expressing a bit of exasperation with the "rising tide of newbie's". (Or, more accurately, the rising tide of questions from...
48
by: Chad Z. Hower aka Kudzu | last post by:
A few of you may recognize me from the recent posts I have made about Indy <http://www.indyproject.org/indy.html> Those of you coming to .net from the Delphi world know truly how unique and...
13
by: vincent | last post by:
I made the suggestion "Need built in obfuscation support in C# compiler" to Microsoft. Anyone here agree with me? If yes, please cast your vote on this suggestion to raise its priority.
11
by: Alan Mailer | last post by:
A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...
9
by: Blarneystone | last post by:
Hi, I am using VB.NET and trying to pull data from two different tables in the database. I am using what I think is standard code. But the data I am pulling is like the following: Table1...
3
by: Jeff | last post by:
Hey ASP.NET 2.0 I'm trying to extend the MembershipUser class, and have encounter a problem: << See in the middle of this post for info about why I do this >> << See below of this post for...
5
by: =?Utf-8?B?SGVyYg==?= | last post by:
I need a Table object in my RDLC with 6 columns on the top several rows, but 1 column on the bottom two rows: COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 COLUMN1 COLUMN2 COLUMN3 ...
6
by: shapper | last post by:
Hello, I am creating a form that includes a few JQuery scripts and TinyMCE Editor: http://www.27lamps.com/Beta/Form/Form.html I am having a few problems with my CSS: 1. Restyling the Select
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.