将复选框列表与SQL表相关 [英] Relate CheckBox List with SQL Table

问题描述

我想将选定的复选框与SQL数据库中表的列相关联.使用ASP对此有什么好的解决方案吗?

这就是我将列名弹出到复选框列表中的方式:

Hi,

I want to relate a selected checkboxs to columns of a table in the SQL data base. Any good solution to this using ASP?

This is how I am pop column names into the checkbox list:

<pre lang="vb">asp:SqlDataSource ID="Columns" runat="server"<br />
            ConnectionString="<%$ ConnectionStrings:myDB %>" SelectCommand="SELECT COLUMN_NAME<br />
FROM [InterBC-WeatherStation].INFORMATION_SCHEMA.COLUMNS<br />
WHERE TABLE_NAME=''Products'' AND (<br />
      COLUMN_NAME = ''Employee'' OR<br />
      COLUMN_NAME = ''Salary'' OR...</pre><br />

推荐答案

ConnectionStrings:myDB％>"SelectCommand =" SELECT COLUMN_NAME< br/> 从[InterBC-WeatherStation].INFORMATION_SCHEMA.COLUMNS< br/> WHERE TABLE_NAME =''产品''AND(< br/> COLUMN_NAME =员工"或< br/> COLUMN_NAME =``工资''或...</pre>< br/>

ConnectionStrings:myDB %>" SelectCommand="SELECT COLUMN_NAME<br /> FROM [InterBC-WeatherStation].INFORMATION_SCHEMA.COLUMNS<br /> WHERE TABLE_NAME=''Products'' AND (<br /> COLUMN_NAME = ''Employee'' OR<br /> COLUMN_NAME = ''Salary'' OR...</pre><br />

好吧
1)您的数据库应为布尔值
2)复选框值应始终转换为布尔值.因此您的代码将类似于

Well
1) your database should be a boolean
2) the checkbox value should always be converted into boolean. So your code would be something like

insert into mytable values (" + checkbox1.value + "....

这不是可编译的代码-只是一个示例.

Checkbox.Checked包含true或false，如遵循 [ ^ ].

This was not code that compiles - just a sample.

Checkbox.Checked contains true or false as follows[^].

这篇关于将复选框列表与SQL表相关的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！