store multiple items in a single table column in sql database : currently i have

    public void bindgrid()
        {
            SqlConnection conn = new SqlConnection("Data Source = 'PAULO'; Initial Catalog=ShoppingCartDB;Integrated Security =True");
            SqlCommand cmd = new SqlCommand("select p.[name], cd.CustomerName, cd.CustomerEmailID,cd.CustomerPhoneNo,cd.CustomerAddress,cd.TotalPrice,cd.OrderDateTime, cd.PaymentMethod FROM CustomerDetails cd Inner Join CustomerProducts cp ON cp.CustomerID = cd.Id Inner Join Products p ON cp.ProductID = p.ProductID", conn);
            
            SqlDataAdapter da = new SqlDataAdapter("", conn);
            da.SelectCommand = new SqlCommand("select p.[name], cd.CustomerName, cd.CustomerEmailID,cd.CustomerPhoneNo,cd.CustomerAddress,cd.TotalPrice,cd.OrderDateTime, cd.PaymentMethod FROM CustomerDetails cd Inner Join CustomerProducts cp ON cp.CustomerID = cd.Id Inner Join Products p ON cp.ProductID = p.ProductID", conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "data");
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
        }

and the [result][1]

what i want to happen is that since it is in the same ID (10), would it be possible if i can have multiple values inside my Name column? like lpg,oxygen,etc?


  [1]: http://i.stack.imgur.com/2czOx.jpg