Learn how to a build a cloud-first strategyRegister Now


DataGridView and DSN connection

Posted on 2006-04-02
Medium Priority
Last Modified: 2008-03-17
I have received a user defined connection string from a MSDASC datalink.  Now I need to have this connection string open the data in a data grid.  Could I please get some help on this, I am a little lost.  It is a windows form.  Thank you,
Question by:dhathsato

Accepted Solution

pbocanegra earned 1000 total points
ID: 16356782

Author Comment

ID: 16375358
This is what I have so far.  Basically it brings the dialog box up for the customer to select or create their connection.  I reveiwed the link above and still a little confused on how I would go about implementing a DataGridView with the returned connection string.

    Private Sub DataSourceToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataSourceToolStripMenuItem.Click
        Dim mydlg As New MSDASC.DataLinks()
        Dim ADOcon As New ADODB.Connection()

        ADOcon = mydlg.PromptNew
            If ADOcon.State = 1 Then
                'connection string returned from dialog box
                MsgBox("Connection Failed")
            End If

        Catch ex As Exception

        End Try

    End Sub

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

810 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