 |
| |
ช่วยดูโค๊ดหน่อยจ้า Parameterized Query '(@moo nvarchar(2),@villagename nvarchar(7),@subdistrict nvarchar' expects parameter @oldid, which was not supplied. |
| |
 |
|
|
 |
 |
|
conn = New SqlConnection
conn.ConnectionString = strCon
conn.Open()
If vID <> txtMoo.Text Then
strSQL = "select Moo from Village where Moo='" & Trim(txtMoo.Text) & "'"
comm = New SqlCommand(strSQL, conn)
dr = comm.ExecuteReader
If dr.Read Then
MessageBox.Show("รหัสหมู่บ้านที่แก้ไข ซ้ำกับรหัสหมู่บ้านอื่นที่มีอยู่ในระบบอยู่แล้ว กรุณากรอกใหม่อีกครั้ง", "โปรดระวัง..", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
dr.Close()
txtMoo.Focus()
Exit Sub
End If
End If
dr.Close()
strSQL = "update Village set Moo=@moo, VillageName=@villagename, Subdistrict=@subdistrict,District=@district, Province=@province "
strSQL = strSQL & " WHERE Moo=@oldid "
comm = New SqlCommand(strSQL, conn)
comm.Parameters.AddWithValue("@moo", txtMoo.Text)
comm.Parameters.AddWithValue("@villagename", txtVillage.Text)
comm.Parameters.AddWithValue("@subdistrict", txtSubdistrict.Text)
comm.Parameters.AddWithValue("@district", txtDistrict.Text)
comm.Parameters.AddWithValue("@province", txtProvince.Text)
comm.Parameters.AddWithValue("@oldid", vID)
comm.ExecuteNonQuery()
Tag : VB.NET
|
|
|
 |
 |
 |
 |
| Date :
2011-02-23 07:55:29 |
By :
เดือน |
View :
1371 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
error
Parameterized Query '(@moo nvarchar(2),@villagename nvarchar(7),@subdistrict nvarchar' expects parameter @oldid, which was not supplied.
|
| |
|
|
| |
| Date :
2011-02-23 08:15:09 |
By :
เดือน |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
