Question

I have an SQL statement in my C# program that looks like:

SELECT * FROM XXX.dbo.XXX 
WHERE Source =  OH 
  AND partnum =  1231202085  
ORDER BY partnum, Packaging, Quantity

When running this query in SQL Server Management, the results are ordered as expected. My first 3 results have the same partnum and Packaging with Quantities of 32.0, 50.8, and 51.0.

然而,当我从我的节目中解答时,最初要退还的产值为50.8。数量数据类型为少数(18.9)。我曾尝试过,这似乎是一个数据类型的问题。

我很想知道,为什么要达到中间数量。

我在我的C#代码,而不是 s子中发现我的问题。

After getting the query results I hade:

if (PurchOrder.Read())
while (PurchOrder.Read())

如果看一看看看看一看我的第一个结果,那是谁却取得了我的第二个结果。

Ive replace the if statement with:

if (PurchOrder). HasRows=真实的

一切都看着罚款。

再次感谢您的回复。处理误导问题。

- 同居

Answer 1

我在我的C#代码,而不是 s子中发现我的问题。

在获得询问结果之后,我说:

if (PurchOrder.Read()) while (PurchOrder.Read())

如果看一看看看看一看我的第一个结果,那是谁却取得了我的第二个结果。

兹将发言改为:

如果是(PurchOrder)。 HasRows=真实情况

and everything looks to fine.

再次感谢您的回复。处理误导问题。

- 同居

Answer 2

如果部分数字是甲型六氯环己烷,除非是你,否则不会按数字顺序分类。

离开Pad partnum到完全相同的特性

Sort with some specialized alphanumeric sorting. I typically use:

order by
RIGHT(REPLICATE( 0 , 1000) + LTRIM(RTRIM(CAST([field_name] AS VARCHAR(8000)))), 1000)

当然,如果你的田地面积较小,你可以使用更低的dding号码。

Answer 3

From the SQL Server side as long as partnum, packaging, and quantity are a numeric/float field this should work absolutely fine. What worries me is if packaging or partnum is a text type variable where 10 comes before 2.

避免出现这种情况:<条码>。在填写<代码>之前,数据类型为: 页: 1 http://msdn.microsoft.com/en-us/library/ms130214%28v=sql.90%29.aspx”rel=“nofollow”

例如:

CREATE TABLE #test
(
 mytest varchar(10)
)

INSERT INTO #test(mytest) VALUES( 10 )
INSERT INTO #test(mytest) VALUES( 1 )
INSERT INTO #test(mytest) VALUES( 2 )
INSERT INTO #test(mytest) VALUES( 12 )
INSERT INTO #test(mytest) VALUES( 20 )

SELECT * FROM #test ORDER BY mytest
DROP TABLE #test

产生不正确的订单。也可以这样处理:

www.un.org/Depts/DGACM/index_french.htm

就客户而言(C#)你是否以某种电网方式储存了这种数据?

友情链接