I'm trying to fetch some data from table and get error:"Invalid object name 'h'".My code is
Dim h As Decimal
'some code
cmd2 = New SqlCommand("insert into h select KvotaX from dbo.Utakmice where ID=@s1 ", conn)
cmd2.Parameters.AddWithValue("@s1", myReader.GetInt32(1))
'some code
f = cmd2.ExecuteNonQuery()
I don't know what I'm doing wrong. KvotaX from dbo.Utakmice data type is real.
You try to set the value of h using a sql statement. This is not correct.
Dim h As Decimal
cmd2 = New SqlCommand("select KvotaX from dbo.Utakmice where ID=@s1 ", conn)
cmd2.Parameters.AddWithValue("@s1", myReader.GetInt32(1))
h = Convert.ToDecimal(cmd2.ExecuteScalar)
You select the record corresponding to the parameter passed in and then read the return value of the ExecuteScalar method. Note that this works only if the query returns one record and only one column. Better to be safe checking the return value before assigning to the decimal
Dim o = cmd2.ExecuteScalar
if o IsNot Nothing Then
h = Convert.ToDecimal(o)
.....
End If
However, your code hints to the fact that you are trying to get the value for the s1 parameters reading from an open MySqlDataReader. This could not be possible because, usually, the connection used by the datareader is busy till the datareader remains open.
I don't think you want the insert into h if you are just trying to fetch data.
Remove that phrase and see if you get what you are expecting.
