In the following code I have two class scoped variables intCompanyID and intEmployeeID. When I set them to a value in btnFetch_Click then try to read them later in btnSubmit_Click they are set to zero.
Option Explicit On
Imports MySql.Data.MySqlClient
Imports System.Data
[code]....
It's good to be back in this forum again hoping someone could help me solve my problem again xD My goal is to import .txt to db.
This is my code
[code]...
Some of the records are inserted but when the code read the part where there is an empty/null value in the column where they are assigned as "decimal" the error message "Error converting data type nvarchar to numeric." pops out.
I am trying to reset all integer values to "0" with a reset button.I try not to use hardcoding by simply set them one by one. So my idea was checking all the variable's type and set them all to "0".
I tried to use this methode, from someone in this forum (sorry, I forgot the name but this is very helpful...) For Each ctrl As Control In Me.GroupBox4.Controls 'Check and see if this control is a TextBox
If Object.ReferenceEquals(ctrl.GetType(), GetType(Label)) Then 'Check and make sure this s the "TextBoxToExclude"
'CType(ctrl, CheckBox).Checked = False
CType(ctrl, Label).BackColor = InactiveColor
End If
Next
But when I tried to find the code, I couldn't get it.So, if anyone knows how to do this,
I want to be able to see if the values a user inputs into 2 textboxs equals the values assigned to a picture. I put these values in the picture's name and tag. Also the picturebox is getting the image from a random function correlating to an imagelist. How would i go about thisI thought of maybe using a checkbox and coding
If picturebox1.image.tag = ("12") _
and textbox1.text = 1 _
and textbox2.text = 2 Then
checkbox1.checked = true
unfortunatly when i debug it says the picturebox1.image.tag = Nothing
cast integer values to an array of enum values?
View 2 RepliesNormally I've been lucky to find someone who has had the same problem and applied their solution but after hours of searching I'm not able to find a solution to this one. I've got a FormView which is default mode set to Insert. When the page is loading I'm checking to see if the session variable which the formview datasource is set to has a value. If it doesn't I've coded in the onLoad that some of the controls in the InsertTemplate would be set to specified value.
View 1 RepliesIn my example, i use a class array to which I assign values looping through textboxes in my form. Using the button Store (btnStore) the values are perfectly assigned to the array (i use an msgbox to check).The problem is that when i created another button (btnTest) to test if these values can be read outside the btnstore code, I get an error (NullReferenceException unhandled) which informs me to use the new keyword (cannot be used with arrays).I suppose the same applies when trying to access the array from another form. The question is how can i assign the values to the array "forever" and be accessed from "everywhere" in my program ?(tried public, friend, redim preserve the array with no luck).
[Code]...
I have a repeater which displays products. Users can select a Size - dropdownlist and an Amount - textbox. Then they press Order or Cancel. When they press Cancel I would like the values of Size and Amount to return to their default values.
Protected Sub lbtnCancel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lbtnCancel.Click
rpt.ProductList is the repeater name
lblFeedback.Text = ("")
lblFeedback.ForeColor = Drawing.Color.Black
End Sub
I am using VB.NET.
I can't seem to get this code to refill the chart with new dat. The first time it executes, all is great, but when I change the year(numericupdown1.value) it adds a new set of data points instead of re-plotting the original set.
Private Sub FillChart()
'
'Fill Chart subroutine
'
Dim SoldMonth As Date
[code]....
i have a textbox with hexadecimal values and i would like to use the slidebar/scrollbar to change the values (increase/decrease) then save the final values to a text file. To prevent the program from writing to many times to the file, i decided to use a timer. As long as the user still making changes or controlling the slide/scroll bar the timer will re-load (5 seconds). When the user is done modifying (no more dragging or clicking on the arrows) at that time the timer already expired, then the value get recorded to the text file.
[Code]...
how to programically clear the data from a form view using vb.net. I have so far come up with the following:
Dim x
For x = 0 To Me.Controls.Count - 1
'if it is a text box then clear it
[Code].....
I'm trying to set an Integer value from my.settings.The values comes frpm a listbox, and then inserted to settings (set to specialized.StringCollection)The problem is when i'm trying to get the values and apply them to my function.Error code: Conversion from string "65 & 71" to type 'Integer' is not valid.To me it looks right, but maybe i'm missing something.
Code: Dim test2 As Integer Dim test As System.Windows.Forms.Keysm trigglist As New StringBuilderor Each item As String In
[code].....
How do I reset My.Settings at run time to the initial default values. I want to do this after the app has been running and the user may have save changed settings. The intention is to reset evering to 'factory defaults' as opposed to the last saved value as done by 'settings.reload'.For example in the property below , I want to restore to the value to '90' as given in the default value. I want to do this for all settings.[code]...
View 4 RepliesI am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
I'm working on a simple BlackJack (player vs dealer) system, that I plan on making gradually more advanced. However, while everything works brilliant, I'm yet to find a logical solution to declaring an Ace as both 1 and 11.So my question is, how do I pull this off. Below is the "New Game" logic (code) so it should give you an idea of what I'm working with (note how player scores are added together, I'm sure it's easy enough to understand...).I'd like lblPlayersum to still be a usable integer, though I'll rework everything if noone has a logical solution.Just quickly note that the "Cards" array is purely used to coordinate images."CardsVal" coordinates that values within the deck. Arrays 48, 49, 50 and 51 are the aces. (Currently defaulted to 11).[code]
View 1 RepliesI have a question, that is: What is the easiest way to get Integer values from a file.The file is structured like this: (Without the text)10...How many values are in the file 1 2 3 4 5 6 7 8 9 10..The values...I know how to do it, the hard way, but I need an easier way, to teach a friend the basics of Vb.net.
View 1 RepliesI want get integer quotient when I divide two values. Per example
X=3
Y=2
Q=X/Y = 1.5 // I want get 1 from results
X=7
Y=2
Q=X/Y=3.5 //I want get only 3 from results
My problem is that I have two forms, Form1 and Form2 ...on Form1 there is a TextBox called txtTotal (this contains the calculation of Ticket Prices, thus it's a numeric value) and on Form2 there is a TextBox called txtTotal2. All I want to do is get the same number that appears in txtTotal on Form1 to appear in txtTotal2 on Form2 .However whenever I try some of the help tips online such as using a declaring txtTotal as global or friend it dosn't work, and any other code iv tried attempts pass the textbox value as String which brings an error.
View 2 RepliesI am working with a future value application and I am trying to display the calculated future values in a listbox. For instance, I input the monthly investment, the yearly interest rate and the number of years into textboxes and I want the application to list out the future value for each year until the number of years in which I entered is reached. I cannot figure out how to get the code to display the value after each year. I am trying to use the "mod" operator to display the value each time the 12th month comes around.[code]...
View 7 RepliesHow do I simply display the integer values of a 10x13 integer array
View 1 Repliesi am having trouble displaying the values i get from an IList(Of T) and displaying that in a listbox found on another form. I have used a for loop to get the values from the IList, then i can display that in a msgbox. for eg:
Dim j As Integer
Dim path As String = ""
For j = 0 To best_tour.Count - 1
[code]....
best_tour is ot type IList() path keeps the name found in the list everything works fine inside the loop..but it does not populate the lst_output listbox.I have tried using files, but in vain. It just get the values from the list but does not display that on the listbox.If that can help, then listbox is found in a panel on the form2, but taking it out of the panel does not affect anything.
I want to split a string that taking both string and integer values like (Cmp_12).
View 4 RepliesWhy is it that in parts of the .Net architecture that ARGB colours are expected be as type Integer when ARGB is outside the range of Integer? (ARGB requires 32 bits of precission, but Int has 31 bits of precission).Now of course I could just do a conversion, but what freaking conversion to use??? (I'm not affluent with all the VB global methods and the sort)
I've tried things like:
Code:
Dim value As Integer = &H80000014
Dim uvalue As UInteger = CType(value, value)
''overflow others include Convert.ToUInt32 -> value was either to large or to small and a few others all offering up nonsense about overflows, when all I freakin' want is a colour that Microsoft's own engineers have done stupid things like expect Integer values in places where UInteger should be, or vice versa. How about some consistency...
Code:
Dim value As UInteger = &H80000014 ''<- not represntable as a Uinteger???
Dim uvalue As UInteger = 2147483668 ''<- same value in decimal, same exact value! and it works this says it's not representable as a UInteger?
how can i do this ? i new how to but i forgot and i need it right now
View 2 RepliesI accept both C# and VB.NET suggestion, even though I'm writing an app in VB.NET I have two lists of intergers
List1 {1,2,3,5}
List2 {2,4,6,7}
I want to have new List3 {4,6,7} which is composed of elements of List2 that are not in List1. I know I can write a nice For Each loop for this but I want it done in LINQ I've been looking for such methods at Enumerable Methods, but I can't find it.
I want Too Know how Can i Fill THat values in the sql Column my Sql Data type is Integer Can i fill any SIGN Valuse like (122,123)(123+123)(321-123)(485;456)(301>908) in these Values Can i use any one in sql column and the column data type is Integer.
View 6 RepliesI have a program that calculates values of a function, say f, with respect to another variable, say L.I have an array of f(L), for L going from 0 to a given integer value, say t-1 in steps of a value i.I need to export the values of this function to an Excel spreadsheet in a given column, and to do this, I would like to re-index the function f, since i is much less than one, and so the following loop I use (see below) won't work:
For L = 0 To t - 1 Step i
Sheet.Cells(L, 1) = L
Sheet.Cells(L + 1, 2) = f(L)
Next L
The first code in the loop will essentially load the values of L itself, at which the function is defined and calculated, and the next line will load the values of the function at each value of L.Since the indexes of the row and columns in an excel spreadsheet only go in steps of 1, I need to convert the indexes of the function, or the indexes to which L is loaded, so that it would be scaled so that the first entry corresponds to L=0, but the next is L=i, but loaded into row number 2, etc.
can i convert colors values to integer?
View 6 RepliesI am trying to assign integer values to the items in 2 different list boxes called lstWorkshop and lstLocation. I then want the equation, intCost = intDays * intLodgingFee + intRegistrationFee, to be executed and the result to be displayed in a third listbox named lstCost. This is what I have so far, but whenever I run the program the value that always gets displayed is 0, which is obviously not correct.
Public Class frmWorkshopSelector
Dim intCost As Integer
Dim strTotalCost As String
[code]....
I have a DEM file(Digital Elevattion Model File) and I am trying to open the file,where we have Latitude and Longitude values inside the DEM file.And, Now I have opened the file using Filestream and Read the file using BinaryReader.But, I am having a trobule in getting the values of Latitude and Longitude.I am getting Byte values randomly as 1,202,31,271 etc.But, we dont have latitude and longitude values more than 180,and also I am not getting 16 bit UInt values.For example, the values should be like Latitude 20.00416666666667 and Longitude 39.99583333333333.So,read the correct Byte values of the DEM file.The code I have used till now is:
Dim fs As FileStream = New FileStream("C:UsersadminDesktopHeader and DEM fileE020N40.DEM", FileMode.Open, FileAccess.Read)
Dim rd As New BinaryReader(fs)
Dim convertDB As UInt16
For i = 0 To rd.BaseStream.Length
[code]....
