Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

data row in Access using VB.net

Posted on 2005-05-11
4
Medium Priority
?
280 Views
Last Modified: 2012-08-13
Hi,

I'm new to unbound controls in VB.net and MS access
I'm trying to  Dimension  a variable named  drCustomer .This variable will store a row from an MS Access data base.

Here's how I've writtern it :
Dim drCustomer As dsCustomer.CustomerRow

dsCustomer is a data set I created

It comes up with a squiggley line under     dsCustomer.CustomerRow

After i type in the 'As'  i expect it to display a dropdown box where I can select the dataset I created 'dsCustomer' but it doesn't
which means that I haven't got use of the CustomerRow class

Is there something I need to set up first......

I have added    'Imports System.Data.oleDb'   but didn't make a difference.

Thanks
Bruce


0
Comment
Question by:delphimate
  • 2
2 Comments
 
LVL 8

Accepted Solution

by:
infolurk earned 500 total points
ID: 13983575
Try
Dim drCustomer As Recordset

When you are dimming an object, you need to set it as one of the available options. To store a record (row from a database), a recordset is the obvious choice.
Being unfamiliar with the options, you were creating a custom variable :)

HTH SFH
0
 
LVL 8

Expert Comment

by:infolurk
ID: 16170473
Sounds good, thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this article, we’ll look at how to deploy ProxySQL.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question