Click here to Skip to main content
15,902,757 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: throw or throw new?; Pin
ZoogieZork6-Oct-03 20:22
ZoogieZork6-Oct-03 20:22 
GeneralRe: throw or throw new?; Pin
jhwurmbach6-Oct-03 22:45
jhwurmbach6-Oct-03 22:45 
QuestionHow to programmatically setting power button action? Pin
Member 3993596-Oct-03 19:30
Member 3993596-Oct-03 19:30 
GeneralRe: (MFC) Need a list w/ multiple columns and children Pin
Mike Dimmick6-Oct-03 23:28
Mike Dimmick6-Oct-03 23:28 
GeneralExcel Locale Issue Pin
Derek Waters6-Oct-03 17:39
Derek Waters6-Oct-03 17:39 
GeneralRe: Excel Locale Issue Pin
David Crow7-Oct-03 3:04
David Crow7-Oct-03 3:04 
Generalhelp me Pin
don7cry6-Oct-03 17:36
don7cry6-Oct-03 17:36 
GeneralRe: help me Pin
xxhimanshu7-Oct-03 0:34
xxhimanshu7-Oct-03 0:34 
Smile | :) To Write:::
db.OpenEx("DSN=YOUR DSN;Uid=YOUR USER ID FOR SQL;Pwd=YOUR PASSWORD FOR SQL",CDatabase::noOdbcDialog)
CString query="INSERT INTO Userinfo(Userid,Passw,Name,Address1,Address2,City,Country,Zip,Phone,Email,Pincode,Dateofentry) VALUES ('" + uid + "','" + pwd + "','" + uname + "','" + add1 + "','" + add2 + "','" + ucity + "','" + scountry + "','" + uzip + "','" + uphone + "','" + uemail + "','" + test + "',GetDate())";
db.ExecuteSQL (query);

To Read::
CRecordset rs( &db );
CString check;
check.Format ("SELECT Userid FROM Userinfo WHERE Pincode='" + test +"'");

rs. Open ( CRecordset::dynaset, check, CRecordset::none ) ;
rs.GetFieldValue("your field",CString variable to store);
after this you can convert it to integer or anythine..thats all..hope it helps..
cheers


Himanshu

Generalload picture example Pin
azusakt6-Oct-03 16:03
azusakt6-Oct-03 16:03 
GeneralRe: load picture example Pin
xxhimanshu7-Oct-03 0:21
xxhimanshu7-Oct-03 0:21 
GeneralVT_CY and VT_DECIMAL Pin
Rome Singh6-Oct-03 15:25
Rome Singh6-Oct-03 15:25 
GeneralRe: VT_CY and VT_DECIMAL Pin
Mike Dimmick6-Oct-03 23:44
Mike Dimmick6-Oct-03 23:44 
GeneralRe: VT_CY and VT_DECIMAL Pin
Rome Singh7-Oct-03 0:40
Rome Singh7-Oct-03 0:40 
GeneralRe: VT_CY and VT_DECIMAL Pin
Mike Dimmick7-Oct-03 0:45
Mike Dimmick7-Oct-03 0:45 
GeneralRe: VT_CY and VT_DECIMAL Pin
Rome Singh7-Oct-03 0:49
Rome Singh7-Oct-03 0:49 
GeneralRe: VT_CY and VT_DECIMAL Pin
Rome Singh7-Oct-03 3:09
Rome Singh7-Oct-03 3:09 
GeneralRe: VT_CY and VT_DECIMAL Pin
Rome Singh7-Oct-03 2:49
Rome Singh7-Oct-03 2:49 
GeneralAutomatic dllname change in VC++ ide Pin
xylan6-Oct-03 15:03
xylan6-Oct-03 15:03 
GeneralRe: Automatic dllname change in VC++ ide Pin
FearlessBurner7-Oct-03 0:29
FearlessBurner7-Oct-03 0:29 
GeneralMaple !!! Help !!! Pin
tankhoasp6-Oct-03 15:02
tankhoasp6-Oct-03 15:02 
GeneralRe: Maple !!! Help !!! Pin
JussiL7-Oct-03 3:29
JussiL7-Oct-03 3:29 
GeneralRe: Maple !!! Help !!! Pin
tankhoasp7-Oct-03 5:58
tankhoasp7-Oct-03 5:58 
GeneralDirectory Selection Pin
PhotoMike6-Oct-03 11:44
PhotoMike6-Oct-03 11:44 
GeneralRe: Directory Selection Pin
Rickard Andersson206-Oct-03 12:04
Rickard Andersson206-Oct-03 12:04 
GeneralCRichEditCtrl and Drawing Fonts Pin
Larry J. Siddens6-Oct-03 10:56
Larry J. Siddens6-Oct-03 10:56 

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.