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 Replies
I am current upgrading some of the functions on an inventory system. Current system accepts manual data input from the user and stores them in a SQL database.One of the inputs is control number which is a primary key in one of our table so it needs to be unique. Since it is manually entered into the system, we have to keep track of all of control numbers so there is no redundant control number which is difficult since we have hundreds of items with unique control number that are entered into the system everyday.Yes, it is waste of time.So I want our newly upgraded system to have a function where the control number is automatically generated so the control numbers are controled by the system. I know there something similar in MS Access 2007 but I cant seem to find it on Visual Studio. [code]
View 4 RepliesI am new to VB and trying my hand at the below code. I am trying to determine the number of records for each possible combination. Depending on the outcome of the number of records groups may be combined. I am not able to find the record count for each grouping. Can you please look at the code below and suggest what I am doing wrong?
[Code]...
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 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]....
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
What is the best way to provide strongly typed access to the session object? I am planning on turning on Option Strict, which is causing the compiler to complain about my lazy programming technique of directly accessing the session object:
Dim blah As Integer = Session("Blah")
My initial thought is to create a class that wraps the session and provides strongly typed properties for the information stored in the session. However, I cannot decide if the class should be a singleton, or instantiated on every use, or where the code should reside (i.e. within the web project or within a class library).
I'm leaning towards a singleton in my class library, but I don't know if that is the best solution, or if I am missing any other possibilities.
Proposed Solution:
Public Class SessionAccess
Public Shared Property Blah(ByVal session As HttpSessionState) As Integer
Get
[Code].....
i 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'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'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 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 trying to connect to an Access DB file when I do a drag and drop from the dataset to the form i get the following error [code]
View 1 RepliesPublic Class Form1
Dim db As New ADODB.Connection
Dim cmdcommand As New ADODB.Command
[code].....
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 have a class assignment and I am having some difficulty with an Access 2010 database and OLE objects in the database. I have the database imported into the project and I am able to view the records from the database that I have in labels and combo boxes.
I used the database DataSoure wizard to create my connection string and import the Access database. In the DataSouce window I set the DataSet for the "Flag" column that contains my pictures to use a picture box object type and added the data bound object to my form.
When I run the application all the field from the database show as expected however, the picture box object does not display the images from the database. When I check the picture box object in the designer the properties window shows that the image source is bound to my database with the little database icon and the data bindings are all correct.
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 RepliesIs it possible to import a query from Access 2003 into Visual studio 2010 (language used vb.net).
I created the queries originally for a project, then when I imported the database to visual studio I can only use the tables that i created. I have started looking at the coding to re-do these, but if I can import them would it be quicker?
I have a program designed in VB.net for a wafer probing system. The software has 3 main components that come standard and three that are options. When a customer decides not to have the three options they are disabled but still in the program. If at some point they decide to buy the options, one of our technicians would have to go there and be able to access the program with an administrative account to enabled the components.
Does anyone have any suggestions on what the easiest way to accomplish this?
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 have the following code compiles without issue. Of course, I get an invalid cast xception when executing the Dim C As IDoThingsC = GetThing_C(). Am I missing something?Would you ever want to return an object that does not meet the interface requirement for a function return value?
Public Class ClassA
Public Sub DoThings_A()
Debug.Print("Doing A things...")
[code].....
i have create a software for my college which is document management. well am doing good so far up to now where i need to upgrade my database what i mean ?
in case i need to make any changes to my database i don't want to enter the database and create new table or add new fields to existing table to my current database,i would like to do that throught visual studio 2010 programaticaly. something like an additional application where i will choose my database path and the application will upgrade the database with new tables or new fields .
i would like also to ask, in order to create database,or if you already have the database and you like to just open the connection to it programaticaly and add new field ,or relate some table ,you have to work with different librarys? Like ADOX,DAO etc ? and other.?
I am using the publish wizard in VB 2010 Professional for deployment as I tried the InstallShield and the Standard Build and cannot get support. My last resort is this wizard. Please help me I am getting the following 2 warnings. I downloaded MDAC 2.8 SP1 for warning 2 and after I run the program it doesn't upgrade and appear in VB2010. How can I install it in VB2010 Pro. Also How can I get the .Net.Framework.2.0 installed.
Warning 2 The 'SAP Crystal Reports Runtime Engine for .NET Framework 4.0' item selected requires 'Microsoft.Data.Access.Components.2.8'. Select the missing prerequisite in the Prerequisites Dialog Box or create a bootstrapper
package for the missing prerequisite. SendGlobalMobileAdvertisingBlasts
[code]....
Visual 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'm starting to learn ASP.NET MVC and since I work in a VB.NET shop I'm converting an example from C#. I'm trying to implement a strongly typed view and the example I'm looking at shows the following:
<tr>
<td>Name:</td>
<td><%=Html.TextBox(x => x.Name)%></td>
</tr>
I've come up with the following in VB.NET:
<tr>
<td>Name:</td>
<td><%=Html.TextBox((Function(x As Contact) x.Name).ToString)%></td>
</tr>
Is this conversion correct? This seems really cumbersome (I know, I know, VB.NET is more cumbersome than C#, but I have no choice in the matter).
I'm looking for a the shortest/aseist way in VB.NET (or C# but using VB.NET at the moment) to get the string value of a method's name dynamically given the method call.For instance, I have a class like this:
Public Class Blah
Public Sub Foo()
End Sub
End Class
Now Foo is a strongly-typed cover for a dynamic setting and I have an event handler that will fire when the setting changes and return the string name of the setting that changed.
I'd like to be able to switch/select on this string and have a case based on the Foo() method. To do this I need to able to get the string name of the Foo method from the method call itself (i.e. somehow GetMethodName(blahInstance.Foo())).
