steps and code to connect to SQL server 2008 for inserting, updating, accessing database using vc++ mfc

Question

1.00/5 (1 vote)

See more:

MFC

VisualC++

steps and code to connect to SQL server 2008 for inserting, updating, accessing database using vc++ mfc

Posted 14-May-13 20:29pm

BJayashree

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

skydger · Answer 1 · 2013-05-14T21:02:00

Solution 1

Hi!
You should use CDatabase[^] and CRecordset[^] classes to work with databases in MFC.
If you plan to work with varbinary() datatypes the following tech note could be useful:
TN045: MFC/Database Support for Long Varchar/Varbinary[^]

Posted 14-May-13 21:02pm

skydger

Comments

BJayashree 15-May-13 3:16am

i need the complete code

BJayashree 15-May-13 3:17am

thanks for the answer as im a beginner i need the complete code

Jochen Arndt 15-May-13 3:29am

You would not get complete code here. The web is full of examples on using the MFC CDatabase and CRecordset classes. These classes are database format independant. The only database format specific tasks are connecting to the database and when using database specific SQL commands.

If you have a specific problem with these classes, we will be pleased to help you.

skydger 15-May-13 4:30am

As Jochen Arndt wrote you won't get a complete code here. Your request covers a wide field of solutions and we cannot guess which one of them you ment. Please refer this link, maybe this tutorial will be useful:
http://www.informit.com/library/content.aspx?b=Visual_C_PlusPlus&seqNum=190

BJayashree 15-May-13 4:15am

CDatabase database;
CString SqlString;
CString ssn,firstname;
CString sDriver = _T("SQL Server");
CString sDsn, sMc;
sMc.Format(_T("MERILDSK33"));
CString sFile = _T("C:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\DATA\\DBTrial.mdf");
sDsn.Format(_T("ODBC;DRIVER={%s};Server=%s;Database=%s;Trusted_Connection=yes"),sDriver,sMc,sFile);

// You must change above path if it's different
int iRec = 0;
try
{
// Open the database
database.Open(NULL,false,false,sDsn);
// Allocate the recordset
CRecordset recset(&database);
// Build the SQL statement
SqlString = _T("select * from dbo.Person");
// Execute the query
recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
// Reset List control if there is any data
while( !recset.IsEOF() )
{
recset.GetFieldValue(_T("SSN"),ssn);
recset.GetFieldValue(_T("PersonFN"),firstname);
recset.MoveNext();
}
database.Close();
}
catch(CDBException* e)
{
AfxMessageBox(e->m_strError);
}
I have written above code for connection ,but it fails at database.open line

skydger 15-May-13 4:46am

I suggest you to update your question with this code sample.
As for error... Please change the path to mdf file to real database name. For example "Database={Northwind}".

BJayashree 15-May-13 5:48am

i had gone through your link but it is for single document but i need it for dialog based, im confused in which functin wat database related code need to be used

skydger 15-May-13 7:09am

Your code sample looks fine, why don't you add it to your dialog-based application?

BJayashree 15-May-13 7:15am

Below error is shown for sDsn.Format(_T("ODBC;DRIVER={%s};Server=%s;Database=%s;Trusted_Connection=yes"),sDriver,sMc,sFile);

error^C2664: 'void ATL::CStringT<BaseType,String Traits>::Format(const wchar_t *,...)' cannot convert constchar31 to const wchar_t

skydger 15-May-13 7:45am

Are you sure you've added _T() modifier to your format string? If so try to replace _T() modifier to L modifier. For example sDsn.Format(L"ODBC;DRIVER...",...);

BJayashree 15-May-13 7:59am

Thanks. The code is working now with the suggested modification.

BJayashree 16-May-13 6:15am

how to insert data in to the database using CRecordset

skydger 16-May-13 14:19pm

Use ExecuteSQL method of the CDatabase object:
http://msdn.microsoft.com/en-us/library/67cze9b7(v=vs.80).aspx