In a Jam, need help quick-Mdf Files

[SoixanteNeuf]

Sorry If this has been asked 1000 times but in a bind..Need simple code using Visual Basic 2005 on how to open a SqlExpress MDF file..How to extract the data would help also..I can open an MDB file with VB5 and extract data no problem. Was told last night I had to do this in Visual Basic 2005 and would by usuing SqlServer Express.And done by monday..Done the Interface not do much of a learning curve,,but the database connection is stalling me.
Any help, pointer to help would be most welcome.
Thanks

[SammyB]

Sorry If this has been asked 1000 times but in a bind..Need simple code using Visual Basic 2005 on how to open a SqlExpress MDF file..How to extract the data would help also..I can open an MDB file with VB5 and extract data no problem. Was told last night I had to do this in Visual Basic 2005 and would by usuing SqlServer Express.And done by monday..Done the Interface not do much of a learning curve,,but the database connection is stalling me.
Any help, pointer to help would be most welcome.
Thanks

I've not done any SqlExpress, but a quick google search had http://www.sitepoint.com/article/hos...ql-server-2005 on top. It seems to have all the information that you need. It is written for C#, but it's pretty easy to translate to VB: usually just rearrange & drop the semicolon. It has this line that seem pertinent to you (I translated to VB)

Dim conn As New System.Data.SqlClient.SqlConnection("connection string")

But, I don't do databases, so it's easy for me! HTH --Sam