Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

DataGridView and DSN connection

Posted on 2006-04-02
2
Medium Priority
?
336 Views
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,
0
Comment
Question by:dhathsato
2 Comments
 
LVL 4

Accepted Solution

by:
pbocanegra earned 1000 total points
ID: 16356782
0
 

Author Comment

by:dhathsato
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
        Try
            ADOcon.Open()
            If ADOcon.State = 1 Then
                'connection string returned from dialog box
                MsgBox(ADOcon.ConnectionString)
            Else
                MsgBox("Connection Failed")
            End If

        Catch ex As Exception

        End Try

    End Sub
0

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