A column data of DB in grid view as 2 Columns

private void BindGrid()

{

DataSet ds = new DataSet();

using (SqlConnection conn = new SqlConnection())

{

conn.ConnectionString = ConfigurationManager

.ConnectionStrings["constr"].ConnectionString;

using (SqlCommand cmd = new SqlCommand())

{

cmd.CommandText = "select * from AS_CATG_MASTER";

cmd.Connection = conn;

conn.Open();

SqlDataAdapter sda = new SqlDataAdapter(cmd);

sda.Fill(ds);

GridCatg.DataSource = ds;

GridCatg.DataBind();

conn.Close();

}

}

}

protected void GridCatg_RowDataBound(object sender, GridViewRowEventArgs e)

{

//Binding checkbox list to Gridview

if (e.Row.RowIndex != -1 && e.Row.DataItem != null)

{

object objTemp = GridCatg.DataKeys[e.Row.RowIndex].Value as object;

if (objTemp != null)

{

Catgname = objTemp.ToString();

//Do your operations

}

//Itendifying checkboxlist in gridview template column

CheckBox chkall = (CheckBox)e.Row.Cells[0].FindControl("cbAll");

chkall.Text = Catgname;

CheckBoxList chklist = (CheckBoxList)e.Row.Cells[0].FindControl("cb_CATG_FORM");

DataSet bpds = ExecuteDataset(sDsn, "select * from AS_CATG_FORM WHERE HCF_CATG_CD='" + Catgname + "'");

if (bpds.Tables.Count > 0)

{

if (bpds.Tables[0].Rows.Count > 0)

{

//Assigning DataSource to checkboxlist

chklist.DataSource = bpds.Tables[0];

chklist.DataTextField = "HCF_FORM_CD";

chklist.DataValueField = "HCF_FORM_CD";

chklist.DataBind();

//chklist.Items.Insert(0, new ListItem(Catgname));

}

}

chkall.Attributes.Add("onclick", "CallChk('" + chklist.ClientID.ToString() + "','" + chklist.Items.Count + "','" + chkall.ClientID.ToString() + "')");

}

}