c# with mysql

[shawn87chau]

---

im having problem involving getting data from my mysql database server using c#..my database looks something like this
------ Col1------Col2 ---- Col3---- Col4-----Col5
Row1--- 7------- 1------- 4------- 0------- 3

i need to get the whole row..then sort the data from least to greatest then put the sorted data back to in database..can anyone please helptnx..

[silent-kill]

wot?, select * from <table> where <condition> order by <columname>

[moz_k2]

So which is the problem?
Query, connection, data objects?

[shawn87chau]

my problem is how to connect and get the datas.. i have my sorting program already,the problem is i dont know how to ge the data in the database..im fairly new using c#..

[silent-kill]

ive used ODBC with mysql before its under system.data.ODBC
pwede pud basin system.data.sqlClient you need a connection string for mysql
thats all

[eax]

Try ni MySQL :: Download Connector/Net 5.2

[shawn87chau]

actually i already have the mysql connector, wat i mean about connecting is the code, i dont know what to type in my code to connect to the db..

[Tin_Tin]

actually i already have the mysql connector, wat i mean about connecting is the code, i dont know what to type in my code to connect to the db..

haya2x insik graduate man march. . .

[crystaldots]

You better read tutorials or ebooks on MySql db handling using C#...

[TheGame!]

 public class DBManager
    {
      private string conString = 
      System.Configuration.ConfigurationManager.AppSettings["ConnectString"].ToString();
      private MySqlConnection DbConnection;

      public DBManager() 
        { 
      
        }
      
      public MySqlConnection GetConnection()
        {
            Console.WriteLine("getConnection");

            if (DbConnection == null)
            {
              try
              {
                DbConnection = new MySqlConnection(conString);
              }
              catch (MySqlException me)
              {
                throw new DBManagerException(me.Message);
              }
              catch (InvalidOperationException ie)
              {
                throw new DBManagerException(ie.Message);
              }
              finally 
              {
                
              }
            }
            return DbConnection;
        }
    }