Display Table From MySQL DB

Hi All,

I'm trying to find a way to display a table to the user using mySQL DB.

The table should have options to merge cells for related items and to embed buttons in the cells.

Thanks for your help.

re: Display Table From MySQL DB

download MySQL .NET Connectore from here

re: Display Table From MySQL DB

Thanks, I will have a look at it right now.

Thanks again.

re: Display Table From MySQL DB

After downloading it, I have noticed that I already installed it in order to implement the DB connection.

what I'm looking for is a better way to display the table (from the DataGrid).
a table that I will be able to embed in it button for example.

Thanks

re: Display Table From MySQL DB

Try using DataGridView

re: Display Table From MySQL DB

How can I embed button in DataGrid View ?
So the button will effect the record it in it.

re: Display Table From MySQL DB

Add a column of type textbox column I think?
There's plenty of examples online and on msdn

edit: oops i meant button column, not sure why i typed textbox

re: Display Table From MySQL DB

What I meant was to do this:

//Set the button object
DataGridViewButtonColumn dgButton = new DataGridViewButtonColumn();
dgButton.Name = "DataGridButton1";
dgButton.Text = "Done";
dgButton.UseColumnTextForButtonValue = true;


//Add the button columns
dataGridView1.Columns.Add(dcButton);


Thanks All For the Help...