Visual Basic Forum for Visual Basic Programmers VB - Interactive Visual Basic Forum .NET Programming & Help

Mitesh2004 · Freshman Joined: 26 Jan 2004 Posts: 43

Hi,

When i navigathe through the records of a database using the DataControl, i keep getting an error "text property is read only". This happens everytime i try to navigate forwards or backwards.

Could somebody please tell me why this is?

Mitesh2004 · Freshman Joined: 26 Jan 2004 Posts: 43

Should i not be using a DataControl? I will also need to add records later on in my project. Should i be using another method to connect to the database?

I have heard that the DataControl is very limited and not used widely. However, all the books i look in only show the Data Control method.

Could anyone suggest any other ways that i could connect my system to a database?

Andir · Posted: Feb 4th, 2004 03:07 PM Post subject:

The datacontrol will work as long as it's bound to the textboxes your using to view data. Can you post code?
_________________
If you happen to see little people sitting on your desk...don't tell anyone or they might think your crazy too.

Avis · Posted: Feb 5th, 2004 02:39 AM Post subject:

You should switch to ADO instead of DataControl. As Andir said DataControl is good as long as it's bound to textboxes or its good if your project is small.

But if you're making an professional app. or a large app. then you should switch to ADO.

You can find an ADO example at:
http://www.avissoft.com/attachment.php?s=&postid=839

Thanks!
_________________
Code Snippets, Tutorials, Utilities, Controls

Low cost Web Hosting
Hosting starts at as low as $4 per year!

Always follow posting guidelines
Put your VB code in [vb ] your code [ /vb] tags!

Andir · Posted: Feb 6th, 2004 04:27 AM Post subject:

I have to agree with Avis. Razz

I rarely use the data control because with ADO you can bind controls to the Recordsets given, or process the data manually. If your looking to just keep it simple and small, the controls work fine, but ADO gives you ALOT more options.

As I stated in another post, ADO is something I think everyone should get to know a little better. It can't hurt, and you'll be able to create more robust data applications.

It doesnt hurt to use it for large data files either. It's more agile than the Open/Close for file operation.
_________________
If you happen to see little people sitting on your desk...don't tell anyone or they might think your crazy too.