May i have a working sample on how to retrieve records from a DB & populate the relevant textboxes after a selection at a dropdownlist. What i have is definitely not working & im working on VS 2008. Can anyone show me the way?
[Code]...
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
Private Sub frmLocation_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.Open()
[Code] .....
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
Visual Basic 2010 Express: I have a form with a combobox that is populated with the names of locations from a datagrid which in turn was imported at run-time (Form_Load) from an Excel database. The Excel database (and the datagrid) also stores the information for addresses and phone numbers for their respective locations.
What I would like to do is have the phone number and address text boxes automatically be updated with the proper corresponding data when the user selects a location from the combobox. Whether the text boxes are updated from the datagrid or Excel database is not a concern; I'm mainly looking for whichever way is simpler.
I have found a couple of examples on the internet to do this but really struggling to get it working in VB. (Tried a converter but had mixed results) I need the selection options of a Dropdownlist to be populated based upon the differing values in the first dropdown list.
Can anyone help with a releativley simple example in VB? Not fussed if the values are "hard coded" in the script. Or a SQL bit that pulls the data from a table
I have a form which populates a TextBox I want to use the textBox.text to then load a gridView with the results
[code]...
I'm trying to write a program that selects an item (Area Code) from a combobox and this list gets the city that was associated with this area code (another comnbobox list)
View 1 RepliesI would like to change the dropdown list and whenever I make some changes it should auto post back and triggers a selectedindexchanged event for drop down list. I am having problem where it does auto post back but doesnt remember what I selected, it refreshes my page and item that i selected gets lost. I would like to do this without AJAX call. But, if AJAX is the only option, I am open to it.
<asp:DropDownList ID="ddlProjectEditor" CssClass="ddlProjectEditor" Autopostback="true" runat="server" >
</asp:DropDownList>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim F As facility = utilities.lookForFacility
'Option to add Project information in editor
_config =
[Code]...
I have created a connection string, and i am populating a dropdownlist with an ID from a sql database.I want to be able to click on a ID from the dropdownlist and run a query to populate a gridview with data. I have made the dropdownlist autopostback = Enabled. I am not getting an error.
Here is my code:
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlContracts.SelectedIndexChanged
Dim ds As New DataSet
[code]....
Where can I get a list of all countries/cities to populate a listbox?
I'm trying to fill my dropdownlist with all world countries from windows, is there any way to make my dropdownlist get all countries from windows?
Or do anybody have a XML with all the list so I can use it?
I am new to Ajax and have a rough idea about Ajax. I am developing a website having a feedback page in which, i want to populate the state/city DropDownList box depending upon the value selected in country DropDownList box.
I have seen some examples downloaded online but they are not working in my application due to many possible reasons, some of them may be the feedback page in my application is a content page, the web application is asp.net 2.0 web application, i don't have any additional ajax tools or scripts installed.give me the solution that should work with asp.net 2.0 web application (in VB.NET) and the feedback page is a content page. I don't want to add custom controls. I want to do it straight away with javascript or vbscript using XMLHTTP object.
After everything is set right with Ajax. What if the browser doesn't support Ajax? What should i do in such case?
I'm using VWD 2010 and a SQL Explress 2008 remote database Within the IDE, I can populate a dropdownlist but after I deploy the website, I recieve this error:
System.IndexOutOfRangeException: There is no row at position 0.
Line 52: cmdEmpSched.ExecuteReader()
Line 53:
[code]....
Have two dropdownlist inside the edit template of a DataList. The first dropdwon is for state while the second is for town. The state is populated from a table state while the second from a table town when state is selected.
View 1 RepliesI want to be able to change an image depending on what is selected in the drop down box. I have this JS code to change the image. Simplified of course.
<script type="text/javascript">
function changeImage() {
var oDDL = document.all("ddlNAME");
var NAME= oDDL.options[oDDL.selectedIndex].text;
switch(NAME) {
[Code] .....
When I call this function I do it in my DDL implementation.
<asp:DropDownList ID="ddlNAME" runat="server" OnTextChanged="changeImage()" >
But for some reason the changeImage() is not firing. It is giving me an error saying
'changeImage' is not a member of 'ASP.default_aspx'
I want to populate the dropdownlist ddVerantwortlich1 with the people with the proper credentials based on the selected process step ddProzesss chritt1.It doesn't work if I want to change it using datasource and databindi have to manually loop through the table in the dataset returned from the query. then it works. but not otherwise.[code]
View 1 RepliesI am currently stuck in one part of my application. I have two combo boxes that i am having the users select from. The first combo box is simply bound to a datatable. that is working properly. The second one i need to populate off another datatable after sorting out what the first one is requesting. Basically it's choosing a line number on the first box and then selecting the machine associated with that line number.[code]...
View 4 RepliesHow can i bind a comobox selection to a datagridview without writting code...
i Need to select an item from a combox and based on that item refresh the datagrdiview. I did something like that in Access but i don't know how to make it work in visual studio 2008.
once i select the datagridview itme that i want to edit i'd like to be able to update back to the database. I know i need to write code for this but at least i'll have the data refreshed on the datagridview.
I am currently using the NorthWindDataSet from the msdn tutorials.So far, here is what I have to populate one of the listboxes on my form:[code] I make a selection in ListBox2 I would like ListBox3 on my form to be populated with that particular person's Order #'s.
View 2 RepliesI have a web page where I am trying to populate the PSI # into the txtPSI depending on which customer is selected in ddlCustomers.I have written it a way it has worked on a past project and it compiles with no errors, however it doesn't work when it runs.
The code adder is not working so I had to add it manually.
Protected
Sub ddlCustomers_SelectedIndexChanged(ByVal
sender As
[code]....
Can you populate a Listbox and not have a default item selected?(Usually I see the first item in the list automatically selected at creation).
View 5 RepliesI need to populate a combobox using the selected value in another combo. The coding that i use doesn't produce the required output. i have an excel sheet with columns called "BaseStation" & "SectorID". Combobox2 must display the related sector id with respect to the selected BaseStation[code]...
View 1 RepliesI'm new to programming and I'm using vb.net 2010 and I'm stuck with this problem. So here are the details, I have 2 tables in my database, a product table and a category table. In my product table I have product no, product description and category no. In the category table i have category no and category desciption. So this is where Ive been stuck for the entire day, I want my combox(product) to populate based on what is in the combobox(category). For example I have "Chair" in my combobox(category), then what would appear in the combobox(product) would be "sofas", "dining chair" etc.'the part below is where the program will read the category description from my database
Sub fillcomboDesc()
Dim fillcatDesc As MySqlCommand = New MySqlCommand("Select catDesc from category;", connection)
[code]....
I have four comboboxes in my Ist form related to course as.c_type,c_stream,c_major,c_nature.......combobox c_type contains the type of courses like degree,diploma, PG etc,similarly "c_stream" contains stream like engg,medical etc. further c_major contains all courses like computer engg(CE),mechnical(ME), physiotherapy etc. and last c_nature has course nature whether regular or private or distance.Now situation is when i select diploma from c_type, corresponding options must be populate in c_stream like engg. And now when i select engg., CE or ME must be there in c_major combobox .Same is for C_nature.The all 4 combobox must show "please select" text on form load event..i also have 2nd form where i have same combobxs. so is there any way to call the same code without again writing that to 2nd form.
View 1 RepliesI have a DropDownList that pulls values from a table in sql server. I want the dropdownlist to populate the list of values based on a selection by the user but also display the contents of the rest of my table in case they need to change something. For ex:
ddl1 has values of: 1, 2, 3, 4, 5 user selects 5, so the value displayed in ddl2 is five, but if you exand the ddl2 you will also see the values of one, two, three, four...
This is the code in my load event...
If Not IsPostBack Then
result = dal.dbConnect(DAL.dbType.SqlServer, ConfigurationManager.AppSetting("SQLServerConnection"))
[Code]....
Working on a project that contains a listView (populated from a database already) and several textboxes. What I am trying to do, and cannot figure out, is to program this so that when a user makes a selection in the listview, it hits a specific database, and based on certain values within that databse, the textboxes are populated with things such as name and address, etc..
View 2 Replieshow to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
[Code]...
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
I have a midterm project where we must replicate what our teacher has made, it is a convenience store program. I am having trouble calling the functions, he wants us to use these:
PopulateItems => Populate Items listbox based on the category selected
GetItemPrice => Retrieve the price for a given item
GetItemPriceFromPurchases => Retrieve the item price from the purchases list box (optional. You may not need
[CODE]...
So far I have the first list box populated when the form loads. However outside of that I do not know where to call the function in order to populate the second list box upon selection of the first.
I have a product table with ProductId,ProductName,ProductCode as fields. I've populated a combobox with productnames. Next I have two other tables called Result_Header and Result_Detail. The Result_Header table has ProductId as a foreign key and BatchNo,TestDate etc. The Result_Detail table has ResultId as a foreign key which is the ResultHeaders Primary Key and other fields such as Result,SpecHi etc. What I need is when I select a Product from my combobox my two datagridviews must be populated via the Result_header and Result_detail tables respectively.
View 20 RepliesI have default.aspx used masterpage, in master page i have a control called DefaultMenuContent, this control have a dropdownlist with autopostback, the problem is loosing the selection even if i use Is Not PostBack in control's load event, how to persist the dropdownlist selection?
In Master:
<asp:ContentPlaceHolder ID="MenuContentPlaceHolder" runat="server">
<art:DefaultArabicMenu ID="DefaultMenuContent" runat="server" />
</asp:ContentPlaceHolder>
[code]....
i am trying to bind a dropDownList control to a select query that has a parameter.the query itself runs fine on sqlserver database when the paramter is replaced with an actual datetime variable.the basic query is: SELECT DISTINCT DeliveryZone FROM dbo.tblComplaints WHERE (DeliveryZone IS NOT NULL)AND (DeliveryZone NOT IN ('**', '??', 'EE', 'T', 'M'))[code]
View 1 Replies