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)

{

MessageBox.Show(ec.Message);

}

}

If you don't want to load data into the DataGridView at a button click then you can make a function for filling in this DataGridView.

public void displayDataGridView()

{

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

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

try

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

con.Close();

}

catch (Exception ec)

{

MessageBox.Show(ec.Message);

}

}

Step 3: Run

Now run your application.