C# School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Dream.In.Code > Programming Help > C#

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

ADO.NET DataSet + DataAdapter

ADO.NET DataSet + DataAdapter

Braindead	25 Jun, 2009 - 09:43 AM Post #1
New D.I.C Head Joined: 21 Jun, 2009 Posts: 9 My Contributions	Hi I'm new to database programming in C#. So here is my question. I have a database with a couple of tables for my little tool. Now, I want to load all these data in a DataSet. But how to? After setup and opening connection I use the DataAdapter. SqlCeDataAdapter DA = new SqlCeDataAdapter("SELECT * FROM XList", conn); Is this the correct command for it? But how can I access the different tables? If not, how can I load all tables in my DataSet? Hope, you understand what I mean and it's not to easy . Any help would be great
	This Post Was Helpful!

Register for Free to Make These Ads Go Away!

newProgram	RE: ADO.NET DataSet + DataAdapter 25 Jun, 2009 - 06:10 PM Post #2
D.I.C Head Joined: 28 Oct, 2008 Posts: 152 Thanked: 4 times My Contributions	QUOTE(Braindead @ 25 Jun, 2009 - 09:43 AM) Hi I'm new to database programming in C#. So here is my question. I have a database with a couple of tables for my little tool. Now, I want to load all these data in a DataSet. But how to? After setup and opening connection I use the DataAdapter. SqlCeDataAdapter DA = new SqlCeDataAdapter("SELECT * FROM XList", conn); Is this the correct command for it? But how can I access the different tables? If not, how can I load all tables in my DataSet? Hope, you understand what I mean and it's not to easy . Any help would be great What database are you using? If you are using SQL Server then you will use SqlDataAdapter, for MySQL it is OdbcDataAdapter. Try this one: CODE SqlDataAdapter da = new SqlDataAdapter(SELECT * FROM XList", conn); DataSet ds = new DataSet(); da.Fill(ds);
	This Post Was Helpful!

Braindead	RE: ADO.NET DataSet + DataAdapter 30 Jun, 2009 - 07:18 AM Post #3
New D.I.C Head Joined: 21 Jun, 2009 Posts: 9 My Contributions	Fine, now it works perfect
	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 02:20AM

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 C# Help!

Be Social

C# Tutorials

Reference Sheets

C# Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month