Data-bound Dropdownlist That Permits Manual Entry Also?
Aug 16, 2011
I am not a .net programmer but I can write bits and pieces that I need, however, I have been having trouble working out the best way to achieve something for a website I'm altering.I basically need to have a drop down list which is bound to a certain SQL call (already in place) but I also need the ability to manually type into the drop down list for items that do not exist. These items do not need to be entered into the SQL (I can handle the additional data separately) but I cannot find a way to type inside a drop down list while it is bound to a datasource.Some entries in the datasource (SQL table) are used for one thing, but then a text string needs to be entered for optional entries which do not exist within this SQL table.
Does anyone know how I can achieve this or maybe another similar control can be used that offers this kind of functionality?**Update to be more clear:I need this at runtime. For instance, I do not need this to be within code I actually need the control to accept user input when someone is on the webpate.Imagine a shopping list and all the items are within the drop down list then the user wants to add another item to the shopping list so they just type it into the drop down box and submit the page and its value will be used instead of an existing item.
View 1 Replies
ADVERTISEMENT
Sep 8, 2009
i am pulling together a cash register that will allow both bar code product entry and manual key entry.imagine if you have a tin of beans in front of you, in a small corner shop they would probably type "47" and then hit "Produce". Fairly straight forward as I have the button Produce to act upon my code and update my salestrans.mdb but,if you scan the bar code I want the same form to handle both 'real' actions, (i assume that keyboard emulation barcode scanner includes "ENTER" after providing 13 digits)....
Q. in perhaps a long winded way i want to know how to kick off an event based on the "ENTER" key being activiated by the barcode scanner)?i do not want to have to hit any buttons if i am scanning bar codes.
View 9 Replies
Jan 26, 2010
the combo box style 1 has both the drop down option but also a manual entry option. I need to know how to code it so that when you manually enter data, it takes that data and places it in a text message "The shipping charges for "data" is $15" displaying in a text box. Shouldn't be hard but have developed a mind block.
View 4 Replies
Apr 9, 2012
I'm trying to create an option to select a specific entry in a SQL table if multiples exists. The Sub listed below is for a textbox (MOTxt) and a button (GotMO) for checking an MO# to pull from SQL. Based on the number entered, will populate other text boxes on the page with that row's data. There are exceptions to this, where the MONumber will be entered more than once with different data associated with each entry. So, here's my situation. If we have a duplicate MONumber listed in the table, it will populate the textboxes with the first entry it finds for an update.I would like to create a dynamic dropdownlist (that displays only if multiples are found) displaying the 'Name' field entries for each MONumber found, then once the correct name is selected from that list, to then populate the textboxes with that selected datarow.Here's my code behind:
Protected Sub GotMONum_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles GotMO.Click
Dim da As New SqlDataAdapter
[code].....
View 1 Replies
Sep 29, 2009
I don't think this can be that hard but I just can't get my head on it. I have a connection to an Access DB, put three text boxes representing three columns in the DB. Using the DataNavigator everything works. But what I want is to be able to enter text in say textbox1 and have textbox2 and 3 update, like when using the navigator.
Add: I want this to function like when you enter a record number in the Navigator and hit Enter, bam, goes to that record and all the text boxes update. I want to enter a number in textbox1...
View 2 Replies
Feb 25, 2010
In .NET (at least <=2) there's a problem serializing objects that raise events when those events are handled by a non-serializable object (like a Windows Form).Because of the way VB.NET implements events, when you serialize an object, its events get serialized too (because events are actually implemented using hidden multicast delegate fields). A side effect of this is that any object which handles events raised by the object being serialized will be considered part of the object graph and will be serialized too.
Some workarounds could be found, implementing custom serialization or using delegates instead of events:[URL]..
View 1 Replies
Mar 25, 2011
When I place data into the list box, I would like the new information to be visible at the bottom of the list without having to have the user use the scroll bar to see it. The data should scroll up automatically as new data is placed into the listbox. Can this be done?
View 4 Replies
Oct 13, 2010
Currently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 Replies
Oct 26, 2010
create website involving payments plus some data entry eg booking of some facilities with the main data kept at a LAN window system.
View 4 Replies
Apr 16, 2012
CODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
View 2 Replies
May 7, 2012
I have an Address Book project with a listbox. The listbox is bound to the database via the little arrow pop-up box in the corner of the listbox. I have the DisplayMember set to FirstName, and obviously only display the First Name of the contact in the ListBox. Is there an easy way to change it so that it displays the First and Last names? I can't change the binding because I need it to get the ID of the record selected.Here's the basis of my code...
Private Sub MainForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CompanyDataSet.Contacts' table. You can move,
[code].....
View 1 Replies
Sep 26, 2011
I have an application that receives data input from an automated set of devices. This data stream I have managed to capture & get it into a list box which I can sort based on the Device ID & the time that the response was received.There is a set time window for the devices to transmit their data into the application and during this each device is not limited to the number of responses it can send (ie :- Device 1 can send in 2 responses where Device 3 can send in 40 responses, etc).All of the responses are captured, listed & sorted within the listbox (this bit is working ).I now need to extract the last (ie:- latest) entry in the listbox for each Device ID & this is where I am stuck. I can retrieve the last item in the list but cant seem to extract the last item for each Device ID.[code]
View 2 Replies
Sep 21, 2011
Basically, our users enter values onto a spreadsheet and I have been asked make the spreadsheet output to a CSV file preferably each one completed appears as a single line in the CSV.Upon examining the spreadsheet, I cannot figure out the best way of acheiving this, or if it is easily acheivable in the first place.I have attached an example of the spreadsheet data, to give it some context the spreadsheet records times that carers have visited a client, which can happen many times a day over many days per week, there is also a yes/no for each day on the sleepin.
View 5 Replies
Jan 3, 2011
I want it so every time I click an ITEM in the Listbox it displays ALL the data into the textbox. I know there's an easy way using table adapters and binding the listbox, but I'd prefer to do it this way for my project.
So this is what I got.
Lst.DataSource = ds
Lst.DisplayMember = "tblStudent.FirstName"
Lst.ValueMember = "tblStudent.StudentID"
[code]....
It only adds the first rows details to the text box when I click the second record the first rows details are still there.
View 2 Replies
May 26, 2011
I have a window having 2 dropdowmlists(schemename-SN and propertyno-PN) , one chkbox ,one "VIEW" button.SN has options "all" with value=0 and many other options with respctive values.Now,i want the code should behaves as follows:
1.0n window onload, SN must b visible bt PN nt.
2.if i select SN other thn All...the PN shud b visible and if i select "All" ,PN hides.
3.when check box is checked- PN hides,and if it is unchecked- PN visible..
Important:-This whole ddl n chk box are in updatable panel,button is nt in that.I want a browser compatible code so javascript can't b used directly(cz they give problem in mozzila and chrome).Right now, i have done this JavaScript and its is working fine.
function window.onload()
{
DisableProperty();
}
[code]....
but this code is not browser compatible.here onload,onkeyup and onclick functions are used , but they dont work in other browsers except internet explorer.
View 1 Replies
May 27, 2009
I have a data entry screen to collect data. At the bottom of the form I have buttons to add a new record, save current and add, save current and end, and an end without saving. The buttons all function properly. After clicking the save current and add new record button, a new blank record comes up with the cursor on the save current and add button. I haven't been able to figure out how reset the tab order so the first field in the entry screen is ready for data. I'm coming up empy on my research.
View 2 Replies
Apr 28, 2011
I have been trying to pass selected data from two dropdownlist (page1.aspx) to (page2.aspx) I am not having any luck as it seems the data is not being passed when selected. Please help, this doesn't seem that difficult, but I can not get it work. On (page2.aspx) the data from the dropdownlists will be passed to a stored procedure and all results will be in a gridview.
Here is my code:
Page1.aspx
<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="ST_Code" DataValueField="ST_Code" />
[code].....
View 1 Replies
Nov 4, 2011
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 Replies
Jul 19, 2010
I Have a data table like this:
UserID Username Password Email
an a dropdownlist that is binded to this table
DisplayMember is Username
Value member is UserID
now how can I get forexample Email when an Item is selected?
View 3 Replies
Nov 14, 2009
I am trying to create a data entry wpf form and I am getting the following error when trying to create a window1 loaded event: "table name table adapter is not a member of file name.new data connection set table adapter.table adapter manager" I understand the error message and checked all my names but to no avail. Below is my class statement and window 1 loaded event:Private data connection as new data connection setprivate tatable as new data connection set table adapter.table name table adapterprivate tamanager as new data connection set table adapter.table adapter managerprivate view as collectionvie
View 1 Replies
Oct 9, 2010
I have a program to make for a class i am in and i am stuck on this one part, its a form application where you have to enter the first and last name of five students along with their final grade then you click a submit button after each one and i need it so that after all five buttons are clicked it activates the summarize button and i can't figure out how to do that and another thing when you hit the summarize button it has to compare the grade against the value of a text box containing the pass threshold to amount how many passed or failed.
View 1 Replies
Jul 1, 2010
Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following code:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub
View 3 Replies
Jul 10, 2009
I am trying to make a program with a bar code reader for the first time. I am programming with VB 2005. I want to differentiate a bar code entry to keyboard entry. My questions:
1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
View 2 Replies
Feb 23, 2012
Im trying to do bind a dropdown list to a details view but keep getting an error about the dropdown list ID field:
<asp:TemplateField HeaderText="Approval">
<ItemTemplate>
<asp:DropDownList ID="Approved" runat="server" DataValueField="Approved" SelectedValue='<%#Bind("Approved") %>'>
<asp:ListItem Text="Approved" Value="Approved" />
[code]....
The error message as follows:
'Approved' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value
What is the proper way to attach the value of the dropdownlist to my object so that it can be properly created in the database? Most of my searches keep telling me how to bind a dropdownlist to an object data source, but that is not what I need to do. This is a basic drop down list of 2 items that will never change.
View 1 Replies
May 10, 2011
I have two dropdownlist, one is State and one is City. When a State is selected, the City dropdownlist becomes populated. At that point you can select a city, however if you select a city and go back and select a different state, the city dropdownlist is populated by the cities for both states. How do I get it clear the cities for the first state?
Here is the code behind
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
[Code].....
View 1 Replies
Dec 29, 2008
I'm new to developing and I work for a small company. I do have previous Microsoft Access experience and have used VBA code to enhance Access applications. But now I have been asked to develop a form for data entry using VB.NET. Is it possible to create a data entry screen from VB.NET that adds, saves, retrieves and manipulates data without using a database for storing the data. Users will not have Microsoft Access (or any other database) installed on their machines. They will only have the .exe file that I create after compiling the VB.NET application.
View 7 Replies
Jul 2, 2010
Using this tutorial How Do I: Create a One-to-Many Data Entry Form? as a reference Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub However, when I do that my related DataGridView (orders) is empty, how do I make it so that doesn't happen?
View 1 Replies
Jun 18, 2012
Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data.I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be the least compicated way to have these textboxes (19 of them) format the Long Integer values as I enter the data. I think a Lost Focus event would be silly; there must be a better, more efficient way.Also want to use this format when I retreive records from the db (don't see a reason to mask data in db)
View 7 Replies
Apr 28, 2009
Im new to this forum and VB Programming. I have installed Visual Basic Express 2008 and SQL Server. The first thing I did was create a new project and within that project created a new sql database. The database I created is to keep a list of clients and I have fields such as client_ID, Firstname..etc The next thing I did was create a data entry form for all the database fields using textboxes. Also 2 buttons named save & cancel. So when the user fills out the client info and clicks on save I want the data to be written to the client table. I know the code has to be written within the save button but I don't know where to start like opening the connection, writing to the database and closing the connection.
View 8 Replies
Feb 3, 2011
I wish to implement a Quicken like data entry into a text box. If you have used quicken check register, you know when you start typing into the Payee field, it presents you with a list of payees that match what you have typed so far as well as the catagory, amount etc.
I wish to implement similiar functionsality in a VB program (VS2008). I have some text(description) and a few atributes which are associated with the description.I wish to persist the data and am thinking about using a text or xml to do this.
I really think that a database would be overkill. I am looking at the textbox's auto complete property. The documentation says that the AutocompleteCustomsource is"AutoCompleteStringCollection" and am wondering how to really use this. I had started by thinking that I would
set up a dataset object (its native ability to read/write xml being a plus) but am wondering how to associate the customsource with the appropiate column in the (one) table in the dataset. The other possibility I am thinking is building my own class(probably inheriting from sorted list) that would also expose an AutoCompleteStringCollection.
View 8 Replies
