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

Split Large App To Smaller Exe With Dll's?

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

.net - Split A Large File Into Smaller Files?

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

Split An Array Into Multiple Smaller Arrays?

Apr 9, 2010

if its possible to split an array into multiple smaller arrays?

View 7 Replies

Split An Array Into Two Smaller Arrays At A Given Index?

Mar 4, 2012

I want to split an array into two smaller arrays at a given index?

View 5 Replies

Split Word File Into Smaller Files?

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

Split Binary File Into Smaller Byte Blocks Like 1MB?

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

Saving Replicated Data - Current Data Saved To Appear In Page Within All The Relevant Fields?

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

Looping Through RTF Box With Tabular Data?

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

Alternative Way Of Presenting Tabular Data Aside From DGV?

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

How To Represent Data In A Tabular Format

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

Display Data In Tabular Form For A Text File?

Dec 26, 2009

code that can display data in tabular form for a text file. vb 2005

View 3 Replies

Store Tabular Data Locally On User's Computer?

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

Forms :: How To Split A Large Application

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

VS 2008 Split A Large Txt File?

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

Download A Pdf File And Import The Tabular Data Into Access 2007 Database

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

Program A Simple Web Browser That Can Search For Keywords And Store Relevant Data In Another File?

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

Best Practice - VB Projects - Using Such A Large Database With Many Tables

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

C# - Split A String And Update Muliple SQL Tables?

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

.NET Data-type Smaller Than A Byte?

Jul 9, 2010

How about a Nibble etc.

View 3 Replies

Vertical Scrollbar Getting Smaller, But No Data Is Shown In The Listbox?

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

Timeout Using SQLite - Create A Database And Several Tables - To Populate The Tables With Data From Arrays

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

Use Datagirdview In Tabular Form?

Feb 26, 2010

i want to use datagirdview in tabular form

example:

Left Right
Normal Yes No
BGDR No Yes

View 1 Replies

ADO To .net Recordsets - Pull Data From A Table Once Then Split The Data With A Filter

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

XML Code To HTML Tabular Format?

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

Adding The Fees To The Relevant Textfile?

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

DB/Reporting :: Unable To Come Up With Any Relevant Documents

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

How Do Others Search For Relevant Info In Web Searches

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

Open File In Its Relevant Application?

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

Serial Data - Split And Show Data?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved