Easy to Create Connection String for .Net


Our .net development.very important is connection string creation .now it will craete easy. You have use DLP(data Link properties) dialog box to save the (.udl) file

How to Create UDL file:

1.Create Notepad file
2.Save As Empty notepad file following extension .udl

Create Connection String:

1.Duple Click the udl file
2.open the DLP dialog box
3.You have select Provider name & provider information ,server name ,Database Name ,Username, password
4.Click Test connection
5.Next
6.And open udl file (open with Notepad)

Data Link File Format:

Total 3 lines it will create
2 lines are udl format
last lines is connection

Format of string

Copy
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=servernamejs;Initial Catalog=databsename;Integrated Security=SSPI


Reference: http://sqlblog.com/blogs/john_paul_cook/archive/2010/07/19/building-connection-files-by-using-a-udl-file.aspx


Comments

Author: Shailesh 10 Aug 2010 Member Level: Gold   Points : 1

Hi,

the another way is to that, drag the sqldatasource in the aspx page & give the user & password details. it will create the connectionstring in the web.config.

Author: asdfg11 Aug 2010 Member Level: Gold   Points : 0

But this technique can be used without opening VS

Author: James Crowley22 Mar 2011 Member Level: Bronze   Points : 1

Just thought you might be interested in a method without using Visual Studio - there's a free online tool on DevFusion. that works for SQL server/SQL express. Makes things nice and simple.

I'm not allowed hyperlinks here but click the 'Tools' link on developerfusion.com :)

Guest Author: Siti20 Mar 2012

Arvilla Landau : My husband and i ended up being quite excited when Michael managed to round up his investigations through the entire ideas he obtained from your very own web site. It's not at all simplistic to simply happen to be offering procedures a number of people may have been selling. And we also keep in mind we've got you to appreciate for that. Those explanations you have made, the simple site navigation, the friendships you make it easier to promote it's got most fabulous, and it is facilitating our son in addition to the family do think that matter is cool, which is quite vital. Many thanks for all the pieces!



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: