CODEWITHSUNDEEP
c#sql-serverwinformsvisual-studio-2010
user12427608
user12427608

Reputation:

Merge 3 columns from database to 1 column in datagridview

Is it possible to merge 3 columns from my database into datagridview as one? I have Lname, Fname, and Mname in my database but i want to show it as a Fullname in my datagridview.

public void LoadRecords()
    {
        int i = 0;
        dataGridView1.Rows.Clear();
        cn.Open();
        cm = new SqlCommand("SELECT * FROM Members", cn);
        dr = cm.ExecuteReader();
        while (dr.Read())
        {
            i += 1;
            dataGridView1.Rows.Add(i, dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), dr[6].ToString());
        }
        dr.Close();
        cn.Close();
    }

Upvotes: 0

Views: 316

Answers (3)

Mahmoud Ramadan
Mahmoud Ramadan

Reputation: 652

 public void LoadRecords(){
    int i = 0;
    dataGridView1.Rows.Clear();
    cn.Open();
    cm = new SqlCommand("SELECT * FROM Members", cn);
    DataTable tbl = new DataTable();
    tbl.Load(cm.ExecuteReader());
    string fullName = tbl.Rows[0][1].ToString() + tbl.Rows[0][2].ToString();
    // 0 points to first row and for example full name exists in second and third column then you can add fullName to dataGridView as one
    dr.Close();
    cn.Close();
}

Upvotes: 0

Nguyễn Văn Phong
Nguyễn Văn Phong

Reputation: 14198

You just need concat string like below 

var fullName = dr[index_Of_Fname].ToString() + ", " + dr[index_Of_Mname ].ToString() + " " + dr[index_Of_Lname].ToString();
dataGridView1.Rows.Add(i,  .., fullName,..);

Upvotes: 0

AJITH
AJITH

Reputation: 1175

You can query it as a single field.

"SELECT Fname + ' ' + MName + ' ' + LName as [Name], column2,column3 FROM Members"

Upvotes: 1

Related Questions