[Help] Errors

07/21/2009 16:34 nestreys#1
Can someone help me fix this errors please.


System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.System.Data.ID bCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at COServer_Project.DataBase.Authenticate(String UserName, String Password) in C:\Documents and Settings\YernaJ\Desktop\RoflCOpter Source\COServerProject\DataBase.cs:line 1609


System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\YernaJ\Desktop\RoflCOpter Source\COServerProject\DataBase.cs:line 1454
07/21/2009 17:09 f0am#2
Post here what is on line 1454 in Database.cs

( Ctrl + G ) to type in line
07/21/2009 17:44 nestreys#3
/* public static void SaveExpball(Character Charr)
{
try
{
MySqlCommand Command = null;
Command = new MySqlCommand("UPDATE `Characters` SET `expballend` = '" + Charr.expballend.ToString() + "',`expball` = '" + Charr.expball + "' WHERE `Account` = '" + Charr.MyClient.Account + "'", Connection);
Command.ExecuteNonQuery();

}
catch (Exception Exc) { General.WriteLine(Convert.ToString(Exc)); }
}*/

thats the whole thing in line 1454....
07/21/2009 17:54 f0am#4
well its in /* and */ shoudn't even show up
07/21/2009 18:05 nestreys#5
ah i see. but what about the first one? Why does my heaven bless cant be save?
07/21/2009 18:12 f0am#6
Do you have teamviewer if you pm me id and pass and turn tv on i will go on and check it out, actually PM me and ill give u my msn. i have togo now
07/21/2009 19:04 nestreys#7
Can someone help me with this problem. Thanks.