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.LocalM achine.OpenSubK ey("SOFTWARE\\O rigin Worlds
Online\\Ultima Online\\1.0");
String folder =
uo.GetValue("Ex ePath").ToStrin g();

String uopath = Path.GetDirecto ryName(folder);
StreamWriter writer = new StreamWriter(uo path +
@"\login.cfg ");
try
{
OdbcConnection mysqlcon;
OdbcCommand mysqlcom = new OdbcCommand();
mysqlcon = new OdbcConnection( "DRIVER={My SQL
ODBC 3.51 Driver};" + "SERVER=localho st;" +
"DATABASE=conne ctor;" + "UID=root;" +
"PWD=root;" );
StringBuilder uobuild = new StringBuilder() ;
uobuild.Append( "select ip,port from baglanti
where id=1");
mysqlcom.Comman dText = uobuild.ToStrin g();
OdbcDataReader resultuo =
mysqlcom.Execut eReader(Command Behavior.CloseC onnection);
String ip =
resultuo.GetVal ue(0).ToString( );

writer.WriteLin e("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.co m

"Dakkar" <da****@sylveri a.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.LocalM achine.OpenSubK ey("SOFTWARE\\O rigin Worlds
Online\\Ultima Online\\1.0");
String folder =
uo.GetValue("Ex ePath").ToStrin g();

String uopath = Path.GetDirecto ryName(folder);
StreamWriter writer = new StreamWriter(uo path +
@"\login.cfg ");
try
{
OdbcConnection mysqlcon;
OdbcCommand mysqlcom = new OdbcCommand();
mysqlcon = new OdbcConnection( "DRIVER={My SQL
ODBC 3.51 Driver};" + "SERVER=localho st;" +
"DATABASE=conne ctor;" + "UID=root;" +
"PWD=root;" );
StringBuilder uobuild = new StringBuilder() ;
uobuild.Append( "select ip,port from baglanti
where id=1");
mysqlcom.Comman dText = uobuild.ToStrin g();
OdbcDataReader resultuo =
mysqlcom.Execut eReader(Command Behavior.CloseC onnection);
String ip =
resultuo.GetVal ue(0).ToString( );

writer.WriteLin e("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