在SQL Server中存储复选框列表的最佳方法是什么

我有一个看起来像这样的复选框列表



< asp：CheckBoxList ID =chkBoxrunat =server>

< asp：ListItem Text =TextValue =Text/>

< asp：ListItem Text =EmailValue =Email/>

< asp：ListItem Text =MailValue =Mail/>

< asp：ListItem Text =CalendarValue =Calendar/> b $ b



我不确定在我的SQL数据库中存储它的最佳方法是什么。我知道我可以查看附加到字符串的值。



但是如果我想重新加载这个表格并且选中了复选框，自动检查，我应该如何将这些信息存储在我的数据库中？



我尝试了什么：



以下是我将这些值附加到字符串的方法



string interests = string.Empty;

foreach（this.chkBox.Items中的ListItem项目）

if（item.Selected）

兴趣+ = item +，;



但我不认为这是理想的。我真的不知道如何将其从表中拉出来并将其显示在表格中。

I have a checkbox list that looks like this

<asp:CheckBoxList ID="chkBox" runat="server">
<asp:ListItem Text="Text" Value="Text"/>
<asp:ListItem Text="Email" Value="Email"/>
<asp:ListItem Text="Mail" Value="Mail"/>
<asp:ListItem Text="Calendar" Value="Calendar"/>


I'm not sure what the best way to store this in my SQL database is. I know I can look through the values to append to a string.

But if I want to reload this form and have the checkbox's that were checked off, checked automatically, how should I store this info in my database?

What I have tried:

Here is how I appended these values to a string

string interests = string.Empty;
foreach (ListItem item in this.chkBox.Items)
if (item.Selected)
interests += item + ",";

But I don't think this is ideal. I don't really know how i would pull this out from my table and display it in the form.