CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2016
    Posts
    10

    Query is not there

    I'm not so new to databases, I programmed some things in MySQL but I'm new to Visual Basic 2010.
    I pretend to use the Compact SQL3.5 that comes with the VS.
    I had a connection with a little database in a window of VS2010, where I defined an SQL join query, so I saved it when it had no query errors, so VS2010 transformed it to something rare.
    Later, the computer failed so it did a shut down.

    Now that I did the code to fill a dataset without errors, I wanted to come back to the query to apply it to this dataset, but the saved window with the query disappeared. I found a .Designer.vb window with a lot of code like XML (attached) but I don't know if it is possible to return to my SQL window where I had tested the code. Or at least, which would be the steps to make again the connection and SQL query. I came to this point by trial and error but I need the assistance to recover this or make it again.

    Thank's for your time
    Luis
    Attached Images Attached Images  
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,283

    Re: Query is not there

    Is there something shown in the Solution Explorer window?

  3. #3
    Join Date
    Aug 2016
    Posts
    10

    Re: Query is not there

    Quote Originally Posted by HanneSThEGreaT View Post
    Is there something shown in the Solution Explorer window?
    In the red square (and is not russian) at right, there are some files but I don't know the extensions. Maybe one of them can show me that query.

    On the left side (and is not russian), is the server explorer showing the structure of a pair of tables

    On center (and is not democrat), is the panel where I'm trying to do another query.

    Thanks for your attention
    Luis
    Attached Images Attached Images  

  4. #4
    Join Date
    Aug 2016
    Posts
    10

    Re: Query is not there

    In fact, Where can I modify the structure of a table already done?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured