Newbie VB ADO.Net Code to retrieve data from SQL table

[Mark B]

I have created a table on SQL Server at GoDaddy with the following 3 fields:

ConstantID (e.g. WELCOME_MESSAGE)
LanguageID (e.g. EN-US)
LanguageText (e.g. "Hi and welcome to my new website")


The goal is that to make the website multi-lingual from the outset. Instead
of having "Hi and welcome to my new website" on the homepage, I'll use:

Response.Write(fGetText("WELCOME_MESSAGE"))

I have these questions:

1) For anyone who is familiar with SQL Server, what field types should I
use? Can I also have an incremental Autonumber field like MSAccess?

2) What would the ADO.Net code be to pull the LanguageText field data based
on ConstantID or MyAutoNumber? (I am a newbie)

3) In order for a Chinese friend of mine to populate the table after I have
finished it, how can I use a Datagrid read/write control on a webpage for
them to enter data (like Excel)?

TIA
Mark