C / C++ / MFC

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();

int array[5] = {0};

(a) for (i=0; i<5; i++) array[i] = 0;
(b) memset(array, 0, 5*sizeof(int));
(c) ZeroMemory(array, 5*sizeof(int));

(a)int *array;
   array = new int[5];
   ZeroMemory(array, 5*sizeof(int));
(b)int *array;
   array = (int*) calloc(5*sizeof(int));

HDC screenDC, memDC;
char buffer[200];
BITMAP bmInfo;
HBITMAP dcBmp;

screenDC = GetWindowDC(hwnd);
memDC = CreateCompatibleDC(screenDC);
HBITMAP myBmp = CreateCompatibleBitmap(memDC, 100, 100);
SelectObject(memDC, myBmp);

dcBmp = (HBITMAP)GetCurrentObject(memDC, OBJ_BITMAP);
if (dcBmp)
{
    GetObject(dcBmp, sizeof(bmInfo), &bmInfo);
    sprintf(buffer, "Bitmap is: %d x %d pixels.", bmInfo.bmWidth, bmInfo.bmHeight);
    MessageBox(hwnd, buffer, "Title", MB_OK);
}
else
    MessageBox(hwnd, "Error", "Title", MB_ICONEXCLAMATION);