hi
your exampe coding gave me some idea but i m not able to implement
can u help me out in adding just the user name and pwd to the database using mysql in asp.net.
Hepl me out

WHAT A LIFE SAVER!!! Thanks so much for this AWESOME code. Can I simply include the MySql.Data.dll fiel with my application and it will work on my user\'s computers? Or does each person need to have the Connector installed on their machine?

No they don't need the Net/Connector installed on their computer, just the MySql.Data.dll.
Awesome tut!

WOW! You're the best!!!

Thank you very much.

It works great but only with localhost and generates error {Un able to connect any of Mysql Host}if Mysql database is hosted on remote server.Kindly explain breifly that what settings to make from server side to get connect with server remotely if we have Mysql 3.23.58 on server and how to give access to Mysql

Thankyou! Thankyou! Thankyou!

Very Good ,Thank you ,

Syed,

Great writeup- short and to the point. Perfect, thanks.

Exactly ... short and to the point...All that u need ... other sites confuse u ..

Thanks Syed ..

Thanks, this article helped me understand a bit more clear than the docs did. I furthered the code and created a 'fetchAll' function which will return all data from a table or based on a where clause. It then does type checking and stores the field names and values in an array.

Great tutorial!

I am not able to add the MySql.Data.Dll and for this reason the name space
using MySql.Data.MySqlClient;
is throwing exceptin.
Please Help me.

I want to display all record in the databse field when i m using while(dr.read()) it cannot execute it on textbox box..coding below

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using MySql.Data.MySqlClient;
using System.Web.Mail;
//using System.Net.Mail;


public partial class _Default : System.Web.UI.Page
{
public conn c1 = new conn();
public MySql.Data.MySqlClient.MySqlCommand cmd;
public MySql.Data.MySqlClient.MySqlCommand cmd1;
public MySql.Data.MySqlClient.MySqlDataReader dr;
public MySql.Data.MySqlClient.MySqlDataAdapter da;
public MySql.Data.MySqlClient.MySqlDataAdapter da1;
public string q, q1, q2, cid;
protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{

etview();

}
}
public void etview()
{

bool co = c1.oc();
if (!co)
{
}
else
{

q1 = "select Email_Id from customer_details ";
cmd = new MySqlCommand(q1, c1.con);
dr = cmd.ExecuteReader(CommandBehavior.Default);

while(dr.Read())
{
//while (reader.Read())
//{ // Read the value...
// string sap = reader.GetValue(27).ToString();
//txtto.Text = sap;
//}
txtto.Text = dr["Email_Id"].ToString();
txtto.Text = txtto.Text ",";

}

}
//dr.Close();
c1.cc();
}

I've spent almost half an hour looking for something to help me with this. I was looking for a way to connect to my mysql database using C#. I needed to start from scratch.

Everything I needed to know I was able to find right here.

thank you for putting together a simple yet effective guide.

Worked like a charm. Thanks!

Can this work with Windows Application??

Don't forget to close your connections when you have finished with them!!

[code]
mysqlReader.Close();
mysqlCon.Close();
[/code]

it's hard to understand

it's hard to understand

it's hard to understand

when i go to install the mysql-connector-net-1.0.10.1.exe it shows that "setup is required for .net framework 1.1" But my .net framework version is 3.5 ...how can i solve this problem?
where i can get mysql.Data.dll file ?

thank you...:)

thank you...:)

mukta, go and download a newer version of mysql-connector.

hi! Great tutorial!
please can you tell me how to connect C# mysql with a server not a locahost but on server like 192.168.0.2?

thanks alot,
short and to the point

http://dev.mysql.com/doc/refman/6.0/en/connector-net-visual-studio-making-a-connection.html

Detail Tutorial

I had to add my PC address to Remove SQL in cpanel on my server and then it just worked. It's not often that a tutorial works so easily. Thank you.

I had to add my PC address to Remove SQL in cpanel on my server and then it just worked. It's not often that a tutorial works so easily. Thank you.

Isn't the MySql.Data.Reader an class? The author of this minitutorial must learn to separate different terms.

Great tutorial... Very informative.. Thanks for sharing.. 'twas a life saver.. I needed this for school..

I just have one question... Which is better to use? this one? or odbc connector? please reply.. Thanks..

nice tutorial

How to execute dos command in ASP.NET.

you can see this tutorial for more details.http://learneveryday.net/asp-net/mysql/insert-in-to-mysql-with-asp-net-part-1/

Thanks dude!!
I am very much thankfull to u,becoz i am trying to connect c# with Mysql from last 4 hrs.but after so many search,i came to these site and after that followed ur steps.
Thanks once again
If u need any help frm me,just let me knw.I will be happy if i can help u.

hi,
can u help me out in adding just the user name and pwd to the database using mysql in c#.net
Help me out.

for inserting values in the database we need only to query like:
string strSQL = "INSERT INTO [Your Table Here] VALUES .... ";
MySqlCommand mysqlCmd = new MySqlCommand(strSQL,mysqlCon);

or i will need another object, something like " MySqlDataWriter"

???