locked
sql server management studio express 2005 and visual studio 2008? RRS feed

  • Question

  • User-1729408034 posted

    How to connect sql server management studio express 2005 and visual studio 2008?
    I am trying to learn asp.net using vb language.
    I want to know how to connect it to sql server management studio express 2005 to retrieve or add data?
    How does it works?

    Wednesday, March 28, 2012 2:10 AM

Answers

  • User3866881 posted

    Hello IAmateur:)

    In my mind,I think open VS,then switch to "View",and then choose "Server Explorer",then on the left there comes up a Server Explorer ToolBox where you can create a connection to a specific connector after you input server's TCP/IP or virutal name,with password……

    Then you can copy the auto-generated sql connection string from right-down property panel,and apply it to something like SqlConnection,SqlCommand,SqlDataAdapter……ect。

    Another way is that you can refer this webiste to get a suitable conn str you like:

    http://www.connectionstrings.com/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, March 29, 2012 9:28 PM

All replies

  • User-359936451 posted

    Check out these tutorials....

    http://www.asp.net/web-forms/overview/presenting-and-managing-data

     

    Wednesday, March 28, 2012 9:47 AM
  • User3866881 posted

    Hello IAmateur:)

    In my mind,I think open VS,then switch to "View",and then choose "Server Explorer",then on the left there comes up a Server Explorer ToolBox where you can create a connection to a specific connector after you input server's TCP/IP or virutal name,with password……

    Then you can copy the auto-generated sql connection string from right-down property panel,and apply it to something like SqlConnection,SqlCommand,SqlDataAdapter……ect。

    Another way is that you can refer this webiste to get a suitable conn str you like:

    http://www.connectionstrings.com/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, March 29, 2012 9:28 PM
  • User-1729408034 posted

    Decker I have done only one connection thing that is grid control.

    Using grid control retrieved data from database.

    Apart from that we can write code someting like connection  string so I want know what is that exact syntax  that will be there in the starting of code page.

    Thursday, March 29, 2012 10:22 PM
  • User3866881 posted

    Apart from that we can write code someting like connection  string so I want know what is that exact syntax  that will be there in the starting of code page.

    Have you looked at my reply?I mean you can generate the conn str and copy it directly for usage……

    For syntax……different kinds of dbs have different kinds of syntax——hard to say……

    Reguards

    Thursday, March 29, 2012 10:40 PM