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

[Mark Rae [MVP]]

"Mark B" <no...@none.com> wrote in message
news:OEwalJC...@TK2MSFTNGP06.phx.gbl...

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

Firstly, unless it's too late, ditch GoDaddy immediately...

> 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?

Secondly, the "normal" way of implementing localisation in ASP.NET is to use
resource files e.g.
http://www.google.co.uk/search?hl=en&rlz=1T4GZEZ_en-GBGB252GB252&q=ASP.NET+localization&meta=

--
Mark Rae
ASP.NET MVP
http://www.markrae.net