Liked us?

Everything to Improve Your knowledge Create MS SQL Connection string Disign Mode | <a href="/">Detailed expert reviews</a>

Friday, December 23, 2011

Create MS SQL Connection string Disign Mode



Easy way to create database connection string vb.net & Microsoft sql server.

Open New Project.
Data ----> Add New Data
Click Create New Connection Button.

See this images.



Open Add Connection Window.

Select SQL Server Name.
If u installed sql server authentication mode , select sql authentication & you must enter sql user name & password. Other wise select windows authentication mode.
Add Select Database name in drop down list.

See images..

Then Click Test Connection Button. if connection is ok display message " Test Connection Successfully "
Other wise popup Error Message.


After Test connection click Advanced Button.

Then Display Advanced Properties Window.
Copy text i mention in highlighted red colour and paste your coding.



Like this ::

    Public Overridable Function Con_Open() As Integer
        Try
            Con_Adon = New SqlConnection(Data Source=**** ;Initial Catalog=*** ;User ID=** ;Password=*** )
            Con_Adon.Open()
            Return 1
        Catch ex As Exception
            Return 0
        End Try
    End Function

Do you have any problem or doubt please comment . i will help you.

Thank you.







4 comments to “Create MS SQL Connection string Disign Mode”

  • July 13, 2012 at 12:15 AM
    james bond says:

    nice Creativity

  • This comment has been removed by the author.
    March 8, 2013 at 10:32 AM
    Sophia Grace says:

    This comment has been removed by the author.

  • September 6, 2013 at 11:57 PM
    Anonymous says:

    This method is very easy to create connection between .net and sql. Thank you for Creating.

  • December 2, 2014 at 10:24 PM
    Anonymous says:

    Thank you nice job. plz keep Update.

Post a Comment

 

Liked

Detailed expert reviews Copyright © 2011 | Template design by O Pregador | Powered by Blogger Templates