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'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.
Is it possible to clear all the textboxes whose title starts txt for example txtname, txtaddress when pressing a button?
Similar to resetting the application without closing and restarting.
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.
As the title suggest is there a way to clear multiple text boxes with a single command as opposed to :
textbox1.clear()
textbox2.clear()
[code].....
I have a reset button created in my VB form, but don't know how to code it so that it will accomplish what I want. I want it to clear the form's text boxes so that new input can be entered. I could just code an end statement but this closes the form, and I want to keep it open to continue working with it.
View 6 RepliesAfter I have entered data into 12 textboxes and pressed a button to execute the code, the data from the text boxes goes into a database.I want to clear the information in the text boxes after the button has been clicked, at the moment I have 12 lines of code which are similar to this.
MsgBox("Data Has been Added to The Database")
tbeventId.Clear()
tbtitle.Clear()
tbstartdate.Clear()
tbvenue.Clear()
is there a easier/simpler way to remove all data from the text boxes without using 13lines of code
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 trigger an event (clear some text boxes) when I click on the "ok" button in the MessageBox. Below is the event triggered messagebox code. A box pops up with the included text and an "OK" button. The program appears at this point to stop and wait for the click on "OK" MessageBox.Show("Check -Sender Information-data")
View 2 RepliesI have a group box with 4 radio buttons and another groupbox with 4 text boxes.how do i write a short code to clear all text boxes and radio buttons within each box.i have written code the long way, ie..[code]but i think there is and easier way but i cannot find the statement.
View 1 RepliesI'm using ASP.net to add a record into a table:
With SqlDataSource1
.InsertParameters("Name").DefaultValue = fldName.Value
.InsertParameters("Email").DefaultValue = Text1.Value
.InsertParameters("tContent").DefaultValue = taLE.Value
.Insert()
End With
I now realize that I need to get the id (a Unique Identifier that Auto Increments by 1) of the record I just added.
How to Show confirmation msgbox when data is successfully inserted into database using detailsview in asp.net ?
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'm trying to come up with some code that can clear a database.
I've tried to loop the "delete" code that i have, tought each row in that database, but i get error at last row saying somethink like "row do not exist" and when i got back and look, there is still one record left in the database. Here is the code i used.
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source =" & Application.StartupPath & "\Filmer.mdb"
con.Open()
[Code].....
wan to ask about anyone know the code about how to clear all the data inside the data grid view without clear the binding source...
View 1 RepliesI'm trying to make a small database out of text boxes and text files, something where sql would be overkill, not to mention beyond my experience. I want to be able to write the contents of the text boxes to a file.txt (the easy part) then being able to retrieve them back out into individual text boxes. How would I pull this one off?
View 5 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 need to know how to clear what is currently in the combo box with a 'Clear' button. Basically, I have a combo box with a list of destinations for the user to choose from. Say the user selects Australia, when I click a clear button, I need this selection to disappear, and be ready for the next user to select a destination.
View 2 RepliesI have an insert statement with a number of DataGridViewComboBoxColumns. When I try and insert the values of these DataGridViewComboBoxColumns into my database the text "False" is being inserted into the fields.
Dim para As New SqlClient.SqlParameter
Dim dateValue As String = CStr(DateTimePicker1.Value)
Dim calendar = Microsoft.VisualBasic.Left(dateValue, 10)
[Code]....
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].....
My application has textboxes that are bound to DataSet fields of a SQl Server 2005 database. The columns in the database allow nulls. The column properties in the DataSet have AllowDBNull set to true. Attempting to write the un-changed data back to the database replaces the NULL values with "", and the update fails on the datetime columns with an error about being unable to convert "" to a date. It appears that the problem is that the null values from the database are being converted into empty strings when the textbox is populated.
View 4 RepliesI have an Access Database that contains two tables. I would like to populate 10 text boxes on my form with the data from the tables. For example: Table1 has a list of names 1 thru 5 and I would like to have 5 text boxes on my form when the form is loaded to populate those names. I know how to populate a combo box with the information, but not sure how to do it into individual text box
Current Code:
'create connection and command string
Dim conStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
[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
I am using a Class_SQL that gets the table, creates the DataAdapter and DataTable.I have a combobox named cboFullname. I can fill the combobox with data from the database, ie: Dim sqlcmdtext As String = "SELECT *, Firstname + ' ' + Surname AS Fullname From Contacts". I can display full records in a datagridview.
I would like to be able to select a name from the combobox and have the record text boxes display the data and be changed with the cbofullname index changed subroutine. Here is my current code to date:
Public Class frmMain Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I have imported a database from Access in to multipul text boxes in Visual Basic 2008. The information is on CD sales and the fields include ID,Tune name, Artist Name, Sales Quantity, and Year issued.i want to Query the database for
1) the tune with the greatest number of sales from a particular year. (year selected from a list box)
2) total sales in a particular year. (year selected form a list box)
3) display all tunes by a particular artist. (typed into a textbox)
With the following example of code, whenever the user clicks a menu item it will load up a new form. This form will then read from a database, and create text boxes throughout.
Private Sub allowances_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If mainMenu.currentSlic.ToString = "0" Then
[Code]....
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