I've been using DevExpress and CrystalReports for previous .NET versions. I'm wondering if there are any native reporting controls for .NET 4.0, so I could do away with the 3rd party ones.
View 1 RepliesI am trying to do a very simple demo - load data from an access database and let the user manipulate it with a DataGridView. Here's what I understand so far:1) Create an OleDbDataAdapter by passing it a query and a connection.2) Create a DataSet by calling .Fill() on the DataAdapter with a DataSet object and a name for the retrieved data.3) Attach the DataGridView to the DataSet using the .DataSource property of the DataGridView and the .Tables property of the DataSet.However, I was told there is a much easier way to do it now in vb2008 using TableAdapters.1) Create a DataTableAdapter ( I can't actually find this object -what is it called?)2) Use the Fill method on the DataTableAdapter to connect it to a DataSet3) Now anything the user does in the DataGridView can be saved simply by using TableAdapter.Update.
View 2 RepliesI'm working on a emulator program where I load all controls from a database. My database looks something like this :
Code:
IDPageTypeControl_Indexnr Property Data
1131Label 1 Text Lbl1
1161Label 2 Text Lbl2
[code]......
How would I go about adding items into my gridivew without having controls that are binded. I know you can hide the controls but thats not the right way to do things i wouldnt think.
View 3 Repliesi have a form with 6 tabs on 3 of which have controls, spent a lot of time putting it all together, set it up to link to a SQL DB, all working fine,Until....at the bottom of the form (in design mode) you have the icons that say BindingSource1 and CustomerDataSet1 etc.Well i accidently deleted some, now when i run the form i got an error saying that it couldnt load, i see the code is there but the form is just the blank form you get when you start(the form is still the same name and if i click view code all the code is there, but on the form are no controls, no tabs ... its all gone....(i only deleted a binding source ) i dont understand where its all gone.
when you click on the undo it didnt put the deleted items back (and i am not sure which one there were) now that the form has gone back to normal there are no Binding sources at the bottom I opened the designer code, i see the names of all the missing items, e.g. CustomersDataSet1 and TblCustomers1BindingSource1 e.t.c do i just re add those back to the bottom of the form and then the main controls will re appear?
I have looked through the code and re added the binding sources and adapters that are referenced in the code along with the Binding navigator, if i run it the form is still blank.I have tried to add the controls back and when i do it adds it as e.gTblCustomers1BindingSource2 if i try to rename them to the name they should be ie. TblCustomers1BindingSource1 it says it already existsI am using VB 2008 Pro?
I am working on a Data Survey Project and first I have a few questions about the different types of databases, and second, I need help querying my tables that have relationships.
1. I need a database that is stand alone. It is just the back end for the program. Simply to hold all the data an employee gets while out on a job. So would I be better using access, or SQL Express? I have played with both, but I do not want a large redistribution to my user machines. When I compile and produce this app does the SQL Database still work without installing any SQL Technology? Or do they have to go in after they install my app, and install Express?
2.Overview: I suppose depending on the first question regarding the database, it might change this question a bit, but none the less...I have 4 tables( using Access at the moment) I will be generating Reports based on data in the database. I haven't gotten that far yet. *Project* is the table that holds all the details that pertain to the job and client. It has a "one-to-many" relationship to *Survey*. So for one customer there are going to be many Survey Records. *Project Type* also has a 1-to-many back to *Projects*. Parts is kind of an orphan, but is linked to the *Survey* table with a one to many. So there can be many parts for one survey. I wanted this table for a drop down box, so the user could just simply select what hardware he was using instead of typing all the names and parts.
So in VS 2008 using the Designers and related Query tools, how do I constrain the Survey Data to one Customer? I have one form that opens from a button that is "New Project" and then there are all the *project* fields listed, so the user fills out the info and hits accept and that opens a new form called "frmSurvey" I need to add some code to the accept button to check what type of project is selected from the frmNewProject and then run a select query based on that. How do I write query statements in the code section of the form, without using the Visual Database tools?
Ill stop here, and get these questions out of the way first. If I could just get a handle on how to use the data properly with different forms and different controls with my queries, that would be great.
DATABASE
CODE:
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
I wanted to know if anyone could tell me how to access the Click_event.I have a boarderles form with a panel control which has the Dock property set to fill and on the panel I have placed a Label also with the Dock property set to fill. I also have a timer running.How can I get code to execute in the Label1 click event.I've tried doing it by using the generic Click_event and also with two variations of the Click_event Handles parameters
'Alternativ 1:
Private Sub Form1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
[code].....
There is newer code in a follow up post. I suggest using the code in the later post rather than the code in this one. You can still read this post though. When designing a user interface, one should be conscious of how many individual controls are required to implement the functionality. In some cases an initial design may begin with many buttons or textboxes (for example) but then further review of
the actual required functionality allows for a reduction in the number of unique controls.
But other times, there isn't a better way (which will still make sense to the user of the application) then to have a series of many repeated controls. So in the cases where one can be certain that the best UI implementation for an application will require the use of multiple copies of a given control, then it often becomes necessary to maintain some method of managing all of those controls at various points
throughout the application. Doing so typically requires that one build up some collection of controls which can then be accessed by index in order to work with any given control; but this can lead to a lot of clutter in the code file which handles these control's events. For instance there will be some kind of collection declaration, some recursive routine to find all of the controls of interest, and then any number of event handler methods with long lists of Handles clauses, or additional code loops to wire up the event handling for each control.
Purpose Since most of this functionality could be considered a requirement regardless of the type of control being managed, or its required functionality, it may make sense to wrap all of the control management functionality into a single class. And since our first requirement is a collection of controls, then a base collection class could be the perfect starting point for our control manager. There are a number of existing thread around this topic, with some recent (at the time of this writing) ones being:[URL]..In this, and related, threads I have posted examples of a simple TextBoxManager and ButtonManager control. But again, with so much similar functionality required regardless of the control being managed, it would be technically possible to create a generic ControlManager(Of T As Control) class which can manage any type of control.
[Code]...
So in summary, one can facilitate managing a large number of user interface controls by building a "control manager" class which both encapsulates the list of control instances, and deals with adding and removing defined event handlers for every control it manages. The generic control manager class itself can be inherited and extended into a more specific class on a per-application basis in order to provide more application-specific functionality. Reed Kimble - "When you do things right, people won't be sure you've done anything at all"
If I have the following ListView, how can I attach a SelectedIndexChanged event listener to the DropDownList so I can perform a command on the respective object? Imagine I have a list of new users and I want to add them to a usergroup by selecting the group from the DropDownList.
<asp:ListView ID="NewUsers" runat="server" DataSourceID="NewUsersSDS" DataKeyNames="ID">
<LayoutTemplate>
[Code].....
I have a maximized form that has controls at the top of it and a large DataGridView that is docked below all the controls. Its kind of like the Ribbon in MS Office. The controls cover about 1/4 of the screen at the top. I would like a way for the user to click a button to hide all the controls then automatically expand into the place the controls were so the user can view more data in the DataGridView and visa versa. For example, in MS Office Excel you can hide the ribbon by clicking a tiny button that has "^" on it.
I'm not very familiar with all the controls in Visual Studio so I would like to hear some recommendations. Is this situation ideal for a SplitContainer or ToolStripContainer or am I way off base here?
I've got a couple of these NumericUpDown controls I put on a form. Without describing too much about the form I basically want to update some variables each time one of these NumUD controls changes value. So for each NumUD I have a call to a Recalculate subroutine within their "changedValue" event.
There are actually two problems. First, if I initialize the "Value" property to something other than zero in VB2010 at DESIGN TIME it won't even open the form when I hit RUN. It gives me a "No Source Available. No symbols loaded for any call stack frame" error. The error box says "InvalidOperationException" was not handled. So if I try to set the initial value of the Value property to anything but zero of either I get this error.
[Code]...
I've been building controls for many years professionally and personally, but even back in VB6 days I just could not work this out. After all this time I remembered about it again.If I create a usercontrol/containercontrol and add one or more controls to the controls surface, I just cannot figure out how to access the controls at design time.
View 4 RepliesI want to draw a rectangle over some controls so that the controls are partly obscured.
View 2 RepliesI have a query about dynamically added controls to a form. I have a series of buttons which are created and added at run time. I have a two drop down lists and two buttons which are created at design time. Button 1 creates a series of buttons called "Test 1.x" based upon the selection of the two drop down lists. This works fine and am happy with the logic.However.... Button two should remove all the dynamically created buttons from the form.This does not happen. What does happen is that 50% of the buttons are removed starting with the first one. WHen checking the loop it only enters the loop half the amount of times that there are buttons. Very strange. When the loop is run repeatability it will remove all controls. Why will my logic not remove all the dynamically created controls at once? What is wrong with my logic?
I attach two code snippets and the .net file for your consideration.Button method which creates the dynamically created buttons from the two drop down lists and adds to form
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Count As Integer
Dim MaxHours As Integer
[code]....
i have created control array , now i wann to loop around as well wann to find which control has triggered the respective event my code :
[Code]...
The object browser in visual studio contains many controls and properties ....so is it possible to remember in mind all these controls. Whenever i am programming in vb 2008 and for reference i look at the examples on internet i always find some new controls,properties etc which makes me confuse.So i was wondering If by any means there is a way to remember all these controls
View 4 RepliesI have aspx form with several textboxes.They are populated with values from a table via retrieval of a dataview.If the row count for the dataview is 0, then I'd like to reset the values in all textboxes. How can I loop through all the textboxes and set a default value?I've tried the following, but no sucess.
For Each ctrl As Control In Page.Form.Controls
If TypeOf ctrl Is WebControls.TextBox Then
CType(ctrl, WebControls.TextBox).Text = ""
End If
Next
My first For Loop was using Page.Controls but it returned only 1 count.The textboxes are inside a tabpanel (ajax), so do I have to locate the tabpage and then find all it's controls (for each tabpage)?
How can I add controls to a form in code and set the properties of the controls using the With statement?Also I would like to know how to add a container control and then add a control to that container.
View 2 RepliesI have a slight problem With an enumaration of child controls on a form. The following code will not get but about have the controls that are on the form. The controls show that the count is correct but when it goes through the loop it skips over some of the controls. If you run it through the enumeration two or three times it will get all the controls a few at a time. The solution uses two forms, one that has the controls and the other that labels are made and displayed on. The Tx is just a index to add a number to the label.name and rename the label. So each label is identified seperately. This works for all the the controls that are seen in the for each loop.
View 11 RepliesI created a class that can take either usercontrol.controls or form.controls as a parameter,how can i pass either to that class? as a property or how?
View 4 RepliesI am rather irritated at this. I have no clue why looping through controls on a form and in groupboxes leaves out 75% of the controls.
Here's the code I have:
Dim settings As String = ""
Dim gbControl As Control
Dim gbbox As Control
[Code]....
I want to have setting save all settings to an ini file, and not have to reprogram the saving routine when I add a group box or control. At random times, any number of controls can be disabled, checkboxes can be checked and unchecked, radiobuttons can be checked and unchecked. Regardless of the state of the control, I want the control to show up in the loop. But they don't. Only controls that are enabled and only checkboxes that are checked, every other control state is ignored. That's crap, and is definitely not what is needed by any programmer of any type. We're capable of determining if a control is enabled, hidden, checked, visible, and otherwise.
How do I get the controls to be included in the loop regardless of their state?
I have a form that when you click a button it begins a query. I want the user to know that they already started a query and they basically need to wait and not hit the button again. To do this I have a list box that has an lbResults.item.add() to it
Code:
Private Sub btnControlKSMS1117Query_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnControlKSMS1117Query.Click
[code]....
I cannot work out the correct formatting of the above type addressing for a textbox in a (sort of) array of textboxes such as
textbox_1
textbox_2
textbox_3
etc.
The controls are on Tabs but I don't think I need to include the Tab as a container control, just refer directly to the textbox on the form, but I cannot work out how this is done in VB .NET format. In VB6 it was relatively straightforward but VB .NEt seems it is different. Can anyone help me with the correct way to formulate
[Code]...
I have a module level sub that I use to clear text fields etc on my forms:
CODE:
The problem I have is in the last few lines of code as I'm not really sure how to access the text boxes contained within the tab controls (of which there are many tabs and many text boxes).
This is the closest I've got but I am getting an "option strict on disallows late binding" error on the tabCtl in the following line.
I wanted to delete all of the TextBoxes that I put on a form that start with "tbx". The below code only deleted some of them.
For Each ctl As Control In Panel1.Controls
If ctl.Name.StartsWith("tbx") Then
ctl.Dispose()
End If
Next
So, I took it a step further in testing...Now I'm really confused about the .controls collection. When I try to delete controls from Panel1 with the below code, it only deletes every other control instead of all controls.
For Each ctl As Control In Panel1.Controls
ctl.Dispose()
Next
It looks like it deletes item(0) which moves everything back one step but then advances the pointer to the next step. For example, if the following controls exist on the form...
tbx1
tbx2
tbx3
tbx4
I would like to know how do .net developers manage a large window application with a large number of controls, such as textbox , button, groupbox? I have seen a number of people do it this way : declare the controls as an array and initialize them one by one at run time . In this way it is easy to manage those controls because they can be accessed by array index; but this solution seems to require very good understanding of control's attribute such as its location, font etc. This could be a difficult task if the project is passed on to a less experienced developer and add changes to it.How do you deal with it?
How many controls can I have before I should start looking at user defind controls because of too many controls making my program go slow?
View 4 RepliesI am trying to cycle throught the lables on my form but it would appear that I am missing quite a few labels... I have a total of 69 lables on my form and I only get 5 hits on the msgbox.
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is Label Then
[Code].....
I'm in the middle of using Visual Basic (Visual Studio 2010) to create dynamically created controls. Essentially what I'm doing is creating a label, a textbox, a label (which will act as a stopwatch), and a button (to control said stopwatch). Each set of controls will be arranged (and named) like this in a row: [Code] I've gotten the bit about creating the elements dynamically as well as creating them within in a panel with a particular number attached to the end of its name on the form that I've created. What I would like to do is wire an event for the button that was dynamically created to control the stopwatch timer that was created through the same event. So in short, I'm asking how do you wire an event to control a particularly dynamic button?
View 1 Replies