I have unformatted text in my SQL 2005 database. I'm pulling it into a masked edit text box with a (999)999-9999 mask.Unfortunately, when I attempt to save the data back it doesn't work because I don't know how to get the 'masked' information back to the 'unmasked' raw data that the database wants.
View 4 Replies
After reading data from an Excel spreadsheet, I wish for the user to have the option to change one or more variable values. I am encountering two key problems:
1) I cannot change the value given the code below:
Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged, TextBox2.VisibleChanged
Dim aircontent As String
[Code].....
I have written some code to get the data from a number of text boxes all named in the style txb_[column name]
I want to write this data to a datatable.
The text boxes were initially filled using a row 'aIndex' from the datatable, then the user can edit the data.
When this code runs, the text boxes all revert to their initial values, regardless of any changes made to their contents during runtime.[code]...
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.
The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
I've already asked on other forums and people are where replying giving me third party programs that I could use to implement this, something I don't really want to do.
I'm in the middle of creating an application that will be used to input customer information whilst the customer is speaking to someone over the phone. This involves the customer giving the employee information such as name, address, postcode etc and the employee inputting that information into text boxes and combo boxes that are in the application.
What I would like to be able to do is after the customers information is given over the phone, I need to be able to send that information to a database which will probably most likely be done by button click. In this case, I'm using Microsoft Access. I'm also hoping that I can do this within Visual Basic coding.The database is set out with multiple tables which include a customer table and a ticket table and both have multiple fields such as first name, surname in the customers table. Both of these tables are in use with the information that the customer gives over the phone.
I find this property useful but cannot find a direct replacement for it in vb.net. Is there one?
View 1 RepliesI am using a masked edit text box in my windows application that was developed by using vb.net. In normal text boxes (CTRL+Z- to revert back to original value) is working fine. But In case of Masked Edit Textboxes its not working fine. This ctrl+Z should provide the functionality as same as normal textbox.
View 1 Repliesi was just wondering if there was a way that i could compare data stored in a text file such as usernames and passwords with data input into text boxes in visual studio vb2008?
View 6 RepliesI have a data set with a parent child relationship between a patient table and an insurance table. There can be up to 4 insurances for each patient. I want to display them in 4 separate panels of a vb.net form. So if a patient had 2 insurances, then txtName1.text on panel 1 would have the company name of the first insurance, txtName2.text on panel 2 would hold the company name of the second insurance, and so on.
How do I display only the insurances related to the current patient? I've tried moving through the rows of the related table, but that gives me all the rows, not the ones I need. Everything I see on the internet suggest using a datagrid, but that's not an option in this case.
I have a text file containing ten pieces of information (5 prices and 5 descriptions) I want to load the information from the text file in to the text boxes, so that it can be viewed and edited if required.
I've declared the filename, and various variables, but I'm not sure how to get the info from the file to my form?
filename = CurDir() & "/charges.txt"
Could I use something like this:
fileopen(1, filename, openmode.append)
do while not EOF(1)
...
...
I am trying to follow the book 'Sams teach yourself VB 2008'. It was going well until the end of hour 4. For exercise 1 I have created the form with a button and two text boxes, but cannot work out the code I need to move text between the two boxes. The Object Browser does not seem to help - am I reading it wrong?
View 14 RepliesI am getting data from the webservice in my VB.net app. I have successfully read the data from the web and got that into a String but now i want to put that XML data in text fields in my App.
I got this XML data in a String.
<?xml version="1.0" encoding="utf-16"?>
<CurrentWeather>
<Location>My City, my Country (RJSK) </Location>
[Code].....
im having a issue where not all the data from my dgv is being loaded into text boxes on a 2nd form. What im doing is using the "DataGridView1.CellDoubleClick" event to open another form and pass the selected row into seperate columns, this works great but as i added more columns to the DGV it seems that the form is loading and not all the data is loading into the text boxes. Is there a way to halt the opening of the 2nd form until the loading is complete? i tried to simple "sleep" at the end right before the form is made visible but that didnt work. heres the code im using to load the DGV into text boxes, there are 16 columns, this is just the first one:
Code:
Edit.Item.Text = DataGridView1.Item(1, i).Value
as i said before, 13 or so of the 16 work fine, its the last few that refuse to load
Here i have code filling a drop down box with the company name.
Private Sub Filllistcomp()
listcomp.Items.Clear()
'define select statement
[CODE]...
This part works. The drop down menu is filled with all the company names. The following part does not work how ever.
Protected Sub listcomp_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles listcomp.SelectedIndexChanged
'create the select statment that serches for a record
[CODE]...
There is no error thrown either. The information is just not showing up.
I don't want to show the data to the user which is not related to him. So, I need something like the following:
SELECT * FROM Projects WHERE ResponsiblePerson='Sudhakar Reddy' But, as I am using the BindingSource control to retrieve the data, I don't know how to do it.
The following is the code on my form:
Private Sub ProjectStatus_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'RPSDBDataSet.PROJECTS' table. You can move, or remove it, as needed.
[Code].....
i have a combo box that on form load is populated but i need to know when i click an item, i will be able to code how to populate other combo and text boxes with data about the same person.
View 2 RepliesI would like to bind textboxes to certain columns from records generated from a stored procedure. The error I receive is "DataMember property 'spCustomerHeader cannot be found on the DataSource". I have no problem returning the data to a datagridview but I need this show this data in textboxes.
here is the code
daCusHdr.SelectCommand = cmd
daCusHdr.Fill(dsCusHdr,
"spCustomerHeader")
[Code].....
I use Visual Studio 8 and Sql server for my database. I have a form with a DataGridView where my records are display on from the database and some text boxes. I want to pass the data from a specific record from the DataGridView to the text boxes whithin the RowHeaderMouseDoubleClick function.
View 3 RepliesI have alot of text boxes across alot of forms in ASP.NET programming in code behind pages in VB. I want to ensurethe user does not enter such characters as ' " ( ) or any which could mess up the sql syntax the script makes, and with some will validate what they entered is of numerical value.
Now I know you can stop the text box allowing such characters in a Windows application, but cannot find for the life of me a way of doing such in a web application - and its not really viable to perform a sub-string check at the click of a button for every box
I'm trying to accept two pieces of data from two textboxes, which will then be inserted into a database on pressing enter, along with a date stamp, and a time stamp. My two text boxes are called; txtindicatorand txtemployee, the database is called; Database11 (Database11DataSet1).
The data would be imported into a table named; Data_Collection and the fields would be; Employee ID (which would come from the info the user inserted into 'txtemployee'), Time (automatic time stamp), Date (automatic date stamp), Type (which would be identified from textbox 'txtindicator').
I need to compare the data between two text boxes and a variable. If the value of the boxes don't match up and the variable is -1, I need to fail it.When I do this:
VB.NET
If Not Me.txtPcidSystem.Text = Me.txtPcidDatabase.Text Then
I have no troubles, but adding the variable check produces a false positive.
VB.NET
If Not Me.txtPcidSystem.Text = Me.txtPcidDatabase.Text And TestData.BypassCheck_PCID = -1 Then
The way the code is laid out, I have to do this in one line. I can't check the first condition on one line and the second on another.I've tried separating the data out with parantheses, but it's producing the same results.
I have a button that inserts data into a database.With that button I want it to serve two functions.One for insert and one for clearing the textboxes after the insert is done.I did a little bit of digging around and her is a code snippet that i found online:
Dim ctrl As Control
For Each ctrl In Me.Controls
If TypeOf ctrl Is TextBox Then ctrl.Text = ""
[code].....
I have designed my form like this it has a combo box and several text boxes. In the form load I want to load the customer IDs of my customer table into my Combo box.Customer IDs data type is varchar and this part is working in my form.The next thing that I want to do is if a user select a single user ID from the combo box I need to display the first name last name and there are several fields of that selected customer id in the text boxes.If anyone can help me in this it'll be a great help.I have designed my data base in sql server 2008 and I'm using visual studio 2008.I added a new sqldata adapter and I created the data set.But I want to know how to pass the selected id of the combo box as the select parameter of sql statement and how to bind data to the text boxes.
View 2 RepliesThis task is a little out of my reach so i dont even really know where to start...I want a user to click the command field "select" in my gridview. I then want them to be redirected ( response.redirect()) to an input form that will have its various asp.net text boxes filled with data from that selected item. I also need the ability to do this logical process:
IF the form is loaded from user
selecting item in gridview THEN
''Populate controls with data from selected gridview item Else Load
[code].....
there is a tab control system. It relies on only five text boxes, and their bindings change when the tab is changed The relevant information is displayed. However, if I navigate to a different record...You can see that the same information is displayed in the tab control text boxes, and not the employee's details I just selected in the data grid or the navigation. How can I fix this? I'm not sure what's gone wrong here. Here's the code that changes the text boxes upon changing tab...
Private Sub TabCheck()
If TabState = 1 Then
pnlTabs.BackgroundImage = My.Resources.tabs1
[code]....
Im want to use the right mouse click to copy and paste the data in text boxes to a clipboard. Ive tried looking for examples of this but couldnt find any.
View 6 RepliesHow to do: on Treeview nodes click wanna show data in several Text boxes utilizing the below sample code
Private Sub Form_Load()
' Visual Bbasic 6 Sample Window Application
' To run this project Add 3 differnt text boxes and
[Code].....
Using Visual Basic in Visual Studio 2008, I have created a Windows form with multiple tabs and questions. Each question has an associated drop-down listbox that the user will eventually click on to enter his or her response. My client has now informed me that she wants to change the standard responses in each response box. There are well over 100 drop-down listboxes, all with the same items, and they all must be changed.
I originally inputted the items using design view. Would someone please tell me if it's possible to edit all of these boxes in the design view simultaneously? When I control + click on more than one box, the Edit Items option that is normally available disappears. Is there a way to do it in code in a manner that would save back into design view?
I have a masked text box and two text boxes. I would like to save all of these fields so that when the "open" button is clicked the field repopulate....
View 4 RepliesThis code for a masked text box isn't functioning correctly. When I type "PM" at the end of the text, it detects it as false, and shows me the message box.
[Code]...
