I have just downloaded VB Express 2008 with the intention of teaching myself how to use it from scratch. Previous programming experience limited to Lotus / Quattro Pro old style macros. Preference would be to work through a good hard copy DIY manual starting from the basics.
View 18 Replieshow to create table in visual studio 2008
View 2 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 should start a project where several clients are included. There is a wcf web service controler that after a call from an specific client about a certain question it will retrive data from a server in London and then it will pass it back to the corresponding client in a different country e.g.
Clients and service are far away. the only way of transportation is through HTTP and intenet connection. Service should be able to callback also so i guess it will be dualHttpBinding.
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 RepliesI am currently debugging throught a lengthy piece of code that behaves differently if the batch loaded is created from one way or another. I have tried going through it and it seems each step is the same, so my question is, Is there a tool that will record each line of code that is hit while debugging? so instead of writing everything down and risk missing something i could just run the program use beyond compare to compare the results of both runs.
View 1 RepliesI have created a table with the following fields
loan_id (PK)
loan_date
loan_return_date
loan_user (FK)
i have set the loan_id column to increment in steps of 1, but when i add a column in visual studio 2008 express it auto increments in minus steps -1 -2 -3. it increments in positive numbers?
What is the code for making steps in dgv? For example I have a button, every time that I press the button I want to make a step in dgv row
View 2 RepliesI am ready to deploy my vb.net project to my client computer.In my development computer I have crystal report 9, sql server express and .net frame work 3.5 installed.My Client computer hasn't got anything installed there.I am trying to making msi installer so that it will be easy for my client to install.I created the new solutions -> setup type project, added the project on it and build it.it successfully created the msi installer but it doesn't installs the sql server express and crystal report.How do i make the installer with crystal report and sql server and also with db
View 1 Repliesi am creating a ticket ordering system, there is 5 - 10 step for public user to choose what they want. These steps is dynamic, can some one advice me what is the best way to store data during steps, so that i can have a back button to return to previous step or retrieve data from step when compiler at last?
View 1 RepliesI would like to know what are the basic steps involved in setting up your application to able to read data from another application. Then take that data and modify it and send it back to the application. The data being read will have over 100 fields.... what is the most efficent way to store them? Put them in a class object?
View 1 RepliesI am relatively new to the world of programming and I was wondering if anybody could help me with a small project. I am trying to create two programs in VB.Net that each do one of the following individual actions:Find the average grade given several user-inputted scores on assignments. The program should also provide the following feedback according to the final score (i.e. A, B, C, D, F).Run two separate threads printing numbers (or words) in ascending and descending orders. (The numbers (or words) should be given by the user.)I have a basic understanding of VB.Net, but I am having trouble when it comes to creating even remotely complex programs. I have a few ideas on how I may go about these, such as using an arraylist for the first question that takes user input to find the grades, and then uses a series of If-Then-Else statements to display the letter grade, and possibly using steps simply with dual threading that would result in numerical order being printed in ascending order and descending order.
View 1 RepliesI have code that runs a deal.deal is a series of conditional steps [e.g., pay Fee1 from Account2 if (Variable5 > 500, Variable5 / 2, 0)].
These conditional steps are stored as strings in an access database.The conditional part can be extremely complex.
What is the best way to get my code to understand the conditional part?Do have to write some huge parser?
Is there a function that can do this for me(something similar to application.evaluation function in VBA)?Or do I need to approach this in an entirely different way?
list the steps to fill a combobox using a bindingsource. I dragged a bindingsource onto a form, created a datatable and datatableadapter(correct term?), added a query. I tried but I am missing something, my combobox displays System.Data.
View 5 RepliesI'm interested in a description of the step-by-step process for creating a custom control and making it available in the toolbox with vb2008. Just for an example, suppose one wanted to have an array of 9 buttons in a 3x3 pattern already labeled 1-9 as a control usable from the toolbox just as a single button or label etc. is, so that one could drag it from the toolbox to the form or a groupbox.
View 1 RepliesI want to write a human resource programme that can accept employee records and compute for their salaries and overtime and also print out the needed salary slips and reports.
View 1 RepliesWith a 1-many relation. Ok, I have constructed the schema, and now I want to make the appropriate forms in which a user would scroll for a customer and then by pressing a button, a new form would appear showing all the orders that he has made.
I am interested in the way of building two forms that would have a one to many relation. That is basically what I would like to know. Also, Do you have any good book to suggest in order to create a real world app, in VB2008, Emphasizing in data-binding and connecting controls with underlying DB, one to many forms, searching etc.
This is weird. I have a class that inherits from IEnumrable whose Count property is reporting 0 (zero) elements but the For Each loop steps into the loop body and tries to use the variable where it should just be moving on. My code:
On Error Resume Next
Dim d As Foo
For Each d In fooCollection
' use d and throws an exception
Next d
Weirder still, every time d is accessed i get an exception thrown in the output window:
A first chance exception of type 'System.NullReferenceException'
but i'm not stopping on the exception (not in a try/catch block).Is "On Error Resume Next" causing this weirdness?
Weirdness found:Per Rowland's and JohnH's comments i checked the Foo class:The GetEnumerator method inside of Foo didn't actually return anything! It had an empty body. That coupled with the On Error Resume Next before the loop caused the havoc! Wow this was ugly.
What will be the steps for finding the DFD of A Project based on Banquet Hall?
View 1 RepliesI 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 RepliesHow can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesWhere in Visual Basic 2008 Express Edition Software program do you specify a specific installation directory for a program?
c:Program Filesfinished program
I want to publish my program to try it out on another system and I want to ensure its installed in the directory structure I want.