Asc Command Not Working Correctly
Dec 13, 2009
I have been making a text based noughts and crosses game and trying to convert an alpha grid reference into a number to run the logic sequence that decides whether the an input is valid. I am using the asc command to convert but it just keeps putting up the error: Conversion from string "a" to type 'Double' is not valid, when it reaches the line If (Asc(Left(choice, 1)) >= 65 And Asc(Left(choice, 1)) <= 67) Or (Asc(Left(choice, 1)) >= 97 And Asc(Left(choice, 1) <= 97))Choice is the input and has already been checked for length, whether it contains an alpha and numeric input (and where they are) and whether the numeric value is valid.
View 1 Replies
ADVERTISEMENT
Apr 21, 2012
My SelectCommand.CommandText is:
dtaadpPoints.SelectCommand.CommandText = "SELECT TOP 1 * FROM PointsTrans WHERE UserID=" & UserID & " ORDER BY PointNo DESC"
This should select the top row from the table PointsTrans where the UserId is what has been declared earlier when sorted in descending order.
But when I stopped the code to see what was happening there dtaadpPoints.SelectCommand.CommandText containe
View 1 Replies
Dec 5, 2011
In my application, I have a call for an update to a table on my database. I know that it is executing because I get a 1 returned when checking the number of rows affected but when I look on the DB the value is not updated - I have refreshed and still no update. Here is the code, taskgrp_template is type bit and taskgrp_id is type integer. Id is also set to the correct value, as the result of my tracepoint - results listed below code.
mycmd.CommandText = "UPDATE p2_taskgroups SET TASKGRP_template = 1 WHERE TASKGRP_ID =" & id
rowsChecked = mycmd.ExecuteNonQuery()
Tracepoint result: the value of id is 55 and the value of templateCheck is 14 the number of rows affected was 1
View 1 Replies
Feb 27, 2012
MVC3 VB.NET application. I have the below section of code in a function. This code is supposed to only fire if the handout1 is not nothing. But for some reason it is going into the then block when the handout1 is nothing in the database... I have tried a hundred different ways of checking but it is still trying to run that line of code even when there is nothing to assign to it....
[Code]...
View 2 Replies
Apr 11, 2012
I am at college and am creating an app. however i have two main problems within my app. my app is a pizza app which will allow staff within a pizza shop to send the orders to the kitchen (this is just a listbox).but, the math doesnt work, the correct pricing isnt being displayed in the label for the orders for some reason. I have tried different ways of writing and placing my code but the result is always the same. also, i have five customers per table. if i select all the customers orders and click on send, only customer two's order will be sent. not any of the other customers, but if i just do customer one on its own, it works.
[Code]...
View 2 Replies
Feb 13, 2009
I have a context menu strip associated with a listview. Everything work just fine however one of my menu options on the context menu strip has a pop-out menu (you know, you hover over the selection, and another menu strip expands out).I can seem to get these to work correctly.
Public Sub ReleasedToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ReleasedToolStripMenuItem.Click
FileEntries(ListViewSelectedIndex).Status = "Released"
[code]....
So I changed my sub to read as the one VB created, and still didnt work. So I went back to edit the context menu, double clicked "Reserved" menu items, then VB creates a sub w/o the _1 (like I had before).Also the check-box status for these menu items works fine.
View 1 Replies
Feb 1, 2010
I have the following function in my program:
Format(Now(), "yMMdd" & "hhmm")
in 2009 it produces 912311200 for 12/31/2009 12:00
in 2010 it produces 1001011200 for 01/01/2010 12:00
It is giving me a 2 digit year. How do I get a 1 digit year?
View 4 Replies
May 11, 2009
I use the following statement to position which row to update;
Dim salonToUpdate = (From r In db.Salons _
Where r.StoreID = storeID _
Select r).Single()
If fileDate = #1/1/1900# OrElse fileDate = Nothing Then
SalonToUpdate.LastDownLoadDate = TableDate
[Code] .....
I've double checked to make sure none of the dates are invalid or null, but when the bolded statement executes, the following sql runs through the trace:
exec sp_executesql N'UPDATE [dbo].[Salons]
SET [LastDownLoadDate] = @p0
WHERE 0 = 1',N'@p0 datetime',@p0='2008-01-04 00:00:00:000'
Of course it's going to fail if LINQ is passing in where 0=1 every time. Shouldn't it be using some unique row identifier, (in my case, the salon id), to update the specific row?
View 2 Replies
Mar 16, 2010
i have a text box that has a max length of 5. when typeing into that text box the character input stops on the 5th character. if i set teh text property to a sting that has more than 5 characters the text box accepts the string. in vb6 i think that the text box would truncate the string to 5 characters.
does anyone know of a way to truncate, or get the text box to only accept the maxlength of the text box
View 4 Replies
Nov 9, 2011
[[code]I have this issue where most of the rows in the table do not fill in the data to textbox2 and any edits made in the text box when this happens do not commit to the underlying datasource.When scrolling down and back up the datarepeater different records seem to be shown each time the data on the left is correct in the standard DGV ... it's just the data repeater that doesn't work.
View 1 Replies
Jan 11, 2010
i'm currently implementing a localized website. I've created a custom ResourceProvider + Factory for storing resources in a database. This all works, i'm storing data as follows:
[Code]...
View 1 Replies
Feb 1, 2012
This issue is driving me nuts. Yesterday it was working perfectly but unfortunately I deleted the form by mistake and I had to build it again. The form contains a datagridview and I have the following code on the Load event:
HTML
Private Sub GUIAS_ConsAd_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Me.ADIANTAMENTOSTableAdapter.Fill(Me.GUIASDataSet1.ADIANTAMENTOS)
[Code].....
The same code on the Sorted event of the datagrid produces the same effect
View 4 Replies
Jul 22, 2009
I found very wiered behaviour for DateDiff. or any other kind to date difference methods avalibale when Date has AM/PM specified in it.
Cl.LunchStartTime =
"2009/7/13 12:10:00 AM"
Cl.LunchEndTime =
[code].....
View 2 Replies
Sep 14, 2009
This is a follow up to another question of mine. The solution I found worked great for every one of the test cases I threw at it, until a case showed up that eluded me the first time around.My goal is to reformat improperly formatted tag attributes using regex (I know, probably not a fool-proof method as I'm finding out, but bear with me).
My functions:
Public Function ConvertMarkupAttributeQuoteType(ByVal html As String) As String
Dim findTags As String = "</?w+((s+w+(s*=s*(?:"".*?""|'.*?'|[^'"">s]+))?)+s*|s*)/?>"
[code].....
View 2 Replies
Nov 8, 2011
Splash Screen VS2010 - Not working correctly
View 15 Replies
May 17, 2012
Ok so on my project it seems the timer is not working correctly, the interval is set to 5000 (which is 5 seconds... right?) so every 5 seconds it would display a MsgBox telling me the current date/time and then a time in a list.
[Code]...
View 4 Replies
Oct 7, 2011
I have an AsynchFileUpload on my page and for some reason when I try to use it to save the file to the server it falls. The control will allow me to select a file locally and it displays the local file path in its text box, BUT when I then click a button on my page which I am going to be using to submit all details then upload the page everything goes wrong and I get a Null Ref Exception from the AsynchFileUploader.
[Code]...
It seems that the filename is being lost somewhere after the button is clicked, or just never stored
View 1 Replies
Dec 10, 2009
I'm a college student just starting out programming in VB and am having a lot of trouble trying to get my drawing program to work. Currently i am using Microsoft Visual Basic 2008 Express Edition and whenever i try to debug my program the window it's supposed to run in is just a gray block. I'm not too sure if this is the right place in the forum to post this so if it is just let me know and ill move it. c:
[Code]....
View 2 Replies
Mar 24, 2011
I have made a form that consists of textboxes nested in groupboxes nested in tabpages. I want to check if all textboxes are empty in every groupbox and even if the controls from a groupbox in a groupbox are empty.When they are empty i should not create an element string for my .xml document.Below is the code that I have at the moment. I call it with the form as the parameter.
Public Sub recurringControls(ByRef ctl As Control)
For Each c As Control In ctl.Controls
If c.Controls.Count > 0 Then
If c.Tag IsNot Nothing Then
[Code]...
View 1 Replies
Nov 15, 2011
I'm trying to see if the microphone on a PC is working correctly by utilizing the SpeechRecognitionEngine class.I'm using the following
VB.NET
Dim RecognitionEngine As New SpeechRecognitionEngine(New CultureInfo("en-US"))
'Dim synth As New SpeechSynthesizer
'synth.SpeakAsync("Microphone")
[code]....
When I run this code, the microphone runs until it detects a sound. If the room is silent, it never stops. At least so much as I can tell so far.But I need a way to detect when it can't detect a sound within a specified interval.I looked on MSDN and all I could find was a property called, BabbleTime. I can specify a TimeSpan that will time out the speech recognition, but from that, I can't determine if it was the timeout that caused the code to continue or if it detected sound.
View 2 Replies
May 20, 2010
I have some update panels on my page that do some asyncpostbacks to keep some dropdownlists correctly populated. My problem is that on my page i have an HTML input that is handling some file uploads. With the AJAX on the page with asyncpostbacks, and while i step through my code behind, the files arent being uploaded. Using a postbacktrigger (non-async) is not possible because of my layout.
Here is my code:
<div id="divFileInputs" runat="server">
<input id="file1" name="fileInput" type="file" runat="server" size="50" style="width: 50em"
onfocus="AddFileInput()" class="textbox" /></div>
[code]....
When I put a breakpoint in at the declaration of service and then check the value of "files", the count is 0. I am expecting it to be 2 when i have one file uploaded.
View 1 Replies
Sep 29, 2011
I have an SQL command I am attempting to execute.The syntax is as follows
[Code]...
View 1 Replies
Jun 11, 2011
I have a piece of code that takes two strings, puts them together, then attempts to save that result into a table in a database. For some reason, the database is only showing the second half of the string ( Me.txtRev.text in this case). When in debug, I can see that newRev is actually correct, with the hyphenated string.
Dim newRev As String = Me.revs(0) & "-" & Me.txtRev.Text
Try
Dim sqlSOPDept As New SqlClient.SqlCommand
[code].....
View 3 Replies
Dec 3, 2010
In my XAML I have this:
<UserControl.CommandBindings>
<CommandBinding Command="Help"
CanExecute="HelpCanExecute"
Executed="HelpExecuted" />
</UserControl.CommandBindings>
[Code]...
But i get the error: Cannot convert string 'MyCustomCommand' in attribute 'Command' to object of type 'System.Windows.Input.ICommand'. CommandConverter cannot convert from System.String. What am I missing here? And please note that I want to do it all in XAML, i.e. don't want to use CommandBindings.Add(new CommandBinding(MyCustomCommand....
View 1 Replies
Apr 20, 2011
why the doc.Save("filename.xlm") might not be working? Trying to do a simple routine - just loading an existing xml file and saving as another name onto local C: drive. Seems to run ok ie no errors, but the file doesn't save. 'Save' part of the doc.Save command is coming up as a different type colour in dreamweaver.
Also, secondary problem, getting error if use a long directory name in the doc.Save destination filename - comes up with 'URI formats are not supported'
View 3 Replies
Jul 22, 2011
the codes run with no errors, but the data is not save in the sql server table event though the codes run.Dim connection As New SqlClient.SqlConnection
connection.ConnectionString = ("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB.mdf;Integrated Security=True;User Instance=True")
connection.Open()
Dim command As New SqlClient.SqlCommand
command.CommandText = "INSERT INTO [studentsummary] (sum1,sum2) VALUES (@sum1,@sum2)"
command.Connection = connection
[Code]...
View 14 Replies
Mar 27, 2012
i have my insert command but when ever i run it and click the button i get the messge "ExecuteNonQuery: Connection property has not been initialized." Here is my code:
Private Sub btnRent_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRent.Click
Dim constr1 As String = "Provider=Microsoft.ACE.OLEDB.12.0;" & "Data source = test.accdb"
[code]......
View 5 Replies
Mar 20, 2012
i have use this code to search the records of my datagridview and put it on my datetimepicker, there's no error occuring but it's not working either?
Public Sub SelectRecordM()
Try
Dim dbConn As OleDbConnection
Dim dbSelect As New OleDbCommand()
[code]....
View 4 Replies
Dec 13, 2011
I am using VB 2005 and the following code returns an error: No value given for one or more parameters. I swear I've done this before without any problems but I can't find my original code.[code]I tested the value of oldid which is set earlier and it does have a value.
View 2 Replies
Mar 15, 2012
I'm experimenting with the sql command builder and it seems to do nothing when trying to update existing rows. If I create a new row and then add it then it works fine but I cant seem to update an existing record.
Heres what I have at the moment
Code:
Dim strConnection As String = "Server=myServerSQLExpress;AttachDbFilename=C:databasepath estdb.mdf;" & _
"Database=testdb; Trusted_Connection=False;User Id=sa;Password=test;"
[CODE]...
But I'd really like to find out why its not working when using the command builder. I'm working with VB.net 2010 express and SQL server express.
View 3 Replies
