Printing From Datatable, What Options Are Available?
Dec 2, 2009
I would like to create a very simple report printout consisting of a simple header, report data made up of five columns and a page footer. Due to the simplicity of the report I don't want a crystal reports/reporting solution, the source of the data will be a datatable.
I've never printed before in vb.net but looking over examples it appears e.Graphics.DrawString is supplied a string to print the data.
Is my best option to read through the datatable formatting the data using a string builder or are the alternative methods to read my data from the datatable to allow it to be printed out?
View 2 Replies
ADVERTISEMENT
Aug 20, 2011
I am in need of a form that shows various options, exactly like the Options in Visual Studio. Since there are so many options I too want them categorized, with a TreeView to the left taking care of showing the right category.The usual 'easy' approach here would be to just place a TreeView control on the form, add some nodes, and give those nodes a tag or key that corresponds to a panel or UserControl with the options for that category.Since there will be a lot of options however, this is not really feasible design-wise; the form would be cluttered with possibly 50 panels, all of which I would need to select and bring to front from time to time to add controls to them that represent the options.
So I decided to create a custom control that does exactly that. The control is very similar to my Wizard usercontrol, users can add OptionsPanels at design time, which inherit Panel and simply represent one panel of options. When they do, the panel is added to a container panel, and at the same time a TreeNode is added to a TreeView. The control uses a custom ControlDesigner to handle design-time clicks in the Treeview, selecting a different node would select and bring to front the corresponding panel, allowing the user to add the controls he wants.
Due to the design time support the problem of having 50 panels is no longer present, only one panel will be visible at a time and selecting the right panel is as simple as selecting the corresponding TreeNode, just as during run-time. Anyway, I got all this working, but only for a single 'level' of categories. As you can see in the Visual Studio options, there can be multiple levels of categories. For example, the Environment node has a bunch of children, where each child represents one 'options panel'. There can even be deeper nesting, see the Text Editor node for example.Let me begin by drawing out the basics of how my control works so far.
The main control is an OptionsView control, which contains a SplitContainer with a TreeView to the left and a OptionsPanelContainer to the right. The OptionsPanelContainer is merely a Panel to which only OptionsPanel controls can be added, and which raises events when this happens, as well as when OptionsPanels are removed from it. An OptionsPanel also inherits Panel, and these are the actual panels the users will see in the control, one for each option category.For now, each OptionsPanel has exactly one corresponding TreeNode (and vice versa). In the Visual Studio options, each 'parent' category usually has a 'General' node as the first child, and the parent and this General node show the same option panel, but I am ignoring that for the moment.
The OptionsView control has a property Panels that returns the ControlCollection (Controls property) of the OptionsPanelContainer (in other words: it returns a collection of OptionsPanels that are in this container panel).
vb.net
<Editor(GetType(Designers.OptionsPanelCollectionEditor), GetType(UITypeEditor))> _ <DesignerSerializationVisibility(DesignerSerializationVisibility.Content)> _ Public ReadOnly Property Panels As Control.ControlCollection Get Return Me.PanelContainer.Controls End Get End Property
A custom CollectionEditor for this property takes care of the designer: even though the property type is ControlCollection, the CollectionEditor knows it should create instances of the OptionsPanel control instead of just Controls.When it does this, a corresponding TreeNode is also created and its Tag property is set to the OptionsPanel. Vice versa, the Node property of the OptionsPanel is set to the node. Hence the node and panel both know their corresponding object.
vb.net
Public Class OptionsPanelCollectionEditor Inherits System.ComponentModel.Design.CollectionEditor Public Sub New(type As Type) MyBase.New(type) End Sub Protected Overrides Function CreateCollectionItemType() As System.Type
[code]....
So far so good, this all works fine. I can add Panels via the designer and when I do a new TreeNode appears in the TreeView. I can select this node and the panel becomes visible (comes to the front).Now, I am a little stuck. How do I implement child option panels? And more importantly: how do I let the user add child panels?The most logical choice I think is to let each OptionsPanel have a property (ChildPanels or something) that returns the child OptionsPanels for that panel. Once the user selects an OptionsPanel then, he can look in the property grid to find its ChildPanels property and add child panels to that.
There is a problem though: what would this property return? It must return a ControlCollection of some container (this is, I think, a requirement for the designer features to work, otherwise panels are not added to the Form.Designer.vb file). But there is no container. I cannot add them to the OptionsPanel itself, that would make no sense because the parent OptionsPanel has its own set of controls (the options itself...), there cannot be another (fully docked) Panel on top of those obviously.The container of the main OptionsView then? That is not an option either, its Controls collection holds ALL OptionsPanels, not just the children of the selected panel. I cannot 'select' only the right panels either, that would require me to return a new instance of ControlCollection, it would be impossible to return the actual ControlsCollection that holds merely a small selection of its controls.
View 5 Replies
Feb 28, 2010
With the following piece of code
CODE:
The Or keyword is confusing me. So in the above example which variable gets set. Does options = options or does it set RegexOptions.none.
View 9 Replies
Nov 26, 2010
As i'm learning more and more about developing ive just got my head around creating classes and modules, i started wondering about something to do with configuration of applications where deployment is in a more diverse environment say in a company where different branches dont need access to all parts of a program, so i thought id throw the question out there in a basic sense and get some feedback. so i can go off and do some more reading and learning.
So the scenario in my head is like this.
So we have for arguments sake FrmConfig which is the master configuration form, then we have FrmMain which is the root menu our application general user interfaces with. So here based on what options are checked as enabled in FrmConfig effects what controls (like buttons/menu options) are enabled in FrmMain.
View 2 Replies
Jul 1, 2010
I need stop printing and paper feeding in the middle of printing in dot matrix printer.(Like a POS Printer - When wrote 'End Doc' on POS printer can stop paper feeding)
View 4 Replies
Dec 6, 2010
I am using VB 2008 & Access Databases for creating WinForm Applications. Also i am using Crystal Reports for Report solution. my question is How do i created reports such a way that they can be printed in faster Ascii Format on any DotMatrix printer. The default true type fonts make printing very slower.
I tried to use "Draft 10 cpi" font which come to available me after i installed a correct driver for my Epson printer. which also helped me overcome this problem. however it wont be the scenario with all my clients i.e. they might have different printers having different Make with different drivers installed. i have tried to open such project on there PC but the printing wont come in Draft instead the fonts get expanded too much & the print wont come right.
View 8 Replies
Apr 19, 2010
I basically have an application that generates reports in a .html file, I use a .html file for the ease of making tables and formatting text.Now I would like to introduce a way of printing the reports from my program. Because I use a .html file, the formatting would not the correct if I was to print it directly from my application (as far as I know). For this reason, I would like to print it just like my web browser would have in order to keep the tabular data intact and the text formatting.
View 1 Replies
Nov 2, 2009
I'm creating an application which has an scheduler to print and it checks if there is a pending job on the print queue before it prints the next file. I use a timer which checks if there is any file to be printed on my database. Example, the timer ticks and selected 10 files to be printed, it should print the 10 files 1 at a time, if there's no print queue, that's the only time the next file should print. I think another timer is required which will keeps on checking if print queue is done. How will i do this?
View 2 Replies
Jun 11, 2011
I am setting up printing (to a printer or file) in my application, and it doesn't seem to print out any new lines that I specify. Here's some of my printing
' Loop through all of the text in the array
For i = 0 To 9
If i Mod 2 = 0 Then
[Code]....
When I print the output to a PDF file using PDFCreator, it stacks all of the letters onto each other rather than creating new lines at the places I've specified. I've also tried using vbNewLine instead of vbCrLf, but I haven't had any luck. I searched the web for this but couldn't find anything about it.
View 2 Replies
Aug 18, 2011
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
View 3 Replies
Mar 15, 2010
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 Replies
Apr 21, 2010
I am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
View 6 Replies
May 20, 2011
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
View 5 Replies
Apr 16, 2012
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
View 10 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
May 28, 2007
Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.
View 6 Replies
Feb 17, 2011
I'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 Replies
Apr 8, 2009
I am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data
View 1 Replies
Nov 18, 2009
load the contents of a query from a dataTable Adapter into a datatable?
View 2 Replies
Aug 6, 2010
I am trying to add NewRow to the database by using datatable in dataset, but before I do that I want to make sure that row is not already there. I create new row for the datatable I am working with, fill it with information. I fill datatable with the row from database that has the same primary key as my NewRow by using tableadapter.fill method, but when I do that my NewRow that was never added to the datatable is filled with information from database(and not information that I assigned to it). I count rows in my datatable before I fill it and it's 0, so why is my NewRow affected by Fill command? (I am using VB.NET 2005 Framework 2.0)
[Code]....
View 5 Replies
Apr 7, 2012
I'm trying to copy one row from DataTable to another, I looked almost everywhere and I can't find a reason why this is happening, I'm using ImportRow and still the New DataTable is empty. Here's one of the answers similar I found and It's still not working!:
Dim newTable As New DataTable
Dim dsFrom As New DataTable
For Each DBShoes In list
Dim iShoeID As Integer
[code]....
View 1 Replies
Oct 31, 2010
how to copy data from datatable to table in dataset i ry this but its readonly property
ds.datatable1=newdt.copy
View 1 Replies
Aug 10, 2011
I have an asp.net application where I have a datatable ("DataTableA") that returns just one column ("ProductID").
I want to read each row of "ProductID", process some business logic, then copy both those columns (ProductID & ProductIDBusinessLogicValue) to DataTableB. This DataTableB is then displayed on the asp.net page.
What would bhe the best way to read each row of DataTableA ?
View 2 Replies
Aug 10, 2011
I am updating a data table (dt_report_crypt) from an encrypted csv file in the code below:I decrypt the colums and update the same dreport_crypt, such that it will contain de-crypted data.This part is working wellI however need to use this de-crypted datatable as a data source to update a second table(dt_report), using the sql SELECT command to filter relevant data,
Dim dt_report As DataTable
Dim dt_report_crypt As DataTable
Using cn As
[code].....
View 6 Replies
Apr 4, 2011
I have a select statement and it will go to a datatable object, I would like to do the following
textbox1.text=datatable(first field value)
textbox2.text=datatable(second field value)
textbox3.text=datatable(third field value)
View 5 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
Aug 26, 2010
I want to learn how to add the menu options that appear when you click your right mouse button.So far I have a normal menu strip control, rich text box control and I have added a ContextMenuStrip control.
I have not got a clue on how to set the properties for the contextmenustrip on the richtextbox control, so when the user clicks the right mouse button the contextmenustrip appears.
View 4 Replies
Aug 22, 2009
Ok lets say I have a combo box with like 3 options in.
Ex:
Combobox
Option 1
Option 2
Option 3
How could I make it so the timer like every 5 seconds it will change from option 1 and be highlighted to option 2? then after so long, to option 3? and loop this process?
View 1 Replies
Nov 21, 2010
I've got a project where each "person's profile" will have many options associated with them, they are broken into groups such as
"Hobbies"
"TV Shows"
"Dinners"
What I was going to do it tick each "group" that applies to each profile and show only the fields that apply to the user.I was going to display them on a panel or a tabpage but How would I show the user what panels need data entered? (there could be 3 or even 4) but would the panels 2-3(or 4) be hidden how would I promt the user to enter data.I don't like the "look and feel" of tabpages.
View 8 Replies
Apr 29, 2010
Well my project will basically involve a database of the sports info of students in my school. It has to work with about 1000 profiles, each containing a personal info record (basically an address book) and a Sports Info record which has some simple information like what sport they do for winter and summer but it also has some records like "Training Info" which will contain a some 10 fields. It'll wind up something like an array of records of records of records.
One of the key points for assessment is that we employ search and sort functionality explicitly using algorithms that have been provided to us. Essentially we'll have to write up our own subs for binary searches and stuff like that.
Now this is group work and I was put in charge of making the database, one thing I'm unsure of is what I should use. Most of the other groups are using .txt files to store their databases as they've been told that these are easier than Access files. However their databases don't appear to be quite as complex as the one my group's planning. Another random titbit of info I heard was that using our own search functions to search an Access file would not only be slower than using the inbuilt ones (another random something gleaned from conversation) [does it have inbuilt search functions?? I heard somewhere else it didn't] but also that it'd be slower than searching a .txt file with a similar sub.
I'm not sure of the veracity of those statements, however I still want to ask if you guys have any recommendations for what I should use to make the database with. The only ones I know of are CSV text files and MS Access, I'd be very grateful if you could point me in the of a good "thing" to use with VB.net for this kind of project.
View 2 Replies
