C / C++ / MFC

George_George wrote:

Thanks for your support for all the help you given to me on the question all the way.

int i;
MYSQL *myDB = NULL;
MYSQL_RES *res = NULL;
MYSQL_ROW row;
CString user,pass,aqp;

if((myDB = mysql_init((MYSQL*) 0)) &&
mysql_real_connect(myDB,"localhost","root",NULL,NULL,3306,NULL,NULL))
{
    if(mysql_select_db( myDB,"gourav"))
    {
        GetDlgItemText(IDC_USER,user);
        GetDlgItemText(IDC_PASS,pass);

        if(mysql_query(myDB,"select * from login"))
        {
            res=mysql_store_result(myDB);
            row = mysql_fetch_row(res);
            MessageBox(row[0]);
        }
    }
    else
        MessageBox("Can't connect !\nPlease try later.") ;

    mysql_close(myDB);
}

if(mysql_query(myDB,"select * from login"))
{
    res=mysql_store_result(myDB);
    row = mysql_fetch_row(res);
    MessageBox(row[0]);
}

int i = mysql_query(myDB,"select * from login");

try
{
//Ur record retrieval code goes here

//On error u write a logic to throw an exception object

}
catch(CException e)
{
 MessageBox(e.what()); // will contain the error message
}