Options For Databases ?
Apr 29, 2010
Well my project will basically involve a database of the sports info of students in my school. It has to work with about 1000 profiles, each containing a personal info record (basically an address book) and a Sports Info record which has some simple information like what sport they do for winter and summer but it also has some records like "Training Info" which will contain a some 10 fields. It'll wind up something like an array of records of records of records.
One of the key points for assessment is that we employ search and sort functionality explicitly using algorithms that have been provided to us. Essentially we'll have to write up our own subs for binary searches and stuff like that.
Now this is group work and I was put in charge of making the database, one thing I'm unsure of is what I should use. Most of the other groups are using .txt files to store their databases as they've been told that these are easier than Access files. However their databases don't appear to be quite as complex as the one my group's planning. Another random titbit of info I heard was that using our own search functions to search an Access file would not only be slower than using the inbuilt ones (another random something gleaned from conversation) [does it have inbuilt search functions?? I heard somewhere else it didn't] but also that it'd be slower than searching a .txt file with a similar sub.
I'm not sure of the veracity of those statements, however I still want to ask if you guys have any recommendations for what I should use to make the database with. The only ones I know of are CSV text files and MS Access, I'd be very grateful if you could point me in the of a good "thing" to use with VB.net for this kind of project.
View 2 Replies
ADVERTISEMENT
Aug 20, 2011
I am in need of a form that shows various options, exactly like the Options in Visual Studio. Since there are so many options I too want them categorized, with a TreeView to the left taking care of showing the right category.The usual 'easy' approach here would be to just place a TreeView control on the form, add some nodes, and give those nodes a tag or key that corresponds to a panel or UserControl with the options for that category.Since there will be a lot of options however, this is not really feasible design-wise; the form would be cluttered with possibly 50 panels, all of which I would need to select and bring to front from time to time to add controls to them that represent the options.
So I decided to create a custom control that does exactly that. The control is very similar to my Wizard usercontrol, users can add OptionsPanels at design time, which inherit Panel and simply represent one panel of options. When they do, the panel is added to a container panel, and at the same time a TreeNode is added to a TreeView. The control uses a custom ControlDesigner to handle design-time clicks in the Treeview, selecting a different node would select and bring to front the corresponding panel, allowing the user to add the controls he wants.
Due to the design time support the problem of having 50 panels is no longer present, only one panel will be visible at a time and selecting the right panel is as simple as selecting the corresponding TreeNode, just as during run-time. Anyway, I got all this working, but only for a single 'level' of categories. As you can see in the Visual Studio options, there can be multiple levels of categories. For example, the Environment node has a bunch of children, where each child represents one 'options panel'. There can even be deeper nesting, see the Text Editor node for example.Let me begin by drawing out the basics of how my control works so far.
The main control is an OptionsView control, which contains a SplitContainer with a TreeView to the left and a OptionsPanelContainer to the right. The OptionsPanelContainer is merely a Panel to which only OptionsPanel controls can be added, and which raises events when this happens, as well as when OptionsPanels are removed from it. An OptionsPanel also inherits Panel, and these are the actual panels the users will see in the control, one for each option category.For now, each OptionsPanel has exactly one corresponding TreeNode (and vice versa). In the Visual Studio options, each 'parent' category usually has a 'General' node as the first child, and the parent and this General node show the same option panel, but I am ignoring that for the moment.
The OptionsView control has a property Panels that returns the ControlCollection (Controls property) of the OptionsPanelContainer (in other words: it returns a collection of OptionsPanels that are in this container panel).
vb.net
<Editor(GetType(Designers.OptionsPanelCollectionEditor), GetType(UITypeEditor))> _ <DesignerSerializationVisibility(DesignerSerializationVisibility.Content)> _ Public ReadOnly Property Panels As Control.ControlCollection Get Return Me.PanelContainer.Controls End Get End Property
A custom CollectionEditor for this property takes care of the designer: even though the property type is ControlCollection, the CollectionEditor knows it should create instances of the OptionsPanel control instead of just Controls.When it does this, a corresponding TreeNode is also created and its Tag property is set to the OptionsPanel. Vice versa, the Node property of the OptionsPanel is set to the node. Hence the node and panel both know their corresponding object.
vb.net
Public Class OptionsPanelCollectionEditor Inherits System.ComponentModel.Design.CollectionEditor Public Sub New(type As Type) MyBase.New(type) End Sub Protected Overrides Function CreateCollectionItemType() As System.Type
[code]....
So far so good, this all works fine. I can add Panels via the designer and when I do a new TreeNode appears in the TreeView. I can select this node and the panel becomes visible (comes to the front).Now, I am a little stuck. How do I implement child option panels? And more importantly: how do I let the user add child panels?The most logical choice I think is to let each OptionsPanel have a property (ChildPanels or something) that returns the child OptionsPanels for that panel. Once the user selects an OptionsPanel then, he can look in the property grid to find its ChildPanels property and add child panels to that.
There is a problem though: what would this property return? It must return a ControlCollection of some container (this is, I think, a requirement for the designer features to work, otherwise panels are not added to the Form.Designer.vb file). But there is no container. I cannot add them to the OptionsPanel itself, that would make no sense because the parent OptionsPanel has its own set of controls (the options itself...), there cannot be another (fully docked) Panel on top of those obviously.The container of the main OptionsView then? That is not an option either, its Controls collection holds ALL OptionsPanels, not just the children of the selected panel. I cannot 'select' only the right panels either, that would require me to return a new instance of ControlCollection, it would be impossible to return the actual ControlsCollection that holds merely a small selection of its controls.
View 5 Replies
Feb 28, 2010
With the following piece of code
CODE:
The Or keyword is confusing me. So in the above example which variable gets set. Does options = options or does it set RegexOptions.none.
View 9 Replies
Nov 26, 2010
As i'm learning more and more about developing ive just got my head around creating classes and modules, i started wondering about something to do with configuration of applications where deployment is in a more diverse environment say in a company where different branches dont need access to all parts of a program, so i thought id throw the question out there in a basic sense and get some feedback. so i can go off and do some more reading and learning.
So the scenario in my head is like this.
So we have for arguments sake FrmConfig which is the master configuration form, then we have FrmMain which is the root menu our application general user interfaces with. So here based on what options are checked as enabled in FrmConfig effects what controls (like buttons/menu options) are enabled in FrmMain.
View 2 Replies
Apr 2, 2012
i've been doing ADO.NET for a while but I would like to know if its posssible to use dao recordsets in VB.Net 2010 and where I can get tutorials and code samples to do database stuff like insert etc. I've tried to google but most of the code available is for vb6 I was going through some stuff on this link [URL]../bb243801%28v=office.12%29.aspx and i'd like to know if it works for vb.net 2010 or maybe theres something i'm missing. because the moment I put "Dim dbmyDB As dao.database" its been giving me the wavy blue line and i am now doubting if it works or maybe i'm missing some other code
View 1 Replies
Sep 9, 2009
If you are using an sql database with a vb.net application, does the user need to have anything extra other than the .net framework installed for the program to run? Meaning, if I simply compile the application, are there any extra steps I need to take to make this work?
View 1 Replies
Feb 20, 2011
Ok, so I am on my last book of course material for college and this weekend I started making my own personal applications, stuff I can really use in everyday life, these projects also serve as a port folio for future employers
View 1 Replies
Mar 14, 2010
I recently moved over to a Windows 7 computer and I can't get databases to work with VB.net.Before I moved I used to do an Access database and connect it to VB through the ODBC thing. However, I don't have Access on this computer (open office) so I'm not sure how to create a database and connect it.I have tried to use the SQL Compact Edition that comes with Visual Studio but I not sure how to get it to work. Also would something like mySQL work with VB? I have looked at the mySQL workbench and like it, what else would I need to download to be able to use the databases created with it in Visual Studio?
View 2 Replies
Dec 14, 2010
I am trying to carry out a synchronisation of two databases: one on the server and the other on a local machine. So that even when they are not connected on the network, the local database can carry on accepting data but when the network is back on, the local database can update the server and the server can also update the local machine with data it accepted during the time when the network was off. by first comparing two tables in two databases and then if they are any differences the updating begins and i've since been stuck.
Private Sub btnCompareTables_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompareTables.Click
'dont know which arguments to put when calling this function
'How do i tell the computer which databases to compare
Comparing()
[code]....
View 1 Replies
Jun 7, 2011
I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file (two different tables SQLtableOrders & SQLtableCustomerA))
datasetOrders.Tables("Orders") >>> the first column "orderID" is a primary unique key. Its structure is details below :
OrderID----OrderName----OrderCost--------Date
1----------A---------------54------------11/11/2010
[Code].....
note that I had already made this by getting the data by SQL Statement "Select SQLtableOrders.* , SQLtableCustomerA.orderID FROM SQLtableOrders, SQLtableCustomerA WHERE SQLtableOrders.orderID = SQLtableCustomerA.orderID" It is really working fine , but the problem that it takes time to get data from the SQL server each time I disply orders. I already have the datasetOrders.Tables("Orders") data on the client PC , I need only to make the client PC extract which orders are assinged to a ceratin customers. I can do it by For... Next , but I guess it will take time , specially if "orders" data contains many data .
View 8 Replies
Feb 5, 2010
What control(s) do I need to use and how do I use them? I am ,looking for tutorials and sample code too.
I'm working on a trivia game where the admin can remove and add questions to a database. [code]...
View 2 Replies
Apr 21, 2012
I am fairly new to programming, and even more new to using database objects. I am creating a program that will calculate a user's BMI, and that will let the user know how many calories are in a food that they choose. I found a database that has a bunch of foods, and each of their calories, so I am using that. I have the program set up so that the user selects each food from a drop down list. The user then adds each of the food to a list box after pressing a button. The program is then suppose to calculate all of the calories after the user presses another button to come up with the total calories. I got all the foods on the drop down list no problem, but now, I'm stuck on figuring out how to get the program to add all the calories for each cooresponding food. I have no idea where to start with it. I know that I'm going to have to create a variable to hold the total calories, but I just don't know how to get the calories from each food.
View 8 Replies
Feb 22, 2010
I am looking to add a local database file (.sdf) into my .Net Project, so i go right click on my project, click "Add" -> "New Item", select "Local Database" and rename it to what i want.I then click the "Add" button and get the following error."The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet assosciated with the file will not be generated."I am using Visual Studio 2008 .Net Framework 3.5.
View 4 Replies
Aug 22, 2010
I have read many articles on multithreading over the past few days and so far I'm fairly comfortable with how it works. I am now working on my actual application, and have come across a few design issues that I'm hoping somebody has experience with.The basic premise of the application is simple. A database filled with files names and a "converted" field that has a 1 or a 2 in it (1 for unconverted, 2 for converted). The application loops through every record where "converted" = 1, retrieve the file and convert it.
My single threaded application works fine, except its far too slow. Due to the huge amount of rows in the database (4 million+) and the time constraints on the project, I have decided to run as many threads as the hardware can allow to cut down on the timings.So, the dilemma is accessing database records and which threads should grab which record and how.
View 3 Replies
Jun 14, 2012
I'm trying to get going with using MS-Access databases in vb.net. In my case, I have a list of MS-Access database paths as strings that I want to talk to. I don't want to add the databases permanently to my project, since there are many of them (hundreds, actually). To start off, I have something like this:
Public Sub main()
Dim conn As New OleDbConnection
conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
[code]....
If I run this, it fails at " Dim rdr = cmd.ExecuteReader", with the error:
"Record(s) cannot be read; no read permission on 'MSysObjects'."
however, I can open the same database using the MS-Access client and run the same query without a problem.
View 4 Replies
Jul 8, 2009
I need to know of is a good tutorial or site of using databases...Mostly the basic functions like...
*importing it into visual basic
*reading
*writing
*updating
I have a good knowledge of visual basic and want to learn how to use the databases.
View 1 Replies
Aug 26, 2010
I want to learn how to add the menu options that appear when you click your right mouse button.So far I have a normal menu strip control, rich text box control and I have added a ContextMenuStrip control.
I have not got a clue on how to set the properties for the contextmenustrip on the richtextbox control, so when the user clicks the right mouse button the contextmenustrip appears.
View 4 Replies
Aug 22, 2009
Ok lets say I have a combo box with like 3 options in.
Ex:
Combobox
Option 1
Option 2
Option 3
How could I make it so the timer like every 5 seconds it will change from option 1 and be highlighted to option 2? then after so long, to option 3? and loop this process?
View 1 Replies
Nov 21, 2010
I've got a project where each "person's profile" will have many options associated with them, they are broken into groups such as
"Hobbies"
"TV Shows"
"Dinners"
What I was going to do it tick each "group" that applies to each profile and show only the fields that apply to the user.I was going to display them on a panel or a tabpage but How would I show the user what panels need data entered? (there could be 3 or even 4) but would the panels 2-3(or 4) be hidden how would I promt the user to enter data.I don't like the "look and feel" of tabpages.
View 8 Replies
Aug 31, 2009
I want to know what are the possible ways to print the data using vb.net?
View 8 Replies
Apr 6, 2012
I'm working alot with dates(more specificly the monthcalendar), and for the user's options I have a few features.I'm having some difficulty with letting the user choose their language. For the language I'm using CultureInfo(String), which I have copied and pasted the 2nd and 3rd column from the NLS API into a combobox.Is there anyway I can speed up language option.
View 1 Replies
May 18, 2011
I use vb.net to backup sql '05 - '08 databases. It works great on smaller databases. but when it comes to large databases it fails at 30 or 40 percent with the error: The backup or restore was aborted.
Dim objBackup1 As Backup = New Backup() With {.Action = BackupActionType.Database, .Database = Common.DsSettings("DataBase", Nothing), .Initialize = True, .Checksum = True, .ContinueAfterError = True, .Incremental = False, .LogTruncation = BackupTruncateLogType.Truncate}
objBackup1.SqlBackup(objServer)
View 2 Replies
Dec 25, 2011
My application security from piracy depends upon fields in my databases. User has to activate the application, that writes Bought in my database. But the problem is if a new user installs my application and replaces all databases from some one who has bought key, the application also becomes active without buying key from me.
Is there any possibility that I could mark the databases to be recognized with the particular setup?
View 1 Replies
Aug 25, 2009
I am trying to add nodes to a treeview that come from different databases, but at the moment i am just trying to add the first set from the first database.
The link between the child and the parent is the ID column in the parent nodes access database this number is in a column in the child database called Section, i am trying (unsuccesfully) to use queries and If statements.
I am assigning the ID column from the parent database to the .Tag property of the parent node and then i am trying to use an if statement within the query "asking" if the parentNode.Tag = number in section column Then Add new node, but i haven't done it right. The code is below:
While RetVal3.Read
If RetVal3(0).ToString = SectNode.Tag.ToString Then
Call AddCalcNodes(SectNode)
[Code]....
View 12 Replies
Jul 4, 2011
I have written a Visual Basic 2008 program which creates a Crystal Report upon completion. The Crystal report contains the main report and two SubReports. Every thing runs fine on my development machine.
However, when I install the program at the client site, I get a dialog from Crystal wanting a user name an password. I notice at the top of this dialog that Crystal is pointing to the wrong SQL server.
As you can see from my code below, the server name should be correct. So I am guessing that it is the sub reports that are generating this error.
The sub report names are: rptPageOne and rptCostCenter
How do I set the datasource for the sub reports? Or what else could be wrong?[code]...
View 1 Replies
Apr 5, 2010
I've been using MS Access for the database in many of my programs (they're always local databases, copied to the user's computer) and as is no surprise to anyone here, it's a horrible choice but it's what I knew and so I've just defaulted to it.What is the best one to use? How do I go about buying/getting it? Does it allow royalty-free copies? Can I import my existing Access databases into this? How do I deploy it?
View 1 Replies
Jan 8, 2009
I am writing an application in VB.Net, the application stores a number of images within the database and therefore the SQL database size gets quite large. At the moment I use a single database, however what I want to do is create a new database for each project within my application. I need some advise on the best way to proceed with this and also the best way to be able to create a new database for each project. Below is the approach that I was planning to adopt:
1. When the application is installed it automatically has a common database that comes with the application and this database is attached to the SQL Server, lets call this application "AppA" and common database "AppADB" Within the AppADB there would be a table called projectsTbl and in this projectsTbl it has a 2 columns called "projectDesc" and "projectDB". projectDesc would hold the description of a project and then the projectDB would hold the SQL database name for that project.
2. The user would login to my application and in the admin side of the application have a create project form. In this form he would enter the project description and also a 3 character code for the project. When the user OK's the form it would take the project descrption from the form and put this in the "projectDesc' field in the AppADB and then take the 3 character code from the form add this as a prefix to "AppADB" and put this within the "projectDB" field within the AppADB e.g. if the 3 character code was "SIM" then the projectDB name would be "SIMAppADB"
3. What I obviously now need to do is create a new database called "SIMAppADB" now what I was thinking was I could create a SQL database backup of a database that has the standard database structure that is required and then I can restore this .bak file (which would be in my application installed directory) to this new name, using the following code:
Code:
RESTORE DATABASE SIMAppDB
FROM DISK = 'C:Program FilesAppA Installed DirectoryDB.Bak'
WITH REPLACE, MOVE SIMAppDB_Data' TO 'C:MSSQLDATASIMAppDB_Data.MDF',
MOVE 'SIMAppDB_Log' TO 'C:MSSQLDATASIMAppDB_Log.LDF'
4. Then when the user logins to my application again, on the login screen he will see a list of projects from the "projectsTbl" table in the "AppADB" database. The user can then select the project they wish to login to and from this the application and extract the database name from the "projectDB" table in the "AppADB" database. I then can store this database name in my application and when the application needs to connect to the database it modifies the connection string to connect to the respective database.
View 1 Replies
Apr 8, 2009
I am making a program that will take your initial balance of your checking account and then you can enter your checks, deposits and withdrawls into a database. Then The option will be given to return a report of deposits, withdrawls, etc. Well, I am having the problem with creating a database I can open when the program runs, first time to get the initial balance, and after to tell current balance. Then, I need to just keep on adding the new checks, deposits, withdrawls to the database everytime the person uses it. So, say I used it and put in 5 checks and then a week later I use it and put another 5 in. I want to be able to give a report of all the checks that have been inputed (this example is 10) back out to the user. So, essentially my question is, I guess, how would I create a database in VB 2008 that I can keep adding to it everytime it gets used?
View 1 Replies
Sep 26, 2010
We've got the following scenario:
Central Database (replicated across multiple servers)
Client Database 1
Client Database 2
The Central db has Users and Roles amongst other things The Client dbs have similar tables to each other but with some fields tweaked - contact, address, At present, each client db has its own user/role information which is copied from the central db by a scheduled process. I want to retrieve the user/role information directly from the central db instead (bearing in mind tables in the client db make reference to the user entity)
View 1 Replies
Oct 20, 2009
I'm writing a little Database administration program.It works fine if you give the db, but not when you don't know which db is installed.How can I enumerate all running databases?
View 4 Replies