MySQL connection / populating datagrid with C# windows application

Bryan Natusch

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! =)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

John Charles Olamendy19y ago
// 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); } }
Shashikant19y ago
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();