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);
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)
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.
How 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.
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.
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:
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.
I 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.
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 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.
How 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.
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 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
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