VB.NET School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Dream.In.Code > Programming Help > VB.NET

Welcome to Dream.In.Code
	Become a VB.NET Expert! Join 300,437 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 1,474 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a VB.NET Expert

VB Datasets

VB Datasets, How to interrogate a dataset

dinomight	2 Jul, 2009 - 08:35 AM Post #1
New D.I.C Head Joined: 2 Jul, 2009 Posts: 1	Hi, I want to create a lookup program for library books using VB6 or VB.net. I have created a Form1.VB with two listboxes :- Listbox1 Listbox2. I’m using an Access Database with a Library Category Table Field1: Category Library Title Table Field1: Category Field2: Title Field3: Author Field4: Publisher Using the Data Adapter ConfigurationWizard I’ve created OleDBDataAdapter1 OleDBConnection1 And from the Library Category table I’ve created Dataset1 attached to Listbox1 OleDBDataAdapter2 And from the Library Title table I’ve created Dataset2 attached to Listbox2. Both Datasets fill using the Preview Data function. I then load Variable CategoryString with Listbox1.text, and I would like to know how to search Dataset2 and retrieve all titles linked to that category and display Title, Author, Publisher in listbox2.
	This Post Was Helpful!

Register for Free to Make These Ads Go Away!

PsychoCoder	RE: VB Datasets 2 Jul, 2009 - 10:22 AM Post #2
Dyslexics Untie! Joined: 26 Jul, 2007 Posts: 14,714 Thanked: 501 times Dream Kudos: 11450 Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net, jQuery My Contributions	Welcome to Dream.In.Code dinomight, glad you decided to join us. For future reference please post your programming questions in the proper forum (This forum is for introductions only). I am moving this to the VB.NET forum for you
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 11/8/09 01:05AM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Advertise on this site through Lake Quincy Media

Forum Index: Programming Help | C and C++ | VB6 | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Mobile Development | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Graphic Design & Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials | Game Programming Tutorials | WPF & Silverlight Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Live VB.NET Help!

Be Social

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month