databases

[Guest]

Hi, I'm new to programming - simple question

I'm using Microsoft Visual C# 2005 Express Edition:

I created a SQL database (customerinformation) - for local server use.
Form1 is used to enter and read the records on the database
customerid - name - address (etc.) - I've put sample names and address into
the table (customertable)

1. what commands in c# do I use to show the first record; then each record
with a click of a "next" button I added to the form?

2. what commands are used to add a record to the database in the same form?

3. How do I refer each record to a textbox on form2 just to show it (read
only)?

thanks,
greg malenky

 

[Guest]

Hi Greg,
you need to look into the System.Data.SqlClient namespace, of particular
interest to you is going to be the SqlCommand, SqlConnection and
SqlDataReader objects.

This would be a good place to start
http://msdn.microsoft.com/library/d...rfsystemdatasqlclientsqlcommandclasstopic.asp

Figuring out your connection string, which you will need for your C# app to
be able to connect to your database, try:
http://www.connectionstrings.com/

Hope that helps
Mark R Dawson