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 Replies
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'm looking for specific and current advice from professional .NET + SQL Server developers on:[code]I'm starting a new position next week in which I will be developing advanced accounting software (LAN software) using Visual Studio 2010, Visual Basic, and SQL Server.I am an experienced programmer (16 years), with a strong background in web development using Python, PostgreSQL, PHP, MySQL. I have also completed a number of smaller projects in Visual C#, so I have a general familiarity with .NET. I have not used Microsoft SQL Server.
View 2 RepliesI need to calculate the location of intersections between multiple date ranges, and the number of overlapping intersections. Then I need to show which date/time ranges overlap each of those intersecting sections. It is slightly more complicated than that so I'll do my best to explain by providing an example. I am working in VB.Net, but C# examples are acceptable as well as I work in both.
We have several high risk tasks that involve the same system. Below I have three example jobs named HR1/2/3/4 with start and end date/times.
HR1 {1/6/2010 10:00 - 1/6/2010 15:00}
HR2 {1/6/2010 11:00 - 1/6/2010 18:00}
HR3 {1/6/2010 12:00 - 1/6/2010 14:00}
[Code]....
What is the code for "Hello World" in Visual Basic 2010 Express?
View 1 RepliesI'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].....
I 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 have a project to calculate how many day is there before 05/12/2010.
View 10 RepliesI 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 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]....
In the TextBox1 I have the following numbers:5 4.1 6.23 0 0 7 7.924
Possible to calculate all the numbers in this way?
like replace all the "space" in "+" and get the answer or something?
I'm new to VB and i want to make a program that calculates with the text in the textbox.So in the first 3 columns you put the names yourself and the last column displays the names from highest to lowest points and the rows in the 3 first columns have points from 100 to 10 (highest to lowest). How let i calculate vb with these column and rows so i get the name with the best result in the "totaal" column?
View 2 RepliesI 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 have created a program that has 5 radio buttons and each button is named after a city. When clicking these buttons a picture of a landmark of that city comes up. However, I would like to enable my "clear" button.I have found a couple of examples such as;
Private Sub Clearbutton_click' Clear previous amounts from the form.
Titletextbox.clear()
Pricetextbox.clear()
end sub
So is what I attempted to do is under my DetroitButton1 i did a
[Code]...
I am trying to calculate the number of years for my calculate age event handler, however i am apparently missing a method or whatnot because im trying to calculate the age , can anyone suggest help on this. I need to subtract years to get my age but when i try the birthdate.Subtract (currentDate) method i get an error about not able to convert from LONG?
So below is what I have.
Private Sub btnCalculateAge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateAge.Click
Dim currentDate As Date
Dim BirthDate As Date
Dim Age As Long
[CODE]
how to calculate "InvTotalTextBox" and "InvDiscountTextBox" values then show the result in "InvNetTextBox"..?
how can i do..?
three TextBoxes in a form
InvTotalTextBox, InvDiscountTextBox and InvNetTextBox
InvTotalTextBox is Binding with Table Field "InvTotal"
[Code]....
how can i make a world map that moves with the cursor and ifor example if i press on asia another page will open for asia's map and the same thing for allwith visual basic 2005?
View 3 RepliesI made a sort of downloader program in Visual Basic 2010, and it downloads okey. It reports the full size of the file, and how much that has been downloaded right now and the percentage.
But, a function that i am missing is to show the user how much time is left on the current downloading. I have searched for it, but i couldn't find any solution that would work.I should also mention that i use a webclient for the actual downloading part.
I Have a datagrid with Item, Description of Item, Qty and Price.I would like on the 1st txtbox display subtotal depending on the quantity, price and add a tax textbox and the subtotal all from the datagrid to to those textboxes.
I already have all of that on my table of Products.
I am creating a puzzle game and would like to calculate the width and height of the puzzle taking into account the original image size and the screen resolution. My screen height is 768 and width is 1366. An example image is 1200 x 1600 and the jigsaw size that works well with this image is 480 (height) x 640 (width). I would like to create an algorithm that calculates the jigsaw size for any image bearing in mind that the screen resolution will change as will the size of the image.
View 2 RepliesAt my school i have to make a program and im almost done with it but everytime if i dont put any inputs on the program and press calculate it crashes. What should i write in the codes not to crash if all the inputs are empty.
View 7 RepliesI Have created a program (see below) that enables you to use you cam. You then draw a line and calculate the angle. The purpose is that I do alot of work with remote control cars and need to acuratley set toe and camber angles, it takes to long with the "old" method So I am creating this little program. ok, so, lets see what I want to do. Well, the first thing I would like to do is draw a line from top to bottom of my picture box dead center of left to right, this is dead center of the cam so the bottom of your item should be posistioned to meet the bottom of the centre line. I then draw a line from bottom to top of the objects angle. I then use the dead center line and the line I drew to calculate the angle.
[Code]...
Is there a way to calculate BesselI functions in VB 2010 Professional. I have calculated this in Excel but do not want to have to open Excel to do this because my clients use Excel 2000 up to Excel 2010 and the syntax is different. Plus it is slow and inelegant. [code] where CM and NTU are floating point variables.
View 2 RepliesI am developing an application for an emergency services organisation using VB 2008 that will enable users to select a map zone of a city centre and plot icons onto it, then save/export the layered map with icons as an image.My problem at the moment is that I am struggling developing the point where the user imports in the icon (for example, a flame icon where a fire started) and drags it around the map within the picture box to the required area.I want them to be able to select their desired icon from a series of commandbuttons and for the icon to 'appear' on the picturebox and be enabled to be dragged around and dropped as required. The organisation already has such a thing working in Microsoft Word (!) and that uses the ActiveDocument.Shape.LoadImage function on a pushbutton to import the icon and then it is placed on the map as required, but this is really unreliable for them.I dont even know if you can layer images onto an existin picturebox within an application in this way and then export as a flat image.
View 3 Replies
