ACCESS 查詢結果只返回50條的SQL語句[想學的 會的進][邊城浪浪子請進]

[CraxyMouse]

SELECT ORDER_ID, ORDER_NO AS 客戶訂單號,PRODUCT_NAME,PRODUCT_NO,PRODUCT_ITEM,
PRODUCT_SOURCE,PRODUCT_PRICE FROM CUSTOM_ORDER ORDER BY CREATE_DATE"

這是我寫的SQL語句,怎麼只選出前50條記錄呢?剛才你給我的SQL語句在Access裡試不通過!謝謝!
select top 50 from CUSTOM_ORDER ORDER BY CREATE_DATE
這樣寫好像不對!!

C# winfrom 中datagrid 怎麼將一列寬度設為0?
我的QQ:9658258能加我嗎?

[CraxyMouse]

oDs = oRetv.Select(sql);
//給ods中table命名
oDs.Tables[0].TableName = "sor";
//建立數據源
gridIN.SetDataBinding(oDs,oDs.Tables[0].TableName);
DataGridTableStyle ts = new DataGridTableStyle();
ts.SelectionBackColor = System.Drawing.SystemColors.Desktop;
ts.AllowSorting = false;
ts.ReadOnly = true;
ts.MappingName = gridIN.DataMember;
gridIN.TableStyles.Add(ts);
gridIN.TableStyles[0].GridColumnStyles[0].Width = 0;
隱藏列實現

[windinwing]

select top 50 * from CUSTOM_ORDER ORDER BY CREATE_DATE
少了一个*


在存储过程里还可以这样
set rowcount 50
select * from CUSTOM_ORDER ORDER BY CREATE_DATE

[dazhu2]

不好意思，忘写了*
select top 50 * from CUSTOM_ORDER ORDER BY CREATE_DATE