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]....
My dropdownlist is set to databine like this...
dt = dal.FillDataTable(SqlConnectionString, "SELECT SQL Query Statement")
dropdownlist1.datasource = dt
dropdownlist1.datatextfield = dt.columns.item(0).tostring
dropdownlist1.databind()
This is turn populates my dropdownlist, when a user selects a value, it is then populated to the remaining textboxes on the remaining forms with a session call...
dropdownlist2.add(ctype(session.item("valOne"), String))
Through this session it populates the one value, is it possible to display the selected value but also include all other dropdownlist items in case they want to change thier selection?
I have a couple of dropdown lists like this
<asp:DropDownList runat="server" OnSelectedIndexChanged="Update_ddls" AutoPostBack="true" ID="ddl1" />
<asp:DropDownList runat="server" ID="ddl2" />
[Code]...
I also have a function called Update_ddls which runs OnSelectedIndexChanged that looks like this
ddl2.Items.Remove(ddl2.Items.FindByValue(ddl1.SelectedValue.ToString()))
Which removes the selected item in ddl1 from the second dropdown but if I keep changing the ddl1 item then ddl2 won't have any items left in it.
Is there a way to re-add the previously deleted items in the Update_dlls function without re-databinding because if I re-databind I lose the selected item in the ddl?
Im doing the same thing as him but in vb express 2008 what i have is a checklist box of 10 toppings, all of which can be selected, (no max or min) to put on a pizza, and i have 3 radio buttons grouped together for pizza size (S, M, L) i cant figure out how to give them vaules in which(for sake of demonstration) s=$5 m=$7 l=$9 and each topping is $0.25 then make them add up to an order total in a msg box or something like that
View 2 RepliesI am a newbie of using a vb.net. And I am eager to know everything around. I have a problem that seems hard to find for. I would like to retrieve data from database using drop down list, and select only the fields that i want to retrieve from it.
DesignationTable From my table i like to display only two in my drop down list
[code].....
I have a few drop down lists that I'd like to populate from a table in an SQL database. I tried setting it in the DataBindings section of Properties but I guess that doesn't work.
View 11 RepliesBackground - I'm trying to populate a drop down list with state information from a database. I'd like the full state name to be the option and the state abbreviation to be the value. Example:
<option value="AL">ALABAMA</option>
Current Progress - The full state names and abbreviations already exist in the DB. I've successfully populated the DDL with full state names from the DB. Here's the code I've used to do this (minus stuff I've deemed irrelevant).Model Context (generated from template):
Partial Public Class BrokerCRMEntities
Public Property States() As DbSet(Of State)
End Class
State Model (generated from template):
Partial Public Class State
[Code]...
Question - In addition to populating full state names like I've done above, I'd also like to populate the value of the select options in the same DDL with the state abbreviations in my DB/model. How is this done?
So in this gridview, there is a column for status and I want to have a drop down list with Pass, Pending, Fail appear when the edit button is clicked. These values are already in a table, so I need to somehow bind from this table to each ddl for every row.Here is the column from the gridview. As you can see, I would like to just have a label showing when not in edit mode, and a ddl when the edit button is pressed
<asp:TemplateField HeaderText="During Production Status" SortExpression="DuringProductionStatus">
<EditItemTemplate>
[code]......
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]....
Does anyone know if it is possible to make a drop down list control (when clicked) list its contents above the item, rather than below? Effectively, I need a drop up list rather than a drop down list...
View 1 RepliesIs it possible to reorder the elements of a drop down list (combobox) via drag and drop?For example, when the list is dropped down, I want the user to be able to drag the items up or down to reorder them. I tried this (and some google searching) but I'm wondering if its just not possible:
Private Sub cmbClassLists_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles cmbClassLists.MouseDown
If cmbClassLists.DroppedDown And Not cmbClassLists.SelectedIndex = -1 Then
[code].....
i want to stop accepting form drop down listbox if certrain criteria is not met [code]how i can cancel the selection of drop down list?
View 3 RepliesI am writing an app that puts multiple controls on a form at run time and then I edit the controls in a property grid. All that is working fine. I'd like to 'mark' the contol when it is 'selected just like visual studio does with the dotted border (or soemthing similar, I don't care that it is just like vs). I'm already using MouseDown event to grab the control and send it to the PropertyGrid, but I have now wired it up to take multiple controls and need to 'identify' them on the screen.
View 1 RepliesI've got a form with following controls: Two Datetimepickers Two Buttons One TextBox One ComboBox The idea is adding and subtracting dates using Datetimepicker contols... I found codes for doing Dates Calculation but is'nt quit correct;for example: if i want to add 21years from today the result will be: sat 30 Aug 1930 The Adding Codes on comand button: Private Sub BTNadd_Click(ByVal sender As System.Object, ByVal e As
[Code]...
I am developing an app that has a treeview on the left in panel1 of a split container. When you click in a node it loads a user control into a tabcontrol that is in panel2. Some of the user contols contain webbrowsers that autorefresh every 15 sec (not under my control). I can successfully remove a tab by a contextmenu but I can still hear the clicking sound of the webbrowsers refreshing. Not sure what to do to completely remove the usercontrol. Treeview control code for one node: there rest are basically the same
Code:
Dim tabcount As Integer
tabcount = TabControlMain.TabCount
[CODE]...
Code to remove a tab and all tabs:
Code:
Private Sub RemoveToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RemoveToolStripMenuItem.Click
TabControlMain.Controls.Remove(TabControlMain.SelectedTab)
[CODE]...
I also originally had this setup to work without the tabcontrol and just load the usercontrol into panel2 of the split container. Each time a new node was selected from the treeview I would have SplitContainer1.Panel2.Controls.Clear() to remove the current usercontrol. I would still hear the clicking of the old usercontrol.
I have a fairly large Drop down menu:
<asp:DropDownList ID="DropDownList8" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList8_SelectedIndexChanged">
<asp:ListItem Value="" Selected="True"></asp:ListItem>
[code]......
Protected Sub registerStudButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles registerStudButton.Click
[Code]...
I created a vb program so anyone in my company can open it and see who is using what phone number offsite, and since different people go to different places each day, i linked the name and place fields to their respective database.
View 3 RepliesLong time no see. I have been feeling out other languages like perl, python, French, Russian, and c sharp.
Anyway, I have this code.
Code:
Imports System.Windows.Forms.Button
Public Class ProBtn
Inherits Button
[Code].....
I can drag and drop items from my desktop or wherever and apply certain properties and values to my button (ProBtn Class) but I don't know how to drag and drop between control to switch them.
how to change 2nd drop down list value after I selected the 1st drop down list value.
The best example is country and state. After user selected country, the state value should change accordingly.
I am still new in ASP.NET and I know in PHP it can be easily done using javascript.
May I know how to do it in ASP.NET using VB language?
I fill a dropdownlist item with the following commands
View 2 RepliesI am trying to compare a calculated date with a value in a dropdown list. The value is a date.toString.This is what I have so far:
Dim sched = scheduleDateVal.toString("d"
If Holidays.Items.Contains(New ListItem(sched.ToString("d"))) Then
ScheduleDate.Text = scheduleDateVal.AddDays(1).toString("d")
End If
Holidays is a dropdown list bound to a database so that I can add a day to a scheduledate if it happens to fall on a holiday. This works if I add a string value to sched rather than converting scheduledateval to a string.
I'm creating a simulation programe. In one sheet I have a group of cells (AngleConf) that have a drop down list. I would like to make some operations when I change the value of one of these cells. It always works when I insert the new value manually. But it doesn't always works when I change it by selecting the value from the list. I supose that that happens because of some option that I change while I'm working but I can't find out witch one exactly.The code that I think that its implicated:
Sub Worksheet_Change(ByVal Target As Range)
If InRange(Target, Range("AngleConf")) Then
Call resistance 'Actualiser le r�sultat mecanique
[code].....
I am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
tbFrom = "one" and tbTo= "two" use drag and drop to swap the values so that tbFrom.text = "two" and tbTo.text = "one" with tbNope.text = "three" but you aren't allowed to drop in tbNope. Show the appropriate symbols for allow drop and don't allow drop. set allowdrop to true for tbFrom and tbTo. So far i have one way working.
Public class Form1
Private sub tbMouseDown(ByVal sender As Object, ByVal e As System.Windows.Form.MouseEventArgs) Handles tbFrom.MouseDown
TbFrom.DoDragDrop(TbFrom.Text, DragDropEffects.move)
[Code]....
I've written a program to work out the flight distance between a set of seven cities around the world using a 2D array but was wondering how I would if possible go about having the values for each city selected via two drop down lists (say start city and destination city).
Public Class frmDistance
Private Sub Flightdist_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim rowcolumn(7, 7) As Integer
Dim sr As IO.StreamReader = IO.File.OpenText("Distance1.Txt")
[code]....
I'm trying to find a dropdown-style list for images I can use in a program of mine. It's fairly simple, just needs to display a few images in a grid with tooltips for each one, and I need to be able to get whichever one was last picked. For example,[URL] without the tab bar in it. Unfortunately my monetary budget is zero which means I can't purchase any controls?
View 2 RepliesI have a need to click on this drop down list and select a month. Here is the HTML code on the site
[Code]....
I cannot get the value from the drop down list and I not sure what's wrong with the declaration and the code.
Dim selectedIntake As String = intakeDropDownList.SelectedItem.Text()
Dim selectedSupervisor As String = supervisorDropDownList.SelectedItem.Text()
.supervisor_ID = selectedSupervisor(0), _
[Code]....
This is the error message I get :
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_student_Details_lecturer_Details". The conflict occurred in database "SKTM-AAS", table "dbo.lecturer_Details", column 'supervisor_ID'. The statement has been terminated.
