473,387 Members | 1,501 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,387 software developers and data experts.

Basic help with connection to database

Ian
Hi everyone,

I am looking for some help understanding the basics of communication
between VB dotnet and a MS Access Database. I am fairly new to dotnet
and even newer to accessing databases when out of Access.
I have created the appropriate database connection, adapter and
datasets, but I cannot work out how to now access actual data. My aim
is to interrogate a record in a table and then bind each field in that
record to a specific text box, much as I would in a Access form.
I realise that this is a trivial problem but I cannot seem to see a
solution to it!

Thanks in advance,

Ian

Nov 21 '05 #1
1 954
Hi Ian

I found the easiest way was to use the DataSources wizard.
On the vb menu, click Data, then Add New Data Source

That will let you drag fields onto your form, similiar as to what you would
in Access. You will be able to view a data sources window, from which you
can see all your access tables, and all the fields in those tables.

Vayse

"Ian" <ia*********@maps-eu.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Hi everyone,

I am looking for some help understanding the basics of communication
between VB dotnet and a MS Access Database. I am fairly new to dotnet
and even newer to accessing databases when out of Access.
I have created the appropriate database connection, adapter and
datasets, but I cannot work out how to now access actual data. My aim
is to interrogate a record in a table and then bind each field in that
record to a specific text box, much as I would in a Access form.
I realise that this is a trivial problem but I cannot seem to see a
solution to it!

Thanks in advance,

Ian

Nov 21 '05 #2

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

Similar topics

7
by: Michael Foord | last post by:
#!/usr/bin/python -u # 15-09-04 # v1.0.0 # auth_example.py # A simple script manually demonstrating basic authentication. # Copyright Michael Foord # Free to use, modify and relicense. #...
0
by: Jim S. | last post by:
I'm having a horrible time simply inserting the date in a MySQL database through a Visual Basic program. I have a table, called "ORDERS"; "ID" is the primary key. I'm trying the insert the date,...
3
by: FC | last post by:
Hello all: I have a very basic question about oracle database structures. I am coming from MS SQLServer where I have three "databases", each database has three "tables". I can access any table...
1
by: Tom Rahav | last post by:
Hello all! I develop application in Visual Basic .NET and ORACLE database. My question is how do I "send" script file to the database using visual basic .net. Other words, is there any way to...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
7
by: Lau Lei Cheong | last post by:
Hello, Actually I think I should have had asked it long before, but somehow I haven't. Here's the scenerio: Say we have a few pages in an ASP.NET project, each of them needs to connect to...
2
by: Sasquatch | last post by:
I'm still having trouble creating a simple login page using the asp:login control. I followed some instructions in a WROX book, "Beginning ASP.NET 2.0," and the instructions are very straight...
2
by: trezraven | last post by:
I am creating a template in Word 2007 using Visual Basic Editor. I am pulling information from an Access database. I know this is probably a stupid question, but for the life of me I can't figure out...
0
by: Killer42 | last post by:
Originally posted by sashi... Connection string More samples MsAccess - Connection String Standard securityoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data...
2
by: jayantim | last post by:
Hi ! I want to know the connection code for connecting visual basic and microsoft access. plese give the detail code for this connection. Actually I tried one code which is as follows: Dim cn...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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...
0
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...
0
jinu1996
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...

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.