sql query to display info grouped by Category

1. Remove the because you don't need the header row in this format.

2. Within the , keep the structure as it is, but remove the header labels. This template will be used for each row of data.

Now, in your C# code-behind, you will need to handle the logic for grouping the data and dynamically controlling the display of the "Obiectiv" values to match the format you provided. You can use a placeholder to conditionally display the "Obiectiv" value only when it changes.

Here's an example of how you can achieve this:

string previousObiectiv = null;

protected void DataList8_ItemDataBound(object sender, DataListItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        DataRowView drv = (DataRowView)e.Item.DataItem;
        string currentObiectiv = drv["Obiectiv"].ToString();
        Label txtObiectiv = (Label)e.Item.FindControl("txtObiectiv");
        PlaceHolder phObiectiv = (PlaceHolder)e.Item.FindControl("phObiectiv");

        if (currentObiectiv != previousObiectiv)
        {
            txtObiectiv.Text = currentObiectiv;
            phObiectiv.Visible = true;
        }
        else
        {
            phObiectiv.Visible = false;
        }

        previousObiectiv = currentObiectiv;
    }
}

Make sure to set the OnItemDataBound event of your DataList control to the DataList8_ItemDataBound method in your code-behind.

This code checks if the "Obiectiv" value has changed compared to the previous row and controls the visibility of the "Obiectiv" value accordingly. This way, it creates the grouped format you are looking for.