Cannot see my updated rows in the database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • holyskylark58
    New Member
    • Mar 2010
    • 11

    #16
    but i am not using sql security option i am using windows security option there is no option of userid or password. so i cant make the connection string.

    Comment

    • CroCrew
      Recognized Expert Contributor
      • Jan 2008
      • 564

      #17
      See this site. It help you out on your connection strings

      All connection strings in one place. Find the syntax for your database connection using ADO.NET, ADO, ODBC, OLEDB, C#, VB, VB.NET, ASP.NET and more.

      Comment

      • CroCrew
        Recognized Expert Contributor
        • Jan 2008
        • 564

        #18
        Sorry more of a direct link here: http://www.connectionstrings.com/sql-server-2008

        Many SQL Server Express examples at the bottom.

        CroCrew~

        Comment

        • holyskylark58
          New Member
          • Mar 2010
          • 11

          #19
          CroCrew ,
          if i create it in my desktop initialy. then move my project to the f:
          there the problem arises.
          ie the database cannot be attached. the error it gives, is there exists same db.mdf file in the desktop. so the db.mdf fie which is in the f: cannot be attached. but i have cut paste my project folder. there is no databade file of same name in the desktop

          Comment

          • CroCrew
            Recognized Expert Contributor
            • Jan 2008
            • 564

            #20
            What is the error that your getting?

            Comment

            • holyskylark58
              New Member
              • Mar 2010
              • 11

              #21
              it says that there exists another database so that this database can not be attached.

              Comment

              • CroCrew
                Recognized Expert Contributor
                • Jan 2008
                • 564

                #22
                Please post the code that your using and the exact error that your getting.

                Comment

                • holyskylark58
                  New Member
                  • Mar 2010
                  • 11

                  #23
                  the code is given above i'll give the error within a min

                  Comment

                  • holyskylark58
                    New Member
                    • Mar 2010
                    • 11

                    #24
                    Database 'C:\Documents and Settings\doyel\ Desktop\clg project\library 1\library1\bin\ Debug\Database1 .mdf' already exists.
                    Could not attach file 'F:\clg project\library 1\library1\bin\ Debug\Database1 .mdf' as database 'Database1'.

                    Comment

                    • RedSon
                      Recognized Expert Expert
                      • Jan 2007
                      • 4980

                      #25
                      You need to remove the definition of Database1.mdf in C:\Documents and Settings...

                      Or you need to rename the Database1.mdf file in your F:\ drive to something else.

                      Comment

                      • holyskylark58
                        New Member
                        • Mar 2010
                        • 11

                        #26
                        the 2nd option i have tried earlier but it still gives error with the new name of the database
                        can you plzzz tell me in C:documents and settings where do get the defntion?

                        Comment

                        Working...