Click here to Skip to main content
15,891,248 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: CString to char* conversion Pin
William.Wang31-May-06 23:22
William.Wang31-May-06 23:22 
QuestionHow to use c++ header file in .c file Pin
saravana pandy31-May-06 20:33
saravana pandy31-May-06 20:33 
AnswerRe: How to use c++ header file in .c file Pin
NiceNaidu31-May-06 20:37
NiceNaidu31-May-06 20:37 
GeneralRe: How to use c++ header file in .c file Pin
toxcct31-May-06 22:45
toxcct31-May-06 22:45 
AnswerRe: How to use c++ header file in .c file Pin
Sarath C31-May-06 20:41
Sarath C31-May-06 20:41 
GeneralRe: How to use c++ header file in .c file Pin
saravana pandy31-May-06 21:50
saravana pandy31-May-06 21:50 
NewsBeware the C++ implicit conversion Pin
Sarath C31-May-06 20:10
Sarath C31-May-06 20:10 
QuestionDisable menu [modified] Pin
Anu_Bala31-May-06 20:06
Anu_Bala31-May-06 20:06 
AnswerRe: Disable menu Pin
Hamid_RT31-May-06 20:14
Hamid_RT31-May-06 20:14 
GeneralRe: Disable menu Pin
Anu_Bala31-May-06 20:17
Anu_Bala31-May-06 20:17 
GeneralRe: Disable menu Pin
Sarath C31-May-06 20:18
Sarath C31-May-06 20:18 
GeneralRe: Disable menu Pin
Sarath C31-May-06 20:22
Sarath C31-May-06 20:22 
GeneralRe: Disable menu Pin
Hamid_RT31-May-06 20:24
Hamid_RT31-May-06 20:24 
AnswerRe: Disable menu [modified] Pin
Sarath C31-May-06 20:17
Sarath C31-May-06 20:17 
GeneralRe: Disable menu [modified] Pin
Steve Echols31-May-06 20:25
Steve Echols31-May-06 20:25 
AnswerRe: Disable menu Pin
Steve Echols31-May-06 20:17
Steve Echols31-May-06 20:17 
AnswerRe: Disable menu Pin
NiceNaidu31-May-06 20:19
NiceNaidu31-May-06 20:19 
QuestionVC++ 8 Doc tool Pin
Fernando A. Gomez F.31-May-06 19:39
Fernando A. Gomez F.31-May-06 19:39 
AnswerRe: VC++ 8 Doc tool [modified] Pin
Stephen Hewitt31-May-06 19:42
Stephen Hewitt31-May-06 19:42 
GeneralRe: VC++ 8 Doc tool [modified] Pin
Fernando A. Gomez F.1-Jun-06 4:10
Fernando A. Gomez F.1-Jun-06 4:10 
GeneralRe: VC++ 8 Doc tool [modified] Pin
Stephen Hewitt1-Jun-06 13:45
Stephen Hewitt1-Jun-06 13:45 
GeneralRe: VC++ 8 Doc tool [modified] Pin
Fernando A. Gomez F.1-Jun-06 13:52
Fernando A. Gomez F.1-Jun-06 13:52 
QuestionContext menu extensions Pin
Anil_vvs31-May-06 19:22
Anil_vvs31-May-06 19:22 
AnswerRe: Context menu extensions Pin
Anil_vvs31-May-06 19:26
Anil_vvs31-May-06 19:26 
Questionvc++ Pin
Y_Kaushik31-May-06 18:58
Y_Kaushik31-May-06 18:58 
Hai to all of you
i am doing my project in VC++ as Front End and MySQL as an Back End,
i am feeling some problem whenever i insert data using Form (VC++ dialog based form) i am sending some line of code written below .Please help me
where i am wrong........

void CEmpDetail::OnSubmit()
{
int i, j;
MYSQL * Conn;
MYSQL_RES * res;
MYSQL_ROW row;
CString sDAt,sEmpid,sEmpf,sEmpl,sDes,iPh,iEx,dDt,sMm,iYy,sQf,sTs,iTx,iHcx,sVis,sLoc,iOdc,sPrj,sGp,iPk,sMid,iFs,iOs;
CString sStr;
if ( (Conn = mysql_init((MYSQL*) 0)) &&
mysql_real_connect( Conn, "localhost", "", NULL, NULL, MYSQL_PORT, NULL, CLIENT_MULTI_STATEMENTS ) )
{
if ( mysql_select_db( Conn, "project") < 0 )
{
SetDlgItemText(IDC_STATIC_LOGIN_MSG, "Can't select the database !\nTry later.") ;
goto exit_here;
}
}
else
{
SetDlgItemText(IDC_STATIC_LOGIN_MSG, "Can't connect to the mysql server !\nPlease try later.") ;
goto exit_here;
}

GetDlgItemText(IDC_EMPID,sEmpid) ; ///////// Getting emp id from user
GetDlgItemText(IDC_EMPNMF,sEmpf) ;/////////emp first name
GetDlgItemText(IDC_EMPNML,sEmpl) ;///////////emp last name
GetDlgItemText(IDC_DESIGNATION,sDes) ;/////////////emp designation
GetDlgItemText(IDC_PHONENO,iPh) ;///////////phone
GetDlgItemText(IDC_EXTEN,iEx) ;//////////ext
GetDlgItemText(IDC_COMBO_DD,dDt) ;////////date
GetDlgItemText(IDC_COMBO_MM,sMm) ;////////Month
GetDlgItemText(IDC_COMBO_YY,iYy) ;////////Year
GetDlgItemText(IDC_EDIT_QFLN,sQf) ;/////qualification
GetDlgItemText(IDC_EDIT_TKSKL,sTs) ;/////////////////technical skill
GetDlgItemText(IDC_EDIT_TOTAL,iTx) ;///////////total exp
GetDlgItemText(IDC_EDIT_HCL,iHcx) ;///////hcl exp
GetDlgItemText(IDC_EDIT_VISA,sVis) ;//////////visa
GetDlgItemText(IDC_LOC,sLoc) ;////////////////loc
GetDlgItemText(IDC_ODC,iOdc) ;//////////odc
GetDlgItemText(IDC_PROJID,sPrj) ;/////////proj
GetDlgItemText(IDC_GROUP,sGp) ;///////////////group
GetDlgItemText(IDC_PACKAGE,iPk) ;//////////////package
GetDlgItemText(IDC_EMPMAIL,sMid) ;///////mail id
GetDlgItemText(IDC_OFFSH,iFs) ;/////////////////offshore
GetDlgItemText(IDC_ONSH,iOs) ;/////////onsite"vas"

if (!mysql_query( Conn,"INSERT INTO emp VALUES (\'" + sEmpid + "\',\'" + sEmpf + "\',\'" + sEmpl + "\',\'" + sDes + "\',\'" + iPh + "\',\'" + iEx + "\',\'" + dDt + "\',\'" + sMm + "\',\" + iYy + "\',\'" + sQf + "\',\'" + sTs + "\',\'" + iTx + "\',\'" + iHcx + "\',\'" + sVis + "\',\'" + sLoc + "\',\'" + iOdc + "\',\'" + sPrj + "\',\'" + sGp + "\,\'" + iPk + "\',\'" + sMid + "\',0,1)")))
{
res = mysql_store_result(Conn);
if(res)
{
MessageBox("Your Data Submit Successfully","Yse...",MB_ICONASTERISK);

}

else
{
MessageBox("Data Not Submitted","Error...",MB_ICONQUESTION);
goto exit_here;
}
}
else
{
MessageBox(" Query Not Execute ","Error...",MB_ICONQUESTION);
goto exit_here;
}



exit_here:
mysql_close( Conn );
UpdateData(FALSE);

}

i think i am lack of using any API Please help me where i am wrong.
Thanking you
Yogendra kumar kaushik

mailing me
Yogi

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.