I have a vb.net app that I can read a .xls file into a dataset or loop through as oledbdatareader and it gives the same result.Some of the rows have all nulls when I loop through them but if I open the same file in Microsoft Excel I can see that row fine.[code]From the info above the first two SKU values would come through fine but when I get to the 3rd row it would show a null.Is it possible that it kind of inherits the first rows type and since the 3rd row isn't all numeric if nulls it? [code]
I have some code which gets child items for a menu via the GetChildren function which takes a list of menuData: Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu If menuData.Children IsNot Nothing Then menuData.Children.AddRange(GetChildren(menuData)) End If Next
If I check if menudata.children isnot nothing, it always is nothing because the GetChildren function is yet to run (providing the child items, which do exist). If I remove this check and just have this code:
Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu menuData.Children.AddRange(GetChildren(menuData)) Next
Then I am presented with a Object reference not set to an instance of an object error on menuData.Children.AddRange(GetChildren(menuData))
By my logic, this should only assign .length to index IF the length of strItem is longer than 0. This check is there in case the listbox is empty, or the user has not selected an item. However, everytime I go through this code without an item selected I get:
I want to read an Excel sheet into a DataTable using an OleDbDataAdapter, however, I only want a section of the spreadsheet (the part that 'looks like a database').[code]
I am trying to read the HKEY_USERS hive of a remote machine with this Class
Imports System.Management Imports System.Management.Instrumentation Public Enum RegHive As UInteger
[Code]....
The value of sSubKeyName is the user's SID + "" + Network (e.g. S-1-5-21-1606980848-2025429265-839522115-560021Network). Now under that key are various subkeys containing mapped drive letters. But it never returns anything.
Strangely, if I use the OpenRemoteBaseKey method it works BUT I don't want to use that because using WMI lets me specify alternate credentials and OpenRemoteBaseKey doesn't
I have a WPF application that uses a third-party library to perform a specific task; this library, in one of its methods, executes the statement Assembly.GetEntryAssembly(). If I run the WPF application on debug (by running a .Net exe for testing) the library works properly and Assembly.GetEntryAssembly() returns a reference to the assembly of the executable, but in production I have a different situation that causes me some problems.
I have the following code in my application. When it is executed it brings out a null value at times, where i am sure there should be a value returned. I have checked by running the sql statement in the database and it returns the correct value. What could be wrong with my code? [Code]
Rather interesting bit on this one, I have all the code where it should be working but whenever it hits parse1 it returns the file as null. [code] I probably just need a fresh pair of eyes because I'm not seeing where this is glitching (...or if it's just my computer in this case.)Rather annoying at this point, tried break points and following the execution to catch the error but no such luck.
I have some VB.NET code that creates a TransactionScope instance:
LoggingUtility.LogDebug("UpdateCallTable", "SatComCallDataImporter", "About to associate call data with contracts") Using ts = New TransactionScope() LoggingUtility.LogDebug("UpdateCallTable", "SatComCallDataImporter", "Getting all unimported SatCom calls")
My application is throwing an exception on the call to the creation of a new TransactionScope, with "Object reference not set to an instance of an object.". The exception isn't thrown on my development machine or my test machine; only on the customers production machine, and I have no idea why. I've placed debug lines immediately before and after this line so I'm positive it is this line causing the problem.
A have used TransactionScopes throughout the application and this is the only place throwing the exception on the client machine."About to associate call data with contracts" gets written to the log and the next log entry is the "Object reference not set to an instance of an object".
Code works fine if I move it out of a transaction.I've been struggling with this for 4 days now and have got no closer.
i hav two openfilefialogs(1 and 2). So i also have a listbox. the files opened with the openfiledialogs will be added to the listbox. and when i need to open the files i need to see if they are from which openfiledialog. so
it is like this.
Path.GetDirectoryName(OpenFileDialog1.FileName) & "" & Form3.ListBox1.SelectedItem.ToString 'if this returns a null then go to this Path.GetDirectoryName(OpenFileDialog2.FileName) & "" & Form3.ListBox1.SelectedItem.ToString
Is their a more elegant way to assign a space to a value, if a database call returns null for a data set column? I am doing the following check which is pretty tedious:
If (ds.Tables("employee").Rows(0).Item("txtNamePrefix").IsDBNull(0)) Then txtNamePrefix.Text = "" Else txtNamePrefix.Text = ds.Tables("employee").Rows(0).Item("txtNamePrefix") End If
I have a DataGridView connected to a DataSet. I want to allow the user to update and insert new records on the RowLeave and CellLeave events. The Update method works: Me.ExpensesTableAdapter.Update(Me.DataSet1.Expenses)
I am basically trying to access the CLSID portion of the registry... some CLSIDs are working, some arent...
Here is my code: Dim regkey As RegistryKey regkey = Registry.ClassesRoot.OpenSubKey("CLSID" & location & "InprocServer32", False) 'Just Returns null when im looking for a certain CLSID Dim SubKeyvalues() As String = regkey.GetValueNames() Dim subkeyvalue As String subkeyvalue = regkey.GetValue(SubKeyvalues(0))
I'm trying to get data with the methods below and I get null response and can't figure out why. I'm just trying out a different way of using a wcf service from silverlight and I don't understand something that I should.[code]...
The employee object will stay null. If I put a break into the service call and follow through the code it finds the correct record from the database and the return statement shows an object with the correct data but still the employee object in silverlight side will remain null.
I want to edit the rows and columns of an excel file using vb 2010 express. NOTE : I dont want to open .exl file but want my program to read and edit them according to user. PS : I want to edit them according to cell number.
There were three similar questions in StackOverFlow but none gave an answer.. If have found why this error in occurring but don't know the fix. I am using Strongly Typed Dataset for my project which is created as a dll for DAL. I have added the Sql Server Table into this dataset using the designer and has created a DataAdapter
I have a several form elements that I am dynamically creating with javascript when a user changes a number value in a textbox, by filling the innerHTML of a div like so:
Then, in the aspx.vb code behind, when the user clicks the Save button, I run through a series of Requests to try and add the values that are in these form elements to a SQL string:
Dim DFTestValue1 As String DFTestValue1 = Request("textbox" & c.ToString)
where c is a loop counter to the # of textboxes created (the input value mentioned above that triggers the create) The problem here is that this code works in Internet Explorer but not in Firefox or Chrome. The Request() value returns null and nothing is saved. I hope I've explained this well enough.
My Visual Basic .Net 2010 application reads data from an EXCEL spreadsheet which will be generated by my "customers". The responses to Alkis last year (23 July 2011) has been a big help and got me over a hump in my application. Now I am down to the last issue - how do I detect a blank cell? Valid data is numeric, starts at a fixed cell (A5 to be specific), and will be continuous until it ends with blank cells. While blank cells appear to print a "zero", when I try to use zero as an end criteria I get a 'System.InvalidCastException'. When I put in a specific end value (-1) in the last cell all works fine but that, of course, is an invitation to a user error.What is the difference between "Value" and "Value2" and where might I find documentation that explains the difference? [code]
Basically i work as a desktop support officer. our team does everything from fixing software errors on PCs in the office to moving them from one desk to another. When we do have to move anything though, it needs to be tracked so that our records can be accurate. To track where things have moved to, we have to:
1. fill out a form in an excel format and then fill out the same information into a text file format, and then attach both formats to the job record in our job listing system and send it to our hardware tracking team.
2. If an asset is being taken away to storage, but is considered to be too old, it needs to have an excel table filled out to create a 'disposal' label, or it can create a 'redeploy' label if it still has some years left in it.
3. If we are putting out a brand new asset, it needs to be updated on our tracking sheet to show that the asset is no longer in our storage as brand new.
This obviously creates a lot of administration work for our staff, so i have built my program to take all the information required once, and then split it off to the forms and labels as required.The part I'm stuck at is number 3. I have been working with the excel files in the following format:[code]What i need to do is as the title suggests, search an excel work book (the user will point to it) for the Asset Number in a particular sheet. Once it finds the asset number, cut the entire line out of the sheet and paste it into a different worksheet at the next empty line with a few edited values.
I am developing a vb.net app that should read cell values from excel. However, it is not returning any results and I thought that it would be really simple. I have imported all the references viz. Microsoft Excel 12.0 Object Library.
Following is the function in my class file which should read the excel file
Dim mobjApp As Excel.Application Dim mobjWB As Excel.Workbook Dim mobjSheet As Excel.Worksheet
Public Function CheckHasRoom(people_id As String, semester As String, year As String) ' Don't let folks already registered for a room register for another. Dim RoomSelected As String
[Code]....
But it is bugging out at hasroom.Any() saying, "Input string was not in a correct format." Any thoughts on why? This is returning a collection of rows just like where I use this same code elsewhere without issue?
In the following code all goes well until the .Sort line. Then I get an error which says, "The sort method is not valid. Make sure it is within the data you want to sort and the first sort by box isn't the same or blank."I've tried various permutations to deal with this exception, all to no avail. The Range is Selected ok and the Excel data are pasted from the clip board ok. Then I get the error and no sort occurs.
In my application I read data (using data binding) from an Excel spreadsheet into a DataGridView. This works, but the data columns contain text fields (strings). I would like to set the data type for some columns to "Date" and Decimal. I cant do this on the DataGridView (error: cant change properties for data-bound stuff) and I cant figure out how to do it on the dataset or data-table that I bind to the DataGridView.The following is the code I use to read and bind the data:
Using con As OleDbConnection = New OleDbConnection(cs) ' 'open the OleDbConnection
[code]....
The commented out code (below the 'Todo: comment) causes a additional table, but I want to change the table with the data.
I have a select statement which was returning the required values but when I changed the OS date from English(US) to English(UK), it now returns null. I believe the problem is concerned with date since in the query am selecting values where the date from the database is the same as the date in a combobox but I don't know what else I can do. It almost looks like the dates in the combox and in the database are not the same and yet the date in the combobox is actually retrieved from the database and has been returning values fine until I changed the system date format.Here's my select command:
cmd4.CommandText = _ "SELECT sum(brought_qtty), recieved_qtty from brought_coffee, centre_weigh where brought_date=#" & _ dtComb.Text.Trim & "#" & _[code].......
I have created a strongly typed dataset in the VS 2005 Dataset Designer. There are two tables that relates to each other in a one to many relationship: Claim and ClaimDetail. The designer automatically creates a function GetClaimDetailRows which returns all ClaimDetailRows for a ClaimRow. Why is this Array's length always 0? Because ClaimDetail contains more than 40 Million rows, i did'nt fill it before i call GetClaimDetailRows but had configured it's selectcommand that it takes a parameter idData to fill only the related records. But that seems not to work because the ClaimDetail-Datatable is empty.
The automatically generated function in the ClaimRow-Class which returns all related ClaimDetailRows: Public Function GetClaimDetailRows() As ClaimDetailRow() If (Me.Table.ChildRelations("Claim_ClaimDetail") Is Nothing) Then Return New ClaimDetailRow(-1) {} Else Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("Claim_ClaimDetail")),ClaimDetailRow()) End If End Function
When debugging I see that it jumps into the else block but returns 0 rows. Do I have to fill the Claimdetail-Datatable first(ClearBeforeFill=True) for each Claim? But then I don't need to use this function anymore. I now fill the Datatable(ClearBeforeFill=True)before i call the Child-function and it works. But I don't understand why it could not throw an exception(optionally) when I try to acess a child-relation without having that datatable being filled(at least with 0 rows). Instead of that it returns 0 rows what can be correct or incorrect and is difficult to detect.
