|
|
|
ช่วยแก้ให้ผมที Conversion from string "select stock.stk_name, order_det" to type 'Long' is not valid. |
|
|
|
|
|
|
|
If Not IsPostBack Then
''RunOrder()
LbName.Visible = True : LbName.Text = "ชื่อลูกค้า :: " & Session("Cus_Name")
LbAddress.Visible = True : LbAddress.Text = "ที่อยู่ :: " & Session("Cus_Address")
LbTorP.Visible = True : LbTorP.Text = "เบอร์โทรศัพท์ :: " & Session("Cus_TorP")
LbOnOrder.Text = DateNow
DMY = LbOnOrder.Text
dd = DMY.Substring(0, 2) : mm = DMY.Substring(3, 2) : yy = DMY.Substring(6, 4)
SqlDetail = ""
SqlDetail = "select stock.stk_name, order_detail.stk_id, order_detail.order_amt, order_detail.order_price, order_detail.order_vat"
SqlDetail = SqlDetail & " From Stock Inner Join Order_Detail On Stock.Stk_Id = Order_Detail.Stk_id"
SqlDetail = SqlDetail & " Where Order_Num = '" & Session("OrderNum") & "'" And " Cus_Id = '" & Session("Cus_Id") & "'" <<<<<<< Error บรรทัดนี้อะครับ
WS.ShowData(SqlBill, DataGrid1)
Conversion from string "select stock.stk_name, order_det" to type 'Long' is not valid.
Tag : .NET, VB.NET
|
|
|
|
|
|
Date :
2011-02-21 10:24:30 |
By :
-wHy-[C]ool |
View :
1085 |
Reply :
4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ประกาศตัวแปร SqlDetail ผิด (เดาเอา)
|
|
|
|
|
Date :
2011-02-21 11:32:36 |
By :
kaimuk |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
พักนี้คุนไข่หมัก ตอบทันที ตอบถี่และตอบได้ดี +1 ให้รุยค่ะ
|
|
|
|
|
Date :
2011-02-21 11:52:00 |
By :
สาวเอ๋อ (ก้อคนมานเอ๋อ) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 00
|