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]......
ComboBox drop up instead of drop down..i want to defualt for a particular drop down box to work this way how can i do it.
View 6 RepliesI'm using an unbound data grid in Visual Basic. I made the following loop for the purpose of searching each cell and each column for a duplicate value. But for some reason I get a "InvalidCastException" when I try to add a second row.
Private Sub AddJudgeBtn_Click(sender As System.Object, e As System.EventArgs) Handles AddJudgeBtn.Click
Dim exists As Boolean
' ToDo: If the value entered is already on the list, don't add again.
If JudgeList.Rows.Count() > 0 Then
[code]...
EDIT: Adding the entire click event.
I am trying to get duplicate values from dgv into a combo:
[Code]...
m_ListOfsAllFields.OrderBy(Function(x) x.DisplayOrder)
here I have DisplayOrder = 0 for 2 fields, so orderby is messing up and not ordering properly. How can I use orderby to order this collection?
How can i avoid the duplicate values in the Access Database?? I am working in VB.NET, to create DataEntry Form. I have Combobox. When enter the value on Combobox and press OK button then the value should check on the database , if the value is not there then it should save on the db. else the Missage will give "It is Saved".
View 6 RepliesI want to insert number for City_Id and City_name , i wrote a query for auto generate number for City_Id,working fine but in the city name i want to avoid inserting duplicate value like if Mumbai is a City ihave already saved then system should not allow that name again. neither in small or in capital or mixed letter.
View 4 Repliesam new to VB.NET and i was wondering if anyone here knows how to check for duplicate values in strings?
View 11 RepliesI need to validate a particular coloumn in datagrid for duplicate values before inserting into database. I am using datatable.
View 9 RepliesGet Random value with no duplicate
[Code]...
How can I avoid Duplicate values in Datagrideview. When I am putting Product Id in Invoice which is adding in datagrideview if it is exist in datagrideview it will Highlight with deferent color and give me massage that this Id is existent in datagrideview
View 4 RepliesI have a form where two fields on the first page of the form make up the primary key. I want to check for duplicate values before attempting to insert the record, since I don't want the user to go all the way through the form only to find out they can't submit it. So I'm trying to check for duplicate values when the user tries to go to the next page of the form. I wasn't quite sure how to do it, and sure enough I'm getting an error. ("Object reference not set to an instance of an object.") The problem is apparently in my if statement, "If myValue.Length > 0 Then", but I'm not sure what needs to be in place of that.
Protected Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate
'get values
[code].....
I am trying to create a .Net application to edit a excel file by deleting some columns and keeping the columns which we need and then removing the duplicate values based on the first column which is going to be the Serial no. which should have a check to have 6 digits by default like 2563 should be displayed as 002563.
Code:
Public Function GetAllFileContents(ByVal path As String, ByRef errorMessage As String) As IList(Of String)
Dim contents = New List(Of String)
Try
Dim files = Directory.GetFiles(path, "*.xls")
If (files.Length = 0) Then errorMessage = "Please select the files"
For Each file In files
[Code] .....
I am trying to create something different by not only letting me do it for excel files but for say txt and csv files along with it. Removing all the values which I dont want and removing the duplicates and then if possible putting a check on the first column of data that the serial number number should have minimum of 6 characters and then The output file should have all the details in Uppercase
How do I prevent users from a inserting a duplicate value using SQL Query
datatype is VarChar(50)
e.g. the name field has already been defined as "Josh", I don't want it to be able to add another "Josh"
I am sending values from Combobox and Textbox to Access Database in VB.NET.I am phasing the problem when i enter the Duplicate values.In the database one of the column is Indexed.(Yes Duplicates not allow)That column i bind to Textbox("txtperson1").I used the TRY and Catche method to solve the Indexed Problem.when i run the application the value which i enter is not a duplicate that value save on the db. Once i enter the Duplicate value , the message box is showing "The Record alread saved".But After i enter the new value the same message is displaying, it is not saving on the db.
[Code]...
Here is my
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BHgardeners11.mdb;")
cn.Open()
Try
str = "UPDATE Products SET ProductCode = ?, ProductManufacturerCode = ?, ProductsTitle = ?,
[Code] .....
If there is only one item in the database, then this code works. If there is more than one record then the error is produced that it is trying to produce duplicate values. This is down to the Primary key in my database which is the only thing that cannot have duplicate values. However, when I remove the primary key it has the predictable problem that it goes crazy and does weird things.
I had restart my program for 5 times, and i still can get through it. the due date just around the corner.
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."
The problem is: I have a list of objects, with some containing the same PlanId property value. I want to only grab the first occurrence of those and ignore the next object with that PlanId. The root problem is a View in the database, but it's tied in everywhere and I don't know if changing it will break a ton of stuff nearing a deadline.
So, if I have a list of PlanObjects like such.
Plan1.PlanId = 1
Plan2.PlanId = 1
Plan3.PlanId = 2
Plan4.PlanId = 3
Plan5.PlanId = 4
Plan6.PlanId = 4
I want to take a sub-list from that with LINQ (italics mean an item is not included)
Plan1.PlanId = 1
Plan2.PlanId = 1
Plan3.PlanId = 2
Plan4.PlanId = 3
Plan5.PlanId = 4
Plan6.PlanId = 4
For my needs, it doesn't matter which one is taken first. The Id is used to update a datsbase record.
I have a program that reads a 3rd party .txt file using OleDB into a DataTable When it reads it, its creating a column alias name, and works fine.
gives the user the ability to save a record to the .txt file by using an OleDb command statement and inserting a record into the DataTable then I re-write the file using stream writer because my understanding is you can NOT write directly into the .txt file.
I have created the program to read column postion rather then name since some data providers call columns different names, but I havent encountered a provider using the same name for 2 different columns.
I am using the TextFieldParser to read a 3rd party .txt Tab Delimited File Sometimes the file contains duplicate column names and subsequently I cant create my DataTable.
How can I check for duplicates first and change the name of the duplicate fields so I can populate my Table?
Example:
I have two columns called ST and would like to Change of of them to ST1 or something similiar to populate my table
Dim safeFileName As String = IO.Path.GetFileName(Me.OpenFileDialog1.FileName)
Using myReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(safeFileName)
myReader.SetDelimiters(vbTab)
[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 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 Repliesi 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]...
Long 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.
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 have two list boxes. A users selects a value from each, clicks a button and the application creates a relationship between the two selected items by saving them in an array and displaying the relationship in a third list box.
What I want to allow is for users to be able to drag a value from one list box and drop it on top of another value. I have the code to capture the value of the item dragged but I don't see how to capture the item that the data is dropped onto.
Is there a way to capture the targeted selected item?
I am able to successfully get a value from a datagridview using the following
MsgBox(Files.Item(4, i).Value)
When the cell has a drop down, I am not able to get the value, it just comes back blank.How can I get the value from a drop down box?