 |
|
ช่วยดูำ error ให้หน่อยค่ะมันขึ้น ExecuteNonQuery : Connection property has not been initialized. |
|
 |
|
|
 |
 |
|
ลองเพิ่ม
Code (VB.NET)
If con.State = ConnectionState.Open Then con.Close()
con.Open()
ตอนนี้มัน error
Object reference not set to an instance of an object. ตรง If con.State = ConnectionState.Open Then con.Close()
con.Open() แทน
ใครรู้ช่วยบอกที่ค่ะ จนปัญหาแล้วจริงๆ
|
 |
 |
 |
 |
Date :
2012-08-19 13:34:11 |
By :
mmm |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Connection ของคุณอยู่ที่ไหนครับ
|
 |
 |
 |
 |
Date :
2012-08-19 13:44:38 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (VB.NET)
Dim sqladd As String
comm = New OleDbCommand
If con.State = ConnectionState.Open Then con.Close()
con.Open()
sqladd = "insert into product(id_pro,id_type,)"
sqladd &= " values ('" & TextBox1.Text & "',"
sqladd &= "'" & ComboBox1.Text & "')"
comm = New OleDbCommand
With comm
.CommandType = CommandType.Text
.CommandText = sqladd
.Connection = con
.ExecuteNonQuery()
End With
MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว", "ยืนยันการบันทึก")
หรือต้อง ประกาศ new connection หรือป่าวค่ะ
|
 |
 |
 |
 |
Date :
2012-08-19 14:04:56 |
By :
mmm |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (VB.NET)
Dim objConn As System.Data.OleDb.OleDbConnection
Dim objCmd As System.Data.OleDb.OleDbCommand
Dim strConnString,strSQL As String
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("database/mydatabase.mdb")&";Jet OLEDB:Database Password=;"
objConn = New OleDbConnection(strConnString)
objConn.Open()
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
"VALUES ('C005','Weerachai Nukitram','[email protected]','TH','2000000','1000000')"
objCmd = New OleDbCommand(strSQL,objConn)
Try
objCmd.ExecuteNonQuery()
Catch ex As Exception
lblText.Text = lblText.Text & "<br> - Record not insert was (" & ex.Message & ")"
End Try
objCmd = Nothing
objConn.Close()
objConn = Nothing
ประมาณนี้ครับ
|
 |
 |
 |
 |
Date :
2012-08-19 14:47:35 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|