How to retrieve email address from aspnet.mdf

Posted on 2007-07-28
Last Modified: 2013-12-26
How can I retrieve all the email address from the aspnet.mdf database. using vb 2005.
I tried to write a query but I keep getting a message that the database is open.
Question by:whiwex
    LVL 48

    Accepted Solution

    Dos aspnet.mdf is your database or do you have another where is stored the email. Is you use aspnet.mdf to store email then you can make a new connection, fill the dataset and retrieve the value(s) that you want.

    You can have a look into this example
    LVL 48

    Expert Comment

    Sorry is not dataset but OleDbDataReader :-)

    Author Comment

    I can't get this to work
    LVL 48

    Expert Comment

    Can you tell me where are you having with problems?

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Open Report with Multiple Criteria 9 59
    VBA - Excel progress bar 22 72
    Is an IP address in a Range 22 64
    VBA error replacing data 6 29
    Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
    The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now