Show Database Value in DataGridView in Windows Application

Here, I will explain how to show a database value in a DataGridView.

Step 1: Form

Drag and drop a DataGridView and a Button from the Toolbox.



Step 2: Code

Now click on the button (Load Button) and write this code:

private void Load_button_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("server = MUNESH;Database=datastore;UID=sa;Password=123;");

SqlCommand cmd = new SqlCommand("Select * from data1", con);

try

{

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataTable dt = new DataTable();

da.Fill(dt);

BindingSource bsource = new BindingSource ();

bsource .DataSource = dt;

dataGridView1.DataSource = bsource ;

}

catch (Exception ec)

{