I have worked in web application. we are using asp.net and vb.net. In vb.net, we are using int16 and integer. I want to know what is the difference between int16 and integer datatype?
View 4 RepliesThis is just a quick question: Are there any difference between
[Code]...
I face a problem that if i make a datattype in sql server of Integer and then use it in linq to sql query it give error of "specific cast not valid" and when i change datatype into varchar the linq to sql query work fine one more thing how to use linq to sql query to make crystal report?
View 2 RepliesI 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 RepliesJust studying and looking for a simple way to remember the difference between the two variables.
View 3 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'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 want to reflect the bit patterns in 2 x int16 (an upper and lower 16 bits) into a single int 32. how can this be done, is bit converter what I am looking for?
View 2 RepliesI try to sort programmatically a dgv with this code: [code]In the first column I read the data from a postgresql database (the data type is smallint) If I try to sort the dgv, I get the error message, that the object type can be only Int16.Why doesn't it work? What does it mean?
View 4 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 to pack and unpack a 16bit Int from/into a Ushort in VB.net This is how I thought I could do it (doesn't work, gives me overflow exception)
'Pack Int16 into ushort '
Dim usPacked = CType(Data, UShort)
'unpack Int16 from ushort '
Dim unpacked = CType(data,Int16)
I am working on fixing a bug in VB that is giving this error. I am new to VB, so there is some syntax that I am not fully understanding. The code that is throwing the error says:
.Row(itemIndex).Item("parentIndex") = CLng(oID) + 1000000
I understand that adding 1000000 is too much for an int16. I can't change that value (not right now anyway). What I don't understand, and can't seem to find, is what .Row is referring too.
I want to create a program that can read and write the data on a file... this file is game music file that contains all information of song, I already know structure and I can read it, I want program only read the level of song (if song is hard to play, the level is more high), I read the data using File Stream and Binary Reader :
Using fs As New FileStream(OpenFileDialog1.filename, FileMode.Open)
Using rdr As New BinaryReader(fs)
Dim seeker As String = fs.Seek(20, SeekOrigin.Begin)
[code]....
(using vb.net) On our intranet site we have an app that loads customer or vendor information and then allows the users to edit info and add/update/delete contacts. I'm not sure what really changed to this program lately, but I keep getting this error:
Method not found: 'Int16 DBLayer.DBTools.ExecuteNonQuery(System.String, DB)'.
This occurs when i try editing any customer info and the vendor contacts, but the program works when I try editing the vendor info/addy. Here's the program code. There's a seperate program on our webserver that contains the classes used. Here's the main code that calls the classes:
TO ADD CONTACT
M2MInterface.M2M.Customers.AddContact(Session("CustVendID"), txtFName.Text.ToUpper.Trim, txtLName.Text.ToUpper.Trim, Tools.RemovePhoneNumberFormat(Phone), Tools.RemovePhoneNumberFormat(Fax), txtEMail.Text, txtNotes.Text, False)
TO UPDATE CONTACT
[code].....
how can i use value (23,32) in sql column datatype int how can i use comma in column data type int
View 8 Repliesive got some simple problem i cant understand how to solve.
str(1) is an array and integer(or double, tried both)
a(1) is an array and integer (or double, tried both)
a(1) = a(1) + 1
Label1.Text = str(1) + a
the big part is where i get: operator '+' is not defined for types 'integer' and '1-dimensional array of integer'.why do i get that message and what does it mean? how do i make the code do what i want?
I faced an error when upgrading VB6 code to VB.NET. The error occurs at AddressOf WindowProc
AddressOf expression cannot be converted to 'Integer' because 'Integer' is not a delegate type
My declaration for SetWindowLong is:
Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA"(
ByVal hWnd As Integer,
ByVal nIndex As Integer,[code]....
What is the reason for the error I get?
I'm trying to create a linked list of an array of integers. Why is the following implicit conversion required?
When I run the code that contains that conversion, I get the following error.
As a real-time data acquisition user control data (a packet of an array of bytes) arrives every second, is converted into an integer array and inserted into a linked list.
The most recently arrived data is painted as coordinates on a grid at the right of a PictureBox using Graphics.DrawLine (pen,X1,Y1,X2,Y2).
The oldest data (arriving 120 seconds ago) will be drawn at the leftmost portion of the Picturebox.
Why a linked list rather than a list? To display 120 views of time sequence data, the draw routine the most recently inserted node to a node that points to Nothing. How do I limit the length of the linked list to 120 nodes and always ensure that the last node points to Nothing?
Do While Not item Is Nothing
item = item.NextItem
Loop
I am a newbie in VB and I got a piece of code which can display the current running program. I need to use that in VB2005 and I got the below error message. Can anyone help how to fix it?[code]
View 18 RepliesI'm trying to convert a VB6 project to .NET, but I get problems with some callback functions, and the following message comes up: "AddressOf' expression cannot be converted to 'integer' because integer is not a delegate type" I've seen several solutions to similar problems like this, but I am not able to understand this issue with delegates.
After the conversion, the code look like this:
Declare Function vsmsgwSetDataPackageCB Lib "vsmsgwW.dll" (ByVal PACKAGE As Integer, ByRef arg As Integer) As Integer
Dim arginitP As Integer
[Code]...
Which gives the error: Method 'Public Function PackageCB(HisNodeID As Integer, ByRef data() As Byte, ByVal length As Integer, ByRef arg As Integer) As Integer' does not have the same signature as delegate 'Delegate Function DelegatePackageCallback(hwnd As Integer, lparam As Integer) As Integer
I have a LINQ2Entity problem, I want to get the value, string, from a database, so I select FProducts.Serial_number, and to end the query, I do .ToDictionary. The problem is, it tells me that it doesn't have sufficient parameters, to convert ToDictionary. So I need something like select FProducts.Serial_number, Nothing). ToDictionary. Also FProducts.Serial_number, 0).ToDictionary doesn't work.
Sub GetStatistics(ByVal ProductNumbers As List(Of String), ByRef Passed As Integer, ByRef FailedProducts As List(Of String))
Passed = 0
FailedProducts = Nothing
[Code]...
this is for a BINGO game final project that I already turned in but this just bugged me that I could not get the sorting figured out. I am trying to get this to sort the random numbers in to columns under the correct letters but I keep getting the error Operator '>=' is not defined for types '1-dimensional array of Integer' and 'Integer' under the line:
[Code]...
I am new to EF Linq and I have been struggling with this query for a few days. From reading this forum, I have managed to get this far:
Dim noPic = (From f In myEntities.FriendLists
Where (f.UserID = Profile.ID)
Select f.FriendID).Except(From g In myEntities.GuestLists
Where g.EventID = _id
Select g.FriendID)
[Code]...
I am trying to get everybody from the FriendList who is not already on the GuestList to display in a Repeater control. After reading the forum I was able to append .First() to noPic at the myNoPic declaration and finally get a result but that only gave me the first element. Does anybody have any advice on how to accomplish this?
Why doesn't CDate(integer) work where integer has format of YYYYMMDD ?and why won't this stupid site let me submit such a short question when I have nothing else to add except some waffle at the end
View 2 RepliesThis is giving me a headache. I have this link query here that grabs an ID
Dim mclassID = From x In db.SchoolClasses Where x.VisitDateID = _visitdateID Select x.ClassID And then later on I have this linq query
ViewData("Staff") = From t In db.Staffs Where t.ClassID = mclassID Select t
I've tried quite a few things but to no avail. I've attempted casting, converting, Is operand, etc.
I'm just writing a bit of code to compare an id of integer with an id of integer? for example:
Dim id As Integer = 1
Dim nullId As Integer? = Nothing
Dim areEqual As Boolean
areEqual = nullId = id
When I try to compile the code I get a compiler error: Option Strict On disallows implicit conversions from 'Boolean?' to 'Boolean'. Whilst it's very simple for me to work around this, I was hoping that someone might be able to explain what's going in the compiler to give this warning.
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].....
i am doing one project in which i declare integer value and asign value to that integer in which
see the following code
[Code]...
I don;t know what datatype while storing the data of datetimepicker in vb.net. The tools i use is sql server.
View 1 Replies