I'm trying to make a program that will keep track of where and who has borrowed a laptop from our department. I've made the access database and connected it to VB - however i am not sure of what code will need to be put in place
View 1 RepliesI am new to Visual Studio and (I am using Visual Studio 2005)I know how to connect/edit, etc to an access database by just using coding but I am having a problem with the Visual Studio Database wizard.
When I create a new Data Source and I specify a Microsoft Access Database File (OLE DB) connection + *.mdb filename, etc I am able to drag the table name onto the form and browse the contents of the database when running the application. No problem there.
The problem is when I run the application and adding new records to the database via the form, the new data does not get saved. I run the app (F5) + add new data to the database + save + then close the app. When I rerun the app from Visual Studio (F5), the new data is gone.
I have an Access 2007 Database with a lot of forms and I dont want to recreate them. Is there a way to convert the forms and further develop them in Visual Studio 2005?
View 3 Repliesi am working on a project and i want your help for something. I use access database and visual studio vb.Net. In one of my forms i want to get records in a datagridview , between two dates . For example , i have the table Sales and i want to see all my sales between the two dates.
[Code]...
I have a very strange problem with the application I wrote.
It is a database application using SQL and Visual Basic 2005 from visual Studio.
I get an error Value cannot be null. Parameter name: context.When I get this error which accumulate 3 or 4 times in design mode, on an open form. some of the properties disappears for the textboxes like dock, buinding and so on. Does anyone knows what this error means.
I've been googling to find a guide on how to access a database with visual studio.I cant find anything complete or up to date. I should point out that I dont have a great deal of experience with SQL.I'm not really 100% sure where to start. Most of the guides I've found tend to assume your accessing an existing SQL database and I need to set one up from scratch. I'm not sure if I'm even setting SQL server up correctly. point me in the right direction on where to get started. A good, up to date tutorial would be great.
For my purposes the SQL database will only be written to from the local machine but there will also be another machine writing to this database.I'm currently using Visual basic Express 2010 and SQL Server Express 2008 R2, mostly because they are the most recent when I googled it.
I have created a form that does some access sql statements. Using the below code, I can run 9 different SQL statements that purge and load tables. For some reason 1 statement does not work. I do not receive any error, it just doenst load the table.
[Code]...
I have an Access Database, which I connect to using the Microsoft .Jet OleDB provider in VB from Visual Studio 2008.For some reason, whenever I make any change to the code (so that the project builds again), the data in the database completely disappears. I can only assume this means it's remaking the database every time. Note that it does this every time it builds, not just when I connect to it in the code.In my project, this is the database I connect to with the connection string, but there's also another duplicate of the same database in my Debug directory that changes to match the first database every time.The problem only started when I remade the access file to move some columns around and then reconnected through VS a couple of weeks ago.
View 2 Repliesi am creating here coding which use to substract number in database from textbox. In my coding i use textbox which receive number from user and it will subtract a number in database. For your info i am using UPDATE sql command for this operation . In the same time i also create table name InItem and have column name Itemquantity After i click the button i got an error InvalidOperationException was unhandled from my coding Here is my coding and correct my coding if it have missing part. I also highlight which code give this error. Oh ya , is that my sql command for subtraction is correct? i also not sure cause it get it from internet.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ra As Integer
[Code]......
I am trying to write a Project to keep track of my favorite sports teams and scores and store and retrieve the data from a database. I am using vb.net and accdb files. I am able to connect to the tables( 3 tables Players'Keep track of individual stats',OpposingTeams'Keep track of who my team played',Games'matches between the two teams') and Visual studio made it easy to display the teams in comboboxes but this is as far as i can get.
I am wondering how to have a textbox query the Games table and "insert a record into the table, thus creating a primary key and returning the primary key to visual studio and display it in the texbox"
[Code]....
Public Class Form1
Dim db As New ADODB.Connection
Dim cmdcommand As New ADODB.Command
[code].....
I have a database in access and one of the fields is 'Is Quick'. I have a query that filters all of these out. How would I get the data from that query in Visual Studio 2010 (Express). VB code please.
View 1 RepliesI need to display records from a database in Access in Visual Studio 2010. The project Im looking to create needs to display all of the records from the database and allow the user to navigate throughout the set of records.
I need controls and codes to:
MoveNext
MovePrevious
FirstRecord
LastRecord
Exit
i have used this code to insert information into microsoft access database.however i dont know how to edit information from vb.the coding is below:
Private
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
I'm using an MS Access database which has password (database password, not a workgroup or smth). I'm using 13 characters - with no special signs- only letters. When I try to open the DB from access it works fine, but when I try to run my Windows Form application from Visual Studio Connection String, I get a message that "Not a valid password".
[Code]...
I would like to access to a SQL Server Database from my Visual Studio project.
I have SQL Server 2005 Express Edition installed on my PC and I have a database with some tables.
In Visual Studio, I open the Database Explorer and I try to create a database connection.
The Add connection dialog box proposes to enter a database *file name* but I cannot select a database *server* and a database *name*.
Perhaps, is it a restriction because it is a free version ?
Within Visual Web Developer 2008 Express Edition, I can select a database *server* and a database *name* !
check the problem inside my code?
Imports System.Data.OleDb
Imports System.IO
Public Class editMovies
[Code].....
HOW TO update and query and erase in database on visual studio using officce access
View 3 RepliesI have to compile projects which was compiled in Visual Studio 6 in Visual Studio 2005. When i compiled i got a set of same error. I opened the project for VS6 by selecting File->open->project/solution and tried to build a solution by Build option but i am getting the following error.
[Code]...
I am working on a project which was made using VB6, and my client wants to change it in VB.NET
i have to configure this projetct on windows vista ultimate..coz i cant go on with Win XP
can some one help me...
I have a form with a data connection to my access database that shows my music collection, Artist,title,year,chart position, media location & filename.It is set to show only artist & title I have a list box that i can manually load files into to create a wmp playlist i would like to be able to do one or both of the following:
1. drag and drop data from my dataset to the list box to provide a playlist
2. create a playlist from this database that will auto play
I am using VS2010/VB.NET/MS Access 2007 I had added a database from ms access to the vb.net application (strongly typed)that table contains an autonumber field.I made a button to add new row and another one to save the row the problem is that I want to get the last autonumber from the database so that I can save the row.
View 1 RepliesVisual Basic Project - Student Check In Form using an Access database backend This form needs to draw information from an Access database containg tables for STUDENT, INSTRUCTOR, and SECTION. These all need to have primary keys and ids. When (the user) clicks on the drop down box that displays all the sections:
{Table Tennis 1, Table Tennis 2, Table Tennis 3, Billiards 1, Billiards 2, Billiards 3}This should populate the listbox or datagrid from the STUDENT table with the Students that have the same SECTIONID as the SECTION selected in the drop down menu above.
After the Student list has been populated (the user) clicks on a student name in the listbox/datagrid and this inserts that student into the CHECKEDIN table that has a datagrid/listbox associated with it.
This is a great project to practice connecting a database to Visual Studio 2008 .net and playing with the data that has been pulled in. You could use SQL instead of Access.
I have to develop an application using MS Visual Studio 2005 or above with the following objective:
* The application should allow users to create as many new forms as they want and each form should behave like a MS Visual Studio WinForm. By saying that it should be a container for drag and drop of controls from the toolbox that I will develop....
* Once the user design's each screen to his taste by placing various controls on the form, he should be able to save the form as a screen. Of course I have to provide functionality for each of the controls such as if he drags a button on to the form, he should be able to specify what action it has to perfom when clicked when the application is put into run mode. Quite similar to regular windows form button.
* My application should have two modes: a DESIGN MODE, where user can drag, drop controls and specify what they should do when put into RUN MODE. This is quite similar to MS Visual Studio designer.
* Last but not least is to be able to access the application via the browser with the same look and feel his desktop version.
I have to develop an application using MS Visual Studio 2005 or above with the following
objective:* The application should allow users to create as many new forms as they want and each form should behave like a MS Visual Studio WinForm. By saying that it should be a container for drag and drop of controls from the toolbox that I will develop....
* Once the user design's each screen to his taste by placing various controls on the form, he should be able to save the form as a screen. Of course I have to provide functionality for each of the controls such as if he drags a button on to the form, he should be able to specify what action it has to perfom when clicked when the application is put into run mode. Quite similar to regular windows form button.
* My application should have two modes: a DESIGN MODE, where user can drag, drop controls and specify what they should do when put into RUN MODE. This is quite similar to MS Visual Studio designer.
* Last but not least is to be able to access the application via the browser with the same look and feel his desktop version.
I'm using Vista home premium and VS2005 (and VS2008 beta 2) When trying to make a new project or and a new file,class,libraryn,... I get the error "requested registry access not allowed".
View 1 RepliesI need to write a paper on the comparison between (Microsoft Visual studio 2005 to develop web applications using asp.net) and (visual basic and Netbeans to develop j2ee applications using java).I need suggestions for good webpages,journals or documents which can help me out here. I have to write at least 1500 words so any suggestions are welcome.
View 1 RepliesI am using: (copied from the/about vb studio window:
Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
[code].....
Visual basic dot.net that runs on visual studio 2005, thats what i have, is it the same as vb2005? If you're not living on the edge, you're taking up too much room
View 3 Repliesi have installed visual studio 2005 in my computer i want to create a sql server 2005 file i saw a sql server 2005 option in my installed components i want to know how to create a sql server 2005 from my visual studio 2005 it is possible or not.
View 1 Replies