How to insert data (probably simple question)

interesting. Have you tried to insert data using the SQL classes and seeing if that works? Try this:

Friend Sub Datainsert(ByVal Name As String, ByVal Surname As String, ByVal DateOfGame As Date)
Dim ConnectMe As New SqlClient.SqlConnection

ConnectMe.ConnectionString = "Server=localhost;Database=ProjektKoncowy;Trusted_Connection=yes;"
Dim Writeit As New SqlClient.SqlCommand("INSERT INTO ProjektKoncowy.dbo.Wyniki (Name, Surname, Points, Status, DateOfGame, KindOfGame, Autor) VALUES (Name, Surname , ' 3 ', ' 1 ', DateOfGame ,' 4 ','John Smith')", ConnectMe)
Writeit.Connection.Open()
Writeit.ExecuteNonQuery()
Writeit.Connection.Close()
End Sub

do you still get the same error? If so, for both and for SqlClient/command, can you post the stacktrace/innerexception of the error?

ahmedilyas at 2007-8-31 >

ok cool. I will see what I can find...since I've never connected to SQL Server using ODBC....ill be sure to post something if I find it.

The command however looks fine to me.

ahmedilyas at 2007-8-31 >

Friend Sub Zapiswygranej(ByVal Imie As String, ByVal Nazwisko As String, ByVal DataGry As Date)
Dim Polacz As New Odbc.OdbcConnection
Dim aConnectionString As String = "Driver={SQL Native Client};Server=localhost;Database=ProjektKoncowy;Trusted_Connection=yes;"
Dim Wpisz As New Odbc.OdbcCommand("INSERT INTO ProjektKoncowy.dbo.Wyniki (Imie, Nazwisko, Punkty, Status, DataGry, RodzajGry, Autor) VALUES (Imie, Nazwisko , ' 3 ', ' 1 ', DataGry ,' 4 ','Moje dane')", Polacz)
Wpisz.Connection = Polacz
Polacz.ConnectionString = aConnectionString
Wpisz.Connection.Open()
Wpisz.ExecuteNonQuery()
Polacz.Close()
End Sub

Sorry for using polish words as the names of variables, I hope it's meaningless.
The result is the same as in my first post.

I "Call Stack" window I found this (last two lines):

system.data.dll!System.Data.Odbc.OdbcCommand.ExecuteNonQuery() + 0xad bytes

Kolkoikrzyzyk.exe!Kolkoikrzyzyk.zapisdobazy.Zapiswygranej(String Imie = "Gracz", String Nazwisko = "Bez Nazwiska", Date DataGry = #10/5/2006#) Line 9 + 0xa bytes Basic

I do not know but something is missing I think, where are the rest of my variables which I want to insert, for example 3,1,Moje dane. Could there be the source of the problem?

Output-Debug window:
'DefaultDomain': Loaded 'c:\windows\microsoft.net\framework\v1.1.4322\mscorlib.dll', No symbols loaded.
'Kolkoikrzyzyk': Loaded 'F:\Moje projekty VB\Kó?ko i krzy?yk\Kolkoikrzyzyk\bin\Kolkoikrzyzyk.exe', Symbols loaded.
'Kolkoikrzyzyk.exe': Loaded 'c:\windows\assembly\gac\system.windows.forms\1.0.5000.0__b77a5c561934e089\system.windows.forms.dll', No symbols loaded.
'Kolkoikrzyzyk.exe': Loaded 'c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll', No symbols loaded.
'Kolkoikrzyzyk.exe': Loaded 'c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\system.drawing.dll', No symbols loaded.
'Kolkoikrzyzyk.exe': Loaded 'c:\windows\assembly\gac\microsoft.visualbasic\7.0.5000.0__b03f5f7f11d50a3a\microsoft.visualbasic.dll', No symbols loaded.
'Kolkoikrzyzyk.exe': Loaded 'c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll', No symbols loaded.
An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in system.data.dll
Additional information: System error.

The longer I think the less i know.

elgor at 2007-8-31 >

Hello Elgor

Perhaps you would do best to first get a simple conection to your database using a select statement. then go on to building your update statement

Try something like this:

Private Sub TestOLEDB()

Dim MyConn As OleDb.OleDbConnection

Dim MyCMD As OleDb.OleDbCommand

Dim MyTable As DataTable

Dim MYConnection As String = "Provider=SQLOLEDB;Data Source=YOURSERVERNAME;Initial Catalog=YOURDATABASENAME;Integrated Security=SSPI;"

Try

MyConn = New OleDb.OleDbConnection(MYConnection)

MyConn.Open()

MyCMD = New OleDb.OleDbCommand

With MyCMD

.Connection = MyConn

.CommandText = "Select * From YOURTABLENAME"

End With

MyTable = New DataTable

MyTable.Load(MyCMD.ExecuteReader)

MyConn.Close()

Me.DataGridView1.DataSource = MyTable

Catch ex As Exception

Throw ex

End Try

End Sub

IbrahimY at 2007-8-31 >

Sorry, I haven't read this entire thread, but what I notice right off in the original post is: you're using ODBC but trying to set a connection string...

The ODBC object in Windows should already be configured with all the appropriate connection info. The ODBCConnection object in code only needs to know what connection you want to use. Typically this connection string looks something like:

"DSN=ODBCConnectionName" Where DSN equals the name of the connection you created in the ODBC Data Source Administrator.

You can add Username (UID=) and password (PWD=) to the string if necessary.

Changing the connection string should fix the problem.

rkimble at 2007-8-31 >