DB/Reporting :: Moving Through Database Records?
Feb 2, 2009
I am a high school student and i am teaching myself VB, C# and C++... it is a slow process containing mainly trial and error, looking up things online, and when the time is right asking assistance from people who know more then I.
I am currently creating a VB program that creates a database of questions, and the same or separate database. using them questions it can initiate a quiz that will save results in a different database for each student. I am having difficulties getting the code right for reading the databases, and getting it to move to the next portion of the database for each question... a little more info:
Question # = Primary key (there will not be more then 1 of the same # problem)
Question Type = i am using different integers right now to specify if the question is a T/F, Multiple Choice, Open info Et Cetra.... Question Answer = Correct answer Alt answer (x3) = option to add other answers for multiple choice problems...
I don't know exactly how to get it to read a problem and when clicking a next button on a form to have it go to the next question in the database..
View 3 Replies
ADVERTISEMENT
Jan 14, 2009
I've got a large and complex database system that is about to get even more complex, and I'm having trouble coming up with a reasonable way to model the new requirements so as to minimize the performance hit.For simplicity's sake, I'm going to use the example of certification exams, although it's not a perfect analogy for my system. So we have the following tables:
- Person
- Certification
- Exam
- Certification_Exams (join table indicating which exams are required per cert)
- Person_Exams (join table indicating which exams a person has taken)
Given that model, we can easily show that Certification A requires Exam 1, and Certification B requires Exam 2 and Exam 3.We can also determine whether a person is certified by checking Person_Exams to see if they have passed all exams required for the certification we're querying. (Note that we are not directly storing certifications for a person; these must be derived. That's one of the areas where the cert exam analogy doesn't quite match my real-life scenario, so please accept that there's a good business reason for it.In my world, the cert requirements are going to change frequently, so a person might get suddenly "un-certified.")Now enter the new requirement: We now need to be able to indicate that Certification A could be satisfied by either Exam 1 or Exam 4.And furthermore, Certification B always requires Exam 2 but also requires either Exam 3 or the combination of Exams 5, 6, and 7.I've come up with a couple different approaches so far, but the subsequent queries to be able to tell whether someone meets the criteria for a given certification are then incredibly complex.
View 11 Replies
Sep 10, 2009
I am finally ready to move off MSACCESS to SQL. All the advice I've received says to go to SQL Express. I am running VS2008 using VB. I have a lot of experience with MS access. My apps are web based and communicate via web services with the clients. All I need is a good starting point, I want to convert my tables to SQL Express. All documentation I've found has been rather disjointed.
View 1 Replies
May 17, 2006
I can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
View 4 Replies
Oct 27, 2009
how to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 Replies
Feb 28, 2008
I have a database table that has in it, for example:
Room1
Room2
Room3
[code].....
View 3 Replies
Nov 20, 2008
i have a query as follow:
gconn.BeginTrans
strSQL = "INSERT table_name (....) " & _
"SELECT fields_name FROM table_name2..." & _
[code].....
View 4 Replies
Feb 24, 2012
I am basically trying to create some records using Structures as you can see below, however the value of Index doesnt seem to be incrementing as I am assigning it to txtCustomerId.text each time form loads, however the value of the text box remains at 1000 all the time
Code:
Public Class Form1
Dim NumberOfCustomers As Integer
Dim Index As Integer
[Code].....
View 1 Replies
Apr 1, 2009
Is it possible to have a quick and easy way of retrieving the last 10 records from a table?
Currently what I have been doing is retrieving all the records then one-by-one cylcing through each record until I have the last 10. To me this seems to have a lot of over-head reading each record. I just wondered if there was a quicker way of doing it.
View 2 Replies
Aug 17, 2009
I have a DataGridView bound to a non-SQL Server database.I need to allow users to edit existing records but under certain circumstances I need to intercept the edit and instead of committing and updating the dataset I need to delete the edited record and re-add it as a new record.I have tried using every event I can think of to do this but haven't managed to get it right. [code] This almost works but sometimes completely messes up and re-adds rows twice and all kinds of other bad side effects.
View 9 Replies
Jun 2, 2008
An order can have many OrderDetails, and a Product can be on many different orders. The OrderDetail table just has the OrderID and productID, so there is essentially a many-to-many between order and product).I have a form for the user to enter a new order. I want to have an unbound box that contains the names of all the products, and to be able to drag these names into a box under the order, to add a new OrderDetail record using the productID of the dragged order along with our orderID.
View 1 Replies
Apr 17, 2008
If I use the CmdObj.ExecuteNonQuery() I got an error
I'm not having an open connectoin.
View 2 Replies
May 7, 2008
I'm trying to build a new customer data entry page for a db project. One of the features I would like to add is a way to check and see if there have been any new records that have been added that haven't been explicitly saved to the db. If so, when the form_closing events fires I want to evaluate whether or not new entries have been made that weren't saved, and then count the number of rows that haven't been saved.
[Code]...
View 1 Replies
Mar 14, 2008
I'm using Visual Basic 2005 and I have created a program to display, edit, and create insurance records. Right now I am using an access database and it is hosted locally. What I want to be able to do is host it on our server here at our office and have the program installed on every computer on the network.
My connection string at the moment looks like this:
Code:
Public con As New OleDb.OleDbConnection
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:Insurance ProgramInsurances.mdb"
'Opens connection
con.Open()
View 11 Replies
Apr 15, 2008
I am using Windows XP and Visual Studio 2003 .NET in VB.
I have created a parameter query using data controls on a form. The SQL works when I paste it into MS Access (and set the values to those I type in the input form) it returns 3 records. In the VB form I only ever get the first matching record. By changing the input by sorting in different orders I still only get the first matching record ( a different one). If I alter my input so the first does not match but the second and third do match I get only the second. Why Don't I get the set of three?
<Code>
Part SQL:
'WHERE
' (Houses4Sale.HousesAskingPrice <= ?)
[Code].....
View 1 Replies
Dec 14, 2008
I created a project in VB.Net 2008. i use a code to Add,Update and Delete record. It works fine. The problem is: How to get current records informations when i click in gridview or listview value.
[Code]...
View 8 Replies
Jul 9, 2009
I have an input parameter for my stored Proc, Instead of choosing available values from a drop Dwn, the customer wants an empty input box that when left blank returns all records. the parameter type is numeric(6,0) in the Db. I have not found a way to leave the input blank and retrieve all records. my default value for all records is '-99' and also is declared as the default value for the param in the proc.
View 1 Replies
Feb 25, 2012
I'm happy to register in this forum , and here is my first question..I have developed an application in Visual Basic.Net 2010 and i used MS SQL Database My question is how do i move the database to another computer in order for my program to run???
View 6 Replies
Jul 27, 2009
I am currently working on a program (VB.net) that use a database (SQL server 2005)that is on a server. I am using a dataset to store queries and update the database.If i was going to copy the database and move the copies location, what would i need to do to make sure that my dataset points to the copy and it's new location.
View 2 Replies
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
Mar 30, 2008
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 Replies
Jul 13, 2010
I have made several posts on here lately regarding master/detail or parent/child data setups but no one has been able to help. It seems like a subject people don't like to tackle BUT I really need help.
I'm having a real hard with the DataView.RowFilter functionality and it is driving me insane.
For the most part, I have the basic master/detail functionality working. When you select a record in the first grid, it shows the correct data in the second grid. When you enter a record in the first grid, you can enter related data in the second grid. I accomplish this by using a dataview and row filter bound to the 2nd grid. When you change the record in the first grid, the rowfilter for the 2nd grid is restated and reapplied.
The problem arises when I overwrite the primary field value in the first grid and the detail records become orphaned. You would think all I have to do is change the ID in the 2nd grid to match the new ID in the 1st grid but this is where I am having problems. I wrote a loop to change the ID of each record currently loaded in the 2nd grid to match the newly changed ID in the first grid. The code is here:
Code:
Dim I As Integer
For I = AuthorizationGroupsDGV.Rows.Count - 2 To 0 Step -1
AuthorizationGroupsDGV.Rows(I).Cells(0).Value = StrEmployeeID
Next
I have used this code before and it works great. It has to step backwards through the grid because when the ID's are changed, they no longer match the RowFilter criteria and they disappear from the grid. They still exist in the dataset. The problem is, while the code "works" the intended effect does not. Some of the records completely disappear from the dataset and do not reload when I restate the row filter against the new ID number.
View 2 Replies
Feb 23, 2011
I have a live database and an Archive database. I want to do a selct on the live and basically create a new row in the archive database table and insert all the columns then delete the row from the live. Here is the code that creates and deletes:-
Private Sub MoveToArchive(ByRef oleDRClean As DataRow, ByRef oleDSArchiveCleans As DataSet)
Dim oleDRArchiveClean As DataRow
oleDRArchiveClean = oleDSArchiveCleans.Tables(0).NewRow
[code]....
I ran a query in access to show the same sql select and after running my routine they all say #deleted. But when I run the query again I get the rows back WHY!
View 5 Replies
Sep 20, 2011
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 Replies
Feb 9, 2012
I'm creating this VB 2008 application and I want to make it into a CD so it can be installed in other computers. Problem is, after I create the setup and start it even from the computer that created the application in the first place, it gives me the "unhandled exception has occurred in your application. If you click Continue, the application will wignore this error and attempt to continue. If you click Quit, the application will close immediately." and "The following file could not be found: "C:UsersMyNameAppDataLocalApps2.0Data\VHMGGXM7.8K8..." errors.
Since my first "form" is a login system, I am not sure if this problem appears because of the database search, or just the transition between forms (unlikely, I guess, since there is sort of an introductory video before the login system which uses the same logic to transition between forms)... So I tried moving the access database to a different path and I wanted to know how to tell the program (through v.b.) that the database is now in "this path" without having to re-connect and create a new DataSet, which will make me have to start the whole project again. I set up the whole project in Program Files (a place all computers must have). The video before the login system works fine, but I can't really find any other problem.
View 3 Replies
Jun 14, 2010
I have done a database system using microsoft access 2007 which connected to a form of vb2008.And now i want to transfer the system to another computer but as i tried it's not work.I already build the file and copy whole folder that contain the bin, obj and my project to the new computer. I tried to run it on the new computer but it show me an error that "selected collating sequence not supported by the operating system".What should i do to overcome this?
View 1 Replies
Jun 12, 2011
Im using VB.NET 2005 i want to sum two records in database. So when i retreive them to display in my textbox they already sum. the numbers are in text.
this is my code.
con.Open()
cmd = New OleDbCommand("select * from ChargedItems where name ='" & Me.cmbfnameEarnings.Text & "'", con)
[Code]......
View 3 Replies
Jun 9, 2011
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
View 2 Replies
Oct 5, 2008
I have this:
Private m_PerformanceCounter As New _
System.Diagnostics.PerformanceCounter( _
"Processor", "% Processor Time", "_Total")
[code]......
View 4 Replies
Jan 11, 2011
I have the code below which does work, but I need to add further functionality to it. The functionality I want to add to it is the text I have commented in the code below.
Dim objSQLConnection As SqlConnection
Dim objSQLCommand As SqlCommand
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
Before the if statement, I want to find out if the database already has records with the username in the strUser variable.
View 2 Replies
