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]...
Are the codes generated from Visual Studio.net 2003 Visual Basic fully convertible and compatible ti Visual Basic 2005 Express Edition ? I tried converting a project which was develop from VS 2003 for VB 2005 but after the process there are some commands which is not supported in the latter version. The deployment module in this project is also not recognised in VB 2005.
View 1 RepliesI have attempted to uninstall VB 2005 express and C++ express using Remove Add programs to no avail. Error message: The Window Installer Package c:program files visual studio 8 vs_setup.msi could not be opened. I have removed the MSDN library and SQL server successfully. I have also tried vs_uninst_betas tool which doesn't find anything to uninstall. I would prefer not to modify the registry if at all possible. If I could find a source for the original install packages for VB and C++ I would attempt reinstalling and then uninstalling....but cannot find them anywhere.
View 4 RepliesI'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]...
How to create multicolumn listbox in vb2005 express edition.
i have created a listbox and set the multicolumn property to true
but how do i add the columns to the listbox ?
how 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.
Old scripts on VB net 2005:
-------------------------------
Import SATA.SMSLibrary
Dim SenderDaemon As New SmsSenderDaemon(Connection)
[Code].....
but still namespace: sata.smslibrary doesn't show up. Also I've tried to add as a reference but failed, still.
At home I use Visual Studio 2008 Pro but a class of mine is trying to have us use Visual basic 2005 express edition. Since we need to submit source code files will there be a problem if I just submit the .vb file instead of the whole solution?
[Code]...
I am trying to connect VB 2008 express with sql 2005 standard edition on a reomte server. Is this possible or VB 2008 express version limits this Can some one guide me with the connection string to achieve this.
View 1 RepliesI have noob question. I made a dataset of a sql express 2005 database using the designer. So it's a typed dataset. Then I declare some tableadapters and fill them.Now I do this to add a record to my dataset:
Private Function SaveOrder(ByVal controlenummer As Integer, ByVal PK_BaanID As Integer, ByVal starttime As DateTime, ByVal stoptime As DateTime) As Integer
Dim orderRow = dsIntveen.tblOrder.NewtblOrderRow
orderRow.Controlenummer = controlenummer
orderRow.FK_Baan = PK_BaanID
[Code]...
Am a 1st year student of IT Management, i have been trying to install VB 2005 and/or the VB 2008 Express from msdn and also from disc given to me from college but it wouldnt download coming up with an "Error 1935". what does this mean?
View 1 RepliesI'm having problems tring to connect to the sql server 2005 express with and vb 2008 express.
I keep getting this error and here is the code too:
Login failed for user 'CHRIS-ARTZGuest'
connFabList = New SqlConnection("Data Source=CHRIS-ARTZ;Database=FabList.mdf;Integrated Security=True;")
I have make an program in VB express 2008 ( Three years work )This program is stand alone , you can start it everywhere My program works on XP , VISTA and Window 7 I have make an setup program to install it in MyDocuments But the path in XP is not the same as VISTA or Windows 7 ( I know how to do this )
What I want to do is to make an short desktop of my program with the same icon as my program on the desktop
I have been learning about working with databases and VB. I have coded the connection string for a MS Access database to my VB project but i cannot establish a connection with my sql mdf database.
The code i used to connect to MS Access is:
<Dim dt As New DataTable()/>
<Dim match As String = ""/>
< Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
[Code]....
What is the connection code in order to manipulate data from the mdf file. Is it similar to the above code.
I have Windows Vista Business on my machine and running visual studio 2005 (Version 8.0.50727.867 (vsvista.050727-8600)) as well as "ENU Service Pack 1 (KB926601)" and "Update for Microsoft Visual Studio 2005 Standard Edition - ENU (KB932232) "I'm trying to connect to SQL server 2008 Express via Visual Basic and I've gone through all the forums to try to resolve my issue and it seems that I have to install " Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support" However, when I try to do this I keep on getting the error "The upgrade patch cannot be installed by the Windows Installer service because the programme to be upgraded may be missing, or the upgrade patch may update a different version of the programme.
View 9 RepliesI'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 working on a simple data encryption program in VB 2008 express. Basically, I want the user to be able to select any file type and the program will read the data and store it in a text box. The user would then input a key, push the encrypt button and the program would XOR each byte of data with each character from the key and store the data in the third text box. I have written a program that has similar functionality only, it will not read from files, it simply reads data from a text box, so I have a encryption algorithm that works.Here is my
[Code]...
when publishing a program is it possible to get it to include or copy over a mdb file and can the setup be made into 1 setup file instead of the "Application Files Folder" and "Program name.application"
View 2 RepliesRun VB 2008 Express Edition program on PDA / Pocket PC
View 1 RepliesI want to convert the following VBscript into Visual Basic 2010 express so I make a graphical interface for it.is script basically runs through excel workbooks in a folder and prints out worksheet 3 of each workbook.
'~~> Folder where the Excel Files are.
Const strSourcePath = "C:\test"
'~~> Path for the log File
[code]....
i am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 RepliesI get the error message: "Format of initialization string does not conform to specification starting at index 0" What does this mean and how can I get the database to open in vb express 2008?
View 5 RepliesI am new to SQLSever, Visual Studio and Visual Basic. I have read through Microsoft Visual Basic 2008 by Michael Halvorson and Microsoft Visual Studio 2008 by Lars Powers and Mike Snell. These books mention the ability to use SQLServer as the DB but I am not clear on the process. I am not knew to programming an have had training in OO programming but have never done any OO programing professionally. So, you can assume I am new to OO programing.
I have created an SQL DB using the Server Explorer in VS, and created a Windows form with Labels, TextBoxes, and ComboBoxes for the application's user to add the demographic information about a new employee. I created a new query with the Query builder that is in the Employee table of the DB which contains all the field for the record for inserting. I have a few questions to understand the process for inserting into the DB.
The DB fields are defined as numeric(6, 0), nurmeric(5, 2), and char(30) for some examples.
The maxlength on the form windows are in sync with the maxlength of the DB for the various fields.
1. What is the process to update the DB with the fields from the form?
2. Do I need to declare and set the results from the form first? If so, how do I call the function (query) that I created in the Employee table.
3. The emp_num I would like to be a dynamically incrementing number starting from 1000. How do I make this a dynamic? The emp_num is also the key on the Employee table.
4. I have a decimal field on the Employee table to hold emp_rate (pay rate). Does the user enter the decimal on the Form or is this resolved by SQL to take the 7 numbers and insert the decimal beause of the table's field definition?
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 Replies