مشکل در اجرای دستور select

[reza4344]

با سلام دوستان

من از این دستور برای ایجاد تقاضا استفاده کردم :


cmd = new SqlCommand("SELECT RTRIM(invoiceNo) as [Order No.],RTRIM(InvoiceDate) as [Order Date],RTRIM(SubTotal) as [SubTotal],RTRIM(VATPer) as [Vat+ST %],RTRIM(VATAmount) as [VAT+ST Amount],RTRIM(DiscountPer) as [Discount %],RTRIM(DiscountAmount) as [Discount Amount],RTRIM(GrandTotal) as [Grand Total],RTRIM(TotalPayment) as [Total Payment],RTRIM(PaymentDue) as [Payment Due],Remarks from Invoice_Info where InvoiceDate between @d1 and @d2 order by InvoiceDate desc", con);


ولی وقتی می خوام رکورد remarks رو ازش جدا کنم ارور میده میگه نمیشه . (به شکل زیر remarks رو برداشتم دوستان)



cmd = new SqlCommand("SELECT RTRIM(invoiceNo) as [Order No.],RTRIM(InvoiceDate) as [Order Date],RTRIM(SubTotal) as [SubTotal],RTRIM(VATPer) as [Vat+ST %],RTRIM(VATAmount) as [VAT+ST Amount],RTRIM(DiscountPer) as [Discount %],RTRIM(DiscountAmount) as [Discount Amount],RTRIM(GrandTotal) as [Grand Total],RTRIM(TotalPayment) as [Total Payment],RTRIM(PaymentDue) as [Payment Due] where InvoiceDate between @d1 and @d2 order by InvoiceDate desc", con);



لطفا دستور درست رو برام بنویسید.

سپاس

[mahan.2002]

با سلام
بهتره سوالات مربوط به زبان SQL رو در تالار T-SQL مطرح کنید.
موفق باشید.