Hi All, I am having trouble trying to import an Excel spreadsheet into a dataset. Code is below: Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dataPath & "\" & LoadFile & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" Dim...more >>

I am new to VB.NET and I need some direction. I am creating classes based upon SQL tables (1 class per table). I know that there are alot of new features in VB.NET (2005) but what is the best way to go about this? In VB6 I would create the properties based upon the table structure, create a ...more >>

Definetly a newbie: I created a dataset with the wizard (based on SQL Server tables) and have dragged some fields onto a form to bind them, but now I have changed some fields on the SQL Server side. How do I get the dataset to recognize the new fields??? Thanks a bunch...more >>

Sorry for this post here, But did anyone else have the newsgroup microsoft.public.dotnet.languages.vb suddenly disappear ? Miro ...more >>

I’m trying to design a front end program in VB.NET for a MS Access database. I’m getting Concurrency Violation errors when updating if there is a DateTime field in my table that has been edited in Access. Seems to be when there is a Time value in the column. This is even happening from ...more >>

I want to create a generic data layer that uses Oracle as the back end. By generic, I just want a couple of procedures. All access will be done with stored procs, and I want one that returns a dataset and one that returns a datareader. I want to pass in the commandName, and a ParameterArray ...more >>

I've got the following code snippet in a button's click event. When it gets to the point of setting the InsertCommand.CommandType an exception is raised. The exception is "Object reference not set to an instance of an object". Help? 'Save the record Try Dim sd...more >>

For those of us learning and fiddling with ADO X databases ( not SQL Express / Other ) I have found a pretty good reference website. It would have saved me a lot of time earlier in my learning process on how to manipulate db's thru code. I was running around knowing what I wanted to do, but n...more >>

Can anyone help me connect to SQL??? I am new to all this... it is been a titanic struggle consuming hours & days & .... I am trying to create an SQL database programatically. But my code stalls before it gets started, and can't establish a connection to SQL. Here is my code: ===========...more >>

Ok I have been slowely - and ever so slowely teaching myself VB.net Currently I have created an MDB file by code, and added fields to the MDB file by code. I like this solution because, ( im assuming ) if I create an EXE and I load an MDB file, I can see if certain fields are there, and if ...more >>

Here's one that should probably have the sub-heading "I'm sure I asked this once before, but ...". Two users are both looking at the same data, from a database. One user changes the data and commits it. How does the other user get the updated view without polling for changes? Is there some ...more >>

Hi, I query the Customers table from Northwind database and I want to fill my combobox with CompanyNames. When the user chooses one item from combobox, I must get its CustomerID to query Orders table and display the orders of this customer in the grid. What's the easiest way to get the CustomerI...more >>

This is driving me mad. Can someone please put me out of my misery? I have a DataSet which I wish to use as the data source for a grid control (it is actually an Infragistics grid). When I assign to the DataSource property like this UltraGrid1.DataSource = MyDataSet I get the following ...more >>

Dear Group, I have a strange problem, I have created a little application that opens an instance of Excel from a webpage in a "test project". This worked without any problems, the instance of Excel appeared. I then move the .aspx and .vb pages for the webform to another project (added the appropr...more >>