VB Missing IsNull()?
Mar 13, 2009I like to confirm that array is created, how can it be done? There is no nul keyword?
View 5 RepliesI like to confirm that array is created, how can it be done? There is no nul keyword?
View 5 RepliesReally crappy title but i have spent the last hour thinking of a working around.
Summery: A textbox is used to list clients i work for, Uses the splitter ","
Being seven days of the work would some times requier 6 splitters looking like this
Breath, Kemp House, garden center, Garden Center, COEL, PPD, Town
As so, but what if i miss a day? Or i dont always work saturdays sundays. from the code below you will see i have not added any work around fora null value. My suggestion is to incorporate a <nw> (no work) tag, but the code needs to change <nw> to my own personal message that i choose.
[Code]...
I am working on a new ASP.Net 4.0 data driven app. In the DAL I check for NULL values on all my data and default to the proper data when NULL. I have a strange issue going on. Two dates are coming back - on one I need the time only. The First line of code for the full date works without fail - but the second line of code errors pointing to the format string but the strange part is that it errors on NULL values which does not use the format string and just returns Date.MinValue. When the second line gets data it formats the return correctly.
Dim dr As DataRow .TourDate = IIf(dr.IsNull("tourdate"), Date.MinValue, Format(dr("tourdate"), "MM/dd/yyyy")) .TourTime = IIf(dr.IsNull("tourtime"), Date.MinValue, Format(dr("tourtime"), "T"))
The error comes on the second line when dr("tourtime") is NULL - the erroe is: Argument 'Expression' is not a valid value.
AS a SQL function, there is "isnull" to find and change the null value to something like below.
DECLARE @VALUE STRING
SET @VALUE
SELECT ISNULL(@VALUE , "THIS IS NULL")
Then the "Select" result will be "THIS IS NULL".
Is there a way that I can achieve this result from VB.NET 2005?
I'm doing an experiment on WPF and MVVM, and while coding the ViewModel on Vb.net I noticed this red wavy lines under my ObservableCollection(of T)s T_T
Anyway, the application is in WPF & VB.Net, under the .Net Framework 3.5 (I checked) and I have an 'Imports System.Collections.ObjectModel' on top of my class. Intellisense shows the other classes on System.Collections.ObjectModel except ObservableCollection.
Here's a screenshot.
So, why is ObservableCollection(of T) missing and how do I make it appear?
I am trying to publish to my hard drive so it can later be burned to CD or DVD a project I have developed and I seem to be missing that file. The person I developed it for does not have good internet access, so downloading such things as SQLExpress and DotNetFx35Client is all but out of the question. How and where do I get the file? I know where to put it on my hard drive once I have it.
View 3 RepliesI have been given the source code to a 2005 VB project to modify. But I can't find the .sln file or a vbproj file or open the project. Don't I need that file to open the solution correclty? or do I have to start a new solution and just add in all files?
View 7 RepliesMy SQL query shows 8 rows when executed but the following code only shows 7. Apparently, it�s missing the first row.
...
Dim temp as String = Nothing
Dim r As SqlDataReader = objCmd.ExecuteReader()
If r.Read() = True Then
[Code]......
I get the following error when i try to run my program. i tried to rebuild it many times but still it doesn't work. visual studio cannot start debugging because the debug target windowsapplication1.exe is missing. its my first time to use ms visual studio 2008.and i think there are some dependencies missing in this software but i'm not sure what are they.
View 1 RepliesI am Telerik controls in my project, Error is telerik.web.ui is not found, Coudn't find assembly
I have added Telerik.web.ui.dll inside Bin directory
Reference Code is available inside web.config
I have the code below that reads the partial app.config below. It works fine. But wondering how can I check that "value" is set to 0 or that the TraceSwitch is missing. If I remove the switches, my messagebox displays a 0. I want to display a user message if the app.config is not able to provide logging. And if the TraceLevel is set to 0, I will not show a message.
Dim s As New System.Diagnostics.TraceSwitch("TraceLevel", "")
MessageBox.Show("Trace Level: " & s.Level)
<system.diagnostics>
[Code].....
I have a problem with this code (look below) and I can't understand where is the problem: In moment of execution it gives a ERROR: Missing (;) at end of SQL statement.?
Dim cs As OleDb.OleDbConnection = New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=password;User ID=admin;Data Source=" & Application.StartupPath & "data.mdb")
Dim result As Integer
Dim cmd As OleDbCommand = New OleDbCommand()
[code]....
I cant find the reference for Microsoft.SqlServer.Smo Where can I find this missing reference for VS2010 Pre release candidiate
View 10 RepliesI completed my final project for a .NET course two days ago and just noticed today that all my project files for every project I have on my computer (about a dozen or so) are missing all the project files except for what's in the bin folders. The folder structure it seems hasn't been affected.
View 8 RepliesCould I have been googling with no joy regarding the fact that my program is not displaying changes made when I run it (Debug).
It is an old program (hence the 2003 VB.NET code) I wrote for my daily use and I decided to make some modifications to make it more useful.
I'm currently working on a project I've just received that is asp.net + vb.I have to add a gridview in one part of the page, but it simply won't let me set the datasource
<%@ Page Language="VB" MasterPageFile="~/Common/Common.master" title=whatever" %>
<%@ Register TagPrefix="uct" TagName="SubmenuControl" Src="whatever.ascx" %>
[code].....
I'm trying to filter a dataview using a DataView RowFilter. I want to filter out data based on two date values checked on one column:
Dim dtFuture As Date = DateAdd(DateInterval.Month, 6, Today)
dv.RowFilter = "ValidUntil >" & dtFuture.ToString & "AND ValidUntil > " & Today.ToString
I am getting the error Syntax error: Missing operand after '00' operator..
I seem to be missing some information from my stack trace, here is what i'm getting: at Foo.Bar(DataTable table) in D:FooBarauthoringApp_CodeFooBar.vb:line 87 Where is the rest of the stack trace infomation?
[Code]...
I using an ObjectDataSource (Should receive 5 rows) and a gridview.When I open the gridview I received all rows except the first one. So I only see 4 rows.Now I sorting my gridview with a click on a column. But I also get only 4 rows. After selecting a filter I receive all 5 rows. What could be the problem?
[code]...
I've tried to use NRefactory(Vb) [url]... but it didn't come with mono.cecil.dll so i downloaded that too, but when i merged it together the versions seem to be off (i had error Mono.Collections missing class)
does anyone seem to be able to get NRefactory working?[code]...
Using VB.NET 2008 SP1 on Windows XP Pro SP3:
I am using an existing COM dll that works fine in VB6, on the same development machine. The VB6 app compiles and uses this dll without issue.
I start from scratch to design a new Windows Form application in VB.Net. Then when I try to add a reference to this dll, the reference is added to the references list but the path shows as <The system cannot find the reference specified>. If I select this reference in the list, the properties window shows a blank for both the reference name and the path. At the same time, a reference is added for VBA, and it shows the reference name (Interop.VBA) and path correctly.
I used dependencywalker to find the dependencies for this dll. It has 3: user32.dll, kernel32.dll, and msvbvm60.dll. So presumably I have all necessary dependent files.
I have tried un-registering, re-registering the dll. I have tried the command line switches for devenv.exe to reset settings and to launch in safe mode. I created a new user account to see if it was related.
I have tried picking the dll from the Add References, COM tab and also via the Browse tab to select the file directly. Same result all cases. I also tried putting the dll and msvbvm60.dll in my bin folder.
I don't understand how the reference name and path are missing in the properties window when the reference name is right there in the list and I select the path directly when I added it. There are no other instances of this dll registered.
I tried using tlbimp from the command prompt with verbose switch, I get the error:
System.Runtime.InteropServices.COMException - Error loading library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRAY)). I wish it would tell us what is missing.
It must be registered properly and all dependencies available for it to work in my VB6 app, Re-writing the dll is not currently an option.
Dim N As String
N = InputBox(Combo1 & " search")
adodc1.recordset.find Combo1.List(Combo1.ListIndex " ' = ' " & N & " ' ")
[code].....
I am developing an accounting application using VB.NET. I use SQLDataAdapter to bind my datatable to the datagridview for the purpose of loading and updating data.In the UI has a TabControl, each tab has a datagridview to store the datae.g. current asset (tab1 and current liability (tab2). Each datagridview has columns for account code (string), Year 1 amount (double), Year 2 amount (double)
View 8 RepliesThis is the XML output of my command in a web browser.I need to get the MachineID value.
<?xml version="1.0" encoding="UTF-8" ?>
- <Response>
<Code>0</Code>
<Message>OK</Message>
[code]....
When i try to build and play my project there is an error:Microsoft Visual Studio cannot start debugging because the debug target "....LCCGDuelArenaVBNETCompatible.exe" is misssing
View 8 RepliesAt the top of my code I have:
imports system.drawing.graphics
but when I try to use it, no DrawImage or DrawString methods are available. I can get DrawImageAbort rather ironically.[code]...
I have made a project in VB.net. and it is working fine on my computer.But when i publish this project and install on my office laptop, i shows:Unhandled Exception: dwmapi.dll file missing. Module can not be found.
View 4 RepliesI have VS 2008 installed and cannot seem to get the form template to show when I try to add a new item to a project. I have tried the dev /installvstemplates from command line and I checked my zipfiles are in the 1033 folder, I think that is where they are meant to be but still no form showing in add new item?
View 9 RepliesI have a listview that I populate with data from a recordset during runtime. After the code has executed and I view the listbox, my columns are missing. I am 100% shure the listview is populated with data. The listview view property is curremtly set on Details. If I however switch the view to anything else eg. view=list, I see the listview items in the listbox. I need to show the user all the columns.
View 5 RepliesI have a form in VB Express 2008 and my form has lost some of its controls. The form size suddenly changed to 945, 591 pixels and every control outside of this is lost. I have all the codes intact and application can run. I simply cann't see the controls and its contents.
View 11 Replies