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

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.
Ebook Download
View all
Learn
View all