I have tried numuerous code conversion tools, and all have failed...I found an interesting snipper of code in C# that I have converted to VB, all but the following line of code. Cound someone please help to convert this C# to VB?
C#:
double totalRows = (int)myCommand.Parameters["@totalRows"].Value;
Is there any code conversion tool for converting Delphi to Visual Basic?
View 3 RepliesVisual Studio 2010 I am trying to learn Caliburn Micro. The sample project is presented in C# only (and runs OK) I have tried several on-line C# to VB converters, without success. Well the conveersion runs without error - - - but the Visual Studio editor chokes on the results. The principal problem seems to be with (what looks to me like) a Lambda. Advanced code conversions are really tough in any case, - but when you do not know C# nearly impossible.
[Code]...
a user will enter a number, n, which ranges from 1 to 30. they will also enter a "P" or an "S" (sum or product). depending on which was selected, it will calculate the sum or product of the numbers from 1 to n.i'm having a conversion error on line 5 stating "Conversion from string "S" to type 'Double' is not valid." [code]
View 2 RepliesForget fancy shmancy web stuff. I'm looking for a good .NET CLI argument processing utility, prefer open source code. This is for quick and dirty utilities that need robust and friendly command line argument handling.These are utilities with maybe a day of effort in them. Investing a few days writing good command line handling seems overkill but they really need it.Features I like in command line handlers. I'd be thrilled with any open source project that had 2 or 3 of the following.A consistent syntax, posix had a nice command line standard, but not necessarily posix.Ability to provide short names for agruments. E.g. "msbuild /t" == "msbuild /target".It supports good command line parsing then gets out of the way. I want some that my code uses, not something that imposes a pattern on my code e.g. I don't want to have to respond to the presence of an arg with an event, that type of thing. Seperation of concerns is good enough that it's logic can be unit tested. Oh - is it two much to ask for it to read attributes off a class properties (as in .NET configuration classes)? I like the config file overrides in msbuild. I can set properties in a build file, but override on the command line. Built in "show usage". WSF files (csript.exe) have this functionality. I'm not willing to write jscript to get the command line handling though.Not powershell. I can't find anyone in my company who can stand Powershell syntax.
View 4 RepliesI'm having trouble with reading a .txt file line by line, converting it into a string, then putting it into a listbox. When I execute I get an error saying "IndexOutOfRangeException was unhandled" Here is my
[Code]...
is there a section on how to add controls, Ie like in fire fox Tools/Options
View 1 RepliesI wish to get a quick feeling for how much copy and paste coding we have, there are many tools for C# / Java to check for this type of thing. Are there any such tools that work well with VB.NET? (I have seen what looks like lots of repeated code,
[Code]...
I am tring to make this print a second page if it is needed. It is throwing an error on the line �lines = streamToPrint.ReadLine()�. The error message is �SystemNullReferenceException was unhandled:Object reference not set to an instance of an object� , which I can�t seem to resolve.
Option Explicit On
Option Strict On
Imports System.Drawing.Printing
[code].....
Are there any free or cheap Code coverage tools I can use "ad hook" just to run my program and see wich methods that is not runned in the project for that session? Im not interrested in tools that has to use unit-tests or a lots of advanced functions. If possible just "hit'n run".Its for a "fun" event in a "programmer pentathlon". I'll get 10 programmers run a program and the person that cover most code when running it will win.
View 1 RepliesI would like to either generate VB Code from UML or vice versa UML from Code. Does anyone know some UML tools for VB6 or VB.Net that can do this?Is it possible with Visual Studio 2010?
View 1 RepliesI am using the given code to copy my database files...it works like a charm in debug mode but as soon as I create a setup, it stops working. The error is
"Database Detach Failed"
I tried checking the code line by line and found that the code does not enter the IF block.I have no idea why.
Public Sub bk()
Try
Dim strDatabasePath As String = My.Computer.FileSystem.CombinePath(My.Application.Info.DirectoryPath, "LIC.mdf")[code].....
I have query that involves a cross-language operation, namely converting 4 SBytes to a signed integer. The source language for this operation is Java, which utilizes the ByteBuffer in order to extract a signed integer from the data stream. The inner workings of ByteBuffer are at best a black box to me, as I haven't been able to find any hints to what actually goes on when Java extracts the integer. [Code]
View 2 RepliesI don't know how to convert the nvarchar value into an int, but that is the way it needs to be set up. I've found other posts about this but I don't know how to use CAST in the INSERT statement I have. All the posts I could find were about converting to int in SELECT statements. I need this statement to change the field @Duration to an int in the database. @Duration is an amount of time. (01:00, 02:00...) They will all get rounded up to the next int value. So if a user enters 0:45, it should be converted to 1. how to get this INSERT to work?
'SQL Insert: Product table
Dim sqlInsertProduct As String = "INSERT INTO Product (ProductName, Status,
CreateDate, ModifyDate, CreateUser,
[Code]....
when running my program I get the following error:Conversion failed when converting date and/or time from character string. After playing a round with breakpoints I discovered the error to appear during:
sqlText = "INSERT INTO dbo.OrderDetails (OrderID, ProductID, Qty) VALUES ('" & _
orderID & "','" & prodID & "','" & prodqty & "')"
ExecuteSQL(sqlText)
[code].....
I have two datetimepickers on my form to set a start date and end date for a SQL server database query. I am passing these dates with parameters to my query from the .Value of the datetimepickers. When I run the program, the code returns an error of "Conversion failed when converting datetime from character string" I am not converting anything in my code. It is my understanding that the StartDatePicker.Value is already a datetime and does not require conversion.
Here is some code:
'Define Wages_Query
Dim Wages_Query As String = _
"SELECT [Department], [Operation_NUM], sum(STWag) as [STwag], SUM(OTWag) as [OTWag]," & _
" SUM(Shift_Diff) as [Shift_Diff]," & _
" SUM(COALESCE(STWag,0) + COALESCE(OTWag,0) + COALESCE(Shift_Diff,0)) as [TotalWages]" & _
" FROM dbo.Financial" & _
[Code] .....
Mostly got these errors : The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. Conversion failed when converting date and/or time from character string.
[Code]...
I've got a problem when converting the text in my textbox to a GUID when I attempt to save the data.Here's my code:
Dim conn As SqlConnection
Dim check As Integer
Dim cmdClient As New SqlCommand[code].....
Edit: I'm using SQL Server Management Studio R2 and Visual Studio 2010
I'm trying to insert data into a table in my database. I'm using MS Visual Studio 2005 with SQL Express/I get the error message: "Conversion failed when converting from datetime to character string". [code]
View 2 RepliesI've been asked by management to convert all of my applications from VB 2005 to VB 2008 (in preparation for taking them to VB 2010). I have a VS 2005 application that uses an ADO Data adapter which was defined using the GUI. I normally define my connections in code, but have been asked to get away from that in favor of ADO (and similar) data adapters.When I run the conversion wizard in VS 2008, it appears to convert this program, with some warnings and I get the 'Conversion Completed' dialog box. However, the VS 2008, will not let me close the dialog box, even after waiting for 3 hours. The only way to get out is to reboot the system.
View 6 Repliesam using visual basics to develop a search on my project using the date picker but any time i try to search for a date on my SQL database i received the following error message from my programme. "Conversion failed when converting data and/or time from character string "
View 5 RepliesWhen using INSERT INTO statement to SQL 2008 R2 to a column with data type as date and the data I am taking from a DateTimePicker control with date format as short. When my system date format short set to dd/MMM/yyyy the INSERT INTO statement is working perfectly but when the system date format short set to dd/MM/yyyy I am getting the above error.I tried by changing the control format to custom and dd/MMM/yyyy but still the same error is coming.I am using VB2010 and SQLExpress 2008 R2 SP1?
View 2 Repliescmd.CommandText = "INSERT INTO Dropping (form_num, filing_date, approval_date, status) VALUES ('" + fnum + "', '" + deyt + "', '" + nulll + "', '" + stat + "')"
here is an sql query statement i run in vb.net. i keep getting the error of "Conversion failed when converting date and/or time from character string." whenever i try to execute this. the datatype of filing_date and approvale_date is "text" but the deyt variable is originally Date, converted to string: (Date.Today).ToString, like so. nulll is simply a variable with vbNullChar as its value.
I used to query:
Dim a As String
a = "INSERT INTO tblVisitor(Name, Sex, TimeIn, EnterDate)
VALUES('"& txtName.Text &"', '"& cboSex.Text &"', '"& Now() &"', '"& DateTime.Parse(cboEnterDate.Text) &"')"
[code]....
Which cboEnterDate is my DateTime Picker. Then I got the message:Conversion failed when converting date time from character string.
I am developing a Windows application for restoring specific databases from our Production platform to "field" tablets by using backups that are taken daily to disk. To preclude "orphaned users" on the tablets, I want to extract the "user name", "password" (hashed) and "sid".I am calling the MS Stored Procedure "revlogin" that produces screen text to copy and paste into a query to recreate those users on another SQL server instance.
IF (@denylogin = 1)
BEGIN -- login is denied access
SET @tmpstr = @tmpstr + '; DENY CONNECT SQL TO ' + QUOTENAME( @name )
[code].....
when saving the "conversion failed when converting datetime from character string" is displayed.
Private Sub BtnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSave.Click
Try
Dim cn As New SqlConnection(ConnectionString)
cn.Open()
[code]....
I'm having a problem converting a string to a datetime format. the string is depicting an hour, for example 08:00, but in the mysql database it stores that as 2008/00/00 00:00 any idea how to solve this?
[Code]
The error is: Conversion failed when converting date and/or time from character string.Basically I'm trying to make it so that when someone clicks a location in a list box it increments the correct field in a Stats table by 1 to say that they clicked the location. I've been trying to solve this for a while now and can't get anywhere. My date is in date format, and so is the Date field in my Stats table. My code can be seen below.
Dim Current As String
Dim Check As String
Dim objCmd2 As Object
[code]....
The issue comes in with the second SQL statement I think. I don't understand why adding a date into a date field would be an issue, I've tried adding it as a string which didn't work.
Dim i as integer
For i = 0 to 365
sqlinsert.InsertCommand="insert into cashdate (date) values (getdate()+'" & i & "')"[code]....
getdate is a function in the database that returns the datetime of now i have an error that says conversion failed when converting date or time from character string .what to do now ??
I am trying to create stored procedure that gone return varchar value, and that value I need to display in textbox.This is the code for stored procedure:
Create PROCEDURE Status @id_doc int, @Name varchar(50) OUTPUT
AS
select @Name =items.name
from Doc,Items where @id_doc=IDN and doc.IDN=Items.ID
return @Name
This is the code in vb.net where i need to display returned value from procedure in textbox:
Public Sub Current()
Dim dtc As New Data.DataTable
Dim dr As SqlClient.SqlDataReader
[code]....
When I try to execute this code I get this message in exception:
"Conversion failed when converting the varchar value 'Blue color' to data type int."