Make A Two Dimensional Database On Vb 2010?
Apr 26, 2011
Im preparing a program for my teacher friends using vb 2010 express. They keep records about their students. I prepared a database that contains a table named "Mystudents". It has columns like "studentId , Name, Surname, etc.." . My problem starts here. Each student attends lots of lessons during a year. I must keep "which lessons they attended", "when they attended", "which topic done in the lessons" for each students. for example
Id: 104
Name : Jason
Surname : Black
Class : 10A
[Code]....
i mean i have a list of data for each record of databese.
View 5 Replies
ADVERTISEMENT
Oct 10, 2009
i want to make a vb.net program that reads from a text file a movie, with the help of a Open Dialog (called openFD in my program) (we don't know how many movie we've got), the actors, the release date, the country, and the rating.
The text file look like this:
Movie1;Actor,Actor,Actor1;Date1;Country1;Rating1
Movie1;Actor,Actor,Actor1;Date2;Country2;Rating2
...
First question: How can I make a 2-dimensional array? line(0,0) - Movie1, ... , line (1,5) - Rating2. Here Is my try, but it's not good:
Dim line As ArrayList = New ArrayList()
Dim itm As ArrayList = New ArrayList()
Dim i As Integer = 0
[code]....
And here is the code for the Delete Button. It deletes a movie from the listbox, but the details of the deleted movie remains for the next one, I must delete the details for the deleted movie, too.
ListBox1.Items.Remove(ListBox1.SelectedItem.ToString)
View 7 Replies
Nov 19, 2011
Dim Paper As Graphics
Paper = picBox.CreateGraphics()
Paper.Clear(Color.White)
[code].....
View 12 Replies
Oct 15, 2009
I want to create a 2 dimensional array and populate it with data from database. I wrote this following code.I made some mistakes here with the arrays.
[Code]...
View 2 Replies
Apr 19, 2012
In my football sim I am trying to save all the info from a game. There are two defined dimensions to this array. The first is the number of weeks(17 always) and then the number of games per week (Number of teams /2). The plays themselves are unknown in quantity so I decided to use List of to store them. With this type of multi-dimensional array that is also a List of I am having trouble with the Get and Set properties. I have a member variable declared as:
[Code]...
View 3 Replies
May 24, 2011
I have a string, which can easily be splitted by seperators into an array.The output has to be splitted again an move into a multi-dimensional array (2nd index)[code]
View 2 Replies
Jun 9, 2011
any one here can help me to make access database and connect it to a visual basic 2010 program and update and retrive information from it
View 2 Replies
Aug 29, 2011
I'm using VB.NET 2010, and Microsoft SQL Server 08 Express. I've never done a data bound project before so forgive me if I have no clue what I'm doing.
[Code]...
View 14 Replies
Sep 21, 2011
I want to make a login for my application, not using a database, for now.
I figured something like this:
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
If UsernameTextBox.Text = "Josh" & PasswordTextBox.Text = "mypass1" Then
[Code].....
View 2 Replies
Mar 30, 2011
I think I need a two dimensional byte array I currently have something like this:
Dim MbyteData(196608) As Byte
' Open the file that is to be loaded into a byte array
Dim oFile As System.IO.FileInfo
oFile = New System.IO.FileInfo(sFilePath)
[code]....
I now need to load several files at once (say four) so I need four arrays of 196608 bytes and I want to reference them by a number - 0 to 3, assuming the array is zero based. If I use Dim MbyteData(196608, 3) as byte or Dim MbyteData(3, 196608) as byte the syntax seems to be correct but I hit an error ("Number of indices is less than the number of dimensions of the indexed array") when I try to add the extra dimension to the stream read with something like oFileStream.Read(MbyteData(index), 0, MiByteCount).
View 4 Replies
Feb 21, 2011
I have been puzzling over this for about 2 days now but to no avail.All i am trying to do is retrieve all the "<a href = "myLink.php">MyLink</a>"
I can do it via the webbrowser with getElementsByTagName but i just cant for the life of me work out how i split the returned html into either an indexed array or just use inStr or Split function to split this into seperate value, But if i have a csv file with 20 links i dont want to have to load every page into a webbrowser control just to use getElementsByTagName.
Now it all works fine and retrieves the source code from the page. I have only extracted part of the code which is relevant to the retrieving html to try to shorten this post.
[Code]...
View 13 Replies
Jun 9, 2011
How do I prompt the user to input elements in a two dimensional array? And how do I then save the output?I've figured out how write and print a program where the program provides the elements (see short version below), but I can't work out how to get the user to input the elements instead.
Solfa(0, 0) = 11
Solfa(0, 1) = 12
Solfa(1, 0) = 21
[code].....
View 2 Replies
Oct 14, 2009
Pass a 2-dimensional to a 1-dimensional function
View 5 Replies
Jan 2, 2012
The project must have different user and each has username and password will be saved in my database but only the admin can add users.
View 5 Replies
Sep 5, 2010
i try to make a program that can share a database to other people using a upload/update system but when i try to download/upload it keeps saying mdf file in use how can i make the code so that it Uploads and overwites the file without that error.as it must be so it must upload to my server (build in)and download (also build in)the error gives file in use constandly how can i fix this issue?of that file in use problem. even when these no querry or other code running?
View 9 Replies
Feb 12, 2011
Consider the following code:
Dim arr1 As New List(Of Double)
Dim arr2 As New List(Of Object)
Dim timeStart As DateTime = Now
For x As Integer = 0 To 1000000
[code]....
It involves 2 lists. The first one is 1-dimensional, the second one is 2-dimensional.The first routine (which operates on the first list) completes in about .015 seconds. The second routine (which operates on the second list), however, takes almost 10 seconds. The only difference is that the second list is 2-dimensional.Is there a way to speed this up or am I doing something wrong? I have a program that requires several 2-dimensional arrays and it's running extremely slow right now. How can I speed it up so I get the same feedback that I'd get if the lists were 1-dimensional?
View 1 Replies
Feb 17, 2010
I have a string containing many lines. Each line has many values separated by commas. Basically it's in CSV format. The number of lines is variable but the number of columns is always 7.
I can get each line into a one dimensional array using Split(Var, Chr(10)).
I'd like to make it a two dimensional array where the second dimension contains each comma separated value.
I've got
Dim VarArray1() As String = Split(VarText, Chr(10))
Dim VaryArray2(0 To VarArray1.Length - 1, 0 To 6) As String
Is there a quick way to get the contents of VarArray1 into VarArray2. I know I can do the following.
For Counter = 0 to VarArray1.Length - 1
Dim line as string = VarArray1(Counter)
Dim Values() as string = Split(line, ",")
For Counter2 = 0 to 6
VarArray2(Counter,Counter2) = Values(Counter2)
Next Counter2
Next Counter
But is there a quicker way to do it that doesn't require passing through each element of VarArray1 and then passing through each element of Values.
The eventual goal in all of this will be to find the highest value in the 3rd column (the arrays are strings at this point because not all columns are numeric). To do that once I get the values into VarArray2 I suspect I have to pass through each element VarArray2, i.e. VarArray2(Counter,2). Unless I can copy the whole third column into a SortedList?
View 4 Replies
Feb 20, 2012
I have an SQL statement like:
SELECT FNAME, LNAME, CITY from EMPLOYEE
How do I create a multi-dimensional array from a datareader which should store values like:
John, Doe, LA
Mike, Johnson, PASADENA
Freddy, Kruger, Long Beach
View 3 Replies
Feb 26, 2012
I have 9 1-dimensional arrays of bytes and 1 of them is empty, I want to make the empty one equal to the others put together like you would a string:
Dim bla As String = "bla" & "bla" & "bla"
'now bla = "blablabla"
but instead:
[Code]......
View 9 Replies
Apr 20, 2010
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
View 4 Replies
Apr 8, 2010
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
View 2 Replies
May 1, 2012
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
View 5 Replies
Nov 11, 2010
heey guys, befoure I explain the problem. I know some vb coding so you can just give me some codes and I can add it to the program. ok,
I want to make a html file with "tags" to make a music database,
<html>
<Song_Database>
<Song Number="1" Name="Memories" Artist="David guetta" Category="Pop">
</Song>
</Song_Database>
</html>
View 3 Replies
Feb 9, 2010
I am having a problem understanding the following error message:
Value of type 1-dimensional array of string cannont be converted to 2-dimensional array of string because the array types have different numbers of dimensions This line seems to be causing the error:
New String((13) - 1) {}
I did a Google search on this but didnt come up with anything useful. I didnt even change the code.I just found this example online and copied/pasted it into a project that Im working on.
All code is listed below!
Calendar.aspx.vb
Imports System
Imports System.Data
[Code].....
View 4 Replies
Feb 14, 2011
I'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
View 5 Replies
Jul 16, 2011
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 Replies
Oct 31, 2009
I have made a database application that uploads a database via FTP here is the code:
Code:
note this line:
Code:
ContactDB.mdf is the database in my application what would i have to insert for it to upload the database i have tried it as it is and its failing i could locate its full path on my machine that works but what happens when i want the application to go on someone elses pc?
View 4 Replies
Sep 17, 2011
I programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 Replies
Mar 10, 2011
Dim Connection As New OleDb.OleDbConnection
Dim dbProvider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=cSSO3sEEhrM4vY3je0qC;" 'connect to the access 2010 database, including DB Password
[code].....
View 11 Replies
Jan 20, 2012
my project needs to store data online, and since i have no experience with databases ( aside from .txt base ones ) i wanted to know if it is possible ( and secure ) to save a database online and allow the program to write data to it and to read data of it. if this is possible could any body hint me in the right wa
View 6 Replies
