sql查询比较文本下拉列表和表 [英] sql query for compare text dropdownlist and table

问题描述

在我的项目中，我需要将用户选择的数据与sql server 2005中的数据库进行比较.

例如
资料来源:孟买
目的地:金奈

如果匹配，则两个dropdownlistselecteditem应该与数据库进行比较.匹配的行将以原来的形式显示

该怎么办呢?

谢谢.

In my project I need to compare user selected data with database in sql server 2005.

for example
source:mumbai
destination:chennai

The two dropdownlistselecteditem should compare to database if match. What are rows match it will display in anthor form

How can this be done?

Thanks.

推荐答案

SQL

SELECT * FROM Location WHERE Source = 'Mumbai' AND Destination = 'Chennai'

C#.Net

C#.Net

string SQL = "SELECT * FROM Location WHERE Source = '"+ ddlSource.SelectedValue +"' AND Destination = '"+ ddlDestination.SelectedValue +"'

这篇关于sql查询比较文本下拉列表和表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！