Exception - Insert Record Into DB

 Hello I’m using express edition to create my trail test
application. Below is the code that I have and I’m trying to insert data to the
database table named “Coin�.







Protected Sub
btnSave_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnview.Click




       
Dim s As
String = txtCname.Text


       
'Dim myConnection As New
SqlConnection(myConnString)


       
Dim desc As
String = txtCDesc.Text


       
Dim ConStr As
New SqlClient.SqlConnection


       
ConStr.ConnectionString = "server=testsqlinstance;
Integrated Security=True"


       
Response.Write("Connection string:
  " & ConStr.ConnectionString)






       
Try


           
Dim SelectQuery As
String = "SELECT
max(coinid) from coin"


           
Dim idval As
Integer = 0


           
Dim command As
New SqlCommand(SelectQuery, ConStr)


           
ConStr.Open()


           
idval = command.ExecuteScalar()


           
Console.WriteLine(idval)


           
idval = idval + 1


           
Dim InsertQuery As
String = "INSERT
INTO COIN(coinname, coinid, ebayid, ebaymember, ebaymemid , amount , coindesc)
VALUES('1992-Proof'," & idval & ",'eewerwer','sp6937','serwryana',67.70,'Matt
Proff of 1992- Mint Set')"


           
Dim command1 As
New SqlCommand(InsertQuery, ConStr)


           
command1.ExecuteScalar()


           
Dim S1 As
String = "Record
insert - Successful!"


           
Console.WriteLine(S1)

 


       
Catch ex As
Exception


 
          Label2.Text = ex.ToString


       
Finally


           
ConStr.Close()


       
End Try

End Sub






 This program is
throwing an exception (mentioned below)
 

Exception --->  System.Data.SqlClient.SqlException:
Invalid object name 'coin'. at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) at
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at
System.Data.SqlClient.SqlDataReader.get_MetaData() at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at
System.Data.SqlClient.SqlCommand.ExecuteScalar() at _Default.btnview_Click(Object
sender, EventArgs e) in C:Documents and SettingsarshaMy DocumentsVisual
Studio 2005WebSitesWebSite1Default.aspx.vb:line 92



“Coin� is the table name – which is in SQL server. Kindly
help me to handle and overcome this exception.



Thanks