{Need Help}mysql in c#

[Mrbrightside]

ok so this is what i have so far
class Program
{
static void Main(string[] args)
{
string MyConString = "SERVER=localhost;" + "DATABASE=user information;" + "UID=root;" + "PASSWORD=9blackheart;";

MySqlConnection connection = new MySqlConnection(MyConString);

MySqlCommand command = connection.CreateCommand(); MySqlDataReader Reader;

command.CommandText = "select * from users";

connection.Open(); Reader = command.ExecuteReader();

while (Reader.Read()) {

string thisrow = "";

for (int i = 0; i < Reader.FieldCount; i++)
thisrow += Reader.GetValue(i).ToString() + ","; System.Console.WriteLine(thisrow);}

connection.Close();



and it works perfectly but i want it to read for a username and password for verification is there anyway i can do this?

[Apoc]

http://subversion.assembla.com/svn/e.../MySqlQuery.cs

Check that out. Should answer all of your questions.

[Mrbrightside]

http://subversion.assembla.com/svn/e.../MySqlQuery.cs

Check that out. Should answer all of your questions.

No not really thanks for trying though, maybe i did not explain clearly enough so far i can read from mysql database and read tables but im trying to find out lets say (textbox1.text equals the username admin in the mysql database)
im trying to make an authentication sequence to login from my program, and read from mysql.

[Apoc]

You obviously missed the point...

If you can't figure out how to do simple comparisons, you should probably go back to the basics before trying to write some auth system.