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 RepliesI have two forms and I am running a sql query to provide a set of variables in my first form that I need to pass to my second form. Here is the code that I have:[code]to form 2 which then shows the data retrieved from a sql query in the load event to a datagrid view.
View 19 RepliesI 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]...
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 Repliescode that can display data in tabular form for a text file. vb 2005
View 3 RepliesI 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?
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.
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 RepliesThis should be easy: If I have an Integer with the value 2043312, how can I convert it to a String that shows it as 2,043,312?
View 4 RepliesIf I have a form in my application that has a datasetview and allows users to edit entries, how best can I present the information back to them to show them the changes that they've made, and ask them to confirm changes?
View 3 RepliesWell this listbox contains sensitive data not very important but i dont want the end user to be able to see what the listbox contains, therefore i have hidden the listbox But my question is how do i store this information i could easily write it to a text file i know but the user could locate the text file. So i attempted to create my text file as a resource and that failed as i can read from it i cant write to it. More simplistic question. I have data i need to save from a listbox but if i save it as a text file the user could still access it and i dont want the user to be able to acesss the file i would like it to be internal because i also dont want the user to be able to delete the file?
View 7 RepliesI have a search function on my company's website (based on .NET 2.0) that allows you to narrow the product catalog using up to 9 different fields. Right now, after you make your selections on the frontend I am building a dynamic query and hitting the database (SQL Server) to get the resulting list of items numbers. I would like to move away from hitting the database everytime and do all of this in memory for faster results. Basically a 3500 - 4500 row "table" with 10 columns: the item number (which could be a primary key) and the 9 attribute fields (which have repeating values for many many rows).
There can be any number of different searches between the 9 columns to get the items you want:
Column A = 'foo' AND Column D = 'bar'
Column B = 'foo' AND Column C = 'bar' AND Column I = 'me'
Column H = 'foo'
etc...
Based on my research, the .Select() function seems like the slowest way to perform the search, but it stands out to me as being the quickest and easiest way to perform the narrowing searches to get the list of item numbers:
MyDataSet.Select("Column B = 'foo' AND Column E = 'bar' AND Column I = 'me'")
In my specific case, what method I use as an alternative that has the same narrowing functionality and better performance instead of settling for the datatable.select() method?
i want to use datagirdview in tabular form
example:
Left Right
Normal Yes No
BGDR No Yes
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].....
For example
month1 month2 month3 total
district1 5 2 9 16
district2 1 0 11 12
total 260 150 140 550
Here final total is not much important. But at least I need to show count per district per month.
SELECT Districts_mst.district_name,COUNT(Payments.PaymentId)users ,DATEPART(M,payments.saveon)Month
FROM Payments
JOIN Subsciber ON Payments.SubId =Subsciber.SubId
JOIN districts_mst ON districts_mst.district_id = Subsciber.District
where lang_id=1
group by district_name, DATEPART(M,payments.saveon)
Which give me list like.....
district_name users Month
dist0 1 1
dist1 1 11
dist2 3 11
dist3 1 11
dist4 3 11
dist5 1 12
dist6 1 12
I've created an app (VB.NET) where each installation of the app works with a single local database on the PC. No multiuser and no ability for the user to change databases - the database is effectively part of the app, with a fixed scema, only the data will change.At the moment the database is SQL CE. It has about 30 tables with some simple relationships between the tables.
I'm wondering if there is an alternative to SQL CE that might be faster in this scenario. Although SQL CE is excellent and easy to use, I get the feeling there is perhaps an unecessary overhead when using it for something simple - and it does seem a little slow when my app is doing complex stuff that interacts a lot with the DB. In my prototype I actually loaded the 'database' tables from text files into Arrays and developed subs and functions to perform the database searches etc. It was blindingly fast but I realised it wasn't a scaleable solution because it was an 'in-memory' database. A compromise would be to 'page' data into array when needed, but it all gets horribly complex and that's probably why some very clver people have created SQL CE !
Using VB.net, I have a namespace which I'd like to rename for the future. However, I'd also like to keep the old obsolete namespace for a time to ensure backward-compatibility for our consumers for awhile. Is there a way in .NET to have two namespaces, one ordinary and one that merely is an alternative name for the other?
[Code]...
From the WINDOWS Date & Time settings FORM is this accessible as an alternative
View 1 RepliesBelow is the code for a linked list search I have tried to implement in to searching through each of the elements of htmlelements .For some reason If element.InnerText = (item) will only work if if is only a string ("example") .Are there any other ways of Implementing the for each loop to search through my item linked list?
Original code for searching for 1 string
Private Sub block()
Dim elements As HtmlElementCollection = webBrowser.document.All
Dim word_found As Boolean
word_found = False
[CODE]...
This is the Loop for item I have tried to implement but is not working ,because of the for each loop .The value of element.Innertext = "" or null when I try to use one of the linked list item[If element.InnerText = (item)] is used and only have a value when a string is used to [If element.InnerText = (google)]
Private Sub block()
Dim elements As HtmlElementCollection = webBrowser.document.All
Dim word_found As Boolean
word_found = False
Dim item As LinkedListItem = words.Head
[CODE]...
I've encountered a problem in a application that I inherited. It contains a combo box that loads information.The problem is that there are more data that the control will hold (32767
View 2 RepliesIs there an alternative to Uri.EscapeDataString? I'm trying to upload an image, by converting it into a base64 string, but I need to use Uri.EscapeDataString on it first, and if the image is big then Uri.EscapeDataString will say that the URI is too long.
View 2 RepliesMy clients web application is using TidyCOM to clean up dynamically created XML files from a SQL database query. With this TidyCOM, they are not able to upgrade the web application to .Net 4.0 framework. Is there an alternative to using TidyCOM so that these dynamically created XML files are validated correctly?
View 1 RepliesWe heard a lot about the vulnerabilities of using QueryStrings and the possible attacks.Aside from that, yesterday, an error irritated me so much that i just decide to stop using QueryStrings, i was passing something like[code]....
View 8 RepliesMy VB application also needs to manage simple appointments in an agenda, however one user has no MSOutlook. Someone knows of an alternative calendar tool, with which I can do this?
View 2 Repliesis there an alternative for timer?
View 4 RepliesSo I've been doing a lot of reading today and apparently SendKeys isn't very reliable anymore.Does anyone know of another alternative to it for what I need:
The application works by the form being positioned over a open window, notepad, word, excel etc and it then determines what it is over, notepad, word, excel etc and then reads the file, and does some processing using SendKeys at the moment.Though I do believe I could probably change the later at some point. The problem I'm having right now is when I try to send the Alt + Tab to change focus it's working roughly 12% of the time.If you are wondering I ran it 50 times and it worked 6 of those,thus the 12%.I'm thinking that is rather unacceptable.This is what I'm using which should work: SendKeys.SendWait("%{TAB}")
XP Service Pack 3 and vb.net 2005
First off, using VB2010. I'm in the process of upgrading some applications from VB6 to 2010 and haveing a great time of it. The current application I'm working on is using Sendkeys of which I have changed over to the WSH.Sendkeys of which is pretty decent. Basically the program is copy and pasting the current open file, reading some data and saving it as a different file type. It also has to change xls files to csv and then saving it to the format as well as a smiliar thing with word. Thus the reason for the copy and paste as it's changing the extension to a dot date (for example, test.830).This is the flow of how it works for a text file (most basic)
1. changes focus to notepad
2. Select all Copy to ClipBoard
3. Open Programmers File Editor and a blank file
4. Paste in text
5. Save as code.date extension to the directory
Excel files obviously have a few extra steps.
I need a good alternative for System.Web that is included in the .NET 4 Client Profile. Currently all of my frameworks are included in the client profile, except System.Web. What is a good alternative?
View 7 RepliesI have an MDI Windows Forms application (.net 2008) that allows the user to associate various file types with the application. I currently do this with a registry entry something like this, that causes the application to load and access the file name via the command line:[code...]
In the pre-.net version of the application, I used DDE (ddeexec in the registry). If an instance of the application was executing when a file was double-clicked in Windows Explorer, it would open the file without starting up a new instance of the application.
Now that DDE has been deprecated by Microsoft, what is the best way in .net for an executing MDI application to open an additional file when the file is double-clicked in Explorer, as opposed to starting a new instance of the application?
I'm running Visual Basic.net. I used to use the INKEY command, available in older DOS versions of Basic, to allow the user to change the flow of a program by touching a keyboard key. It seems to be available only in Visual Fox Pro. Is there an alternative for Visual Basic?
View 4 Replies