绑定下拉问题 [英] binding drop down problem

问题描述

SELECT in_website_id, in_website_type_id, vc_website_name, vc_login_name FROM dbo.website

    WHERE bt_active = @bt_active ORDER BY vc_website_name

使用给定的查询我这样绑定下拉列表..

Using given query i am binding dropdown like this..

if (dtWebsite.Rows.Count > 0)
    {
      ddlWebsite.DataSource = dtWebsite;
      ddlWebsite.DataTextField = "vc_website_name";
      ddlWebsite.DataValueField = "in_website_id";
      ddlWebsite.DataBind();
      ddlWebsite.Items.Insert(0, new ListItem("Select Website", "0"));

这里我要展示两个in_website_id（1和604）到顶部如何在sql中实现这一点

Here i want to show two in_website_id(1 and 604) to top How to achieve this in sql

推荐答案

要将id = 1和604的网站放在列表顶部，需要像这样改变你的ORDER BY子句：

To have websites with id = 1 and 604 on top of list, you need to alter your ORDER BY clause like this:

SELECT
    in_website_id, in_website_type_id, vc_website_name, vc_login_name
FROM
    dbo.website
WHERE
    bt_active = @bt_active
ORDER BY
    (CASE WHEN in_website_id IN (1, 604) THEN 0 ELSE 1 END),
    vc_website_name

可能你需要这样的东西：

Probably you need something like this:

SELECT 0, null, 'Select Website', null
UNION ALL
SELECT in_website_id, in_website_type_id, vc_website_name, vc_login_name FROM dbo.website
WHERE bt_active = @bt_active ORDER BY vc_website_name

这篇关于绑定下拉问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！