Split A Large Set Of Tabular Data Into Smaller Relevant Tables?
May 11, 2011
I'm really hoping I can describe this question in an understandable way. This is a puzzle that I have not been able to begin to solve even though I (mostly) understand it. I'm just not sure where to start, and I'm really hoping someone out there can get me headed in the right direction.
I have a LARGE table of data. It describes relationships between objects. Let's say the Y-axis has items numbered 1-1000, and the X-axis has items 1-1000 also. If item #234 on the Y-axis is related to item #791 on X, there will be a mark in the table where the row and column cross. In some industries this is referred to an a Truth Table. One can, at a glance, see how many items in a system relate to each other. The marks in the table can help to identify trends and patterns.Here's some other helpful stuff about the nature of the table:
The full range of the number of relationships (r) for each item on either axis can be 1 <= r <= axisTotal.The X and Y axis will share common items, but each axis will also have items that the other axis does not.Each item will only exist once per axis. It can be on X and Y, but it would only be on each one 1 time.The total number of items on each axis will most likely NOT be equal. Each axis could have from 50 to 1000's of items.
The end result is that this is going to be a report that needs to be printed. We have successfully printed a table that had about 100-150 items on each axis on an 11in X 17in piece of paper. Any more than that and it begins to be so small it's unreadable.
What I am trying to do is split the super large tables into smaller tables, but related points need to stay together. If I grab item 1-100 on X then I would need each item they relate to from Y.I've generated a number of these tables and, while the number of relationships CAN be arbitrary, I have never seen an item relate to all other items. So in real practice the range is more like 1 <= r <= (10% * axisTotal). If an item's relationships exceed this range, it can be split up into multiple tables, but that is not optimal at all.
At the end of the day I think we, and our clients, would be happy if a 1000x1000 item table was split into 8 to 10 printed pages of smaller, related tables.One other thing worth noting, there will be no empty rows or columns in the table. Every item on both the x and y axis will relate to at least 1 item on the opposite axis.
View 2 Replies
ADVERTISEMENT
Aug 3, 2010
The exe can call functions and forms in the dll's that are part of the solution BUT is there anyway
for the dll's to access forms, dataset's etc in the main exe project?
It doesnt appear that it works that way.
I forgot to add this is a VS2005 application.
View 3 Replies
Oct 8, 2011
I have a large file (2.7GB). I need to split it into smaller files. How to split a large file into smaller files using VB.NET 2003? Cannot use LINQ and the resources (cpu and memory) on operating environment are very limited (it is a shared hosting environment).
View 1 Replies
Apr 9, 2010
if its possible to split an array into multiple smaller arrays?
View 7 Replies
Mar 4, 2012
I want to split an array into two smaller arrays at a given index?
View 5 Replies
Jan 30, 2012
I've a word file i open using the word object library.... now i need to split it into a number of files divided by the numbering, ie the file is in the format[code]...
View 3 Replies
Jul 3, 2009
Im working on a FTP Server (File Transfer Protocol) where i can download files.The problem occoured when i was about to download a 4BG large file from the server when i only had 3GB RAM on the server computer and the function to read the binary files was " data = File. ReadAllBytes("Files File001.7z") "... so how do i split the binary file into smaller byte blocks like 1MB?I've been trying this which seems to have been a total failure.[code]
View 11 Replies
Jun 2, 2010
What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
View 2 Replies
Feb 22, 2012
I need to be able to copy and paste data from a spreadsheet that may be an .xls, .xlsx or .csv into my app. Then once the data is pasted in I need to do some parsing and saving to an Access database. So I put a RichTextBox control on my form and put the following code in a command button to get the data into the textbox. Will this work as is to allow me to get to the values? And if so, can someone show me a little snippet of how I can get to the values? And if this approach is wrong, then how do I go about this?
[Code]...
View 8 Replies
Dec 13, 2011
What is an alternative way of presenting tabular data aside from DGV? I tried DGV but i cant seem to populate the DGV automatically using datasets. Is there a way to manually place my data on the DGV using the read.Item("column1")?
View 5 Replies
Feb 8, 2012
i can retrieve the data from the DB and put it in a vector and then, vector in a JTable, to display data in a tabular format in java, all i wanted to know is there any similar way in vb dotnet?
View 4 Replies
Dec 26, 2009
code that can display data in tabular form for a text file. vb 2005
View 3 Replies
Feb 1, 2010
I am currently developing an application that will require each end user to specify a rather large set of tabular data specific to his/her own preferences. Each time the user starts the application, it will load this set of data.
what is the best way to store this data locally on the end user's local machine? Should I use XML, Access mdb, flat text files?
View 2 Replies
Mar 17, 2009
I have a large financial application which I am migrating to VB.NETIt has two main components: charting and financial statements.I want to know if it is possible (and how) to create a main exe, and then two separate projects for the two components (as dll's?).
View 3 Replies
Mar 15, 2012
I have a large text file which I want to split into many different items.
On the next file I have a time between each item it's like this
01:20 a.m.
01:44 p.m.
In between these items is information like you would see in a log file.
How can I split these items like this?
View 13 Replies
Sep 21, 2009
how could we download a pdf file and import the tabular data into access 2007 database, i have tried and got successful in downloading the pdf file from an URL, but not able to import the table data into access 2007 database/or may be an excel file through a VB6 program.
View 1 Replies
Aug 19, 2011
Hi, I need to program a simple Web Browser that can search for keywords and store relevant data in another file.I am facing a problem with authentication, mainly cookies and maintaining a session.So I read that Web Browser Control is based on I.E.? So may I know how are cookies and session handled?Do I have to implement them manually or are they stored and retrieved from the same folder as the one used in I.E? If so, if I delete the I.E.'s cache, am I also deleteing the cache of any Web Browser I make using Web Browser Control?
View 2 Replies
Feb 21, 2012
The Adventureworks database is used extensively for tutorials in Visual Basic applications. This has many tables that can be bound to a solution. What I would like to know is, when using such a large database with many tables and using lots of them, is it better to construct your program with a number of projects all under one solution or to put everything into a single project. If you use a number of projects, what is the syntax for accessing each module from a menu strip in your main form? I know how to do this in a single project - all you do is Form(x).show. In Adventureworks, you have a table for Employees that could be put into a single project with a number of forms - one for data entry, one for displaying all of the employees, a filter to a single employee, etc., etc.
If two small projects rely on each other for some reason, again the syntax for linking them could be an issue. Would it be better to combine them into a single project? My reason for asking is that I would feel safer if I created an application on a project by project basis and then brought them all together in one solution. This way they can be tested individually and then linked together where necessary. Making a disastrous mistake in one then only requires a small re-write rather than the headache caused by a total crash of the whole solution. I would like to know which option professional developers take. I am using Visual Studio 2008 Professional and SQL 2005 Express
View 5 Replies
Jul 27, 2009
I have an Article object with the following properties:
Article Name (varchar)
Article Body (varchar)
Article Tags (varchar)
The Article Tags is a space delimited string of text values that a user has tagged the aritlce with. The 3 properties are passed to a stored procedure.
I now want to do the following:
1) Insert the Article Name and Article Body in the dbo.Articles table and return the article id
2) Insert each value of the Article Tags string in the dbo.Tags table as a separate row but first check for duplicates. If duplicate then return the tagid of existing record, if new record then return the new tagid
3) insert the article id and each tagid as a separate row in the dbo.TagMap table
I need to know the best approach to how I would accomplish this, also being conscious that it does not cost too much in performance.
View 2 Replies
Jul 9, 2010
How about a Nibble etc.
View 3 Replies
Jan 9, 2009
I have been working on a much larger project and came to a point where I decided threading should be used.It seems in previous version of .Net, a background worker was able to update controls that were were not created on that thread. Now, it doesn't seem to be the case.I basically just began a new small project to try and teach myself the basics.Form1 Consists of A listbox, A progress bar, a label and two buttons, one to start and one to cancel.
imports system.threading
private sub btngo(byval sender as system.object, byval e as system.eventargs) handles btngo.click
pbprogress.minimum = 0[code=....
This code appears to be updating the listbox.I can see the vertical scrollbar getting smaller, but no data is shown in the listbox. The progressbar is also updating properly while that is working, indicating proper background operation.But what it's not doing is this:
1. Label is not updating percentage
2. The form is not free to be used by the user (me)
View 17 Replies
Jul 25, 2012
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
View 4 Replies
Feb 26, 2010
i want to use datagirdview in tabular form
example:
Left Right
Normal Yes No
BGDR No Yes
View 1 Replies
May 22, 2010
I am trying to learn the new methods in .net, but, I cant see a way to step through the data like you can in an ado recordset. I want to pull data from a table once, then split the data with a filter, then step through the rows gathering the dtata till eof. Clear the filter and reset it for the next batch.
View 1 Replies
Jun 4, 2009
I have a table of values that I have being saved into xml, but I need the data to be formatted for the user to view as a compiled data view of all the tables the program generates. I'll give an example:
Rev
Number of
Discs
[code].....
View 4 Replies
Dec 20, 2011
I have a project that is used as management for a YouthFootball Team. Part of this is adding training fees and keeping track of who has, and has not paid.This part of the project is adding the fees to the relevant textfile.Textfile - Trainingfees.txt
Each line looks like - player name|number of sessions attended|amount paid I have a form with a DataGridView. Each row is populated with: Checkbox Column, Player name in textbox column, blank textbox coloumn The user then ticks who attended the training and how much money they paid in that session.
I then have this code to loop through the DataGridview and add call a separate function that adds the relevant information to textfiles.
[Code]...
View 6 Replies
Apr 27, 2008
I have created a web application that is used within our company to track our inventory.What I would like to do is create a windows forms application that I can distribute to certain managerial staff with some additional functions.I have tried googling this, but am unable to come up with any relevant documents. What I need is some direction on how to implement login through my windows forms application that will validate login against the ASPNET_DB so that the same roles and logins can be used.
View 1 Replies
Dec 14, 2011
The help in visual basic express 2010 directs me to the web,My searches often pick up info on C pgms and VB 6 etc.I have been adding VB 2010 to each of my searches.e.g. Format vb 2010.How do others search for relevant info in these web searches.
View 4 Replies
Feb 4, 2010
I'm a relative newcomer to VB.NET so please forgive any lack of knowledge.
I'm writing a web application that lists the contents of a directory in a listbox and then (in theory) opes the file that the user clicks on.
What I'd like to do is open the listed file in it's associated application (so if it's an excel file, open excel; if it's a notepad file, open notepad).[code]...
View 10 Replies
Jun 25, 2009
I am using Visual Basic express to create a serial interface to a multi-room audio controller. I have started by creating a form that can connect to the controller and I can type commands into a text box and have set up a button that sends that text to the serial port. This text is displayed in a big text box as well as the feed back from the serial port (multirom audio controller).
Here is an example of what I send and receive to and from the controller;
I send *Z01STATUS (query's the Zone 1 status of the controller)I then receive the data from the controller #Z01PWRON,SRC4,VOL99 (This tells me Zone 1 is on, Source 4 is selected and the volume is at level 99 I can easily create buttons to turn the zones on and off and control the unit. My problem is I want to make things change on my form coresponding to the data received. ie I want to display the current volume of each zone and whether thetay are on or off etc. How do I get the individual bits of data from the data received. IE how do I get the VOL99 to show 99 in a text box?
View 10 Replies