MySQL - VB.NET

[Thorsten Reichelt]

hi, 
i want to use " Select " to get informations out of a Database ...

i tryed to write to SelectCommand in the OdbcDataReader

SELECT kdnr, auftrag
FROM standart
WHERE (KdNr = ' " & cbokundenr.text & " ')

- i use 1 OdbcDataReader, 1 DataSet and 1 OdbcConnection

i want to read data`s(kdnr) out of a combobox to search with this
number(kdnr) for data`s out of another database. 
but with this above nothing happens ... 

i hope someone can help me. 
complete new ways are also welcome.

greetings thorsten

-- 
+++ NEU bei GMX und erstmalig in Deutschland: TÜV-geprüfter Virenschutz +++
100% Virenerkennung nach Wildlist. Infos: http://www.gmx.net/virenschutz


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

vb.net - mysql

[Thorsten Reichelt]

Hello,

i write a front-end in vb.net and want to save data`s out of a text field
into a MySQL database.
But i have trouble
with
this.
-
a short example out of my source code to save data`s directley into MySQL.

Private Sub btnSpeichern_Click 
 Dim MyConString As String .

Dim MyConnection As New OdbcConnection(MyConString)
MyConnection.Open()

Dim MyCommand As New OdbcCommand
MyCommand.Connection = MyConnection

MyCommand.CommandText = "insert into test(firma) values ('test')"
  

MyConnection.Close()
-
How can i write into MySQL the data`s i type into a text field?

Regrads
Thorsten 

-- 
+++ NEU bei GMX und erstmalig in Deutschland: TÜV-geprüfter Virenschutz +++
100% Virenerkennung nach Wildlist. Infos: http://www.gmx.net/virenschutz


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]