用复选框造句 sql查询

Question

如题string strsql = "select EmployeeID as 工号,EmployeeName as 姓名,EmployeeSex as 性别";
string strsql2 = "";
string strsql3 = "from tb_Personnel";EmployeeFolk.Name ="EmployeeFolk";//EmployeeFolk 是个复选框
EmployeeFolk.Text = "民族";
if (EmployeeFolk.Checked)
     strsql2 = EmployeeFolk.Name +"as"+ EmployeeFolk.Text;SqlDataAdapter sda = new SqlDataAdapter(strsql+strsql2+strsql3, con);

Answer 1

 
 string strsql = "select EmployeeID as 工号,EmployeeName as 姓名,EmployeeSex as 性别";
string strsql2 = "";
string strsql3 = "  from tb_Personnel";EmployeeFolk.Name =" ,EmployeeFolk";//EmployeeFolk 是个复选框
EmployeeFolk.Text = "民族";
if (EmployeeFolk.Checked)
     strsql2 = EmployeeFolk.Name +"as"+ EmployeeFolk.Text;SqlDataAdapter sda = new SqlDataAdapter(strsql+strsql2+strsql3, con);

Answer 2

如果再做的简便一点
代码如下foreach (CheckBox cb in this.Controls)
                {
                    if (cb.Checked)
                        strsql2 += ","+cb.Name + cb.Text;
                }提示无法将button 强制类型转换为 CheckBox !!!

Answer 3

总感觉你这SQL语句拼接的不习惯！！哪有拼接语句还用前面的查询字段啊，这些拼接基本都是根据查询条件利用的哈

Answer 4

我刚还试了GroupBox 也不行

Answer 5

string strsql = "select EmployeeID as 工号,EmployeeName as 姓名,EmployeeSex as 性别"; 
string strsql2 = ""; 
string strsql3 = "from tb_Personnel"; EmployeeFolk.Name ="EmployeeFolk";//EmployeeFolk 是个复选框 
EmployeeFolk.Text = "民族"; 
if (EmployeeFolk.Checked) 
   strsql2 = EmployeeFolk.Name +"as"+ EmployeeFolk.Text; 
SqlDataAdapter sda = new SqlDataAdapter(strsql+strsql2+strsql3, con);
改成：
string strsql = "select EmployeeID as 工号,EmployeeName as 姓名,EmployeeSex as 性别,{0} as {1} from tb_Personnel"; "; EmployeeFolk.Name ="EmployeeFolk";//EmployeeFolk 是个复选框 
EmployeeFolk.Text = "民族"; 
if (EmployeeFolk.Checked) 
   SqlDataAdapter sda = new SqlDataAdapter(string.Format(strsql,EmployeeFolk.Name,EmployeeFolk.Text), con);