/C#/How to refresh the data table in C# window form datagridview

How to refresh the data table in C# window form datagridview

con.Open();
MySqlDataAdapter MyDA = new MySqlDataAdapter();
string sqlSelectAll = "SELECT * from dailyprice";
MyDA.SelectCommand = new MySqlCommand(sqlSelectAll, con);

DataTable table = new DataTable();
MyDA.Fill(table);

BindingSource bSource = new BindingSource();
bSource.DataSource = table;


dataGridView1.DataSource = bSource;
con.Close();

Source: stackoverflow.com

How to refresh the data table in C# window form datagridview

cmd = new OleDbCommand("insert into FWINFOS (ID,Name,Gender,DateOfBirth,Race,WorkingPlace,PassportNO,DateOfExpire,[Position],Photo) values('" + textBox5.Text + "','" + textBox1.Text + "','" + textBox2.Text + "','" + dateTimePicker1.Value + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + dateTimePicker2.Value + "',@Position,@Photo)", con);


        cmd.Parameters.AddWithValue("@Position", comboBox1.SelectedText.ToString());
        conv_photo();

        con.Open();
        int n = cmd.ExecuteNonQuery();
        //cmd.ExecuteNonQuery();
        con.Close();
        if (n > 0)
        {
            MessageBox.Show("Inserted");
            loaddata();

            rno++;
        }
        else
            MessageBox.Show("No Insert");



    }

Source: stackoverflow.com

Similar codes

0 vote188 views4 answers
Kube dashboard expose access port
C#
0 vote226 views1 answer
How to set border for groupbox in c#
C#
31 votes237 views3 answers
Raycast unity
C#Unity
0 vote198 views1 answer
How to hide tree level button when no record found for devexpress child grid view in Winform c#
C#
6 votes203 views1 answer
Asp.net core entity framework database first
C#
0 vote191 views1 answer
Resharper render pages folder asp.net core
C#
2 votes186 views1 answer
Unity 2d detect click on sprite
C#
1 vote259 views1 answer
Unity particle system playing at the wrong location
C#Unity
5 votes185 views2 answers
How to check if key is held in unity
C#
0 vote186 views2 answers
How to write excel content type while returning from mvc view
C#