(adsbygoogle = window.adsbygoogle || []).push({}); *You need to create a mysql database to use this. Its really easy!

1. Create a WinForms Application
2. Add a DataGrid and call it dataGrid
3. Add a reference to MySql
4. Create a class called MySql

Add this to your MySql Class:

It is safer to fetch the connection string from where else instead of hard coding it in!

    

 public static void Connect()

        {



             try

            {

                 MySqlConnection connect = new MySqlConnection("Server=" + "server" + ";" +

                                              "Database=" + "databasename" + ";" +

                                              "Uid=" + "username" + ";" +

                                               "Pwd=" + "password" + ";");

                connect.Open();





            }

            catch (MySqlException ex)

            {

                MessageBox.Show(ex.Message)

             }

}

    

  public static void CustomerInformation(DataGridView dataGrid)

        {

            string cmdAll = "SELECT * FROM (TableName)"; (* means ALL)

            MySqlDataAdapter dataAdapter = new MySqlDataAdapter(cmdAll, connect);

            DataTable dataTable = new DataTable();

            dataAdapter.Fill(dataTable);

            dataGrid.DataSource = dataTable;



        }

}

Add a timer to your Form1

    

     private void Form1_Load(object sender, EventArgs e)

        {



            MySQL.Connect();

            MySQL.CustomerInformation(dataGrid);

            timer_GridUpdate.Interval = 100000;

            timer_GridUpdate.Start();

         

}

    

private void timer_GridUpdate_Tick(object sender, EventArgs e)

        {

           MySQL.CustomerInformation(dataGrid);

           

         

        }

*I did not add any of mysql exception checks in this tutorial so make sure you add them
Source: You must login or register to view this content.
(Source is very incomplete so don't expect much out of it lol)

Video:

I could use this with my VB database, testing now thanks. :p

Well i have tried but you forgot to mention that i have to install Mysql class library, here's the link to it: You must login or register to view this content.

I have tried multiple times but i never succeeded, i don't get any sign if the project is working or not, even the labels isn't changing, have you tried your project? it has the same problem as mine.

Thanks anyway.

Yes, I tested my project and it works fine. Watch the video.

Not sure what you are doing wrong unless I can see your code.

Try enabling inner exceptions and see if you get any errors or you can send me your project.

i usually set up an api with php to do all the work and have the c# app use post cmds, and get cmds, i just find it unsafe if my client logs into my mysql db from time to time lol. Nice tutorial btw