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 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 am using an update panel and when I click a button it will update all the panels. updapanel1.update() is very simple, but my data is not updating unless I hit the button twice. My gridviews shows data for a selected user, and then all the grids reflect that users data. works fine all the update panels work for the gridviews. Now for somereason when i try to do a row count and update the panel with the summary, it does not work, i get either the previous users summary or if i hit update again for the same user i get the correct data.
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.
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 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 have a linq query which loads approx. 1000 lines into a variable, during that process I want to display a progressbar, not necessarily stating the percentage, can be marquee style, doesnt matter.
This progressbar is on a modal form to precent the user from interacting with the app for the time the query's running.
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'm facing a problem while updating data in a database through datagridview. I'm changing the cells using a for loop and then updating db using below code. All data rows get updated but 1 (the last one).
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.
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
What i have in a text box that is the discount. The text box talks to the label as you type and updates it accordingly The problem is that once the discount_rate.text get to 10 or above the discount is off by 5 cents and increases as the number goes up..
Private Sub discount_rate_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles discount_rate.TextChanged Select Case radio Case "one" If discount_rate.Text = "" Then
In a windows forms project, I have several combo boxes. The first combo box contains a list of objects. Those objects then have several lists which are used as the datasource's for the successive combo boxes, depending on which item is chosen in the first.
Public Sub UpdateStaff(ByVal sr As StaffRecord) Dim oldSr As StaffRecord Dim q = From staff In db.StaffRecords Where staff.Employee_Number = sr.Employee_Number Select staff oldSr = q.First oldSr.Address_Line1 = sr.Address_Line1
[Code]...
The helper function I have written seems to do everything I want apart from update the db. Stepping through the code, the oldSr is updated by the new sr parameter but no update on submit changes.
I just upgraded a project from VB 2008 to VB 2010. Before, the project did not use LINQ. I have started implementing it. So, I have updated the target framework from 2.0 to 3.5, and added a reference to System.Core, and imported the namespace System.LINQ to the entire project and also imported System.Data.LINQ into the form I'm working with (because it was not available in the list for Imported Namespaces in the references tab).
It's not throwing any errors now, but my IntelliSense is not working for LINQ stuff.
For example... I write this:
[CODE]....................
Then, if I type S. on the next line, the IntelliSense doesn't grab what it should for S (Only get Equals, GetHashCode, GetType, ReferenceEquals, and ToString, instead of the options I should get like Count, First, FirstOrDefault, etc...). If I Type S.First. then its the same thing, no IntelliSense that lists the available fields for S, just the standard options (Equals, GetHashCode, GetType, ReferenceEquals, and ToString). I should be seeing my column names in my table when I type S.FirstOrDefault.
So any ideas what is going on? When I type the code, for example, MessageBox.Show(S.FirstOrDefault.FirstName), it works perfectly. But it doesn't change the casing of the text (so it would read s.firstordefault.firstname) and no intellisense while doing it. But no errors. BTW - Everything works perfectly when creating a NEW VS 2010 application, it's just my projects upgraded from Visual Basic 2008 that have this issue.
I started developing an application several weeks ago and decided today that I may want to use LINQ. So I changed my project from .NET Framework 2.0 to 3.5 and restarted the program. However, I can not get the most basic LINQ statement to work. I thought it was my code until I started a blank .NET 3.5 project and inserted the basic code (below) which worked without issue. So I then started another .NET 2.0 project and inserted the code (which I knew wouldn't work) and the errors are the same as the project that I converted. So next I converted this new .NET 2.0 to 3.5 and the code still doesn't work. So migrating from 2.0 to 3.5 isn't working for LINQ.
My question is: If one changes from a .NET 2.0 to a .NET 3.5 how do they get LINQ to work properly?
What happend to my Intellisense?When I type a line like this ...
Dim users = (From u In Membership.GetAllUsers Select u.UserName)
I get (almost) no Intellisense when I get to the Select u. part. Only Equals, GetHashCode, GetType, ReferenceEquals and ToString appears. Not "UserName" and the other relevant propeties of the MembershipUser class.The code compiles and works just fine.
