C / C++ / MFC

#import "msado15.dll" no_namespace rename ("EOF", "adoEOF")

if(OleInitialize(NULL) != S_OK)
{
  // Error, stop
}

CString strConnectionString;
strConnectionString.Format("uid=USER_ID;pwd=PASSWORD;driver={SQL Server};server=SQLSERVERNAME;database=DATABASE_NAME");

_ConnectionPtr ptrDbCon;
ptrDbCon.CreateInstance(__uuidof(Connection));
ptrDbCon->Open((_bstr_t)strConnectionString, "", "", -1);
<code></code>

aaaan wrote:

Bt there is no table present in the database with name myTable.

Chandrasekharanp wrote:

well there was nothing abusive in that.

Chandrasekharanp wrote:

i justed wanted to help him. that's all.

raju.k wrote:

i dont know how to use API's .

CStdioFile csf;
CFileException cfe;
CString str, sTemp;
CStringArray csa, csa2;
int iSize=0;

int n=3;

//Create a CStringArray which would hold the new column to be added
for(int i=1; i<=n; ++i)
{
    sTemp.Format(_T(" (%d,%d)"),i,n);
    csa2.Add(sTemp);
    //AfxMessageBox(sTemp);
}

if ( !csf.Open(_T("E:\\Some.txt"), CFile::modeReadWrite, &cfe) )
{
    AfxMessageBox(_T("Failed to open the file"));
    return;
}

int iLoop = 0;
while(csf.ReadString(str))
{
    str.Format(_T("%s%s"),str, csa2.GetAt(iLoop));//Read each and every line in the file
    csa.Add(str);//and append the new column to each line
    ++iLoop;//loop through each line
}

csf.SeekToBegin();
iSize = csa.GetSize();

for(int j=1; j<=iSize; ++j)
{
    sTemp.Format(_T("%s\n"), csa.GetAt(j-1));
    csf.WriteString(sTemp);//Finally write it to the file
}
csf.Close();