Go Back  HTML Forums - Free Webmaster Forums and Help Forums > WEBSITE DEVELOPMENT > Server Side Programming > ASP and ASP.NET
User Name:
Password:
 

Reply
Thread Tools   Display Modes
  View First Unread
 
Old 09-17-2009, 04:11 PM
  #1
Iconoclast
Novice (Level 1)
 
Join Date: Sep 2009
Posts: 1
iTrader: (0)
Iconoclast is an unknown quantity at this point
Help with basic ASP.NET page using Access DB as datasource?

Hey guys, I'm familiar with both ASP and C#, but I'm pretty new to ASP.NET...anyways, I'm looking to make a pretty basic page that will use a customer-based Access DB (which I have already created and can provide if necessary) as a datasource...when the page loads, I want it to load the first customers' information onto the page. I also want to have a drop-down menu that users can click to select different customers within the DB and have it load their respective data.


Here's what I know:

I know I need to make a Customer.cs class within C# with public fields for each column in the Customers table in the DB, and somehow use it to create a Customer object that will contain the information about the selected customer.

I know I need to add the database as the datasource for the default page of the site...it needs to return all rows and columns from the Customers table sorted by Name...then somehow I need to bind the drop down menu to the datasource so the name column is displayed for each item in the list and the CustomerID column is stored as the value for each item. (I'm not exactly sure how I would do this, if anyone can help me with this part)

I'm going to use a table to align the information being returned from the DB (phone #, address, email, etc.)


If anyone can help me out with what I need to do to start something simple like this, I would greatly appreciate it, I'm kind of at a loss of where to start and I know it shouldn't be too complicated. Thanks for any help! And remember I'm new to this stuff!
Iconoclast is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Old 09-18-2009, 05:30 AM
  #2
JosephJames
Fighter (Level 4)
 
Join Date: Aug 2009
Posts: 37
iTrader: (0)
JosephJames is an unknown quantity at this point
Hello
http://www.asp.net/learn/data-access...ial-62-cs.aspx will be a good place to satart IMO.
JosephJames is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote

Reply
KEEP TABS
SPONSORS
 
Boxedart
 
 


 
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
  
 
 
 



 
  POSTING RULES
 
 
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Thread Tools
Display Modes

Forum Jump

 

All times are GMT -5. The time now is 10:39 PM.

   

Mascot team created by Drawshop.com

Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.

Server Monitoring by ENIACmonitor 0.01
HTMLforums.com © Big Resources, Inc. Web Design by BoxedArt.com
vRewrite 1.5 beta SEOed URLs completed by Tech Help Forum and Chalo Na.