how to retrieve data from table to a datagridview in mysql [Resolved]

Use System.Data; and System.Data.SqlClient

//create connection as per your database
MySqlConnection con = new MySqlConnection(@"server=localhost;User Id=userID;database=db"); //replace userID as u are using and db by your database name
con.Open();

MySqlDataAdapter adp = new MySqlDataAdapter("Select * from table1;" ,con);

DataSet ds = new DataSet();
adp.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataBind();

Thanks,
Rajni Shekhar

Jerome, if this helps please login to Mark As Answer. | Alert Moderator

Hi Jerome,
Refer to :
http://christianasp.net/usingmysql50withaspnet-part1.aspx
http://www.codeproject.com/Articles/12300/An-ASP-NET-Application-Using-a-MySQL-Database

Thanks,
Sanjay

Jerome, if this helps please login to Mark As Answer. | Alert Moderator

thanks for responce,ill try it..

Jerome, if this helps please login to Mark As Answer. | Alert Moderator

hi Jerome,

please mark as answer if you find any reply as your answer.

Thanks,
Rajni Shekhar

Jerome, if this helps please login to Mark As Answer. | Alert Moderator