RE: Newly getting started in C#

[=?Utf-8?B?UGFua2Fq?=]

Please go to http://www.a2zdotnet.com/Default.aspx
for step by step tutorials for beginers in ADO.Net sections.

--
regards,
Pankaj
http://www.A2ZDotNet.com
"George" wrote:

hi all,

I am trying to make the jump from VB6 to C#. While I do have a couple of
books, the best way I can learn something is to write something I know. So
please forgive me in advance if this question sounds a bit off in the C#
terminology.

I am taking a simple thing like opening a MS Access database and filling a
listbox with names from 1 of the tables in the database.

I am using Visual Studio 2005 and I created a new project with 1 mdi form.

In VB I would create the connection to the database and connect to it in the
startup module (sub main). Then when needed in the program I would pass the
sql statement to a public subroutine to open the recordset, retrieve the
records and close the recordset.

While I believe I have the correct coding to connect to the database, open a
table, retrieve the needed field/column and then close the table for C#, I
cannot figure out where the best places are for the routines to go. Would I
put the connection routine in the program.cs module? I see that this has
been created in the program.cs module:
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(fals e);
Application.Run(new MDIMain());
}

so I was guessing that I could do a:
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(fals e);
Application.Run(new MDIMain());
ConnectToDatabase():
}

for my initial connection and have the routine ConnectToDatabase() in the
program.cs module.

The next question would be where do I put a "ExtractRecords" routine so that
all of the forms in the program could access the routine and extract from the
database? Would that go in the program.cs module as well?

Thank you for your support,

George