Search results for query: *

  • Users: gs99
  • Content: Threads
  • Order by date
  1. G

    Copy Visual Basic 2010 project with SQL database to another computer

    I have a Visual Basic 2010 project with SQL database (2008 R2), detached from server. The db was not copied into the project. It resides in the SQL directory. I need to debug the app on this computer and another computer that has VB 2010 but SQL 2012. All are Express versions. When I copy the...
  2. G

    Delete obsolete settings in My.Settings

    VB 2010 Express. When I display user.config, it shows old settings that I've deleted via Project, Properties, Settings. I know the file is current,since it reflects changes made recently. How can I delete the obsolete settings? The Windows (7) path is...
  3. G

    Usage of query in other procedures (public scope)

    Using Express VB 2010 and SQL 2008. When a query is made, how can the results be made available to other procedures? For example, in Module: Sub makeQuery() dim myQuery ... End sub Sub useQuery() for each p in myQuery ... End sub
  4. G

    Question SQL identity does not work

    I set a primary key to have identity. Seed 239, increment 1. In SSMS (2008), I inserted 2 records, correctly being assigned 239 and 240. When I run the file in VisualBasic.NET, these 2 records appear, so I know the DB is current. When I add a record in VB, I expect it to be 241. But the...
  5. G

    Question Have DataSet reflect modified database?

    I'm using VB and SQL Server 2008 Express. These are the steps I take to make a simple SQL database application: Create new Windows Application project. Add new item; Service-based Database named MyDB.mdf. In Data Explorer, Add new table named Person. Add two columns, ID and FirstName. Add New...
  6. G

    Question Cannot start Configuration Manager

    I have SQL 2008 R2 Express. It seems to be working OK, but I'm wondering what's in Configuration Manager. When I try Configuration Tools, SQL Configuration Manager, I get an error message: "Cannot connect to WMI provider. You do not have permission or the server is unreachable... the specified...
  7. G

    Question Login failed for user - Windows Authentication

    I have SQL Server 2008 R2 When starting it, I have the "Connect to Server" dialog that shows Authentication: Windows Authentication There is a database called testDB, that came with SQL. In VB 2008 Express, I have a simple app including this code: Dim objConnection As New...
  8. G

    Question controls cannot be added to the form?

    1. What determines that some controls cannot be added to the form? (I tried several, not all of them) 2. Where does the image for Column 1 About form come from?
  9. G

    Question Information about class About in NET 3.5

    (1) How do I display information about a class in NET? A display of the whole class as if I had created it, with all the properties and methods. (2) The specific class: About (a windows form template). What I've tried (I have VB 2008 Express, NET 3.5): In Visual Studio; F2 Object Browser...
Back
Top