I have a dropdownlist that I want to populate with a specific value and specific text. I'm not using a datasource but I am manually making a connection and retrieving data in code. How can I populate this dropdownlist? If I read the data with a datareader and increment an array I only get either the value or the text. This is what I have so far, but it is completely wrong:
//connection string etc goes here
Dbcmd2.CommandText = "select dept,deptname from table"
Dim dr As SqlClient.SqlDataReader[code]....
How can I get this to work without having to create a class object for Department? Is there anyway or should I create the class object?
What i am trying to do is get a user to change one drop down, which then calls an ajax function which posts to the code behind (vb.net file) then clears and populates another asp dropdown list with the data returned from the function..[code]...
i have a requirement of using a dropdown list/combobox in data grid for allowing user to select from the list. how can i do that.I want to have a particular column with this option available that should be filled with data from the SQL database.
[Code]...
now in this what i want is that user could select the emp id for which he wants to enter the data.then on the basis of the selection emp name field should be filled automatically and then user enter the salary which get saved after pressing a button on form how could i achieve that in VB.net and using SQL databse
Is it possible to change the data source of a dropdown list in a gridview from another dropdown list selected index changed method in the same gridview?
for example I have a dropdown that needs to change its contents depending on what is chosen in the previous cell of the gridview, which is also a dropdown list.
I am working on a project and I want to have a list box with a custom data template populate with user data. My question is, when I click on an item in the list box, how can I tell what item I selected? Basically, if I select "kevin", I want to display his data. If I select Dave, I want to display his data. I do not know how to get the data our after it is bound...
I have created a sub that I am using over and over again. However, I am not able to get the values from the database. Screen shots and code attached. I need a second pair of eyes, can't seem to figure out what is wrong.
Form Load vb 'Populate the drop down lists PopulateDropDownListFromDB(cboReferrerType, "ReferrerType", "ReferrerName")
I have the following "contact" data (exampled below) stored in an xml file.I've created a frmContacts windows form and placed a list box control inside it.I'm new to the list box but plan to have the users manage the list by letting them add, delete, and pick from it. For searching there should also be a sort function/button (by last name then first name).If the user deletes from the list the corresponding data in the file will be deleted.If the user picks from or adds to the list, I'd like to find the best way to populate the corresponding data elements on another form (i.e., in their respective text boxes). This will include the ability to edit/save from this other form too.
I am trying to populate a VB.net dropdown box which is repeated in a datagrid. Basically I have a bunch of images and the user needs to select from a dropdown listwhat colour the item is so that I can then save it in the database.
Dim DDLPlayColorList = New DropDownList DDLPlayColorList = dgImages.FindControl("DDLPlayColorList") Using oConn As New
I am trying to select a dropdown and populate about 10 textboxes with information. The information is in a database. I know one option would be to write a stored procedure and pass the value of the dropdown box to the sp and then use SqlDataReader to readthe values to populate the textboxes. I am new to VB and was wondering if i should attempt this using LINQ?
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]
How can i make a dropdown list with checkboxes ? I have a windows app ( vb.net) and the checkboxlist control is not real an option with the available space on my form.
I have a web form in which i have droped 6 dropdownlists and each dropdownlist have previous seven dates to open files from a specific folder concatenated with date at the end of file name.Problem is that when i select first dropdown list it opens file fine but when i select a date from anyother dropdownlist to open file then it open the same file which was opened from the first dropdownlist.Please see the code and make correction in it.
Function Monitor() As ActionResult Dim db = New QuarterDBContext() Dim items As IEnumerable(Of SelectListItem) = db.getQuarter.[Select](Function(c) New
i want to create a dropdown list which depend on each other. as example. the 1st dropdown list will let the user to select the type between sector or subsector.
select type: 1) sector 2) subsector
if the user choose sector, the sector value will be appear in the dropdownlist
I would like my gridview to be filtered by the dropdown list I have. It is pulling specific information from the database, so when you choose a value from the dropdown list, it should search through all the records and find only records with the ddl value in them.
The code that I am using in the codebehind for the SelectedIndexChanged is not right though. I get an error message saying 'Value' is not a member of 'Integer'. This is on the line dsCompanyFilter.SelectParameters.Add
It probably has something to do with the gridview not tying to the dropdown list properly, but I am not sure how to fix that code.
I have a dropdown list control which when a particular item is selected, another dropdown's list is populated based on that selection. The code behind is below.
Imports System.IO Partial Class Data Inherits System.Web.UI.Page
im working on an app for work that just simplifies some tasks. what id like to do is place all running processes in a combo box so that when i click "kill process" it will kill the selected process.
Public Class Form1 Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Function Monitor() As ActionResult Dim db = New QuarterDBContext() Dim items As IEnumerable(Of SelectListItem) = db.getQuarter.[Select](Function(c) New
how to setup a dropdown list over the gridview when I am in the editing mode? I would like use the code behind to bind the data after assigning to the data source... I am using Visual Studio 2008 ...
How do I make options in a drop down list display variables? For example this is what I would like to have done:-in form1, a user types seven words into 7 text-boxes.-in form2, a user clicks on a drop-down list to select one of the words that was previously typed in to a txtbox in form1.
I want to retrieve value from database.........I have a sql table with (Username [Primary Key] , Friends, dob, contact ) columns; table name is MyFriends
Now Code is...... string qry = "select Friends from MyFriends where UserName='hrs'"; da = new SqlDataAdapter(qry, connection);
