I originally posted this to the XML forum and it was suggested that I post here to see what other options might be available. The complete post is here. [URL] Wondering if someone can offer me some advice on a suitable solution for an application I'm developing. I've used xml and text files in VB.net fairly extensively for storing configuration files and the like but I'm wondering if there
[Code]...
Needs to be a component of some sort. No additional installation needed.The datastore needs to be on the local hard drive.I am using VB.Net for a desktop app running Windows XP through 7 so it needs to callable by that environment.It needs to replicatable. If I have four copies of my app running on the network, each local copy of the datastore needs to replicate with the others. As close to real time as possible.
View 3 RepliesI have an application that generates a excel file using a datastore data.It was all working fine till the user asked me that he wants choose the location and name for the new file.I tried to use the html control file field, but it works only wth a pre-existing file. Then i tried the following code :
Dim fdlg As System.Windows.Forms.OpenFileDialog = New OpenFileDialog
fdlg.Title = "Escolha a localiza��o para a grava��o do arquivo excel"
fdlg.InitialDirectory = "c:\"
fdlg.Filter = "Excel Files (*.xls)|*.xls|Excel Files (*.xlsx)|*.xlsx"
[Code]...
It seams to work, but the browse window, does not appear. After sometime i realized that it opens, but behind the bowser, and it does not work since the buttons and windows does not appear.
Am Developing a program that requires alot of questions on a database. each question have four options in answer. one of the four options is .is the correct answer. i need idea on how to arrange the question and four answer options table in access. do i need different access database for the question and each of the answers options.?
View 2 RepliesI'm using the code from the following site to create a file manager within my app: [url]Which, I think is great. When I first started programming, I wanted to use this code, but I couldn't understand it. I love how now, I understand most of it and know how to implement it. Which, I owe much of my progress to some of you at this site Well, back to what I was saying. I want to be able to make a right click menu and have it access options like copy, paste, etc. I'm sure I can figure that out, but I can't seem to figure out how to make a right click menu.I thought I could manipulate a menustrip, but I wasn't sure how.
View 3 RepliesI 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.
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.
Have Two Text Boxes one for "user name" and the other for "password" and also have a MS Access database with three coloums "UserIdNum" which is an auto num, "UserName" and "password" i want it so when i click one button "create user" it adds the data from the two textboxes to the two coloums "UserName and Password". At the min got it working so it adds the "User name" textbox to the "UserName Coloum" but cant find soloution for password.[code]...
View 4 RepliesI don't know if is possible to make multi-form with vb.net & access.
I don't have code from now.
Actually I want to make a project, to assign a new form (one form with one table) to a new person for each time, it will be multi-form with tables, right?
How do you to make a new forms with tables?
This project is about the admin to assign the jobs to managers, so the managers will use same blank new form and to manage jobs, it is the room setting for multi-manager.
1. how to save the multi same form values with vb.net & access?
2. One of the combobox - room names (computer center, first meeting room, second meeting room, etc) on this multi same form, but it is limited from the admin, actually,the admin will assign the room to the manager to set the room. (I will do this room names combobox from the other table binding.) My question for this, is possible to have multi same form, but with different combobox values for each manager?
The first list box contains the project name. Based on whatever is selected in the Projects list box, the 2nd list box is generated with Custodian names associated with that project. I am having problems generating the 3rd list box. This holds the data sources associated with whatever is selected in the 2nd list box (Custodians)
View 1 RepliesI have been using access for my applications from over 4 years now. I realize its time to move on now and i need suggestions for a new database. Here are my requirements :should be able to connect it with Vb.net windows form frontend GUI - all database functions such as add/delete/edit/update will be done through the vb.net front-end only.Should be able to place the db on LAN and each client on the LAN can then access the centrally stored db through their individual front-ends.At the most 5-6 users will be reading/writing to the database at the same time , so the database should not crash or slow down Since i come from MS access background, i would like something thats similar to it so that i can learn and adapt to it quickly.Not very important, but i think its worth mentioning. This db will be the main central db for my .net application.My .net application will also be interacting with quickbooks and magento via some apis but ultimately all this data will go to the central db. So just curious, will there be any compataibility issues with the database that you suggest Should handle about 10 tables and around 10k records in each table Should be secure - just that i should be able to lock it up or anyhow prevent it being accessed from anywhere else other than the vb.net front-end.
Lastly, I would prefer it to be free to use if possible but not essential. I realize there are some topics like mysql vs sqllite and on databases, but pls understand i need suggestions for one that will be apt for the purposes i have listed above.
Edit : Just curious - Would i pushing the limits if i still stick to access - i understand access won't be good for multi-user access but i guess 5 users is not much ?
there is a database, containing a table with personnel. in the personnel table there are names and ID'sthere is a second table departemens, containing the names of departements and their ID's.in the third table it says which departement ID and which personnel ID are to be linked,
example
the employee called ruben has an ID 5
the employee called kevin has an ID 10
[code].....
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.
I have an application with 4 threads. (GUI, Controller, Producer, Consumer) The GUI is self-explanatory. The controller starts the producer and consumer threads after some intial setup. The producer creates items and places them in a free slot in a "ring buffer". The consumer takes items from the "ring buffer" and writes them to disk. The producer creates items at a much higher rate than the consumer. The consumer is IO heavy and IO bound. Currently I am checking a variable in each ring buffer slot to determine if it can be written to.
if Slot.Free then
Write Slot.Data To Disk
end if
I am not using lock/synclock instead I'm just reading / writing the value of the slot's "free" variable. I don't believe that is correct even though it is a volatile read/write. Is there a better method to read/write this variable? The variable is of type "integer" and is either 0 or 1.
I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it?
View 4 Repliesi have a database created in access showing in multi text-boxes in visual basic 2008 express edition. the database is showing music information and sales (tune name, artist, sales, and year issued) there are a few processes i want to do but can not work out the coding.1. display the top ten selling tunes in a particular year in order ( the year needs to be selected from a list box and displayed in a list box)
2.display the total sales in a particular year ( year selected from a list box)3. display the tune with the greatest sales in a particular year ( year selected from a list box)
[Code]...
I've got this code
Public Class Form1
Dim m_listener As HttpListener = Nothing
Dim m_asyncCount As Integer = 0
[code].....
I'm adding multi-threading facilities for the first time. I have a function that is wrapped to be run in a separated thread. This function retrieves data (text) from a combobox and it works for sure without multi-threading.
When I call it as multi-threaded, I get the following error when I try to retrieve the data from the cmobobox: Cross-thread operation not valid: Control 'cmb1stBL' accessed from a thread other than the thread it was created on.
It looks like a restriction of thread-safety... I assume that the child thread cannot read from his parent, to make sure that he doesn't change his parent data. So how can I read the data from the combobox? Should I read the comoboxbox data before calling the child thread?
I have a need to build an app that will access about 10 websites and pass data to them, etc.I've read about something called multi-threading when searching Google. I've also seen people say that they use multiple browsers.Which route is better to use? I figure if you have to do some sort of multi-threading that you would access a single browser?
View 2 Replies May i know how to change my below login code to support for multi access level login? So that i can differentiate between manager and normal employees login so that i can enable or disable certain features for different department? I have the below code that can serve as a basic login.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'login code can work
conn.Open()[code]......
i have one project with multiples web services so i created various singleton class thinking in
performance. now i think create one singleton class and that have the instances of my webservices
[code...]
I have a need to build an app that will access about 10 websites and pass data to them, etc.I've read about something called multi-threading when searching Google. I've also seen people say that they use multiple browsers.Which route is better to use? I figure if you have to do some sort of multi-threading that you would access a single browser?Not sure which way I should approach this app.
View 2 RepliesI 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.
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?
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.
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.
I want to know what are the possible ways to print the data using vb.net?
View 8 RepliesI'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 RepliesJust wondering if it possible to save a form. I have a form with dgv and various other user selected options.
Is there a way to save this form on closing so that it will open again exactly as it was closed?