ASP.net 05 to SQL Server 2000 Basics

[Ggalla1779]

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

[mendhak]

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

[Ggalla1779]

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

[mendhak]

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

[Ggalla1779]

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