I set the phone number field to number datatype.......in the access database...the field size is set to long integer.While trying to save a data in the database, when i enter a 10 digit number then an exception is thrown but upto 9 digit it works great.
View 39 RepliesI am using the following code in the Load method of a VB form to generate random numbers in the range 1 to 8. Without fail after enough loops the range is exceeded and 9 is the random number returned every time. The line using the Rnd function is from: Rnd Function (Visual Basic)
[Code]...
orking with vb 2010 and ms access as data base, just newbie.im trying to save the loged out date and time to my access table by selecting from tblloghist wherein my column SystemUserID is equal to my textbox SysID(located at my form) then it will save the timelogedout by getting the value of lbltime from my form. the problem is the data type property of my column SystemUserId is in autonumber so i got error saying "Data type mismatch in criteria expression"
Dim con As New OleDbConnection
con.ConnectionString = "Provider=microsoft.jet.oledb.4.0; data source =..systemsdb.mdb"
Dim ds As New DataSet
[code].....
Is there any way that I can use to check the datatype of an object??What I want to check is like below (yes, below will not work. Its just a scratch logic).
example:If TypeOf(objPasser) = Integer Then
.....
ElseIf
[code]...
I create one column which is tinyint then I go to VS2008 and create typed dataset by wizard. Then I check that column's datatype it is now byte datatype. MS SQL 2005 tinyint = VS2008 byte ?
View 2 Repliesanything wrong with using datatype object and determine datatype in class property? I have a typed dataset and it has several integers columns that are null in the db. and when I make a call it throws exception.is there anythign wrong with setting it as object in my dataset.. changing the throw exception property to Nothing and passing it to my property as integer?
for each row in myDS.DataTable
cRate.CustID = row.CustID
next row
and in my class
Public Property CustID() As Integer
Get
Return _custID[code].............
I am making a program that chooses the active runway at an airport from the wind data. So far I have a formula that works without out a number range:
Private Sub TextBox1_TextChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If TextBox1.Text = "" Then aarwy.Text = "Run"
[Code].....
I'm using VB.NET 2008 Express Edition and I'm trying to create a simple program that will roll a number of dice I choose. It does this by generating a random number within a specified range (I'm rolling 3-sided dice in this case so I'm generating numbers between 1 and 3) and adding each number to a textbox to create a total of all the dice rolled so far.
This is my
Private Sub butRoll_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butRoll.Click
Dim RandNum, i As Integer
Dim RandomClass As New Random()
'if at least one dice is rolled
If txtD3.Text > 0 Then
[Code] ......
Now the problem I am having is that although my random number generator is generating the right numbers (confirmed by checking the txtLastRoll textbox), when I add it to txtTotal, it seems to be getting another number from somewhere and adding that to my random number then adding it to the total and I have no idea how this is possible! txtTotal always starts as 0 but txt1 is not showing that. Normally I would just set txtTotal to 0 there but if I do that, I won't be able to add the numbers together. I've tried finding a pattern in the mystery numbers appearing in txtTotal but they just seem to be random.
How could I limit the random number range? For instance, limiting the number within the range of 1-100.
View 5 RepliesThe object of this project is to write a computer program that will allow the computer to guess a number that you have selected. The computer will make a guess and you, the player, will tell the computer if it guessed too high, too low, or that it guessed the number.The program will also allow the player to start a new game or to exit the program. PROJECT INSTRUCTIONS:
1. Create a form with a labeled box to display the computers guess.
2. Create a new game and an exit button.
3. Create objects to indicate if the guess was too high, too low, or right on target.
4. Create program code to respond to the player�s indication by selecting and displaying a new computer guess.
5. When the computer guesses the player�s number, reset the so that a new game may begin.
I have done all as above and so far my code looks like so
Public Class Form1
Dim Guess As New Random()
Dim HGuess As Integer, LGuess As Integer, current As Integer
[code]....
The problem i ran into is that if for example a user has a number 24, when the program makes an initial guess of 50,i want to be able to click low, and the program should generate a lower number say example 22. If i then click higher as my actual number uis 24, the program should not shoot higher than a number it has previously guess incorrect (in this case 50) it should guess anywhere from 22 - 49 and in turn limit the range of the next consecutive guesses it till hits the right number. My code right is guessing as it shuold but not within the limited ranges.
I have a VS2005 utility that I'm working on that has an Access 2003 backend. A couple of days ago, my boss asked that I change one field in two tables from TEXT to MEMO, to allow more information to be put in. In doing some final pre-deployment testing, I find when I hit my button to pull up the list of tickets, I get the error
"System.Data.ConstraintException was unhandled
Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.""
The datagrid is based on a query I have in the database. The query runs fine, and when I go through the XSD and go into Query Builder, the QB is also returning data. I have made the various changes to the utlity as suggested by Microsoft, but no luck. When I put the two columns back to TEXT, the Grid works fine.
How the heck do I set it up so that the grid will recognise the new data format? The number of characters for the individual columns is set to 37,627 (I believe, it's whatever the default is). I only have 200 characters in my test data. I need to rebuild the whole dataset - this deployment has to be done by the end of the day tomorrow and I have a whole pile of other stuff left to do.
EDIT: I am so sorry! I have added my thread to the C# discussion thread instinctively wherein in fact I have been creating my application in VB.NET so sorry! Please transfer my thread to the appropriate location! I am currently trying to mess around with a simple mp3 player and am in the process of creating a shuffle list from all the songs in my playlist.
View 2 RepliesI know that there is a way in which you can generate any random number between any range using the random variable. But my question is that is there any way to do the same thing but with letters?
View 1 RepliesHow would I go about generating a unique receipt number in the following range:
GA00000-GZ99999? I am not allowed to use the 'I' and 'O' letters so GI00000-GI99999 & GO00000-GO99999 would be excluded. Ideally, I'd like to create this in T-SQL but can also do it in VB.Net. This number will be stored in SQL and I can access it prior to generating the next one. They do not have to be sequential.
Does anyone know the range of digits of Motherboard Serial Number?
View 5 RepliesI'm attempting to pass in a collection of dates to a T-SQL 'IN' clause via a date array (see below for how data is collated).
'Workout weeks difference between start and enddate
Dim wksDifference As Integer = CType(DateDiff(DateInterval.WeekOfYear, bookingStartDate, bookingEndDate), Integer)
[code].....
I have a table with a Real datatype field. I just can't multiply it with other integer fields although the editor doesn't show any error - the result is always '1'.
View 4 RepliesI'm using a 3rd party chart COM object (National Instruments CW graph) to plot data versus elapsed time.The x value needs to be a VB6 equivalent Date type which is a .NET DateTime datatype.What I need is a way to convert a TimeSpan datatype to a DateTime datatype.
Dim testTime as System.DateTime 'date
Dim plotTime as System.DateTime 'date
Dim elapsedTime as System.TimeSpan[code].....
I have a database in mysql. The column in table is of datatype time(0)
Similarly I have a control datetimepicker in vb.net I have assigned format property as custom to the control and the CustomFormat property as HH:mm:ss tt so that it can just provide the time. I dont want the date to be in it.
Issue comes when I try to retrieve the value from database I get an error as Converion of type 'Timespan' to type 'Date' is not valid
Try
Dim myCommand As SqlCommand
myCommand = New SqlCommand("select * from [HMS].[dbo].[DoctorSchedule] where DoctorID='" & txtDoctorID.Text & "'", Connection)
[Code].....
I'm creating a number guessing game. [Code] Textbox1.text refers to the answer input by player. There are two labels for displaying the range of the answer within. Label1 and Label2 refer to the lower limit and higher limit respectively. If the input value is smaller than the answer, the label1 will show the number that input into texybox1. If the input value is larger than the answer, then vice-versa. However, the program doesn't work as my expectation. Once I input the answer, the MsgBox doesn't appear. When the input value is smaller than the answer, the label1 doesn't show the input value.
View 15 Repliesi need to check whether a demical is 0 through 49.99 or 50 through 99.99 or 100 through 199.99 or greater than 200. i am trying to do this with select case, but i am not sure of the syntax.
View 7 RepliesI am using this to populate column1 combobox from a text file and it works fine.[code]I tried to add a number range using this to populate columns 4 and 5..[code]The number range populates the combobox(CB) fine but when i select a number from the CB it causes a error and selects the first item, the error loops evertime the mouse hovers over the CB..[code]
View 5 RepliesHow to write a if else statement to check if the number user enter follow within a range.
View 5 RepliesI am working on a produce inventory database in my VB Express program.I have a form on the bottom and a spreadsheet at the top. I want to enter all the data in the form and have that data automatically transferred as a group to the spreadshet in the upper part of the page when I press a button.I know that there's an insert function.I set it up correctly. The problem is that I have to convert the textbox, which contain string data, to the datatype used in the database spreadsheet.HOw do I use CAST or do this?Here's the function I am using:
Me.TableAdapterManager.InventoryTableAdapter.Insert(IDTextBox.Text, fruitName, unitprice, unitsize, unitIn, unitTransit, unitOut)
Evernything is a string cause the data is coming from a textbox, I need to convert it to the datatypes used in the database.Also how do I use the CAST and Convert functions
I have a number like 12000 10^(m-1) < 12000 < 10^(m)I wanted to know how to find m value.I am new in VB.Net programming...
View 1 RepliesI keep getting the error message "Index out of range exception" when I run the following code.
XX
GN3 = (Loops * 5)
For a = 1 To Loops
For b = 1 To GN3
R1 = Seeds1(Counter1)
Randomize()
R2 = CInt(Int((56 * Rnd(R1)) + 1))
Counter1 += 1
MessageBox.Show(R1 & " " & Counter1 & " " & b & " " & GN3)
Next b
Next a
The message box conforms that the last entry in the array has been reached. And that Counter1 and b both start at 1 and go to 2845. And that GN3 is also 2845 all of the time.
i'm using VB.Net 2005 application program.i'm trying to convert VB6 code to VB.Net 2005. QSockB is DLL file.this is the code i used for VB6. This is code i'm using to create socket, when program runs... and when i hit start button it calls Q_SendHeader function.
Form1_Load(.....................
Q_KDSPort = &H8000&
Q_MyPort = Q_KDSPort + &H100&
[code]....
This works fine in VB6... but Q_SendHeader is not working in VB.Net 2005.
Why are there no examples that I can find on how to import an excel range into SQL Server, there are plenty of example on how to import the whole spreadsheet but none for the range? I find this wierd.
What I need to do is import an excel named range into a sql table using vb.net. I have been able to import the range from excel to access but not to sql server. I used the many examples that are on the web using OLEDB for the connection part and ODBC for the command. However I continually get the cannot find and installable ISAM. I have excel 2003 and Excel 2007 on the box.
I know this can be done using SQL Server SSIS package, which I have used before, however you have to install certian SQL Server features on the box that is running the application for this to work. I want my application to be able to run on any box that it is installed on without the need for the SQL Server features to be installed.
I have an integer array which contains the different col widths for an range of excel worksheet.when i use Range.ColumnWidth= ColWidths (Colwidths is the int array), it takes lot of time to do all the process (i.e opening excel , formatting range, setting values)But when i use Range.ColumnWidth = 15 then all the process is done in a flash.Why using an integer array takes time? I did even try replacing int array with string array, but same time taking result?
View 1 RepliesI need to figure out whether a certain date falls within a range of dates. For example the date 11/07/97 (MM/DD/YYYY) falls within the following range of dates formatted as shown below:
01-Apr and 31-May
01-Jun and 31-Oct
01-Nov and 31-Mar