System.NullReferenceException: Object reference no
Hi
I am getting error while i am inserting data in the database. my code is:
If pnss.Visible = True Then
Response.Write("I am panel for splitspoon")
smssinsert = "INSERT INTO tempsplitspoon ("
smssinsert &= "[RecordID], [HammerType], [HammerTypeTop], [HammerTypeBottom], [HammerSize], "
smssinsert &= "[HammerSizeTop], [HammerSizeBottom], [PenetrationTop], [PenetrationBottom], "
smssinsert &= "[RecoveryLength], [SamplerLength], [InnerDiameter], [OuterDiameter], "
smssinsert &= "[LinerInfo], [Catcher], [SequentialSampleNo]) VALUES ("
smssinsert &= record.Text & ",'"
smssinsert &= txtssht.Text & "',"
smssinsert &= txtsshtt.Text & ","
smssinsert &= txtsshtb.Text & ","
smssinsert &= txtsshs.Text & ","
smssinsert &= txtsshst.Text & ","
smssinsert &= txtsshsb.Text & ","
smssinsert &= txtsspt.Text & ","
smssinsert &= txtsspb.Text & ","
smssinsert &= txtssrl.Text & ","
smssinsert &= txtsssl.Text & ","
smssinsert &= txtssid.Text & ","
smssinsert &= txtssod.Text & ",'"
smssinsert &= txtssli.Text & "','"
smssinsert &= txtssc.Text & "',"
smssinsert &= txtssssn.Text & ")"
Response.Write("**" & smssinsert & "**")
Response.Flush()
Dim addsmss As New OleDbCommand(smssinsert, myconnection)
i = addsmss.ExecuteNonQuery()
ElseIf pnsbt.Visible = True Then
Response.Write("I am panel for shelbytube")
smsbtinsert = "INSERT INTO tempshelbytube ("
smsbtinsert &= "[RecordID], [InnerDiameter], [OuterDiameter], [Length], [PenetrationTop], "
smsbtinsert &= "[PenetrationBottom], [RecoveryLength], [LinerInfo], [SequentialSampleNo]) VALUES ("
smsbtinsert &= record.Text & ","
smsbtinsert &= txtsbtid.Text & ","
smsbtinsert &= txtsbtod.Text & ","
smsbtinsert &= txtsbtl.Text & ","
smsbtinsert &= txtsbtpt.Text & ","
smsbtinsert &= txtsbtpb.Text & ","
smsbtinsert &= txtsbtrl.Text & ",'"
smsbtinsert &= txtsbtli.Text & "',"
smsbtinsert &= txtsbtssn.Text & ")"
Dim addsmsbt As New OleDbCommand(smsbtinsert, myconnection)
i = addsmsbt.ExecuteNonQuery()
I dont understand where the error is.But rest of the similar code is working fine. So, please help.
Thanks
Regards
Nidy
|