Hey,
If you get data from sql---
<pre lang="SQL">
D_id Designation name Employees
1 Consultant GHI
2 Project Lead DEF
3 Project Lead PQR
4 Programmer ABC
5 Programmer JKL
6 Programmer MNO
Then you should work on RowDataBound event of the grid to taking a string Variable to put the initial Designation name value.
string sDesignation=string.Empty;
initialize with the Designation name value.
then check with
if(sDesignation!=current Designation name value)
{
// code to set the Designation name
}
sDesignation retail the Designation name value.
TRY................ With this logic.