ASP.NET and mySQL

HelloWorld · #1 (**permalink**) 07-09-2007, 07:38 PM

Hey! I finally can work and have fun with ASP.NET after long time figuring out how to setup everything for my workspace haha... Anyways, I'm now trying to create a registration form, but I don't know how to connect to the database and how ASP.NET handles mySQL commands...

If anybody can help, I'll be appreciate it.. This is my current code for the form:

PHP Code:

  <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 
<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>REGISTRATION PORTAL</title>

    <style type="text/css">

    body {

        text-align: center;

    }

    </style>

</head>

<body>

    <form id="registerForm" runat="server">

    <div>

        <table border="1">

            <tr>

                <td>Username:</td>

                <td><asp:TextBox ID="username" runat="server"></asp:TextBox></td>

            </tr>

            <tr>

                <td>Password:</td>

                <td><asp:TextBox ID="password" TextMode="Password" runat="server"></asp:TextBox></td>

            </tr>

            <tr>

                <td colspan="2"><asp:Button Text="Submit" OnClick="submitBtnClick" runat="server" /></td>

            </tr>

        </table>

    </div>

    </form>

</body>

</html>

Nothing much other than CSS, HTML, and some ASP.NET fields.. just need to connect to the database on my localhost (installed), create the table, and insert the username and password each time they click submit.

I don't care about security right now, and just want to see how it works first

P.S I've searched over the web, and have not found good tutorial for it!

Lee · #2 (**permalink**) 07-10-2007, 05:41 AM

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

ccoonen · #3 (**permalink**) 07-10-2007, 07:09 AM

Yup, definitely get the MySQL ODBC Driver... you might even be able to use the driver as a DataSource Provider and use the Strongly Typed Datasets... which will bring the power of Enterprise Manager right into .NET for you

HelloWorld · #4 (**permalink**) 07-10-2007, 08:30 AM

Quote:

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.

there's no way I can install it. Because my PC currently does not support .php files. Don't tell me to install XAMPP again, cuz I will get the same trouble as before XD
I personally use mySQL Query Browser and memorize the sql query commands. But I'm not sure if there's other optional way of myphpadmin & MS Access

I prefer to use mySQL than any microsoft DBMS

Quote:

you might even be able to use the driver as a DataSource Provider and use the Strongly Typed Datasets... which will bring the power of Enterprise Manager right into .NET for you

can you please clarify this for me? I have no clue what are you talking about...

sorry, I'm too newbie at Server Side. ASP.NET is my Server Side programming that I'm learning now

Quote:

"Driver={MySQL ODBC 3.51 Driver};uid=YourUID;password=YourPWD;Server=YourSe rverIP;Option=16834;Database=YourDB;"
or, you can use:
"DRIVER={MySQL};SERVER=ServerIP; DATABASE=YourDB;USER=YourUID;PASSWORD=YourPWD; OPTION=3;"

I have no clue what he's saying, he just said that and it should run off XD

ccoonen · #5 (**permalink**) 07-10-2007, 09:00 AM

load up visual studio, and add a folder called "App_Code" in the root of your website. Then right click on your app_code folder and click ADD. Add a Dataset and name it DataLayer. This is a GUI for creating data tables and queries. From here you can create a connectionstring (it will ask you right away) and will store it in the Web.Config file. Then you can create table Adapters that you can use later on. If you have a 'User' table in your database, then add a User Table adapter... then you can add queries like GetAllUsers or GetUserByUserID or GetUserByEmail, etc... all in the Table Adapter 'User'.

Then in your page code, you can bind your controls directly to the Table Adapters

You can say...

Code:

Using UserAdapter as New DataLayer.UserTableAdapter
     Using UserTable as New DataLayer.UserTable = UserAdapter.GetAllUsers()
         DropDownListControl.DataSource = UserTable
         DropDownListControl.DataBind()
     End Using
End Using

- by using the using, it does the try catch, and dispose of the objects for you... it fills a datatable called UserTable from the UserAdapter's Query GetAllUsers... Have fun... this is pretty addictive once you get used to it

HelloWorld · #6 (**permalink**) 07-10-2007, 01:06 PM

Quote:

This is a GUI for creating data tables and queries.

are you saying that we can control SQL from VS2005 ???

I'm kind of confused because I'm planning to use mySQL. Is this going to create msSQL ??? What do you use for your database..?

ccoonen · #7 (**permalink**) 07-11-2007, 09:20 AM

Yessir, VS has SQL fully integrated right into it

you can even have multiple database connections open at once... tis pretty nice, hehe. I use MsSQL and Access and SQL CE but I think with the MySQL ODBC Driver you can use that as well

HelloWorld · #8 (**permalink**) 07-11-2007, 11:04 AM

Quote:

Originally Posted by ccoonen

Yessir, VS has SQL fully integrated right into it

you can even have multiple database connections open at once... tis pretty nice, hehe. I use MsSQL and Access and SQL CE but I think with the MySQL ODBC Driver you can use that as well

Can I use SQL Query Browser of VS for mySQL too? I think I should try it out, I've been really busy these days with summer school.. sigh...