我有要求是：我希望显示1到58个数字和58之后我希望通过使用Sql Server编写查询在Combobox中的“其他”文本。 [英] I Have Requirement Is :I Want To Display 1 To 58 Numbers And After 58 I Want 'Other' Text In The Combobox By Writing Query By Using Sql Server.

问题描述

我有要求是：我希望显示1到58个数字，58之后我想通过使用sql server编写查询来在组合框中找到其他文本。





请帮帮我.....

解决方案

你可以使用sql server中的以下代码将你的组合框与数据库绑定

 DECLARE @first int = 1; 
 DECLARE @last int = 58; 
 
 WITH num AS（
 SELECT @first AS number 
 UNION ALL 
 SELECT number + 1 
 FROM num 
 WHERE number< @最后
）
 SELECT号码
 FROM num 

它会给你1-58和'其他'你可以在组合框中添加静态值

i have requirement is :i want to display 1 to 58 numbers and after 58 i want 'other' text in the combobox by writing query by using sql server.


please help me.....

解决方案

you can bind your combo box with database using following code in sql server

DECLARE @first int = 1;
DECLARE @last int = 58;

WITH num AS (
    SELECT @first AS number
    UNION ALL
    SELECT number + 1 
    FROM  num
    WHERE number < @last
)
SELECT number
FROM num

it will give you 1-58 and for 'Other' you can add static value in combo box

这篇关于我有要求是：我希望显示1到58个数字和58之后我希望通过使用Sql Server编写查询在Combobox中的“其他”文本。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！