I have a table that has a "date" column and an "amount" column. I also have a form with two DateTimePickers ("dtp1" and "dtp2"), a button and a label. The label should show the total amount calculated from the rows whose "date" value is between the dates picked by the user with the DateTimePicker controls.
I keep getting an error with my SQL statement, and I don't know what to try. My code is as follows:
Private Sub getData(ByRef total As Double)
Dim connection As OleDbConnection
connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\proyectogestion.mdb")
I have this sql statement: CREATE TABLE [dbo].[User]( [UserId] [int] IDENTITY(1,1) NOT NULL, [FirstName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [MiddleName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_A
What I want is regex code which I can use to get all fields and data type. So will return something like that: FirstName varchar MiddleName varchar The sql statement will always have this format. I am using .Net to run this regex
I have an Entity I'm pulling three columns from Title (nvarchar(256)), Popularity (int), and Type (int). I'm then trying to use QueryExtender on a radiobuttonlist to allow the end user to filter out all but specific results but I keep getting an "Argument Types do not match" error. Here is the actual code:
If I have the following structure:[code]How can I select it in a conditional like this? [code]I know that myUsers.Contains(.ID = "1") is totally wrong, but I am curious how to do something like that?Is it possible? Is this a job for LINQ?
I'm trying to translate some C# LINQ code into VB.NET and am stuck on how to declare an anonymous type in VB.NET.[code]How do you translate C#'s new { ... } syntax into VB.NET?
I've just been burned again by the fact that there is no compiler warning when you fail to return a result in a Function that returns a Value type. I wrote the function:
Public Function CompareTo(ByVal other As MessageIndex) As Integer Implements System.IComparable(Of MessageIndex).CompareTo Me._messageIndex.CompareTo(other._messageIndex) End Function
which performs the CompareTo Function for two integers, then throws the result away and returns 0, because I forgot to either assign a value to CompareTo, or use Return, and that isn't flagged by the compiler because it's valid VB for a Value type.
I happen never to use "FunctionName = ReturnValue" because it hides information from maintenance programmers and also because I think it's insane .
Is there any way I can get the compiler to issue a warning whenever my Functions are missing a Return, whether it's a Value type or not?
In VB.NET I would like to create a complicated data structure with multiple types of data stored in an array like format (see below). I am trying to create a data structure that would look something like this: [Name; xLoc; yLoc; zLoc; [Jagged Array]] Note: Name needs to be dimensioned as a string, xLoc and so forth as integers. The Jagged Array would look like this:
Am trying to match characters or combination of the characters i specify in any order they appears
vb Regex.IsMatch(teststring "[nuls]")
what i want matched is either any single character, or combination of any of them in any oder. this means that it should not match any character not specified in the pattern.
I have 2 representations of similar data from 2 different systems and I need to match each entity in one system with the entities in the other.[code]...
I have a small databse program that reads a .csv or text file.
my code Public Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OpenToolStripMenuItem.Click OpenFileDialog1.InitialDirectory = "c:" OpenFileDialog1.Filter = "CSV Files (*.csv)|*.csv|Text Files (*.txt)|*.txt" Me.OpenFileDialog1.FileName = ""
[Code]...
i am trying to Catch a data mismatch, if the user happens to select a .csv or text file but they arent of the right type of data. Dim result As DialogResult = MessageBox.Show("Wrong Data Type", "Data Error", MessageBoxButtons.OK, MessageBoxIcon.Stop)If result = Windows.Forms.DialogResult.OK Then
(not sure what to put here) End If Catch End Try
I want to make it so that if the user selects the wrong file, it stops executing shows the message box , the user is only given the option to hit "OK"then it starts the openfiledialog click event again or stops and the user can open the filedialog again It seems that even though the ex is caught the rest of the code will keep running and from what I can tell from the documentation thats by design?
I am developing a vb.net application with MS Access Database . I have a field(cut) with double data type in table marks of markss.mdb.[code]On debugging , when I enter ,say 7.9 , in Textbox 1 ,I get an error saying Data type mismatch in criteria expression.
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
I'm trying to call a C++ DLL from inside VB.NET and am having difficulty with the data types (I think), I understand VB.NET far more than I do C++...I think my main problem is differing data types and I don't understand enough C++?In C++ the DLL is called (I don't have the source for the DLL which would solve my problem, I only have a sample project written in C++) by this;
I use Philip's MfRc500.dll for communicating with RFID chips. It contains a function for reading data, which is defined like this:[code]The second parameter in function Mf500PiccRead can returns "16 byte data block", so my long data type is too small. If I use byte() instead of long, then i get ExecutionEngineException Exception.
I'm torn between using UniqueIdentifiers(UID) or some other field as my primary key for my new web app. I have two tables. I need to be able to find the UID on one record in Table1 and put that UID in a new record in Table2. I also need to be able to create a brand new UID for the new record in Table2 on the fly.
Visual Basic 2010 (Express). If I take a string from a textbox and assign it to an integer variable, I'm under the impression that you're supposed to use CInt to explicitly convert the contents to an integer.intMyCount = CInt(txtUserInput.Text)However, if I don't do that, it still seems to work. Similarly, if I have an integer and concatenate it into a label's text property, it still works: lblResults.Text = intMyCount & " number of times." rather than using intMyCount.ToString.Why does it work? Is VB doing implicit conversions when possible? Are there examples where not explicitly converting with .ToString or using CInt would cause unexpected results?
I am trying to wrap a c++ dll and can use system.runtime.interopservices.dllimport and declare function to call functions from the dll. But how do i wrap the data types and everything else?
I am create a mysql table with TIME data type Field. And then store time type data into that field. But can't view in datagridview ( not show in other controls, like LABEL,TEXT,LISTBOX etcc..) . Using method is:
(LEAVEFROM TIME DATA TYPE, LEAVETO TIME DATA TYPE) Dim cmd As New MySqlCommand Dim adapter As New MySqlDataAdapter Dim table As New DataTable
[code]....
Run time display error:ArgumentException was unhandled Argument 'Prompt' cannot be converted to type 'String'
I never thought I'd say this, but I am getting pissed at how easy it is to just plop down a variable in python without any declaration. I have an existing python script which interfaces with a server, and it builds its own messages to be communicated via sockets. What I am trying to do is take the command line python script and convert it into a VB GUI app that is more user friendly.
I'm creating a VB.Net Windows Form Application. Apologies if this is not clear as I'm still new to .Net. This consists of a text box and a gridview.The user is able to write SQL code in the textbox, click run and see the results in the gridview.It uses a SQL DataAdapter and the fill method to a datatable to populate the gridview.My problem is that I need to know the SQL datatypes for each column in the data table (NOT the .net ones). I.E SQL Server 2008 data type 'Date' is stored as System.Datetime in the datatable. I need to know if the SQL Server datatype is 'Date' or 'Datetime'.
I have a class with a Property called 'Value' which is of type Object.Value can be of any type, a structure, a class, an array, IList etc.My problem is with the setter and determining whether the value has changed or not.This is simple enough for value types, but reference types and lists present a problem.For a class, would you assume that the Equals method has been implemented correctly, or just assume that the value has changed every time the setter is called?If I did assume it's changed, then perhaps I should assume it for value types as well, so that the behaviour is consistent.
I define 3 arrays: ID(n), Hour(n), Showed(n). If Hour(i) = actual time, I get the data pointed by ID(i), if not Showed(i).
BUT... I can add new hours or modify some existent, but I need to have the Hour array sorted. If I sort this array, the ID and Showed will point to different data.
So I though some different solutions:
1 - To make a string array with all inside (a 7 characters ID, a 5 characters Hour and 1 char for showed (T or F)). It could work, but, how can I sort the middle part of the array (Hour)? So, this don't work.
2 - A 3 dimensions "multitype" matrix (1 dimension of type Integer, the second of type Date and the third of type Boolean). I have no idea about how this can be done.
3 - A 3 dimensions string matrix, some like the "all inside" array: ID converted to a fixed size string, hour converted to a 5 chars string (hh:mm) and Showed converted to T or F. And sort the second dimension.
4 - Sell my copy of Visual Studio and drive a taxi cab
How to create a class which inherits from a data type, specifically from Char data type? I just want to add one property to it. If it's not possible, are there any other ways to accomplish this?
