VS 2008 Convention For Using A DataTable With Multiple Forms
Mar 15, 2010
So, I'm trying to do things according to accepted convention as much as possible.
I have a DataTable that holds data that is read in from an XML at the launch of the program. This DT contains data about folders that are added by the user. It is primarily accessed by a single form, but another form used for Adding/Editing folder data will need to update it.
So, what is the best way to handle this: Currently the DT is created/maintained in the main form (FolderPad) that uses it. Would it be better to put the DT in a public Module for access, or allow the add/edit form to access the reference to it in FolderPad? Or is there a more accepted way to do something like this?
View 2 Replies
ADVERTISEMENT
Jan 28, 2011
VB2008 & mysql
Is it possible?
If so how?
Wanting to have multiple datagridviews showing unique information (via filters?) based on cell content all coming from one data table.
Example:
3 datagridviews accessing the same datatable that has a [Job Status] column limited to one of the following 3 entries NEW, JOBS IN PROGRESS or COMPLETED and having that column hidden from view on all gridviews
Top grid showing only NEW jobs
Middle grid showing only JOBS IN PROGRESS
Bottom grid showing only COMPLETED jobs
View 7 Replies
Jun 5, 2012
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
View 15 Replies
Mar 15, 2010
Im very new to programming all together, but Ive recently been messing around with Visual Basic 2008..
1. When using multiple forms, how do I make a form be the form that opens with the program (default form?)?
2. How do I assign a button to open a second form?
With what I'm trying to make, I have both forms ready, I just need form2 to be the one that is the first to open when running and I need the code for a button to open form1.
View 7 Replies
Aug 6, 2011
I have a VB Solution with a dozen forms trying to implement invoice system.My main form (Say Form1) only has a design to create , Edit or Delete Customers.My form 2 will be opened if Create button is clicked. In my form 2, I have textboxes where user can enter Customer details and click on SAVE. My doubt is here....On clicking this SAVE button in Form 2, I want a INSERT command to happen on the MSAccess's Database table called Customer (which I have already created... this table does not have any records as of now). In my form 1, I added a MSAccess Database with a Connection String. In my Form1's code I have code like this[code]...I got this piece of code from this link [1]: vb.net - sharing mdb access connection among multiple forms/Now, I do not know what more code does this require to INSERT records from my text box into the Customer table's fields.
View 1 Replies
Dec 24, 2011
I'm trying to make a string inputted on a separate form's text box adjust the value of a string on another form. Is there a way to do this rather than exporting the data to a file and retrieving it on the other form?
View 7 Replies
Nov 4, 2010
I have used CSV files before for a simple database of about 12,000 items - this was a simple one page form... Now I want to have the same database but with the data available to multiple forms at the same time.. eg.. Form 1 displaying persons 1,2,3,5,7 name, addy, phone etc and form 2 pulling info for persons 2,3,4,8... Is this possible with CSV files?? or even XML?... The only other thing is that I do it all in .NET 2.0....
View 3 Replies
Dec 12, 2010
I am trying to display(in a status strip label) the user name of a user that is currently logged in across multiple forms. The initial form is a log in screen that queries an SQL database for the user name,password,and user type. If the query returns a match,then a different form is displayed based on the user type. How do I retain the user name of the user that is currently logged and display it in the label?
BTW,it's a point of sale program.
View 5 Replies
Jan 25, 2012
I have a class (let's call it foo) that has several public properties.
private _fee as object
private _fie as object
private _fo as object
[Code]....
So far this seems to work... I'm just worried that something might get screwed up scope wise.
What is the normal way someone would name the constructor variables in a class like this?
View 9 Replies
Apr 4, 2011
In a label box, I want to list a couple of websites, email address along with some text. How do I go about it?
Potential uses- As a Help > About dialog box where websites, email of the author can be listed.
To make things as easy as possible for the user, and encourage visiting of the mentioned websites.
Simple text will be ignored, while standard blue color, underlined text with hand mouse-cursor will need no thinking on user's part.
View 1 Replies
Sep 16, 2010
What is the most commonly used convention (in C# and VB) to name object, when I want to emphesize that it is an instance of class that implements some interface. Like here:
//is iDisp correct name?
protected void Dispose(IDisposable iDisp)
{
iDisp.Dispose();
Console.WriteLine("Disposed");
}
View 4 Replies
Oct 3, 2010
I addressed a meeting and used the following....she worked there for 17 years.I was corrected later that it should have been 16 years.I argued that the first year of this persons employment was 1966 and her last years work was 1982. Therefore 17 years.Does someone have an articulate mathmatic reasoning that explains dealing with inclusive numbers.
View 12 Replies
Jun 11, 2008
I am trying to convert visual basic 6 code to vb net. How do you in Visual basic .net get the universal naming convention.
View 8 Replies
Nov 26, 2010
In the past when I have written classes and constructors, I named the variables in the constructor parameter something different than what would have been stored in the actual class itself.What I do now is name them the same, and reference the internal variables with Me.varname.Here is a class I just started building.Is my naming convention incorrect? [code]
View 1 Replies
Jun 16, 2010
How can I link to a file automatically based on some naming convention , example the application should link to a pdf file when it finds like the below combination : " ...... some text .... ammended by Rule 80/85 published in 05/12/2000" so the application should link to the file named R_80/85_05/12/2000 (R for Rule) if the file is available it should link if not it will stay normal
View 3 Replies
Jun 13, 2008
I have run across exam ples of how to create code for getting the universal naming convention for mapped drive in VB6 and access but that don't work in VB net.
View 4 Replies
Apr 4, 2012
the question is really what is the correct convention (style) for raising and handling events. When a button is clicked it is generally handled by this method. [Code]
I have recently been trying to follow this convention by creating my own EventArgs class and inheriting the system.eventargs, Then adding my own properties. The problem is as my projects get bigger/complex I seem to be writing multiple eventarg classes. I then decide to try and create a generic eventarg class but this then seemed pointless thinking it would be easier just to pass the object directly instead of wrapping it up in "someEventArg" i have created.
View 4 Replies
Apr 9, 2010
I have the requirement to create an application that has multiple front ends developed using Windows Forms, WPF, ASP and Compact Framework Mobile Forms.I would like to be able to create a series of obejct representing the business logic and have this logic accessible from the various front ends available. My first thought was to use remoting as I'd like to be able to pass the business objects back and forth between client and server but the compact framework doesn't support remoting and also transferring a full framework business object to a compact framework business object doesn't seem possible.My next thought was to use web services but again the passing of business objects seems to be very hard to accomplish. Without doing this I would have to create individual web methods for each business operation.
Finally my next option is to use sockets and write the whole client/server logic within some classes and expose them to the UI/Business layer. My only problem with this is it is not scaleable should the number of clients increase dramatically whereas using remoting or web services I can host the solution via ASP.Net.Does anybody have an ideas on the best way forward for this or even have any input on how they would write an application that required a windows form, wpf, asp website and mobile device GUI all of which want to use the same business logic?
View 3 Replies
May 25, 2010
I have googled high and low to find an answer to this but I must be searching wrong.I have an application which has a listview displaying some items that are stored in a SQL Compact database. I am using a second form to add new items to this list directly into the database.When the second form closes I want to call the sub in my first form to refresh the list from the database.
How can I get it to fire the form1 sub routine on the close event of form2
View 3 Replies
Nov 3, 2009
i was doing a fair amount of programming many years ago, like 10 it feels like, so I'm sorely not up to date on how my newly downloaded Visual Basic Express expects me to communicate with it.I am writing a program that pulls a cell from a database after the user has gone through several forms to determine which cells they want. When I write it like that, it doesn't sound very efficient, but I've designed it this way for usability.Here's where I have a problem: Should I store the path the user takes in a string, an array, what?
Here's an example:Someone wants baseball stats and trivia. They run my program, main form pops up, they select National League button, the NL Form pops up. Now the way my program is set up right now, is there are two ListBoxes on the form, one is populated, and as the user selects a Team from ListBox1, it jumps to ListBox2. Once they've selected all the teams they want info for, they click a button Next.
What I now need the program to do is show the next form "Team: name" once for each team, and insert the name of the team on the form in the appropriate label which I'll have blank. This form will also do the Listbox thing except the first listbox will populated with Topics like HR Stats, Pitching Stats, Coach History, etc.
View 1 Replies
Mar 16, 2011
Is there a way to nest a datatable into another datatable? I know you can do this with gridviews but thats not what I'm looking for.
Also, I don't want to merge the datatables. What I'm trying to do is have a datatable with 2 columns and each column containing different datatables.
View 7 Replies
Jun 19, 2010
am new in crystal report, here wana to add 2 datatables in the crstal report' Private Sub btbPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btbPrint.Click
[Code]...
View 1 Replies
Jan 23, 2011
Here is my [code]...
My textbox (txtCopies) default value is 1 so naturally, as it is coded above, the datarow is added once into the Movies Table. But what I need to know is how to code if the txtCopies field has a greater integer value.
View 6 Replies
Apr 6, 2012
I am using Microsoft Access database. Since Access Database Table cannot have more than 255 columns, I am using vertical database partition technique where I have splitted informations into 5 different tables. Each table has 100 columns, and first column is primary key. Now I need to read data from these five tables so that I can export it into Excel file.
[Code]...
View 2 Replies
Jun 6, 2009
How to create datatable with multiple records.
View 6 Replies
Mar 4, 2009
I am using VB.NET 2005. I need to know if I have some data values in a Datatable consisting 4 rows then is it possible to insert all these rows into a Table of a Database using a single INSERT statement?
View 7 Replies
Feb 2, 2012
I am trying to merge multiple datacolumns in a datatable. Eg. The address data is stored in a different columns such as, Housename, street, city and postcode. I want to merge those datacolumns in to one and put it into one datacolumn as "Address".
View 1 Replies
Jun 22, 2010
is there a way i can get my datatable to have multiple constraints that are attached to a unique id? an example of what i'm talking about is if i have a unique machine but it's on many lines, can i show that somehow in a datatable? the reason i'm asking is that i have code that sorts the data by line number and shows the relevant machines in a combo box based on the line selection out of another combo box. i'm having to input the data into the datatable (as a starting point for the data base) and it's very tedious. i'm entering machines that have the same name in multiple rows because the line number is different. i can't figure out how i can add multliple values into my line number column so that it will sort properly when queried.an example of what i'm asking with regard to the datatable is as follows:
Machine LineNumber
slicer Line 1, Line 2, Line 4
conveyor belt Line 1, Line 6
So that when called to fill the combo box, the correct one is called.The code i'm using to sort right now is as follows:
Private Sub linecbo_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles linecbo.SelectedIndexChanged
Dim cline As String
[code]....
View 3 Replies
Mar 23, 2011
If the application is used with multiple users/instances adding records to the same database, whats the best practice for doing this and not incurring any conflicts with primary keys. Right now my partial solution is to do a tableadapter.fill before adding a new row to retrieve any new records. But this obviously isnt the best practical solution as the likleyhood of a conflict still exists when letting the apllication increment the key.
Whats a "correct" way to do this, any reading or examples would be great for me to learn.
View 2 Replies
Aug 2, 2011
Unable to select multiple column in datatable [code]....
View 3 Replies
