When i run the program, i get error on the statement inside Do While Loop. The piece of code from my application is:
Dim selectString As String
selectString = "Select ContactName, Address from Customers"
Dim cmd As OleDbCommand = New OleDbCommand(selectString, con)[code].....
Object reference not set to an instance of an object
I am building an app to read a customers .xls file in to a array list the array is the being reordered and im writing a file out the back end.its doing several lookups in the .xls file to see if relivant data is there and it writes a different file (9 different specs) depending what is in each line/column.Sound simple and I have the app working great however when I use a customers live data I get an ex.message = "Could not decrypt file" the file opens in excel witthout any password prompts however it does look like the sheet is write protected but all im doing in my app is reading the data.
Using fileConn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & OpenFileDialog1.FileName & "; Extended Properties='Excel 12.0 Xml; HDR=yes; IMEX=1'")
fileConn.Open()
[code]....
i need to read a sql table and insert all the records into another sql table in the same schema. It sounds dead simple but I've spent weeks trying different methods with no success.I'm using a datareader on the source table and a dataset on the target table. The program errors on the second iteration of the loop saying "@FunderAgreementNo" has already been declared. This is because I have the Parameter mappings contained in the loop (I think). I've tried moving this code elsewhere but then get different errors.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'
' Declare local variables and objects
[code]....
what is the difference between OledbDataReader and OledbDataAdapter?
View 5 RepliesWith ms access as the database storage software. And if you know of other ways on how to read data base on a certain criteria and displaying the results that meets the criteria.
View 1 RepliesI'm getting an "index out of bounds" exception and I can't figure out why. Unfortunately, my VS 2010 is in Spanish, so I can't say what the exact message says, but it's a System.IndexOutOfRangeException.
This is a table with a column holding Double values and a column with Date values. I have a form with two DateTimePicker controls, so the user can set a date range and they should see a number showing the total amount calculated between those two dates.
I did something like this:
Private Sub getData(ByRef total As Double)
Dim connection As OleDbConnection
connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
[Code]......
What is the difference between OleDbDataReader & OleDbDataAdapter? What are there main functions? And what is OleDbCommand and what is the function of it?
View 1 RepliesI try to compile a project with msbuild.exe I have this error :
vbc : error BC30136: Error creating Win32 resources: Error reading icon '"Recycle Bin Empty.ico"' -- The filename, directory name, or volume label syntax is incorrect.
This icon is the Application icon which is in the same directory of the project.vbc is started with /win32icon:"Recycle Bin Empty.ico" parameter.Don't know why MSBuild can't reach the file.
I am using the OleDbDataReader routine to examine and manipulate Access databases.I am trying to find a procedure for indicating when the end of file is reached.I am getting an error message once the end of file is reached and another record is attempted to be read.The.HasRows modifier does not work; that merely determines if the source database contains rows, not if there are any rows remaining.
View 2 RepliesAfter connecting to a database using DataReader, how can I count the number of rows ?
View 2 RepliesI am creating an application which uses OleDb to connect to an Excel spreadsheet and read the data into DataTable. The problem that I am having is that some of the columns I am getting are coming up blank, I've managed to narrow down that this is because that the first few lines for that column are blank. As unfortunately this is valid in the context of the Excel spreadsheet as not all dates etc. are required to be filled in. I was wondering whether anyone knows of any way that I could go about ensuring that the columns are populated by the OleDbDataReader even if the first x number of rows have that column as blank.
View 2 RepliesI have two tables say "Table1" and "Table2". I made a UNION query and saved it as "AllTimesFailure". It is worth mentioning, I am using Access DB. When I am trying to fetch the records from AllTimesFailure through oledbDataReader, it says "The Microsoft Jet database engine cannot find the input table or query 'AllTimesFailure'. Make sure it exists and that its name is spelled correctly.". I double checked query name and found correct but the problem still exists. when I run the same query as I pass through my command object, it works fine in Access query analyzer and fetches records normally.
[Code]...
I'm new to VB.NET. I'm trying very hard to not go screaming back to VB6...... I have a Query stored in an Access2000 database called 'build_VNMON'. (Does that make it a Stored Procedure ?) It uses multiple tables and multiple Union Statements to arrive at the desired results. It may not need to be as convoluted as it is, but I inherited it, and it works. What I really need is to output one column of the build_VNMON result to a text file, so I'm trying to use an OleDbDataReader.
[Code]...
I got an error when I tried to save a deleted record in a table which I use to store username and password.
I can delete with no problems but the error message popped up when I clicked on the update icon
My login code is like this
Imports System.Data.SqlClient
Public Class Form1
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As
[Code]....
I am getting the error "system.argumentException; Column ' test_id2' does not belong to table Table. At System.Data.GetDataColumn( string columnname0 at system.data.datarow.get_item(string columnName).
This error is occuring right after I set the parametervalues in the report object of the Crystal report.(Note this a visual basic.net 2005 windows form application.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cryRpt As New ReportDocument
Dim sql As String
[code]....
The value for the first parameter @Parm_1d1 value to the crystal report version 11 is correct. However, when trying to access the second @Parm_1d2 parameter ,the values past to the crystal report is not correct.
How to read per row in a table in mySQL as the database? i want each username when they login, they will go to their respective forms. Like for example, there are 3 users and each user have their different forms.h this.This is my code:
Dim conn As MySqlConnection
Dim myCommand As New MySqlCommand
Dim dr As MySqlDataReader
[code].....
I am reading a Sql table into a dataGridView. The SQL Table contains many nulls and my select query is not returning them. I would like to include them with a wildcard search.
[Code]...
I have mysql connection for user to login, but I need to read some more information about the user, when he is actually logged in...
Code that I'm using for login:
Code:
rivate Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[code].....
I am trying to read records from a table base on unique values read from another table and want to write these records depending on value from a For Loop into different tables. This is code is what i have so far and it only read the last value of the loop and does not even write it to the appropriate table. [Code]
View 2 RepliesHow to use Select Case in reading rows in a table in mySQL? by not using the username of the user.
View 1 RepliesReading binary file from hard drive in VB and writing to database.
View 3 RepliesI have login system and also I know how to get 1 exact row from mysql but how can I create a table which will be filled with values from mysql table?
[Code]...
I have some data that is contained in HTML tables within a webpage. I need the simplest means of extracting the data for storeage in SQL tables. I am knowledgeable of how to add the data to SQL tables...this portion of the code is already written. I would like to pull the data into the VB.NET 2008 environment using the XML DOM or a more efficient option.
View 1 RepliesI have a problem while reading xml file in vb.net i.e. giving error message "Data at the root level is invalid. Line 860, position 18." My xml file with error while reading is as follows.
[Code]...
I'm making a program that needs to read .txt files and I keep getting this error message when it tries to open a .txt[code]...
View 4 RepliesThere are already multiple threads about this, but i don't have the knowledge about the different SQL databases/methods to make heads or tales from it.I am using an OleDbDataCommand, an OleDbDataReader and the following code
Dim Query2 As OleDb.OleDbCommand
Dim RetVal2 As OleDb.OleDbDataReader
Query2 = New OleDb.OleDbCommand("Select [section], [title], [id] From " & DtSections & " Where [volume] = " & volu & " And [chapter] = " & chapter & "", AccessConn)
[code]....
value)In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. Type) Object?
i am importing data from Excel workbook having around 30 sheets in each book. Application works fine but after uploading few books it gives error continuously Exception from HRESULT: 0x800AC472 i used thread.sleep(1000) for each workbook into folder remove that? if these due to hyperlinks in some sheet, is any way to disable hyperlinks through code in vb.net
View 1 RepliesIn my project i read text file line by line by checking with a specific word and store that line into textboxes.
My code id
Dim fName As String = " Z:\rdf1.txt" 'path to text file
Dim testTxt As New StreamReader(fName)
Dim allRead As String = testTxt.ReadToEnd() 'Reads the whole text file to the end
[Code].....
I have some troubles reading an image from a networkstream.Every time the when program runs this procedure its shuts down without a warning.[code]...
View 11 RepliesI'm in the process of creating a tile based game. This game requires a method to load a text file and write the numbers between the delimiter "-", to a multidimensional array. However, an error message "object not set to an instance occurs. [code]...
View 4 Replies