|
![](/images/resource/spacer.gif) |
|
[ขอความช่วยเหลือ] เวลากดบันทึกข้อมูลลง sql แล้วมันแจ้งว่าไม่ผ่าน |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
Code (VB.NET)
Dim sql As String = ""
sql = "INSERT INTO po1 (PO_ID,ID,NAME,Timeproduct,PRICE,MEMID,Firstname_m,Lastname_m,EMPID,Firstname_e,Lastname_e,COMMISSION,Employee_wage,Owner_wage,Date,Time) VALUES (@PO_ID,@ID,@NAME,@Timeproduct,@PRICE,@MEMID,@Firstname_m,@Lastname_m,@EMPID,@Firstname_e,@Lastname_e,@COMMISSION,@Employee_wage,@Owner_wage,@Date,@Time)"
dc = New SqlCommand(sql, sqlcon)
For r As Integer = 0 To dg2.RowCount - 1
With dc
.Parameters.AddWithValue("PO_ID", (txtpo_id.Text))
.Parameters.AddWithValue("ID", dg2.Rows(r).Cells(9).Value)
.Parameters.AddWithValue("NAME", dg2.Rows(r).Cells(0).Value)
.Parameters.AddWithValue("Timeproduct", dg2.Rows(r).Cells(1).Value)
.Parameters.AddWithValue("PRICE", dg2.Rows(r).Cells(3).Value)
.Parameters.AddWithValue("MEMID", (txtMEMID.Text))
.Parameters.AddWithValue("Firstname_m", (txtFirstname_m.Text))
.Parameters.AddWithValue("Lastname_m", (txtLastname_m.Text))
.Parameters.AddWithValue("EMPID", (txtEMPID.Text))
.Parameters.AddWithValue("Firstname_e", dg2.Rows(r).Cells(2).Value)
.Parameters.AddWithValue("Lastname_e", (txtLastname_e.Text))
.Parameters.AddWithValue("COMMISSION", dg2.Rows(r).Cells(6).Value)
.Parameters.AddWithValue("Employee_wage", dg2.Rows(r).Cells(7).Value)
.Parameters.AddWithValue("Owner_wage", dg2.Rows(r).Cells(8).Value)
.Parameters.AddWithValue("Date", dg2.Rows(r).Cells(5).Value)
.Parameters.AddWithValue("Time", dg2.Rows(r).Cells(4).Value)
End With
MessageBox.Show("บันทึกข้อมูลสำเร็จ", "ร้านเฮอบัลสปา", MessageBoxButtons.OK)
dc.ExecuteNonQuery()
dc.Parameters.Clear()
![VB VB](https://www.thaicreate.com/upload/stock/20150709170254.jpg?v=1001)
Tag : .NET, VB.NET, VS 2010 (.NET 4.x)
![](/images/adv.jpg?v=1001)
|
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-07-09 17:06:22 |
By :
indygunaza |
View :
859 |
Reply :
4 |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
data type ไม่ตรงกับที่ออกแบบไว้นิครับ
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-07-09 17:22:23 |
By :
lamaka.tor |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 05
|