I don't know what you would call it but I want to do something like this:
I have a list that contains the following and will have more in the future.
{buffalo}
street
street2
street3
{end}
[Code]...
i m working on a project on vb.net with access database...and i need a code for separating the information from my complete package by following some kind of search,
1. for example if we type a word "publish" in a textbox and then click on a button...then it should display all the rows and columns containing the word "publish" in the grid view.
2.i also need a code for selecting the information from a particular column based on the key(or keyword) provided by the user
I need to strip out part of a datafield namely Column name "City" the data provider adds an abbreviation to the end of the City name Example: Houston[HST] I need /want to strip out the [HST]been trying to modify my statement with no luckI am using Jet 4.o and database is a .txt or .csv file
OleDb.OleDbCommand("Select *, (([AddressDisplay])&',' &([City])&',' &([State])&',' &([ZipCode])) AS Address, IIf(IsNull([BathsQuarter]),0,[BathsQuarter]*.25)+ IIF(IsNull([Bathshalf]),0,[Bathshalf]*.5)+ IIf(IsNull([Bathsthreequarter]),0,[Bathsthreequarter]*.75)+ IIf(IsNull([BathsFull]),[BathsTotal],[BathsFull]) AS BATH From " & Me.OpenFileDialog1.SafeFileName & " Where ListStatus <> 'Closed Sale'", con)
I want to do something along the lines of
txtCapital.Text = "Berlin" Or "Lisbon" Or "London" Or "Madrid"
but Visual Basic.Net says this is an invalid cast exception.Is there another way to create a random selection of for example a capital city from a list and then put into a text box?
I really need to know the list the types of components that are provided by the VB .Net?
View 3 RepliesI have been searching but unable to find any code examples of using a GPS coordinate to navigate to another GPS by road way. Is there a dll from MS Streets and Trips or any other software that would allow this to happen? This would also need to be done offline, so no Google or other online serive call outs.
View 1 RepliesSuppose you have list 1 (ilist1) and list 2 (ilist2) both lists have 3 items.
At index 0 item1 which has text "-- Select --"
At index 1 item2 which has text "Yes"
At index 2 item3 which has text "No"
Both lists have identical items. I would like to know if it is possible to have the selection of list one be "Yes" and the selection of list two be "No" and vice versa using SelectedIndexChanged or something of the sort.
For example:
ilist1 = --Select--
ilist2 = --Select--
[Code]....
I have a List myList of MyObjects. Is it possible to check if myList contains a particular myObject based on a property of myObject in VB.NET? In C#, you'd something similar to this right:
myList.Exists(myObject => myObject.property1 == 3)
What would be the fastest way to sort a list that contains a list of objects, based upon another list? An example follows:Say I have multiple lists of employees. Each individual list has a common property value, say "Department". So I have a list of employees, in one list they all have the department string value of "Sales". In another list all the objects have a department value of "Finance". These lists of employees are then contained in a list which holds them all.
I have a second list, which should drives the sort order of the employee lists. The second list simply contains a list of strings like, "Finance", "Sales", "IT" and so on. I'd like my lists of customers to be sorted in the order of "Finance", "Sales", etc.I'm using VB.NET in .NET 2.0
The problem at hand is to search an Access database for "duplicate" street addresses, given user input of street address, city, state, and zip code.Given the zip code, city and state do not need to be looked at.
My thought was to select off records in the database with the zip code that matches the input, then loop through those records, performing a "similarity" test on the street address field as compared to the input street address. Obviously we cannot test for exact matches (i.e. "SW" vs. "South West", etc.). This problem has obviously been solved before with post office software, algorithms used by mapping applications, etc.
But do you have any thoughts on what algorithm I might implement in a VB 2005 app?
I'm trying to display the population of a city, as soon as it has been chosen in the combobox.I put it on my formload, and it will always read the index of -1 since it hasnt had a chance to be chosen, how would I bypass this without a button being clicked?
If cboCities.SelectedIndex <> -1 Then
lblCurrentPop.Text = "The current population is: " & CStr(intPopulation(9))
Else
MessageBox.Show("You must select a city!")
I have here a code that will get the address entered. We want a dialog box to pop out with the city entered. Here is the code.
Code:
' displays the city name
Const Prompt As String = "Please enter a city name followed by a comma, a space, and a state name."
address As String
[code].....
sort a list based on numeric value of a list struct element:- For example... private structure myparamsdim level as integerdim otherend structure...level_list as new list(of myparams)..dim mydata as myparamsmydata.level=5level_list.add(mydata)mydata.level=9level_list.add(mydata)mydata.level=2level_list.add(mydata)'how do I get a list sorted by myparams.level?additionally, do I have to resort every time I add an entry or can I add in a way that it add's by .level?
View 1 RepliesI have following codes
str2 = "select sno,name from employees where sno =" & Val(Me.TextBox1.Text)
cmd2 = New SqlClient.SqlCommand(str2, con)
da2 = New SqlClient.SqlDataAdapter(cmd2)
[Code]....
Now dt2 has two columns as sno and name But I want to add a 3rd column city type char(80)
I have two dropdownlists, the first is State & the second is City. I have the State ddl populated, but I would like to populate the City ddl via the selection in the State ddl. I am using autoPostBack, so it goes through the motion of updating but nothing loads. I am sure it is in the code behind or in the databind.
View 1 RepliesI am parsing a file which contains customer address in the following 2 formats:
Format #1 12345 Melrose Place New York NY USA 12987
[Code]...
I need to put the data into Address, City, State and Zip fields. I am able to parse and put the data (specifically line 2) in the fields for format #1 but am having issues doing the same for format # 2 because format # 2 doesn't have USA as a reference point.
[Code]...
So I've gotten a lot of help from this forum for this incredibly large, incredibly pointless application I'm making right now.I need to be able to have people type in, say, the name of a city. Then it will display a table of Name / phone number.So I need a table that can change for each "city name", and can scroll down. I know I'll most likely have to save it to two variables for each "city", I'm already set up to do that. ( Variable Name, Variable Phone Number) What I don't know is how to... print the data into a table, or make two text boxes that will scroll simultaneously.If there is a way to attach a scroll-bar to two text boxes, that would be my preferred method. If I have to use a table, what would the substring and code look like to change:[code]
View 9 Replieshow can i split this? i have two different formats:
2920 Emmaus Ave, Zion,IL 60099
200 Lakeside Ct,Apt 1426 St. Charles,IL 60174
i was going to split by comma but sometimes the apt will end up in the city name. i don't want that.
I'm working with Windows Forms - VB.NET.Here's what I have:
A ListView with checkboxes set to True
A Button (triggers the update)
A database table with similar fields as the ListView
What I want to happen:when the user clicks the Button, all items on the ListView with checkbox checked will be updated.My progress:I've already collected the ID of the checked items and stored them in an array. I'll be using this to update the database table.I don't know how to put them in the SqlCommand.Parameters Also, I don't know the update command for such scenario (where in/exist (@parameters))
I am writing in VS2005 what, on the face if it, should be a relatively simple DLL, which will allow me to build a list of custom objects when called from within Excel 2007. To do this I have a Column and Columns class. As implied, Columns is a list of Column objects. The relevant classes are defined as follows:
[Code]...
I'm working with Windows Forms - VB.NET.
Here's what I have:
A ListView with checkboxes set to True A Button (triggers the update) A database table with similar fields as the ListView
What I want to happen:
when the user clicks the Button, all items on the ListView with checkbox checked will be updated.
My progress: I've already collected the ID of the checked items and stored them in an array. I'll be using this to update the database table.
The problem: I don't know how to put them in the SqlCommand.Parameters Also, I don't know the update command for such scenario (where in/exist (@parameters))
I know how to calculate a city's location on the world map by using its geographical coordinates as a pixel on the map but how in .net can I draw a link with a cuve? Once I have the curve does anyone know how to determine where the curve should be for the shortest route?
View 12 RepliesIs there a way to make one list box dependent on the other based on user input. Here's my situation: A teacher has the ability to enter the name of the student into a listbox via a textbox. The teacher may then select the student from the first student list box and input grades that would go into a grade listbox. If the teacher selects another student from the student list box, the grade listbox would either go empty or show the grades inputed for the other student; all the while retaining all previously recorded grades for other students.
View 1 RepliesI need to determine the ranking of the List items specified by one specific property of the items.
I have the following Class:
Public Class LevelA
Property items as New List(Of LevelB)
Public Class LevelB
Property factor as Double
ReadOnly Property rank as Integer
End Class
End Class
For example, let's say I have three items in the List. I have set the factor property for the first item as 5.50, the second item as 6.60 and the third item as 3.30.Now I should be able to get the rank property of each item (the highest value should be ranked as 1). Here the first item in the list should have the rank as 2, the second item as 1 and the third item as 3.
What kind of procedure is needed for the "ReadOnly Property rank as Integer" for returning such values? It should somehow be able to access the list in the parent class probably?
I am using a list to keep track of a number of custom Row objects as follows:
Public Rows As List(Of Row)()
Row has 2 properties, Key (a String) and Cells (an ArrayList).
I need to be able to sort each Row within Rows based on a developer defined index of the Cells ArrayList.
So for example based on the following Rows
Row1.Cells = ("b", "12")
Row2.Cells = ("a", "23")
Rows.Sort(0) would result in Row2 being first in the Rows list. What would be the best way of going about implementing this?
I have a list of collection of points on the screen. I want to order them based on their distance from a seperate, independent point. What's working is I have a function GetDistance which does the dirty pythagorian work of returning the distance between two points.
'Create the set point from which to start all measurements from (startpoint)
dim SetPoint as new Point(200,200)
'Create a list to hold arbitrary points to test (endpoints)
dim ListOfPoints as new list(of point)
[Code].....
I have a database that has a text and a lot contain a free form of the person's address, city, state, and zip.
Incoming text would be:
John W Doe 1234 Big Lake Dr., Fort Worth, TX 76120 111-222-3333 jdoe@domain.net
Output of function should be:
1234 Big Lake Dr., Fort Worth, TX 76120
Here is some code I tried but doesn't seem to find anything:
Private Sub btnXMLTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnXMLTest.Click
lblOutput.Text = fnRegex("'John W Doe 1234 Big Lake Dr., Fort Worth, TX 76120 111-222-3333 jdoe@domain.net")
'other samples
[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 created a .NET application that reports to a log file the contents of a registry key. My code works perfectly but it is choking on one of the string values found in the registry. The code that works normally is below.
[Code]...
Sub Users_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Users.Click
Dim fmtstr As String = "{0,-15} {1} {3}"
[code]....