I have a "if This > That then" statement, that doesn't seem to work, as it triggers regardless that "This" is smaller than "that". Does it matter that these variables are marked as strings vs integers?
View 8 RepliesI am working on a UDP Client/Server, and currently i have them sending back and forth strings, which i convert to bytes, and then open the bytes to read. I want to now send an Object instead of those strings, which includes multiple unsigned integers and strings.
View 39 RepliesI got a quite a big sql statement and I get errors when dealing with dates and numeric values. All of this is in order to copy the data to a new table.so these variables I am trying to use for passing the data:
Dim orderdate As Date 'on my sql orderdate is datetime
Dim custntitle As integer 'on my sql is numeric(2,0)
Dim country As Integer ' on my sql is numeric(3,0)
for the date I get an out of range exception,and for these two integers (custNtitle, country) I get invalidCastExceptions when dealing with strings there's no problem but dates and numbers causes errors for me?
Imports System.Data.SqlClient
Public Class Form1
Dim serviceid As String
[code]....
I got this in my SQL statement. I "BOLDED" the problem.SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddressShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE CustomerID =@CustomerID
View 5 RepliesI got this in my SQL statement. I "BOLDED" the problem.
SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders
[code]......
I suspect there is something wrong in my application, specifically in a part where I have to compare a couple strings and a couple integers.
I do something like this:
If myString = myOtherString Then
do something
End If
And the same thing for integers.
However, for some reason, it is not returning true... also, I heard somewhere there were more proper ways to compare strings and integers.
I'm trying to split an inputted string (txtStart.text) into separate integers. The split function works fine for me, but I can't figure out how to store the each part of the array... This is my current code that I based on an example from MSDN library:
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
SplitStringIntoWords()
End Sub[code]......
if i have 2 textboxes and i want to do subtraction with textbox1 and textbox2.
The value inside textbox1 is "5 12 30 8 2"
The value inside textbox2 is "7 9 14 8 3"
May i know what can i do so that the result will be "-2 3 16 0 -1"???
I suspect there is something wrong in my application, specifically in a part where I have to compare a couple strings and a couple integers.
[Code]...
However, for some reason, it is not returning true... also, I heard somewhere there were more proper ways to compare strings and integers.
I Know you cant sum to strings to each other so i trying to make the variables to Integers first but i can figure it out why it does not work![code...]
View 12 RepliesOriginally i wanted to ask if it's faster to sort Integers than Strings.But i have answered this question myself and i'm suprised of the big difference.Why is sorting and BinarySearch Integers as much faster compared to Strings?
The (VB.Net) Test with 1.000.000 Int32/Strings:
Private Function CheckIntBinarySearch() As TimeSpan
Dim watch As New System.Diagnostics.Stopwatch()
Dim rnd As New Random(Date.Now.Millisecond)
Dim intCol1 As New List(Of Int32)
[code]....
Consider having large collections of "String-Integers"("1","2","3",...). Would it even be better to parse them to integers before sorting and searching them? What is the cost of parsing Strings to integers?
I am using an oleDb connection to connect to an excel spreadsheet (.xlsx) file and load the information into a datagridview. From there I hope to have it edited by a person and programmatically at runtime. However, I noticed that when I import a file that has integers in a column, it will not import any of the string values in that column. Also, It will not allow me to manually enter strings into that column at runtime - it results in an error stating: [Code]
View 16 RepliesHow would I create a list of elements in VB.NET, save it to a .dat file, and make Ruby re-create such list (as an array) with such elements (they will be strings, booleans and integers)?
View 2 RepliesAm new to programming and i would like your help to this question. [b][color="Red"]Write a declaration statement of an array of integers to store 15 numbers. Initialise the first 5 values.
When I open the Visual Studio 2005 I don't see the template i.e. Win32 Applications, C++
I am starting design of a program that needs to run no matter if the user is logged in to the PC or not. So I will be writing it as a VB.Net Service.
As I am not overly familiar with SQL Server Express, is it possible to connect to a local SQL Server Express Instance and access the database from a VB.Net Service while the user is not logged in to the PC?
[code]...
Someone can tell me why the VB pass for the if marked by bold and don't execute them????
I used to add 2 strings variables and it works but when I tried using VB2008 it didn't work. [code]
View 9 RepliesI need to create a variable which can symbols for only "1, 2, 3, 4, 5, 6, 7, 8 or 9 " so that I can use to check for a certain text.[code]...
View 9 RepliesIf I have a list box or something that has a list of like 4 years (like 2006 through 2009), how do I programmatically make variables of these years with names like pTable2006, pTable2007, etc (as ITable of course). If this isn't possible and I have publicly declared these tables in the declarations (like pTable2006 as ITable, pTable2007 as ITable, etc), how can I programmatically assign these variables based on user choice?
What I'm asking is, if the user wants to choose years 2006 and 2007, how can I write this:
pTable & ListBox.Items.Item(0) = [table path string] & ListBox.Items.Item(0)
(please ignore the syntax of the "listbox", I'm just trying to come up with an example)
Whenever I put something like pTable & "string", I get an error.
How would I use a system variable such as %userprofile% in a string in VB.net? I have this in my program, but calling the system variable directly isn't working
[Code]...
how to convert an array of strings to an array of integers? I want to convert a string array with 77, all string numbers, to an integer array?
View 1 Replies[code]How do I use variables in a SQL statement?
View 20 RepliesI need to pass two variables/strings to a background worker at the same time. he background worker needs to return the first variable, and the time consuming boolean result of the second variable.From what I have read, I can only pass an object that contains multiple variables.This is where I get confused
View 1 RepliesI tried coding for an application that will display the positive integers, negative integers and zero entered in a inputBox. for some reason it keeps crashing down.here is my code. paging all visual basic professionals. [code]
View 6 RepliesI have a simple table in an access database that I'm using in a VS2010 project. I have a combobox control that a user can select the horse power of a motor. I then take that selected value from the control and copy it to a string variable called gstrSelectedHP. All I want to do is run a query that will pull up the full load amps of that horse power motor from the table. I have the query already, but I need to somehow put the gstrSelectedHP in the WHERE part of the query so that it only returns that value.
View 14 RepliesAnyone know right off hand a cleaver way to chop up a Text value from a table... Scenerio is this I have one table with a name (Smith, Timmy Alan) in a table text(30) format. I can pull the value to a string in VB but I want to only take the last name for one string and the first for an other string.
View 4 Replieswith the following code example:
T04Command04 = New SqlCeCommand("Update GameResults Set CN01=@T04Var02 Where Counter=@T04Var03", T04Database01)
T04Command04.Parameters.AddWithValue("@T04Var02", T04N01)
T04Command03.Parameters.Add("@T04Var03", T04ClnRec01)
T04Command04.ExecuteNonQuery()
I am trying to use two different variables in this SqlCeCommand series, to (1) update only a particular record in the database (2) with a particular variable value. However, I get the following error:
"An SqlCeParameter with ParameterName 't04var03' is not contained by this SqlCeParameterCollection."
Dim gg = From gs In AllData_TableList Order By gs.Biology Descending, gs.ChemistryDescending, gs.English Descending, gs.Frensh DescendingAll I need is to make this Statement order Dynamically like this
Dim Variable1 as string=Biology
Dim Variable2 as string=Chemistry
Dim Variable3 as string=English
[code].....
Is there an easier way to do this?
The .ColorReportedDate, .ColorTypeKey, .IsColorKeyNull, etc are from my strongly typed dataset row.
If .IsColorKeyNull Then
.ColorReportedDate = Now()
ElseIf cboColorType.SelectedValue <> .ColorTypeKey Then
.ColorReportedDate = Now()
End If
I have a listbox that is dynamically filled by certain values depending on what table has been selected from another list box. Once a value is selected, it is being graphed vs a date & time range. With my ignorance of linq: depending on what value is selected, the linq to sql statement I need to create to grab data from my database is different as I can't use an index on an anonymous type.
result = From t In db.APS _
Where t.DateTime >= startDate And _
t.DateTime <= finishDate And t.Weight = weight _
Select t.DateTime, t.TotalConcentration
t.TotalConcentration should be selected if my listbox value is "Total Concentration", but if it's something else, like "Temperature" or "Flow Rate" (connected to appropreate database columns) - this method obviously isn't going to work. I need to be able to dynamically select a specific column from the anonymous type list, or use some other method I'm unaware of to do this.