Reader problem...

[Craig Lister]

Newbie alert!

I am trying to get data from my mySQL database...

With some help, I have got this far, but there is an exception in data.dll
(??) on the :

"OleDbDataReader Reader = Command.ExecuteReader();"

line.

Can you see a problem here ?
string ConnectionString = "Location=myconn;Provider='MySqlProv.3.0';User
ID=*******;Integrated Security=;Data Source=******;Extended
Properties=;Password=********";

OleDbConnection Connection = new OleDbConnection(ConnectionString);

OleDbCommand Command = new OleDbCommand("Select id from users where
surname='Lister' ad firstname='Craig'", Connection);

Connection.Open();

OleDbDataReader Reader = Command.ExecuteReader();

// while(Reader.Read())

{

textBox1.Text = Reader["id"].ToString();

}
--
Websites:
http://www.thelisters.co.uk/
http://www.myschoolmates.com/

MSN Messenger: cr***********@hotmail.com

[Moty Michaely]

Hey Craig,

First check the connection (Is there any exception executing the command?).

textBox1.Text = Reader["id"].ToString(); Second, use this instead:
textBox1.Text = Reader.GetInt32(Reader.GetOrdinal("ID"));

Third, which exception are you getting?

Fourth, I think mySQL requires ODBC. worth to check...

-Moty-
"Craig Lister" <in********@removethelisters.co.uk> wrote in message
news:42***********************@news.zen.co.uk... Newbie alert!

I am trying to get data from my mySQL database...

With some help, I have got this far, but there is an exception in data.dll
(??) on the :

"OleDbDataReader Reader = Command.ExecuteReader();"

line.

Can you see a problem here ?
string ConnectionString = "Location=myconn;Provider='MySqlProv.3.0';User
ID=*******;Integrated Security=;Data Source=******;Extended
Properties=;Password=********";

OleDbConnection Connection = new OleDbConnection(ConnectionString);

OleDbCommand Command = new OleDbCommand("Select id from users where
surname='Lister' ad firstname='Craig'", Connection);

Connection.Open();

OleDbDataReader Reader = Command.ExecuteReader();

// while(Reader.Read())

{

textBox1.Text = Reader["id"].ToString();

}
--
Websites:
http://www.thelisters.co.uk/
http://www.myschoolmates.com/

MSN Messenger: cr***********@hotmail.com

[fuzzymelon]

Hi Craig,

If you are developing on a Windows box:
Try these steps: create an ODBC link (system/user DSN) to your databas
in your computer's "Data sources" interfac
(Start...Programs...Administrat....etc).
Then test the connection and copy the connection string out of th
created
DSN and into your connection string in your code.

Give me a shout if that doesnt help. Just remember that on MySQL you
user has to have access to the localhost or your machine name needs t
be listed under your username in the MySQL database.

Enjoy old chap!
Fuzzymelo

--
fuzzymelo
-----------------------------------------------------------------------
fuzzymelon's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187055242

[Craig Lister]

Hiya Fuzzy!

Thanks for that...

I hold up my hands, as the code was infact right... I had a basic error in
the SQL! Apologies!

Here is the final code, which does infact return an ID, as expected.
string ConnectionString = "blah";

OleDbConnection Connection = new OleDbConnection(ConnectionString);

OleDbCommand Command = new OleDbCommand("Select id from users where
username='craig'", Connection);

Connection.Open();

OleDbDataReader Reader = Command.ExecuteReader();

Reader.Read();

// while(Reader.Read())

{

textBox1.Text = Reader["id"].ToString();

}

Now to build on to this very very basic start! Thanks for you help though!
Nice to have a few guys around who are willing to take the time and help
others!

Thanks!

"fuzzymelon" <fu***************@no-mx.msusenet.com> wrote in message
news:fu***************@no-mx.msusenet.com...

Hi Craig,

If you are developing on a Windows box:
Try these steps: create an ODBC link (system/user DSN) to your database
in your computer's "Data sources" interface
(Start...Programs...Administrat....etc).
Then test the connection and copy the connection string out of the
created
DSN and into your connection string in your code.

Give me a shout if that doesnt help. Just remember that on MySQL your
user has to have access to the localhost or your machine name needs to
be listed under your username in the MySQL database.

Enjoy old chap!
Fuzzymelon
--
fuzzymelon
------------------------------------------------------------------------
fuzzymelon's Profile: http://www.msusenet.com/member.php?userid=2457
View this thread: http://www.msusenet.com/t-1870552429