New to reports here. Using VB.NET, my application makes use of datatables it creates from a postgresql database.These datatables are defined at runtime rather than design-time, and I would like some way of generating reports from these datatables at runtime as well.
Should I be trying to create the report template at design-time, and then "binding" a datatable to it at runtime?
In VB.NET,I want to create template at runtime and save it the template with name. for ex : Administrator design a page with 5 fields like using firstname, lastname, dob,nationality and job. He want to assign this page to the user with some restriction like user1 need to enter the all the fields and save it the forms as user1profile, but user2 need to enter only firstname and lastname and save it as user2profile.(in features, he can remove the fields from the form).
View 1 RepliesWe're developing a WPF & MVVM application that requires multi-language support. On each control with static text, we're using a converter to do a lookup for the appropriate word for the user's language.
However, this means that each control does not display any text. This causes some irritation for the UI developers at design-time. Is there any way to display design-time text?
For example:
<TextBlock>
<TextBlock.Text>
<Binding Converter="{StaticResource Translator}"
Path="Controller"
ConverterParameter="Search for" />
</TextBlock.Text>
</TextBlock>
How can I make this converter execute at design time to display the translated converter parameter?
I work with VB 2008
I need to design my reports by users
please tell my the best way,or the best report type
In some of the forms ,whenever i change some properties using the Properties Window of some controls or the form they get reflected in the Properties Window but will not get changed at Run Time.
I am facing this in quite many of the forms, hence i am applying the property changes in form load, this is causing performance breach .
Im doing my first project with WinForms, and Im trying to get the DataBinding working. Theres no database in my project, but I'd like to bind some of the TextBoxes to objects' properties. In the other section of this forum (here) I found this line of C# code which does it: textBox2.DataBindings.Add(new Binding("Text", this.myPerson, "LastName"));
my question is can data binding to object properties be set up during design time (without writing code)? If so, how? P.S. I know how I would set up this binding if in WPF, but I'm forced to use WinForms.
In a VB.NET winform App I want to place icons on each tab header of a TabControl.I set the ImageList property of the TabControl and for each Tab I set the ImageKey property.My icons show as expected on each tab at design time within the IDE but when I run the App, my icons don't show (an empty space is shown instead).
View 1 RepliesI have a small dataset which has most of its schema defined at design time, but I add a few columns to one of its tables at runtime. My problem is how do I reset those changes? he dataset is not linked to any datasource. It just has its own table which I "manually" populate. The static columns have been added to the datatable at design time. However, I add a few columns as runtime based on a list of categories. Like this:
[Code]....
The dataset is used in a small dialog that pops up within my application. I add the dynamic columns when the dialog is opened by using the Load event. Everything works great the first time. But if you close the dialog and reopen it, there are problems. My startup routine tries adding the dynamic columns again, but an error is thrown saying the column already exists. I have tried a lot of things and did some reading but I can't figure out a way to reset the dataset when the dialog is closed. The only solution is to close the whole application and reopen it. I have tried the following in the Leave event of the dialog form:
[Code]....
I use try catch finally to handle errors in my program. And these work fine when i debug application, but when i install it, error handling does not work?!
View 1 RepliesI want to ask a question about adding controls in design time (controls may be any win form control or a user control) and adding the control in run time.
View 2 RepliesI've created an SQL Query using the query builder. In the query builder, you can test the query by clicking the button "Execute Query", and entering the desired values in the parameter fields.
My query returns the correct results when I do this, but when I seemingly pass the same values at runtime, I get 0 records returned.The query is designed such that you can pass nulls if you don't wish to filter data by that particular parameter.
SQL Query:
SELECT ID, UPC, Quantity, Manufacturer, Style, Color, Size, Category, DateReceived, Cost, OriginalRetail, Retail, LocationID
FROM Inventory
WHERE (UPC = @UPC OR
[code]....
In the query builder "Execute Query" dialog, I enter a value I know that the db contains in the "Size" field, "1/1/1900" & "1/1/2199" in Dates A & B, respectively, and nulls for all other fields. This returns 1 record, which is just as I expected. It works correctly.But when I pass the same values into the method created by the designer, I get 0 records returned. I can't figure out where the problem lies. Even if I enter nulls for all fields other than the dates, it returns 0. This tells me that the dates are causing the problem, but I can't figure out why, because I'm passing strings equivalent to what I entered in the query builder.
I'm using .net 2008 Trying to create a small graphic component, I have a problem setting background both at design time and then runtime. I derived a panel like this
[code]...
But it isn't working! If I don't Overrides Property BackColor, this is working as expected but I really need to group in my custom tab.
Is it possible to create a menu at design time and populate it at run time and then display it at the mouse pointer when I click on a cell in a datagrid?
View 11 RepliesI am creating a custom Label control (by simply Inheriting the standard Label control and re-painting the background and text) because I need a very specific background and border. In the constructor of the control, I set the AutoSize property to false so I can have a standard default size for the new label.
Public Sub New()
/*Set the default size of the control to 75x24*/
Me.Height = 24
[code]....
In my application that uses this control, if I create the new custom label at run time (in code), the AutoSize property stays False, and it works properly.If I try to add the new custom label to my form at design time, it comes in with the AutoSize property set to True, and I have to manually set it to False in the properties window. It's not a huge problem, but I don't understand why the behavior is different.
I'm a newbie in visual basic dot net. I tried to create a design in run-time. Here's my simple code.
Dim frmLogin As New Form
Dim lblUserName, lblPassword As New Label
Dim txtUserName, txtPassword As New TextBox
[code].....
i want to make a report at run time using vb.net and sql server stored procedure.
View 2 RepliesI created the dataset and connection to my SQL database at design time to make it easy to drag and drop bound controls and stuff to my form. My problem is this, when I did this it creates the connection string in design time also, but the connection varies depending on where the software is installed after the development.My question, is there anyway to set up the bound controls on my forms and everything with the typed dataset created in design time on the connection created in design time... then when the application is run, can it change the connection string at run time to get it connecting to and creating the dataset from the the correct sql database?
View 1 Repliesi have a treeview which has a bunch of parent and child nodes preset at design time, there is 1 parent node tho which is called developer, that i want to add child nodes to at runtime.When the form first loads im trying to have it check a text file and for each line in the text file add the text/string from that as a child node tot he 'developer' parent node.
vb
Dim reader As String = My.Computer.FileSystem.ReadAllText(Application.StartupPath() & "ConfigDevs.txt")
Dim strs() As String = Split(reader, Environment.NewLine)
For Each s As String In strs
[code]....
Thats what i have so far, how can i set it so 'Dim parentNode As TreeNode = ' points at the 'Developer' node?
I've got a VB.Net form application that dynamically loads user controls based on which navigation link the user clicks on. I'd like to make it easier to use at Design time by putting a link of some sort to open the User Control at design time. The link would go onto the form in the space where the User Control will be going. This just saves a little time from having to browse through the files to open the correct file.
View 2 RepliesI've got a calendar app where we're loading up a DataTable from one method, then merging the results with another method - both methods return the same type of data and the same columns. One of the columns in the results is "start_time", which has a date and time. What I want to do is sort the entire, merged, DataTable by the time in the "start_time" column, disregarding the date completely. I've gotten this far, but can't see how to get it done:
Public Function GetDates(ByVal dStart As DateTime, ByVal dEnd As DateTime, ByVal nPageId As Integer) As DataTable
Dim dt As DataTable
[Code]....
I think I need to create a new column and grab the time from the start_time column and then re-sort the table
One of the problems that I constantly see with Winforms applications is that the GUI thread is stuck while a long-running task is running or just plain stops refreshing (yes, I know - needs threading). Is there a code template/design pattern I can use when reacting to mouse clicks or button presses? Should there be a processing thread always running in the GUI app? Basically, how do I write a great Winforms Application that is easy to maintain and doesn't have any quirky refresh bugs?
View 4 Repliesi have tride to generate report by using in built functions of report viewer. but it disply only the default color in to the legend. in my report i am showing chart report by using student marks and their name. the chrt bar color get changed as per the students marks means if student is pass then the the report bar display with green if failed then with red color i want to show the legend with student pass and fail status but on my x axis i have given a only a marks column value and it s showing only marks lable in legend but i want to show it with their status means pass with green color and fail with red color if anybody have the answer of this query plz reply immediatly
View 1 RepliesI am planning a three form checklist/status report for a FEED template. Each form will address a different FEL. FEL1 is really a simple checklist and is easily dealt with using the Windows Form. My question is there a better structure to handle the more complex FEL2 and FEL3, like the web page? FEL2 will have approximately 20 questions and FEL3 will have about 50. I am still undecided whether to use radio buttons (radio button list, which I do not understand yet) or text boxes that will take a value between 0 and 10. I may weight the questions to give an overall percent complete that I can show on the progress bar or some such. If there is a better structure than the Windows form, can it and the Windows Form be linked? If not, will abandon efforts to complete current FEL1. Conceptually, you cannot start FEL2 until you have completed FEL1, and FEL3 until FEL2 is complete.
Public Class FrmFEL1
Dim PctCmpt As New ProgressBar()
Private Sub CboxChrtr_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CboxChrtr.CheckedChanged
[CODE]...
This is what I have so far. It is no working at all. No values appear when boxes checked. Would like a value for each checkbox that can be added in in order to get a total. That total to be added to the percent complete (TxFEL1).
using VS2008, targetting framework 3.5I have a rather complex UserConrol which does some of its own rendering.I display this UserControl on a form.Opening that form in the Designer creates an instance of the UserControl in the Designer, which tells me a NullReferenceException is occurring in one of my rendering methods.I have attempted to correct this by making alterations to the UserControl's default constructor, but have not found success.
View 1 RepliesI created a button instead of the print button in crystal report because i need to record the report printed report serial number, date and time to the database. when i click on the button, dialog box appear. if i click on the ok button , system record the printed report details to the database and report printed successfully. but when i click on the cancel button , system again recording the printed report record.
[Code]...
how to design a report to be printed. I have a table of data, and some textboxes with more data. I save this to a file using binary formatting (it's a small amount of information).I want to be able to print this table and data onto paper but I cannot work out how to do it.Do I have to use graphics to design a report? Do I then add the data?Basically, I want to be able to add a table of data and the other sections of data to a report and print it?
View 2 RepliesJust started with VS2010. (vb)
Coming from VS2005. (i skipped VS2008)
My question is this. Why do I have to hit save before every build in order to see design changes at runtime? Example: I change the text on a button at design time. I click on run and the text does not reflect the change. But if I saved the form before clicking run, than it does. Also like to add VS2010 runs much slower compared to VS2005 running on the same computer. I understand VS2010 can do more, but a lot of times you don't need it to.
I�m working on a project that saves records to a datatable/dataset. I then serialize the dataset to save it, and deserialize to show the records in a datagridview, I add more records, serialize, deserialize etc etc. � I�m using binary formatting. I added the dataset/datatable from the toolbox and selected �untyped� for the dataset. I want to print out this table and other text. Do I need to draw a report using graphics on to a page and then programmatically add the data from the deserialized file, or is there a better way to design and add data to a report? I�ve looked at crystal reports and report viewer and I cannot see how to programmatically add data using them � they both talk about connecting to a SQL or ADO database which mine isn�t.
View 5 RepliesI am new to VB.Net. I need to develop enduser design report (creating movable, re-size controls like textbox,dropdown)i.e when end user click create text box button a text box should create on the report editor grid(like listview with grid or any other, i dont know even how to or which control will have vertical and horzontal grid lines)Please give me idea how to develop it in vb.net.which Microsoft components i need to use.i saw an application like this it looks very simple when user click design template buttona window opens with an editor with horizontal and vertical rulers. on the top there is a menu control with menus like Add text box, Add label, add muliti select, Save.
View 7 Repliesi am in the process designing the screen of a report form.I would like to have the Report selection (button, search criteria) on the left hand side and crystal report on the right hand side of the form.My idea is such that:Report Selection take up 30% of the screen and Crystal Report take up 70% of the screen.User are able to view the crystal report immediately after they have filled in all the search criteria and press the OK button.My purpose of doing this is to avoid to have another pop up for crystal report.Is it possible to do so in VB.NET?
View 4 Replies