ASP.net 05 to SQL Server 2000 Basics

Hi all

I dont do web work that often...ie once in last 5 years!!!

How would I add a new record in code to an online (ie url name) SQL Server 2000 database? I have a membership form that needs filled out then validated...am ok with this part.

Then to run a query against it and get back dataset..... then show this on form....gridview or something

I also would like to do a dynamic search and build up sql for what user wants to see....but worried about SQL injection

cheers George

Is this your database or is it owned by someone else? In other words, do you have the login credentials?

this is a database that sites on ISP...hosted package for me.

I have login and password...... and URL/ IP..... I have created the Database/ table

Even just knowing how to connect to database and add anew record would be good

You'll need a Connection string and an ADO.NET tutorial and knowledge of SQL as well.

thanks mendhak....I just hacked it in the end, although I managed to connect to mySQL database as well as part of working out what I was doing wrong!!!

I had good fun!!!!

thanks George