MySql Data Read Problem?

[Dakkar]

I write a program for connecting to mysql database and read the values
that i want from the database so i wrote my code like this
RegistryKey uo =
Registry.LocalMachine.OpenSubKey("SOFTWARE\\Origin Worlds
Online\\Ultima Online\\1.0");
String folder =
uo.GetValue("ExePath").ToString();

String uopath = Path.GetDirectoryName(folder);
StreamWriter writer = new StreamWriter(uopath +
@"\login.cfg");
try
{
OdbcConnection mysqlcon;
OdbcCommand mysqlcom = new OdbcCommand();
mysqlcon = new OdbcConnection("DRIVER={MySQL
ODBC 3.51 Driver};" + "SERVER=localhost;" +
"DATABASE=connector;" + "UID=root;" +
"PWD=root;");
StringBuilder uobuild = new StringBuilder();
uobuild.Append("select ip,port from baglanti
where id=1");
mysqlcom.CommandText = uobuild.ToString();
OdbcDataReader resultuo =
mysqlcom.ExecuteReader(CommandBehavior.CloseConnec tion);
String ip =
resultuo.GetValue(0).ToString();

writer.WriteLine("LoginServer="+ip+",5631");
writer.Close();
}

catch
{
this.txt1.Text += "Dosya Bulunamadi";
}
but its not working what is the problem?

Note:My program should take both ip and port part from mysql and write
it to file that i want

Thanks
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Nicholas Paldino [.NET/C# MVP]]

Dakkar,

You really should be playing Worlds of Warcraft instead, much better
MMORPG IMO. =)

How is it not working? Is ip a string or is it an integer? It could be
that it is an integer made up of the four values that make up the IP ranges.
If this is the case, you will have to pull it apart, using an overload of
the IPAddress class.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Dakkar" <da****@sylveria.gen-dot-tr.no-spam.invalid> wrote in message
news:41********@127.0.0.1...

I write a program for connecting to mysql database and read the values
that i want from the database so i wrote my code like this
RegistryKey uo =
Registry.LocalMachine.OpenSubKey("SOFTWARE\\Origin Worlds
Online\\Ultima Online\\1.0");
String folder =
uo.GetValue("ExePath").ToString();

String uopath = Path.GetDirectoryName(folder);
StreamWriter writer = new StreamWriter(uopath +
@"\login.cfg");
try
{
OdbcConnection mysqlcon;
OdbcCommand mysqlcom = new OdbcCommand();
mysqlcon = new OdbcConnection("DRIVER={MySQL
ODBC 3.51 Driver};" + "SERVER=localhost;" +
"DATABASE=connector;" + "UID=root;" +
"PWD=root;");
StringBuilder uobuild = new StringBuilder();
uobuild.Append("select ip,port from baglanti
where id=1");
mysqlcom.CommandText = uobuild.ToString();
OdbcDataReader resultuo =
mysqlcom.ExecuteReader(CommandBehavior.CloseConnec tion);
String ip =
resultuo.GetValue(0).ToString();

writer.WriteLine("LoginServer="+ip+",5631");
writer.Close();
}

catch
{
this.txt1.Text += "Dosya Bulunamadi";
}
but its not working what is the problem?

Note:My program should take both ip and port part from mysql and write
it to file that i want

Thanks
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Dakkar]

No that ip means
a mysql table data i'm keeping the ip inside of the mysql table as a
varchar(string) like 127.0.0.1 so i just want to pull that data from
mysql to c#
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Dakkar]

any idea?
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Dakkar]

any idea?
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com