Refer to Microsoft visual basic 2008 Step by Step. Author: Michael Halvorson. Chapter 8. Debug the Debug Test Program.Line 15. On the Debug Menu, Point to Windows, and then click Autos, but I cannot find this command, I can find only:
View 2 RepliesI have a form that reads the data from the database table ( so you can see I have figured out how to attach to a databse table)On the form I can scroll through the data with use of the binding navigator that VB automaticly installed on the form, but I need to search the table for specific data in one field.I am guessing that one way is to use a query, but I can't figure out how to use one.I realize that this may be real simple, but because I am just learning VB, I don't know where to start.
View 4 RepliesIn debug mode is the command window option available in visual Basic express 2008?
View 1 RepliesWhen I used to play wiith VB 5.0 I was able to create an array of comand buttons on the form. This allowed me to have one routine that knew which of many buttonshad been clicked and I could then take specific action based on which button was clicked. I can't see how to do this in VBE 8. Is this possible?
View 11 RepliesI'm at the end of my tether now.I'm trying to build a website which takes its information from an access database. ASP.net seems to be the answer, so I've downloaded Visual Basic Express 2008 and Visual Web Developer Express 2008 and I'm following a tutorial to learn the basics.
I can't seem to get the OleDBConnection and the OleDBCommand functions to come up in my toolbar. I've created a ASP.net Web Application, a Webform and tried "Choose Toolbar Items", where I've ticked the box for both, but they still haven't came up in the toolbox. This is the last step in what has been as steep learning curve for me.
I have both the VB and C# versions of Visual Studio 2008 Express. When I run a console application in either version, instead of the console opening in an old DOS style command window like it does in VS 2005, it actually blacks out both monitors attached to my computer and treats the entire screen real estate as the console.Anyone know how to get the app to run in a small command-type window when I run it? It's like the console is running Full Screen. If I set a break point, switch from the IDE t the console and then hit Alt+Enter it switches to the small window that I want, but I still can't figure out how to make the app start with the console that way.I could post a screenshot but it would look like a big black square...no window, no frame, just the inky blackness of frustration.
View 2 Replieshow to find data using search command in my form application like searching a name in my database?
View 1 RepliesHow do you open the autos window for debug in vb .net 2010?
View 2 RepliesIm trying to build an error-logger that loggs running values that is active in the function that caused the error. (just for fun so its not a critical problem)When going in break-mode and looking at the locals-tab and autos-tab you can see all active variables (name, type and value), it would be useful to get hold of that for logging purposes when an error occur and on some other occasions.For my example, I just want to find all local variables that are of type string and integer and store the name and value of them.
View 1 RepliesI have a sound level meter connect to the PC with COM5, and I tried to sent the command through VB express 2010, following is the code I wrote:Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
Is there any way to add command line arguments to a vb express Windows form application?
View 9 Replieshow I can implement my calendar with VB .net express 2008 and MSSQL 2008 Express. How do I get it to work with datasets, binding source etc.If I go to Properties>settings my connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CalendarDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
and I have a table with fields:-
CalendarID
Subject
Location
Purpose
[code]....
I can Add the event to the calendar I have the necessary items on my form linked to my table and I can save them to my table:
Me.Validate()
Me.CalendarTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CalendarDatabaseDataSet)
But I cant keep the event displayed on my calendar when I close it and open it again.
I'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myConnection As New SqlConnection
Dim myCommand As New SqlCommand
[code]....
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesI am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
The program I am trying to modify was initially written using VB 2005 Express. I have subsequently downloaded the 2008 version. The program creates a monthly spreadsheet from a template. The old code that will no longer (highlighted and underlined) compile is as follows:
[Code]...
I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options:
connecting to Access db
connecting to SQL Server 3.5 compact db and
connecting to SQL Server db file.
[code].....
I have SQL 2008 Express and Visual Basic 2008 Express runing on XP Professional SP2. When I select add new data source from VB I don't have the option to connect to SQL Server 2008 express to get at the to SQL Server Database. I also notice that the OLE DB connector is not availble as a data connector. Can somebody please confirm that VB 2008 Express can connect directly to SQL Server 2008 Express and how I can achieve it.
View 5 Replies'm trying to use Visual Basic 2008 Express and connect to a DB of SQL Server 2008 Express but ... you can tell me why in the Database Explorer and the Data menu of VB only have the following options for data source? Microsoft Access Database File Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File does not have the options Microsoft ODBC Data Source Microsoft SQL Server obs.: I have the Visual Web Express 2008 installed, and there are the options available.
View 10 Replies1) Why the pause button and also the pause command does not exist in VB 2010 Express?
2) I have some solutions under 2010. In 2 or 3, while debugging, I can change instructions without restarting the application. In others, I cannot change anything (Is like readonly), Looking in 'My Applications', Tab 'Debug', Option 'Configuration' I can choose several Options. In the applications I can debug, the default is 'Active (Debug)'; in the others is 'Active (Release)'. If I change the options, the word 'Active' remains attached to the original option.
I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesI`m developing an appication which works with a mssql server database.At this stage I don`t have a problem connectiong to a database, because it`s on my computer.But the release version will be installed on few computers, when after installation user will have to choose the correct database to use with the application. I know how to find a working instances of MS SQL server in LAN, but after choosing an instance how to choose the correct database?
1. How to show databases availabale in th instance?
2. How to separate database designed for my application from all other databases in chosen instance?
how to add and remove entries from a database and now I need to know how to search it. I'm going to be scanning a directory and subdirectories and adding all files found to the database. I need to check if the file has already been entered into the database before adding it.
I though it'd be simple and would just require looping though each entry and checking the item for each entry. I played around with a while loop a bit and ran into some problems. Like when the database is empty.
I don't want to half-ass some code that seems to work, since that'd probably be slow and inefficient.
Also what are the technical terms for a column and row in a database. I'd to use the proper terms in the future.
Now that we have that part out of the way lets start with the question.I am attempting to create a small application which will use data form CSV or TXT file and display it in a DataGridView.But what I am interested in is if I would be able to use SQL commands to search through the imported file. Commands like (SELECT, FROM, WITH etc.) and then poplute the DataGridView with the results.
View 9 RepliesI'm currently in the middle of attempting to create a query that will be used so that the application user will be able to search the a customers id number. I'm completely new to adding queries using the query builder so I've become slightly stuck on trying to get this to work currently. I have a database which is set up and in this case the table is called 'cid' which defines the customers id column in the database, this is a primary key and the column has a data type 'AutoNumber'. I've become stuck as I'm not sure what I would have to put into the filter to make this query work.
View 7 Repliesthis is what I've got so far:
Dim find As String
Dim search
find = InputBox("Enter Search Text")
search = MyRichTextBoxEx1.Find(find)
[code].....
But how can i search for the next occurrence of the search?
I'm searching through an html page and I want to put all of the Regex matches into an array? How would I go about doing this? I see the Regex.Matches but I can't quite understand how to use it an MSDN sucks when it comes to explaining it.
View 4 RepliesI haven't programmed for some time, so I'm a little rusty Basically I'm storing HTML within a variable, and I need to count the amount of times a specific element appears e.g. <h3 class=r> for now.
I thought of using a for each loop, and passing the string above into the parentheses of the loop (using a variable ofc) however for many reason's, I don't think this has a chance of working (won't bother explaining why, as I assume you can guess). Then thought of using the .Contains method of the string class, but I simply can't think of how to use it with what I'm trying to do.