thiago costa

thiago costa

  • NA
  • 319
  • 0

SQL Database Connection Class Help Please.

Jan 4 2011 8:56 PM
hello there guys ...

Sorry to bother..
About 2 years ago, I was running a game server (Dekaron Ultra) ...

I was using MSSQL 2000 SP4 for the database...
I had a very nice program that Me and my Indian Best Friend developed together... He made a Database Connection Class for me LONG time ago (2009) But my HDD blew up...
My 2 TB Raid 0 setup blew up so I lost about 1.7 TB of data just recently...

I lost the source code too... :'(

Well...
What I am trying to do is:


1) I was wondering if some one could help me with a class, which would be compatible with the code below...
What happened was, I lost the source code, and the only thing was left was this text file... LOL...



 private void buttonLogin_Click(object sender, EventArgs e)

{

string password = textBoxPassword.Text;

if (SQLDataAccess.ValidateConnection("Account", password) == true)

{

SQLDataAccess.Password = password;

MessageBox.Show("Login Successful");

textBoxPassword.Text =

"";

textBoxPassword.UseSystemPasswordChar =

false;

{



FileStream fs = new FileStream

(

"log32.txt", FileMode.Append, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs); sw.WriteLine(DateTime.Now); sw.Close();

}


buttonLogin.Visible =

false;

label1.Text =

"Input Box";

}


else

{



MessageBox.Show("Login failed");

}


}




I am currently downloading SQL 2005, and I am going to load my old database to it, then I can try to connect...
But If some one could help me create a class (the above code was running off of SQLDataAccess ...

Thank you so much guys... I'm trying to get this on our Open Source c# Generator software...

Best regards..

Again, Thanks 1000x guys.

----------EDIT--------
My friend I mentioned above, is a hardcore c# programmer like you guys... I will see if he wants to join us here when he is back from India..
Again, Thanks guys.
----------EDIT--------
I really cant believe I lost this source code :'( ... Vinnoth is only comming back in a week, and my only solution was to bother you guys.
----------EDIT--------
I am really stuck in this problem :'(...


Answers (2)