Displaying to CheckBoxList Comma separated values from single column database in asp.net with c#

See more:

ASP.NET

SQL-Server-2008R2

i have one textbox,DropDownList,checkboxlist.

Silver Gold, Gold,Sterling Silver,Silver Brass


4 String insert in Single Column but comma separated values.. like(Silver Gold,Silver Brass) or(Gold,Sterling Silver,Silver Brass)

then Access the Checkboxlist related the value can checkbox can checked....???

Problem:- data save in database but not properly save.. i mean comma saparated values....

My Code Is:-

protected void btnADDSAVE_Click(object sender, EventArgs e)
{
InsertMetal();
}

protected void InsertMetal()
{
SqlConnection con = new SqlConnection(str);

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_addnewproduct";
cmd.CommandType = CommandType.StoredProcedure;



cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = txtName.Text.Trim();
cmd.Parameters.AddWithValue("@category", DropDownList1.SelectedItem.Value);

//SqlParameter metal = new SqlParameter("@metal", SqlDbType.VarChar); ;
// metal.Value = CheckBoxList1.SelectedValue;
// cmd.Parameters.Add(metal);


cmd.Parameters.AddWithValue("@metal", CheckBoxList1.SelectedItem.Text.Trim());
cmd.Connection = con;

string baby = "";
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{

if (CheckBoxList1.Items[i].Selected)
{
baby += CheckBoxList1.Items[i].Value + ",";

}
}
baby = baby.TrimEnd(',');

Response.Write(baby);

try
{

con.Open();
cmd.ExecuteNonQuery();

Response.Write("Added");
}
catch (Exception e)
//catch
{
throw e;
//Response.Write("NOT Added");
// return baby;
}
finally
{
con.Close();
con.Dispose();
}

}