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.
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
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....
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.
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.
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?
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
[[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.
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:
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
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*)/?>"
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.
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
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:
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
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.
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.
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.
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
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....
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'
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
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"
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.
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.