Changing Column Title of DataGridView When Connecting SQL Server in Windows Application

Here, I will explain how to change the column title of the DataGridView when connecting the SQL Server.

Step 1: Form

Drag down a data GridView and a Button from the tool box.



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 Eid as 'Employee Id', Name as 'Employee name' , surname as 'Employee surname' ,Age as 'Employee surname' 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);

    }

}  

Step 3: Run

Now run your application.

You can also visit my blog_munesh  to learn more.