Last post Mar 16, 2009 04:13 PM by MuffinMan123
Mar 16, 2009 06:02 AM|MuffinMan123|LINK
I have build a MS sql database file from visual web developer, and now I need to access the file using VC++ express 2008.
Basically I need to be able to execute commands like this
SELECT [HomeAddress], [Number], [Material] FROM [ThisTable] WHERE ([RegisterKey] = @RegisterKey)
and maybe store these data in a list of some sort.
for the moment I only need to read from the mdf file not writing to it, so select should do the job.
I heard VC++ express used to offer project template called sql server project, but this is not in the 2008 version, I also heard about ADO.net on VC++, but I could only find msdn articles on it.
if possible please give me tutorials and links beside msdn.com because I always find the site confusing to negivate. thanks.
Mar 16, 2009 08:32 AM|jaiswarvipin|LINK
Please refer the below link help you to do the connection with SQL server as well as retrive the data from database
Refer this below link tewll you how to read table frm CSV file
Mar 16, 2009 04:13 PM|MuffinMan123|LINK
do I really need to connect to the sql server to find the database? is there any way for the program just read the mdf file and pull out the tables?