No Code Runs After ExecuteReader()?
Aug 3, 2011
I am using Microsoft visual basic 2010. I am using the following code to connect to a local access database. After the line myReader = cmd.ExecuteReader () no code runs. I am not receiving an error message.
Dim connectionString
As String =
"Provider=Microsoft.ACE.OLEDB.12.0;data source=C:UsersmikeDocumentsFCE_Database.mdb"
[code]....
I have used this method to connect to the same database multiple times in the same program without a problem I've also tried using OleDb with the same result.
View 20 Replies
ADVERTISEMENT
Jul 11, 2011
Can anyone tell me How do I solve this error.Error: NullReferenceException was Unhandled - "Object reference not set to an instance of an object."
Line: Dim reader As OleDbDataReader = dbCommand.ExecuteReader()
Database: MS Access
IDE: VB 2010 Express
[code].....
View 1 Replies
Jun 5, 2011
I've got a vb.net 2005 form that calls a stored proc to load a combobox with eligible sales reps. There are approximately 40k sales reps available...I know that's a lot, but that's what I'm dealing with. I'm trying to figure out why it's taking this form 15 seconds to load.
Here's my code:
Want to load this in the most efficient way possible given the HUGE amount of data that my client is wanting to see.
Can you help me? :confused:
View 1 Replies
Apr 21, 2011
Having recently installed IIS Express I was hoping that it was going to make life easier for me, but I've run into a problem almost straight away.Consider the following which is representative of some live code:
Public Shared Function GetServiceId() As String
Dim principal As MyCustomAuthentication.Principal.MyPrincipal
principal = CType(Thread.CurrentPrincipal, MyCustomAuthentication.Principal.MyPrincipal)
[code]....
Running the code under the ASP.NET Web Server (Cassini) everything is fine and I can see that Thread.CurrentPrincipal is of type MyCustomAuthentication.Principal.MyPrincipal.Running under IIS Express this same line throws an InvalidCastException and checking the type I find it is now of System.Security.Principal.GenericPrincipal which is confusing as nothing else has changed.I can confirm that MyCustomAuthentication.Principal.MyPrincipal implements IPrincipal and remember this is Live code, it is currently deployed and working.
View 1 Replies
Jun 15, 2011
i wrote a piece of code to write some data to a card reader, and read back from that device, filling a form with the data (after reformat).When I step through the code while debugging (using F5, F8 for stepping forward) the form is filled correctly.However, when I run the code (Ctrl-F5), the program seems to hang for about 5 sec and then throws an exception: 'Length should be >0' When looking further during debug - it seems that the program calls 2x the Sub Frm_Read_Display(). I
Imports System.Windows.Forms
Imports System
Imports System.IO.Ports
Imports System.Threading
[code]....
View 5 Replies
Mar 10, 2011
this code was just working! but for some reason it stopped to work now. when i run this project the following code is supposed to execute but it does
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim xmldoc As New System.Xml.XmlDocument()
[code]....
View 2 Replies
May 4, 2012
I once heard about a software that could dynamically run dotnet instructions (C#, if I remember well) on its command line, e.g when entering 1==1, the output would be true.I don't remember the name of this soft, and sometimes one just wants to know the result of a given instruction, without having to create a new program, compiling it and run it...
I would happily take the challenge to make a soft like this on my own later, but for now on I'd just like to find this soft.Does anyone know its name, or another app which would achieve the same result? (Don't tell me PowerShell, I'm searching for something more handy.
EDIT For those who use Visual Studio and who didn't know (I just learnt about it), you can also use the Immediate Window. It even allows you to get intellisense in some cases.
View 4 Replies
Mar 3, 2011
I'm creating some buttons in Word 2007 that I want to use in my company application to make our teams life easier. The application is a server application but when it loads it goes through our internet explorer.If I could reveal the source code then I could get the ElementbyID to hook up the button to the text field in the application.When the application loads I can quickly right click on view the source code and it is written in C#.This is one of the id's i was able to grab
id="upEnvironmentHidden" value="PRODUCTION"
How can I make it possible to view the source code of this application...also the internet explorer will dissapear and then the application is launched.
View 1 Replies
Mar 23, 2010
I've almost completed my first VB.Net app which is a rewrite of an old vba app I wrote.The last part that I need to write is the timed events part. What I have in VBA is quite straightforward.Every 500ms the Timer event runs through, it checks if certain variables have been flagged and if so runs the relevent code? Code is nothing major, just updates a networked device.I've looked into timers in .net but it seems like there are various routes that I can go down.
View 10 Replies
Sep 16, 2011
I'm running VB2008 on Windows 7; I've written out a ver simple piece of code:
Option
Explicit
On
Module
[code]....
When I run or debug the code, it asks for the First Number and then just completes the running of the program without asking for the second number and uses some random number. The console.readline() doesn't work either, the console window just disappears.
View 2 Replies
Oct 2, 2009
I was wondering if there is any way to make a sub run when another bit of code has run like doing a handles event bit.The reason I want to know is that I have made a custom message box and would like to effectively create a shortcut by whereby when the string CusMsg (my chosen variable for the message box message) appears in the code and runs, it makes form3 (custom message box form) open and label 1 on that form is the writing the of the message.
View 2 Replies
Mar 28, 2011
I have some vb.net code which should print out labels using Teklynx LabelView software (which I've had working before.)Problem is, it runs fine on Dev machine, but when I run it on the end user's PC, I don't get any error messages until it completely dies with the "Send error report to Microsoft" message.
How can I troubleshoot this???
[Code]...
View 5 Replies
Nov 7, 2010
Here is the code:
'Add images column to DataTable.
ds.Tables(0).Columns.Add("Image", GetType(BitmapImage))
'Create array of image paths.
Dim currentDir As String
[code]....
View 2 Replies
Jul 20, 2011
I have a problem and i can't find it, i'll explain on the codeThe first time it runs without errors but, the second time...lista is a ListView
Dim l As New List(Of String)
Sub LoadData(ByVal user As String)
lista.Enabled = False
[code].....
View 3 Replies
May 31, 2011
How to use the ExecuteReader calling a stored procedure with a parameter array?
View 1 Replies
Apr 19, 2010
I am getting an ArgumentOutOfRangeException when I try to run the following code,[code]the table that is being read has a single row of data, the database and connection are fine as I can run INSERT/UPDATES etc but wherever I have used a datareader I am getting this exception each time on the "Using reader As MySqlDataReader" line.
View 2 Replies
Jun 2, 2011
I am executing stored procedure using ExcuteReader() command. If I execute Stored Procedure in SQL server it is taking 2 secs. But in code taking around 2 mins. I tried DataAdapter.Fill(). Still the same.
What is wrong in the code?
spString = "usp_graph"
sqlcmd_q.Connection = sqlCnn
sqlcmd_q.CommandText = spString
[Code]....
View 1 Replies
Feb 12, 2012
Dear friends I am new in .net world and I am trying to display a single row to a literal. I prefer VB so my code is as follows but I'm getting the error "ExecuteReader: CommandText property has not been initialized".I also tried sqlCmd.CommandText = "getLastModificationDateTime" without the EXEC statement
View 3 Replies
Jun 4, 2009
Public Class app_mainform
Dim mssqluname As String
Dim mssqlpword As String
[code].....
View 16 Replies
Jul 5, 2011
i have this code in form1 at buttonpreview
[Code]...
View 2 Replies
Jun 6, 2011
i have problem with my code
here is my code
Public Sub increment()
Dim dr As SqlDataReader
If con.State = ConnectionState.Closed Then
[code].....
View 7 Replies
Jun 30, 2011
Public
Class Form1
Dim conn
[code].....
View 2 Replies
Aug 4, 2009
i have app that connects to a mysql db.i get data from the db with executereader.but i want to execute some sql depending on the result from a other db.but i get a error when doing ExecuteNonQuery() when the reader is still open.Here's a part of my code where the problem occures.
Code:
tracecom.CommandText = "select * from testsms left join customer on customer.id=testsms.id where date_sub(now(),interval 1 minute) > testsend"
tracerd = tracecom.ExecuteReader()
If tracerd.HasRows Then
[code]....
View 4 Replies
Mar 23, 2010
I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file
[Code]...
View 4 Replies
Jun 20, 2012
I am using below mentioned Ado.net function and resultset bind with grid view, however I am getting the duplicate rows in the resultset.
[Code]...
View 2 Replies
May 20, 2010
I have a program using the OleDbCommand to read an indexed Access database. [code]I notice that when step debugging the program, the file is not being read in correct order.Example: it will read the record with "B" in the D01 field before a record with "A" in the same field.The record with "B" is the second record in the database.I do note that all records in the database are read before exiting the loop, just not in any apparent order.
View 5 Replies
Mar 24, 2010
could someone help me with some simple coding methodology for doing database searches within the ExecuteReader function that will return results regardless of case?For example, if the variable to search for within the database is John Smith,I would want the search to be successful if john smith is the user-provided variable.
View 8 Replies
Dec 17, 2010
I have a stored procedure that repeats a block of T-SQL statements using WHILE logic until it finds a matching record in a table. When I execute the procedure directly from the SQL Management Studio, it works and returns a record, even when the statements within the WHILE logic have to be repeated over and over again before a matching record is found.
However, when I use the same stored procedure as the commandtext property of an sqlcommand object in Visual Studion 2008 (VB) and call the executereader method of the sqlcommand, the resulting SqlDataReader will only return a row if the T-SQL statements within the WHILE logic find a matching record after a single pass. If it takes more than one pass to find a matching record the SqlDataReader does not return a row. It's like it abandons the execution of the stored procedure after the first pass of the statements within the While logic, disregarding the repetition.
View 1 Replies
Dec 19, 2011
my problem is first of all i created a button and a datagrid to display the mydb.mdb in it the code behind that is as follows when i click on button the students table from mydb.mdb (which resides in my pc) needs to display in datagrid
<code>
using System;
using System.Collections.Generic;
using System.ComponentModel;
[code]....
the error is at Line: dbReader = cmd.ExecuteReader();an the error is :ExecuteReader: Connection property has not been initialized.
View 2 Replies
May 23, 2010
is it possible to skip forward or backup to the previous record in a database within a Do Loop of an ExecuteReader routine? For example, with the following code:
DMDatabase01.Open()
DMCommand01 = New OleDbCommand("Select * From DB01Table01 Order By DB01F01, DB01F02", DMDatabase01)
DMReader01 = DMCommand01.ExecuteReader()
Do While DMReader01.Read = True
[Code]...
I have the need as part of a larger data comparison program to not always read the next sequential record - at some points I want to go back to the previous record, or skip forward to the next record, but stay within the Do Loop.
View 6 Replies