C / C++ / MFC

spicy_kid2000 wrote:

if it a unsigned int, it should be 2 ^32 -1

void main()
{
  unsigned int u = 0;
  u = ~u;
  printf("%u (%x)\n", u, u);
}

#include <stdio.h>
#include <stdlib.h>

int main()
{
    char myVar = 0xFF;

    printf("Signed: %d\n", myVar);
    printf("Unsigned: %d\n", (char unsigned)myVar);
    system("Pause");
    return 0;
}

Signed: -1
Unsigned: 255
Press any key to continue . . .

manju#123 wrote:

I want to change a date format from dd/mm/yyyy to yyyy/mm/dd..

manju#123 wrote:

SYSTEMTIME sysTime;
GetSystemTime(&sysTime);

manju#123 wrote:

I am trying with the below code but i am getting the system time..

manju#123 wrote:

Datee.Format("%04d%02d%02d",sysTime.wYear,sysTime.wMonth,sysTime.wDay);

Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_

CString Date = "12/05/2008";
CString YY,MM,DD;
int nLen;

nLen = Date.ReverseFind('/');
YY   = Date.Right(nLen - 1);
Date = Date.Left(nLen);

nLen = Date.ReverseFind('/');
MM = Date.Right(nLen);
Date = Date.Left(nLen);

DD = Date;
CString sNewDateFormat;
sNewDateFormat.Format("%s/%s/%s",YY,MM,DD);

manju#123 wrote:

I am trying with the below code but i am getting the system time..

manju#123 wrote:

can anyone help me

Datee.Format("%04d/%02d/%02d", sysTime.wYear, sysTime.wMonth, sysTime.wDay);

CString Date = "12/05/2008";
COleDateTime dt;
dt.ParseDateTime(Date);
CString Datee = dt.Format("%Y/%m/%d");

1)First of all import msado15.dll into your workspace

#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")

2)Initialize COM libraries using 

CoInitialize(NULL); 

3) Create connection & record set pointers

_ConnectionPtr pConn("ADODB.Connection");

_RecordsetPtr  pRst("ADODB.Recordset");

4) Open data base

#define STR_DATABASE L"DRIVER={sql server};SERVER=serverName;Database=datbaseName;" L"UID=sa; PWD=sa;"

HRESULT hr = S_OK; 

hr  = pConn->Open(STR_DATABASE, L"", L"", adOpenUnspecified);

if(FAILED(hr))
{
  AfxMessageBox ("Error instantiating Connection object\n");
}

5)Execute Query and read values

try
{
 CString strSQL("Select * From MyTable");
 pRst->Open( _variant_t(strSQL),_variant_t((IDispatch *) pConn,   true),adOpenDynamic, adLockReadOnly,adCmdText);

 if(!pRst->EndOfFile){
 CString strValue = (char*)(_bstr_t)pRst->Fields->Item["FieldName"]- >Value;

 int nValue = (long)pRst->Fields->Item["FieldName"]->Value; 

// Here "FieldName" is the column name of table. You will get the value of this column in the corresponding variable.

}

catch(_com_error &ce)
{
  AfxMessageBox(ce.ErrorInfo);
OR
  AfxMessageBox(ce.Description());

}     

6)Close connection and record set pointers

if(pRst->State == adStateOpen) 
   pRst->Close();
if(pConn->State == adStateOpen)
   pConn->Close();

7)UnInitialized COM library

  ::CoUninitialize();