View Single Post
  #2 (permalink)  
Old 07-10-2007, 06:41 AM
Lee's Avatar
Lee Lee is offline
PT Staff*
Awards Showcase
Quality Tutorial 
Total Awards: 1
Join Date: Jun 2007
Location: Blackpool, UK
Posts: 616
iTrader: (0)
Lee is just really niceLee is just really niceLee is just really niceLee is just really nice
Check this out for connection strings:
ASP.Net Tutorial - Using MySQL with ASP.NET

To insert if its like php and other languages you would do something like:
$var = "INSERT INTO dbname (usr,pwd) VALUES ($usrtxtbox,$pwdtxtbox);"
mysql_query($var)

install phpmyadmin to your computer to make the databases it makes it much easier and later on if your making scripts with an install page you can learn the coded way (which you would learn in 10mins by that time), for my insert example where i put "(usr,pwd)" your tables column headings would have to be usr and pwd, "($usrtxtbox,$pwdtxtbox)" these 2 are the values of whats in your text box's im sure you know in asp how to put the value into a variable.

Some good words to include in your search:
mysql, ASP.NET, INSERT INTO, connection string, tutorial...Mix them up a little and you should get some results.

Hope it helps you a bit

__________________

Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!
Reply With Quote