根据组合框选择删除sql server中的查询 [英] delete query in sql server depending on combo box selection
本文介绍了根据组合框选择删除sql server中的查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好
在我的表格中,我有3个组合框,分别有相应的详细信息:
公司名称
公司代码
公司别名
现在删除时我想要如果用户从3个组合框中的任意一个中选择任何一个值,那么他应该可以删除。
请告诉我该怎么做
我试过了在删除查询中使用OR运算符但它不起作用..
delete 来自公司其中 CompanyName = ' & cmbCompanyName.SelectedValue.ToString()&' OR CompanyCode = ' & cmbCompanyCode.SelectedValue.ToString()&' 或别名= ' & cmbComapnyAlias.SelectedValue.ToString()& '
谢谢
解决方案
从公司中删除CompanyName =' + cmbCompanyName.Text.ToString()+ 'OR CompanyCode =' + cmbCompanyCode.Text.ToString()= 'OR Alias =' + cmbComapnyAlias.Text.ToString()+ '
Hi all
In my form i have 3 combo box having the respective details:
Company Name
Company Code
Company Alias
Now while deleting i want like if the user select any one value from any of the 3 combo box , then he should be able to delete.
Please tell me how to do that
I tried using OR operator in delete query but it''s not working..
delete from Company where CompanyName='" & cmbCompanyName.SelectedValue.ToString() & "' OR CompanyCode='" & cmbCompanyCode.SelectedValue.ToString() & "' OR Alias='" & cmbComapnyAlias.SelectedValue.ToString() & "' "
Thank you
解决方案
"delete from Company where CompanyName='" + cmbCompanyName.Text.ToString() + "' OR CompanyCode='" + cmbCompanyCode.Text.ToString() = "' OR Alias='" + cmbComapnyAlias.Text.ToString() + "' "
这篇关于根据组合框选择删除sql server中的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文