Merging Two columns under same heading in Gridview
-
Hi Buddies, I wanna to combine two columns with same heading using asp.net with c#.values i'm getting from database. For example: database retruning rows as empid empname empdept empbranch 1 Suresh dev Bangalore 2 kavitha tester bangalore 3 Siva dev chennai Required Result in UI is: emp_personal emp_official empid empname empdept branch 1 suresh dev bangalore 2 kavitha tester bangalore 3 siva dev chennai
-
Hi Buddies, I wanna to combine two columns with same heading using asp.net with c#.values i'm getting from database. For example: database retruning rows as empid empname empdept empbranch 1 Suresh dev Bangalore 2 kavitha tester bangalore 3 Siva dev chennai Required Result in UI is: emp_personal emp_official empid empname empdept branch 1 suresh dev bangalore 2 kavitha tester bangalore 3 siva dev chennai
Try concatenating the two columns in your select statement. Example: select empid empname + ' ' + empdept + ' ' + empbranch
-
Try concatenating the two columns in your select statement. Example: select empid empname + ' ' + empdept + ' ' + empbranch
Hi David, i don't want to merge values,need to show them in separate table under same heading
-
Hi Buddies, I wanna to combine two columns with same heading using asp.net with c#.values i'm getting from database. For example: database retruning rows as empid empname empdept empbranch 1 Suresh dev Bangalore 2 kavitha tester bangalore 3 Siva dev chennai Required Result in UI is: emp_personal emp_official empid empname empdept branch 1 suresh dev bangalore 2 kavitha tester bangalore 3 siva dev chennai
SELECT ISNULL(empid, '') + ' ' + ISNULL(empname, '') AS emp_personal, ISNULL(empdept, '') + ' ' + ISNULL(empbranch, '') AS emp_official FROM emp check this query and please confirm me is this working for you or not?