MySQL connection / populating datagrid with C# windows application

Question

What's the complete process of populating a datagrid using C# from MYSQL? I need help from the very beginning--including establishing a connection to the server. I have been able to successfully connect to my server, but the thing is I can't seem to find an example of using that method to populate a datagrid because most people seem to use the Ole method. Any help is greatly appreciated! =)

John Charles Olamendy · Answer

// Connection String private const string ConnStr = Driver={MySQL ODBC 3.51 Driver};Server=localhost; + Database=mydatabase;uid=dba;pwd=mypasswd;option=3; // DataBinding private void BindDataGrid() { using(OdbcConnection con = new OdbcConnection(ConnStr)) using(OdbcCommand cmd = new OdbcCommand(SELECT * FROM Customer con)) { con.Open(); DataGrid1.DataSource = cmd.ExecuteReader( CommandBehavior.CloseConnection | CommandBehavior.SingleResult); } }

Shashikant · Answer

Try This..hope this is helpful.... sqlCon.Open(); SqlCommand sqlcmd = new SqlCommand( NAME OF STORED PROC  sqlCon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.CommandText = NAME OF STORED PROC ; SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = sqlcmd; DataSet ds = new DataSet(); sqlDA.Fill(ds); RadGrid2.DataSource = ds; RadGrid2.DataBind(); if (sqlDA != null ) sqlDA.Dispose(); if (ds != null ) ds.Dispose();