Storing checkboxes value in a single row

abhishekkashyap27 · April 3rd, 2008, 01:55 AM

HI ALL

I AM MAKING A WEB APP USING C#,SQL SERVER 2005. I M USING VISUAL STUDIO 2005 PRO.

I HAVE MULTIPLE CHECKBOXES. PROBLEM IS THAT I HAVE TO STORE THE CHECKED VALUES IN A SINGLE COLUMN AS A COMMA SEPARATED VALUES. EXAMPLE UNDER HOBBIES CATEGORY, I HAVE CHECKBOXES FOR READING, EATING, SINGING ETC., IN MY TABLE I HAVE ONE COLUMN 'HOBBIES',DEPENDING ON THE USER SELECTION, THE VALUES SHOULD BE STORED IN THE TABLE UNDER COLUMN HOBBIES AS READING, EATING(AS A COMMA SEPARATED VALUE, IN A SINGLE ROW)

I AM NOT USING ANY REPEATER CONTROL, OR GRIS=D VIEW, I AM PASSING IT IN A SIMPLE WAY...
TELL ME HOW TO DO IT SHOWING CODES.....

weicco · April 3rd, 2008, 02:30 PM

CAPS! My eyes! Thery're burning!

But I'm in a nice mood and my crystall ball shows something like this:

Code:

StringBuilder sb = new StringBuilder();
foreach (Control ctrl in Controls)
{
    if (ctrl is CheckBox)
    {
        sb.AppendFormat("{0}={1},", ctrl.Name, ((CheckBox)ctrl).Checked));
    }
}

if (sb.Length > 0)
{
    sb.Length--;
}

string yourString = sb.ToString();

abhishekkashyap27 · April 8th, 2008, 12:13 AM

Thanks for the help, but one more thing is intriguing me..., that is how to retrieve back the chaeckbox values in page which i have inserted.
Suppose i have textbox where i will enter studentid and will press 'Go' button, then all the records will get fetched, including the checkbox. How to get the checkbox value back into the page, can u explain me through code...