I would like to use multiple textbox controls in a simple program for the user to input the number of items . I would like to check the values and store them in an array . I am using the tabindex of each control as the array index for the items. How can i retrieve the text of each control and store it in the array ? I keep retrieving the text value of the form itself.
View 2 RepliesI'm having a problem adding multiple dynamic controls. the problem is that I can add one no problem, but when I try to add more it only adds one with the label's text = the last file name in openfiledialog. [Code]
View 9 RepliesI 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].....
I'm having trouble trying to access a list of comboboxes created dynamically in one procedure from another. I believe I have to add in an event handler but I not sure how this is going to work. Or should I change the array scope?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'variables declared here.
[code].....
I am making an application that uses multiple WebBrowser controls, and multiple proxies.The code for changing the proxy settings are as such:
#Region "Proxy"
Public Structure Struct_INTERNET_PROXY_INFO
Public dwAccessType As Integer
Public proxy As IntPtr
[code]....
Note: getRandomProxy gets a random proxy from a list.Problem is that whenever RefreshIESettings(getRandomProxy()) is applied, the proxy will be applied to all of the WebBrowsers, while i would need to have a unique proxy for each WebBrowser. Not having this would just error out the page in the other browsers and so on.
I have a form which displays related data from three different tables. There is a foreign key between the master table and the two related. Currently I have three stored procedures to return the data based of the return key value from a search becuause I am using DataAdapters to select and modified the recordsets. This works great, but I'm sure adds a lot of overhead. In VB 2008 with SQL 2008, is there a way I could use only one stored procedure to accomplish this?
View 3 Repliesi get an "This SqlTransaction has completed; it is no longer usable." error everytime i run my code:
the main code
If DBOpen() = True Then
Try
'begin transaction
[Code].....
i specified the transaction of sqlcommand named cmd via the Public Sub BeginTranscation. but, is this correct?
also, the error points to the Public Sub RollbackTransaction if the insert to the stored procedure fails. : "This SqlTransaction has completed; it is no longer usable."
how can i perform multiple stored procedure calls within a single transaction correctly?
I am using this vb.net code file to call a procedure to get dates (among other things). When I execute this procedure in SQL 2005 Server Management Studio, I get about 10 columns. However when I execute this code, the dataset seems to only have one index value, maybe I am misunderstanding something. When I change this
ds.Tables(0).Rows.Count.ToString
to
ds.Tables(1).Rows.Count.ToString <---changing the index value to 1
(or higher)
I get no information. So my question is;
Does the DataSet contain the other columns, only not indexed like an array? What I want to do is choose which of the columns to filter out and turn the rest into JSON formatted strings.
Like the title says I want to create a SQL (2005) stored procedure where I say:
Select a, b, c from A
Select b, c, d from B
Select c, d, e from C
[code].....
This is my main table structure:The expertise column is a many to many relationship with another table that has a list of available languages.I wanted to have a flattened structure to display all the languages that a person expertise's, so I wrote a stored procedure that stringifies those multiple expertises to fit for each user. When I called this sp from my wpf application, its not showing the values. I tried the 'preview data' from object browser which showed only one row of my table.
(Expected result: What is the problem with my approach?
my Sp:
create procedure myView as
Begin
DECLARE @count INT,@finCount INT,@result varchar(50)[code].....
I'm doing a project in database development which requires to use a list box that will populate from a SQL Server database.I'm confused on setting up the listbox to have multiple columns that will be populated from a stored procedure within SQL.I drag and drop the listbox onto the form, size it, change it's property to multi-column, set column width to 10, but don't know what to do next.The listbox on the form design doesn't show multi-columns.
View 2 RepliesMy experience with Stored Procedures is limited and I'm hoping this will solve my payroll problems. Further, for what I'm attempting to accomplish a Stored Procedure may not be the best answer.I'm attempting a Payroll function in which the goal of the Stored Procedure is to fetch the data for a given Payroll Period, do math on the first returned employee, output a calculated result, then move to the next. Let me explain a bit more...Based on a Pay Period ID which is given to the Stored Procedure, I would like it to do the following:Select the employee in that period, add a total of his hours worked, then add that employees total commissions, whichever amount is greater - return that value (along with the totals - such as the total hours and total commission) - then move to the next employee until completed.
View 2 Replieseveryone! I've been at this for a while, and I'm not sure how this issue can be resolved:I'm working on a project in VB.Net, and I have a form with a rich text box. I have a groupbox with 4 radio buttons inside that are intended to change the font color of the text. Coincidentally, I have to repeat this same functionality for a 2nd set of radio buttons that would change the text font family.
At any rate what I've only been able to do is the following to successfully change the font color of whatever text I highlight in the rich text box:
Private Sub rbtnBlack_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbtnBlack.CheckedChanged
rtbxTextEditor.SelectionColor = Color.Black
End Sub
Private Sub rbtnRed_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbtnRed.CheckedChanged
[Code]...
Is there a way that I could write a sub (I'm assuming I would use a sub, since I don't think I need to return anything, thus eliminating the use of a function) that would handle the action of changing the selected text color in the rich text box without having to use a separate sub for each radio button? Mind you, per my teacher's specs, she doesn't use a button handler for any of this.
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]...
When I click a cell or a row in a datagridview I want to be able to open a new form with several textboxes and comboboxes in it and to be able to edit the selected row. The only thing I managed to do so far, was to fill a texbox from the form with the info from the sellected cell using the following code.
Dim
cell As
DataGridViewCell
[Code]....
I have the following code which is used by 7 comboboxes, the only difference is the combobox1 to 7 and the DataGridView5 to 11. In VB6 I would have used arrays, is there any way to write the code once or do I have 7 ComboBox1_SelectedIndexChanged subs.
[Code]...
My application has a TabControl which has 5 tab pages. Each page represents a "department" and each department has to run this software. So when the user opens the application, they navigate to their department's page.
The software runs a serious of automated and manual tests. The tests are customized for each department. But I need to update the UI during each section of the test.
On the main tab, there is one panel that has 17 PictureBoxes. Each PictureBox represents one test. The PictureBox can either represent a test in progress, a test passed, or a test failed.
All of the tests are in their own code files, for the most part. And in the main form is when I call the tests and update the UI from a single method.
The issue I'm having is how to update the PictureBoxes without creating a bunch of redundant code.
When the test runs, I update the first PictureBox with "in progress", then when it completes, it's update again with pass or fail. So for a single test, I could need to place the UI update in several places, within the same code block, for planning out all the possible conditions.[code]...
visual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
AM trying trap specific events for some controls on a form. i tried this, but its not fireing the events
[Code]...
EDIT I found out that am placing the control in multiple controls, on the form is a panel, inside the panel is different groupbox, these group boxes have the controls am trying to trap their events
Recently i worked on a VB. I have to know how can create controls Dynamically on the run time and how can access these controls on the runtime??
Ex: I want to Create 10 checkboxes at runtime. After creating Checkboxes Dynamically how can i access these Checkboxes?? like i create Checkbox Called "chkAll" , If i check "ChkAll" checkbox then all Dynamic Checkboxes should be Check otherwise UnCheck?
In my project, I am trying to change the visible property of my various pictureboxes using a for - next statement. My aim is to get the value of my numericupdown1 control and use this number to make the pictureboxes visible. For example, if this number is 8, the picturebox1, picturebox2, .......8 will be visible. Here is the code I wrote:
[Code]...
I need to change size parameter of OvalShape, I have about 100 of them, named like OvalShape1, OvalShape1...... OvalShape100
This example works for Label, but throws error for OvalShape, following is my modified code that giving error;
For Count As Integer = 1 To 100
[code].....
This sounds simple and I'm sure it is. I have a form with textboxes and combo boxes within a tabview that has 8 tabs. All the data is loaded from a database. The user has the ability to update these controls and then update the record in the database. Is there a way that I can check an entire tab view or group of controls for value change other than using an if statement to cycle through each control? Something to the effect of If TabControl changed, then execute...
View 2 RepliesI know how to create a control at runtime e.g.[code]Can anyone tell me how to create multiple instances using a for-next loop? e.g.[code]The part I can't work out is how to give each new button a new name... like button1, button2 etc
View 4 RepliesI have a form with six picture boxes on it. Each Picture Box has a button underneath it. When the button in clicked, a "Label" and "Textbox" appears. My question is, how can I close the currently open "Label" and "Textbox", when I click another button. I have a working code below, but it's not efficient. As you can see, I will have to list all labels and textboxes on the form. Is there a way to identify all labels and textboxes without naming them all. [code]...
View 3 RepliesHas anyone tried using controls from different sources into their application that uses winforms? Will these combination of controls work together?
View 3 RepliesI have eight NumericUpDown controls in my form, I call them NumericUpDown_1 thru NumericUpdown 8. I first noticed when I set a breakpoint in say NumericUpDown_1 routine and have code inside this routine to manipulate say NumericUpdown_6's value, the code would immediate jump to NumericUpdown_6 routine because the value changed. This makes sense since the handler fires due to the default handler - numericUpDown_valuechanges. But I do not want this to happen so I removed the handlers for all NumericUpdownX routines, one thru eight and instead I use "addhandler" and "removehandler" statements inside the individual routines to "mask off" this problem every time I change a numericUpDown.Value that is not in it's own routine.
My problem is this does not work. What I found is if I use removehandler numericUPDown_x.valuechange addressof numericUpdown_valuechange statement the coding would work however when I'm done in that routine I follow up with addhandler numericUpDown... statement and I'm back to the same problem. A different numericUpDown routine will fire because I changed it's value in another routine but I had the handler removed before I changed it's value so I don't understand. It's almost like it remembered that it's value changed as soon as I turned back on the handler using addhandler. I'm working with Visual Basic 2010.
I have a set of controls and code behind them that I'd like to reuse on multiple forms. How can I do this? I know of reusing code via modules, but I'm not sure how I can add the same controls and their underlying code. If I achieve this, will changing data on one form affect the values of another form when they're both open? For example...
Cbox1's selected item affects the choices within Cbox2, and Cbox2's selected item affects the choices within Cbox3 (and so on).
So if I do something on Form1's Cbox1 and it changes Form1's Cbox2, will it NOT change Form2's Cbox2?
just trying to confirm wat i noticed in vs2008,when developing a web app(or wat ever), in my design view, i cant select multiple controls & set same properties i.e. width or CssClass for them all at once (available in vs 2005). i dont know, was it delibrately removed by ms?
View 4 RepliesI am trying to modify our web based program to allow for a second column of information to be entered and updated to the same table as what was in the first column. This program was written by others, so I am trying to keep within their format and structure.The idea is to have three columns (a fourth is currently sThe first column is the label column, the second column is a numbered assessment (1-10) and is currently free form textbox, and the third column (the one I am not able to get updated) should be a free form text box allowing as much comment as possible (without being a SQL text field).
The following is the two sub sections of the vb script:
Sub GetSkillsAssessment()
Session("PeSkills") = Nothing
[code]......