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);
[code]....
how to do this Also the drop down list in web service..
View 5 RepliesI am using dropdown list values Bound from data base my code
Public Function get_type() As String
'get type
If IsPostBack = False Then
[Code]......
Basically I have a form which has 2 drop downs. In the 1st drop down I am selecting City category. When the city is selected I want to update the 2nd drop down values in correspondence to 1st value choosen in 1st drop down. I have done like this,This adds the value in the 1st Drop Down:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim s As String = "connection String"
sqlconn = New SqlConnection(s)
[code]....
I've created a custom user control that has several properties. One specifies which database I want the control to access. I want to be able to present the user of the control a drop down from which he can select which database the control will interact with. How do I get the dropdown to work? I can get default values, but have yet to figure out how to get the selectable list.
View 4 RepliesHow to query a record in vb.net using combo or textbox via linq to sql like the search engine? Just like when you search in google or youtube, once you typed in the initial string on the textbox or combo box it will show a drop-down list. I tried to use it in my application using linq method but the problem is it would duplicate on the first string that you entered on the dropdown list if that record exist on your database after you press the space key. I used the code below which duplicates the records on the drop-down list when you type in your string after the space key.
I just want it to be like in any search engine that when you type in the string or your initial string, it will display on the drop-down list all the records from the database that contains the string you entered without duplication. In my case, I'm trying to query a name from my database. This is how it should work, For example, if you type an initial string in the textbox or combo box a named 'Mark', it should display all the names from the database containing 'Mark' into the drop-down list before it changes into its final string that you entered.
Here is the codes I used:
Private Sub ComboBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles
ComboBox1.TextChanged
Dim db As New MultipleDatabaseOperationDataContext
Dim search As String
search = ComboBox1.Text
[Code] .....
I have a list of servers in the first dropdown. I want to get list of all databases in the second dropdown depending on the server selected in the first dropdown.
For this I need to query each server while selecting the server.
This is the code that i did to fetch data from the database and filling it to the combobox dropdown list at the form load event:
[Code]....
i have the project as below...And i am putting the code over here.Imports System.Data.SqlClient Imports System.Data 'We have to add this line, its mandatory, if u dnt add this line and start declaring the variable "Dim dt As DataTable" Then u will get the error.
[Code]...
I'm populating a custom dropdown list control on the fly that's tied to data grid using VB .NET 2008. The form will display all the manufactures when the edit button on the data grid is selected.
The dropdown I created works fine. However, when I try to populate the drop down with the respected manufacture values from the database, I only get a value of "System.Data.DataRowView" that being populated in the dropdown list as opposed to my values from the database.
Here's the basic code I use to first create and populate the drop down control:
<asp:DropDownList ID="Manufacturedd" Runat="server" DataSource='<%# m_ItrackerData.Tables("Misc_Manufacture") %>' SelectedIndex='<%# getSelectedManufacture(DataBinder.Eval(Container, "DataItem.Manufacture"))
%>'></asp:DropDownList>
[Code]....
I have a custom control. I need to add a property, say, Comparison, to the control. The property should be set at design time using a dropdown. The Dropdown will have String values like '=','>','<' etc.
I tried using Enum values and working perfectly but I need to do some extra coding to convert the Enum values to the string I required. It would be great if I can get the values from the dropdown so that I can directly use the selcted value.
I am having trouble using the values that were selected from the dropdown list. How would you reccommend passing the selected values from the view?Ideally, we want to use the selected dropdown values to determine a query.
View 1 RepliesI am making a app that reads options of a ini
dim config as new iniconfigsource("patch.ini")
dim test as string = config.configs("news").getstring("test")
Then I made a dropdown with options
I want my script to compare the values of the dropdown with the string readed from the ini
then uses it as selected value (the so called standard value) the one uc without clicking on the arrow if the none of the values match with the string value of the ini then it executes
dropdown1.selectedindex = 0
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.
View 5 RepliesHow can I add a data to my drop down list came from database? My code is this. And when I try using this:
<form id="form1" runat="server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
[Code].....
It got errors in a webpage that says controls are not allowed to be put here. I only have an empty dropdown right now.
<asp:DropDownList ID="DdLocation" runat="server"></asp:DropDownList>
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.
[Code]...
How to get a list of the files that were added to the resource file so I can add them to a dropdown list?
View 4 RepliesFunction Monitor() As ActionResult
Dim db = New QuarterDBContext()
Dim items As IEnumerable(Of SelectListItem) = db.getQuarter.[Select](Function(c) New
[code].....
I need to create a sample question types web form in VB.NET which allow user to the following:he user selects the control type from dropdown (TextBox, RadioButton, ListBox etc). Generate controls dynamically based on the control type on the webform.It will always show the TextBox (where user writes the question) and (generated control - TextBox, RadioButton, ListBox etc) and save those values to the database.
View 3 RepliesHow to set up a Chart using the new MS Chart control. I want to be able to populate the data via SQL because the user will be able to dynamically change the values via drop downs. The format of the data will be the same (Qty, Time Period) but the Focus of that data will change. I'm honestly not sure where to start, I can draw the chart but I have no idea how to populate it with data via code so it can be changed dynamically.
VBE 2010, and I'm hitting an AccessDB
I want to have a drop down menu with the values:
Year 7
Year 8
Year 9
And I want to display different tables for each the values selected in the drop down menu. For example, when the "Year 7" value is selected in the drop down menu, a table is displayed for that year.
There are three files:index.aspx
serverInfo.cs
setup.aspx.vb
My enum is in:
//Class:serverInfo.cs
public enum ServerVersion
[Code]...
See which version is selected via dropdown list, compare this to the value in the enum store in var and add to my connection check.
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
select sector: 1)technology
2) trading
3) industrial
but if the user choose subsector, the subsector value will be appear in the dropdownlist
select subsector: 1) computer
2) utilities
3) consumer
i try to use the hide code but it turns out to be error. i think because of the data overloading.
add optgroup option to dropdown list, The dropdown source is getting from sqlserver.
View 3 RepliesI 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.
<asp:Content ID="Content2" ContentPlaceHolderID="body" Runat="Server"><br /><br /><br />
<asp:linkbutton id="btnAll" runat="server" text="ALL" onclick="btnAll_Click" />
[Code]....
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?
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
[code].....
Is there a way to disable an asp.net dropdown list from the vb code behind?
<select id="reassign_reason" name="reassign_reason">
This is the name of my drop down list and I tried this in the code behind in vb.net
reassign_reason.disabled = True
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
[Code]......
Function Monitor() As ActionResult
Dim db = New QuarterDBContext()
Dim items As IEnumerable(Of SelectListItem) = db.getQuarter.[Select](Function(c) New
[code].....