I have a series of text boxes in my form that can accept 6 digits. Upon entering the 6th digit I want the focus to move to the next text box. Is there a way to initiate a Tab command (just putting chr(9) didn't work...so that may be wrong) once the counter hits 6? I currently have the following code, using the .focus command but I am hoping to not have to create 25 subs to set focus to the next. My current
Private Sub txtEnter1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtEnter1.KeyDown
[Code]...
I can't just add txtEnter2.KeyDown (etc.) to the Handles of the sub declaration because then they would all set the focus to txtEnter2 instead of to the next text box. I'm sure it is something ridiculously easy but it is escaping my grasp.
I'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons Public a As Short ... Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
I am building VS2008 app using Data Source Wizard. The Data connection is working. The Table Adapters are built. The DataSet is created and I can preview data through it. I used drag/drop from the DataSource/DataSet to put a DataGridView onto a form.I can view the records there. I can delete records there. But when I update or add records from there, all of the data is not getting changed. I am connected to ISeries DB2. If I add a new record the only field that get populated in the database is the key field (the first field in the file). If I update a record in the database, the only field that gets changed is the key field.
Re DataGridView Sorry don't really have any code - just a whole project. Basically I changed the underlying Access (accdb) Table by adding a new field, The new field shows up in the DataSources section of the Solution Explorer and in the "Edit DataSet with wizard" page but when I attach the binding source to a datagrid view, the new field is not there. I also created a new bindingsource but still not there.I just noticed I've another table where I changed the names to something more meaningful, and the old names are still there and the data for those fields doesn't display in the DataGridView
Lets say we have an Access file in a well known path (i.e. "C:MyFolderMyFile.mdb"). That file does not have a primary key set on the table we are interested in . Is it possible to set one of the fields as a primary key (for example the "ID" field , which is also an AutoNumber data) ? And one more thing : I'd like to change the name of a field on that table . For example , lets say there is a field called "My Field 1" (note the space characters) and we want it to be renamed as "My_Field_1" . If it's possible , I'd like both these changes to be permanent in the data base file itself , not just in the imported DataSet ,
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
my problem is in access to lines of a text file .I can write my text data line by one using below code . but i couldnt write to a specific line(like line 5) or else read a specific line . and also clear one line and rewrite new string.I searched many . but I couldntt get result related to this problem.
Dim objReader As New System.IO.StreamReader(C:\test.txt,true) Dim objWriter As New System.IO.StreamWriter(C:\test.txt, True) objWriter.WriteLine(my text)
I am running a index search on a string in a rich textbox, i have a list of keywords which need to be a different color in this textbox. how do i run a search on a string in vb2005 and get a list of indexes where the text matched my search?
I've inherited a .NET app to support / enhance which reads in a couple of files of high hundreds of thousands of rows, and one of millions of row.The original developer left me code like :-
For Each ModelListRow As String In ModelListDataArray If ModelListRow.Trim.Length = 0 Or ModelListRow.Contains(",") = False Then GoTo SKIP_ROW
[code].....
and it takes an age (well, nearly half an hour) to import these files.
i want to take a comma delimited text file and then select all unique records based on one of the fields in the text file. should i read the text file into a data table or just use a data reader?
I'm working on a feedback form for my project that has labels for questions, and text fields for answer input.For my feedback form, I need a code that "binds" or links all the label(s) text and textbox(s) text. Basically, almost like a survey. I need all this text to be able to be sent to an email address.
how to save information into a text file from runtime VB2005. However, I wish to be able to write the information into any kind of form of file that cannot be simply opened and read by anyone (such as text file can be). Is there anyway that VB2005 can do this?
I tried searching for a solution, but couldn't find anything, so if I am re-asking a common question, don't beat me too badly. For a class, I have to create a form that allows someone to enter in the names of six students, as well as five test scores each. It also averages the scores, and displays them in a label.
What I am wondering is if there is a way to clear the text from all 36 text fields, as well as the 6 labels without having to do everything individually? I could certainly go through, and write out txtField1.text = String.Empty 36 times, but it seems there would be a more elegant solution. Also, if there is a way to do so, would the same would apply for putting the data entered into an array, or saving it to a file?
I am writing a little program that does the following:Allows the user to enter a id number.Then when the find button is clicked, we connect to the database and run a select statement for the id.I am trying to figure out how to get the first name, last name and birthdate into textboxes on my form.
I would like to have a way to display a messagebox if the resultset = 0 so as to tell the user no records found.Then if the information is correct I am going to have a button to update the information which is going to call a stored procedure I have in place to update the record.how to make the connection which I think I have working and then loading the individual fields into the appropriate textboxes.
I'm working on a project using SQL Server Express 2008 R2 and Visual Basic 2008.My table has 8 text fields, each using the data type VarChar(num) with the number(num) ranging from 5 to 50. There are also number fields and a boolean field in the table.When I try to insert or update the table in Visual Basic the program runs through to completion, but the VarChar fields only contain the first character. The other fields come out fine. If I create the record in SSMS the fields are not truncated.
What would be the fasted method of get a string list of all values within [] in a string of text? For example: [client_name], are you are doing today? My name is [my_name]. The list of strings would be:
I'm not getting this at all I suppose. I've tried so many variations to split the lines into individual fields and I still cannot get it to do what I want.
I have to get lines from a sequential file which read like:
CODE:
And load them to a listbox like this:
CODE:
With the ID # padleft(10, "0") and the commas eliminated, and only the Last Name, First Name and Middle Initial showing.
This is my mess of a code (it is just one of many variations)
CODE:
I've got the ID field right but the rest just shows up as it is in the file commas and all.
I need to build a rather simple form for collection some information from our membership. It has 4 Text boxes and one Submit button. The contents of the text boxes need to be emailed to a fixed Address and a fixed Subject. Before I got to fancy I tested the form to see if the email portion worked which I did get the email but not all the data. I am trying to stick with VB as I had experience with it years ago.
My problem seems to be in building the string for the body of the message. Trying to use StringBuilder but my syntax is messed up somewhere. The Fields that I have are: Name, Phone, Email Address: and Comments. They are named in the form as txtName, txtPhone, txtEmail and txtComments. [Code]
web page has a few fields to allow the user to enter payments. After the system processes the payments, the fields weren't cleared out.so my task is to simply clear them out.[code]The procedure is writing an HTML receipt into the strBody and displaying it to the user.They see the 'File download, do you want to open or save this file' and can open the receipt in ms-word. Without those three lines, the resetting works. So clearly they are messing up something, I just don't understand what.I've got a workaround, but I'd like to know what is going on.Even to the tune of is this a correct way of creating/downloading a document.This in an inherited system, the original designer is long gone.
I am using crystal reports with vs 2008 express and i am having trouble with one part. I have a parts filed in my database and I need to insert each part into a different unbound field. I have been trying to use the split function but I can't get it to work. The parts list can unlimited so there is no way i will know how long to loop for. This is how the string appears in the database.
I have a series of text fields on a simple form (inside a group box) I would like to enforce all the text be upper case upon submission to the database. I know I can use the Ucase command. The question is implementation. How can I very efficiently force all the field values to upper case vs. say doing Ucase(TextBox1), Ucase(TextBox2).... ( I have 12 fields in this case) Is there a way to treat the text boxes as a collection and do it in one shot? Just trying to be very efficient and create clean, tight code even on such a simple thing.
Class Foo ReadOnly name As String Public Sub New(name As String, dependentUpon As Foo) Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing. Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing. Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
My intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
I have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
