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
Re: ASP.net 05 to SQL Server 2000 Basics
Is this your database or is it owned by someone else? In other words, do you have the login credentials?
Re: ASP.net 05 to SQL Server 2000 Basics
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
Re: ASP.net 05 to SQL Server 2000 Basics
You'll need a Connection string and an ADO.NET tutorial and knowledge of SQL as well.
Re: ASP.net 05 to SQL Server 2000 Basics
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