MySQL with C#, from a PHP Developer's Standpoint

Question

I understand that with PHP I can use mysql_query($sql); and mysql_fetch_array($result); to fetch some MySQL data and place it into an array. How is this achieved in C# to where I could place my data in say, a datagrid?

Well you have a line for the query just like in php but after you have a DataSet then DataFill and finally DataSource, here is a simple sample: windows-programming.suite101.com/article.cfm/… — Prix
– Prix, Commented Aug 3, 2010 at 18:23

Justin Niessner · Accepted Answer · 2010-08-03 18:22:35Z

3

This is probably the most quintessential ADO.NET code to fill DataGrid you're going to see (using disconnected DataSets, that is):

DataTable results = new DataTable();

using(MySqlConnection conn = new MySqlConnection(connString))
{
    using(MySqlCommand command = new MySqlCommand(sqlQuery, conn))
    {
        MySqlDataAdapter adapter = new MySqlDataAdapter(command);
        conn.Open();
        adapter.Fill(results);
    }
}

someDataGrid.DataSource = results;
someDataGrid.DataBind();

answered Aug 3, 2010 at 18:22

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

npinti Over a year ago

The MySQL connector for .NET can be downloaded here: dev.mysql.com/doc/refman/5.0/en/connector-net.html

Joel Mueller Over a year ago

You can stack the using statements on top one one another and have a single block rather than two nested blocks of code. It's functionally identical but (I think) less busy looking.

Collectives™ on Stack Overflow

MySQL with C#, from a PHP Developer's Standpoint

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related