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 RepliesI 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'm trying to format a string to represent a date in a specific format using the Format function but it's return odd results.
Here's an example:
Dim s as String = "01/01/2000"
Dim result as String = ""
result = Format(s, "dd-mmm-yyyy")
result equals "dd-mmm-yyyy" (the format string) very strange.
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]...
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 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 RepliesI'm creating a program that outputs Quotations (and other information relating to these 1. What is the BEST way to read/write from a database (I only really know how to use Access but if XML or SQL would be better, I'm willing to learn). The database needs to be stored and accessed from the same state every time that the program opens. I've tried multiple different ways, both through DataAdapters (in code) to doing it through connecting the database through the Visual Studio GUI. Neither have seemed to work. Other people have told me that using DataAdapters and such aren't the best way, but no one has been able to tell me what this 'best way' is. Also, I need to somehow be able to link pictures in the database - apparently it's not easy to do in SQL?[code]...
View 5 RepliesI'm trying to set up a CLASS to represent a data stream.This is a newbie question so if the answer is obvious, please excuse me.Several of the data items are multiples which I would normally represent as an Array element.For example, in the code below, the element SolarNameplate has up to 10 instances, so I'd like to use array notation.I get errors, and it doesn't work, so I assume I can't do it like below.
QUESTIONS : 1 - is it possible to use an array element in a class ?
2 - is there another way to achieve what I want ?
Public Class SM1PS01
Private _Projid As String '... name or number of project
Private _LogoFile As String '... file containing customer logo[code]...........
What suggestions do people have for a timeslot data structure? I have a number of activities and I'm planning to display them in a datagrid with days as columns and timeslots as rows. This suggests to me a timeslot data structure with 5 properties for the five days (the columns) for every value I want to use e.g. a timeslot ID and the number of slots left.
So.
Property Day1ID
Property Day1Slots
Property Day2ID
Property Day2Slots
Property Day3ID
Property Day4Slots
etc
Then each TimeSlot structure would be for a specific time. say 9:00 and another for each hour after that. Then I'd have a list of timeslot structures that will auto bind against the datagrid. I'm exploring new ground here and as you can see I'm not very clear on what/how to do it?
I have a DGV that is getting data from a sql db. The dates in this db are stored as doubles ie 40025.708681
How do I format this column as Date/Time?
I tried but this doesn't seem to work.
how to do this? DGV1.Columns("HostDate").DefaultCellStyle.Format = "d"
i want to use datagirdview in tabular form
example:
Left Right
Normal Yes No
BGDR No Yes
This the test example.
Dim dt As DataTable = New DataTabledt.Columns.Add("StartTime")dt.Columns(0).DataType = System.Type.GetType("System.TimeSpan")
[code]....
I'm trying to convert old VB.NET code into C# and I'm not sure about the current line and what it means really.
[Code]....
I know you can put unicode character codes in a VB.Net string like this: str = Chr(&H0030) & "More text"..I would like to know how I can put the char code right into the string literal so I can use unicode symbols from the designer view.
View 5 RepliesBelow is the code I am using to restrict user from entering any other characters except for the predefined ones. But using my code I cannot hit backspace.
How to include backspace also ?
Dim s As String = "0123456789$"
If s.IndexOf(e.KeyChar) = -1 Then
e.Handled = True
End If
i just write code for application, in which data is get by user and entered data is to print in a particular format?give me a code for vb.net button by which after click on it will print entered data?
View 1 RepliesI am reading a pot that has a range of 1000 to -887.I need to convert that numeric value to represent 0 to 1024Where 1000=0 and -887 = 1024.
View 4 RepliesI have a parcel post assignment, and i have three textboxes that represent height, width, and length. here are my questions1. how do i decalre them as integer? do i decalre the textboxes or the labels that represent them?2. how do i multiply all three together and multiply the total by 4pence and add 20p?
View 6 RepliesI'm pondering a design that will require zooming. My intention was to use pictureboxes to represent a variety of items, and I have the code written to draw on those pictureboxes, as needed. However, there will be many pictureboxes on the form at any one time, though only a portion of them will be visible. That shouldn't be a problem, necessarily, as there isn't any issue with having controls that are not on the visible area of the screen. My issue is that when the user rolls the mouse wheel forward or back, the image will have to scroll in or out, which means that the location and size of the pictureboxes will have to scale relative to the point where the mouse is located.
Technically, this would be more easily accomplished using graphics directly, since I can use ScaleTransforms and...uh...one other, to do the scaling. However, I would prefer to stick with the pictureboxes because I will be doing lots of drag and drop work with them (dragging things into and out of them), and that code is already written. If I were to change that to use rectangles and circles drawn dynamically and scaled dynamically, I'd have to use some kind of hit testing to figure out which object I dragged or dropped onto, and where. Therefore, switching away from pictureboxes would require a fair amount of recoding. There really shouldn't be a problem scaling and translating the controls on the form, but rather than writing the math behind that, I was wondering if there were any built-in tools that will do it for me or will help with the process.
In a tic tac toe game I'm working on I have 2 dictionaries (plyrPairs and cmptrPairs) In the program there is a procedure that is used numerous times. The procedure varies with the dictionary that it calls. I'd like declare a variable in a sub procedure that will represent these two different dictionaries. Here is what I have:
Here are the two enumerations:
vb.net
' Assign values to player pairs enumeration
Private Enum plyrPairsList
empty = 0
[Code].....
I am creating a Point of Sale software for a small company I work for. I am a beginner with Visual Studio and have just stumbled my way around. I have completed the GUI and would like to start assigning code. The problem I am having is assigning numbers to a keypad on the screen. I would like each button to represent numbers like on a calulator of keypad. When these are pressed they need to input into TextBox2.
View 6 RepliesI'm working in VB.Net developing data logging software. I've developed classes implementing a common interface that works with many of the data loggers my company produces. These classes handle the low-level hardware interfacing and expose common methods for accessing the data logger's records.
[Code]...
i am working with serial communication in vb.i need to know how to get &h1 to be &ho1 to represent the byte o1 in hex or 0000 0001 in binary.i cant remeber how to parse the byte and represent it with two characters instead of one.
View 8 RepliesI have a theater seating project. I am creating checkboxes in a panel that represent the seats. Each of the rows has a label on it, giving it a row number.When a user clicks one of the check boxes, I need to be able to determine what row the seat was that they clicked on. I then use the row number to determine the price of the seat. I am stumped!! I can't seem to figure out how to get the row number associated with the seat. Here is my where I am configuring the seats:
Private Sub ConfigureSeating()
intTheaterID = CInt(frmTheaterTickets.cboTheater.SelectedItem)
Dim strSQL As String
[code].....
I have a TableLayoutPanel that is 1 column wide. In it, I make UserControls to represent components of a color formula.When a user chooses a formula on the left, I call "TableLayoutPanel.Controls.Clear" and then using the data from the formula, set the number of rows and create X many new user controls in a loop and TableLayoutPanel.Controls.Add them.
The problem is, if one keeps this screen open and selects through roughly 60 to 70 different formulas, eventually, without warning, the program will crash in an unhandled exception: Error creating window handle. (There is no debugger breakpoint)What's causing this? Is it a disposal problem? Should I be doing something other than TableLayoutPanel.Controls.Clear? Would you handle building the objects differently? I'm including a screenshot of the screen in question (you can see the usercontrols vertically on the right) and the error box that comes up.
I have a very large number of tables with data in the following format:
A X Y Z
1 0-2 0-13 0-1
2 3-5 14 2-4
3 6-9 15-16 5-10
In other words, there is a variable (call it A) with a single value that corresponds to a range of values in the other variables (call them X, Y, and Z).My program needs to accept user text input of values of X, Y, Z, etc. and then match each to the corresponding value of A.Example: User enters 4 in the X text box; program determines that if X=4, A=2.Again, we're talking about tables and tables of data in this format. Unaware of a better method, I have been using arrays.
Example:
Dim a() as double = {1,1,1,2,2,2,3,3,3,3...}
Dim x() as double = {0,1,2,3,4,5,6,7,8,9,10...}
Note how I had to artificially deal with variable A so that the index of each score corresponds to the index of the matching X variable.It is this modification of the variables that is taking forever. There has to be a better way! Hypothetically, what I need is the ability to do something like this:
Dim a() as double = {1,2,3,4...}
dim x() as double = {0 to 2, 3 to 5, 6 to 9...}
Is there a way to represent a range of values at a single index of an array, such as my hypothetical example above? This would save me hours of re-shaping the data to make the arrays work.