Again I have problem with checking whether DataReader object has data or not?
Dim cmd as SqlCommand
Dim drd as SqlDataReader
cmd = New SqlCommand ("SELECT * FROM Stock", conx)
drd = cmd.ExecuteReader()
[Code]...
I have an SQL statement like:
SELECT FNAME, LNAME, CITY from EMPLOYEE
How do I create a multi-dimensional array from a datareader which should store values like:
John, Doe, LA
Mike, Johnson, PASADENA
Freddy, Kruger, Long Beach
I have a form in where I work with some data readers. One of my readers only gets the information from the first row. When ever I try to get something from the second row onwards I get an error saying that "no data found in row". I am using "ExecuteReader" not "ExecuteScalar". I cannot understand why I get this behaviour. Here is the The reader that gets me this error is reader2.
Dim reader As OleDbDataReader
Dim reader1 As OleDbDataReader
Dim sql5 As String
Dim SQL As String
sql5 = "SELECT * FROM Services WHERE ServiceID = " & Me.ServiceIDTextBox1.Text & ""
[Code].....
I am returning a date from my database table:
objSQLDataReader("date")
Which gives me:
31/05/2011 16:00:50
How do I change this to:
31 May 2011
I have Memberships and Bookings tables in database containing an attribute cust_id which is primary key in Memberships and reference key in Bookings. When i am executing data reader I want it to read cust_id values from membership table but it is reading it from the bookings table. Also when i compare two cust_id values, 1 taken from a textbox and the other taken from database column, even though both are same but the comparison result is false. I have compared using string.equals(str1, str2) and have also compared the two directly using if statement but in both cases even if the string is same but result is otherwise. [Code]
View 2 RepliesI am experiencing an error. I have a microsoft sql server database and need to colelct the data from the results and get the nullreference error shown below. I check the SQL string and executed it directly in the database and it yielded the correct results.
Quote: Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. I use this code for connecting and reading the DB:
[Code]...
i have a form with one combobox and textbox now on other hand i have a sql database
named balance with two column one as customername and and another as obbalance now i had binded all the customer name to the combobox now what i have to do is wen user selects a customer name from the combobox the textbox should show the obbalance of the selected customername here the customer name will not be repeated only one name with a customer
[Code]...
I am not sure how to phrase my question properly but I want to achieve something like this.
I have a class named Products public class Products
private ID as Integer
private Name as String
Public Property ProductID()
Get
Return ID
[Code]...
When I do the same, I am getting an error "Object Reference Not Set to an Instance of an Object.
i have a form with one combobox and textbox now on other hand i have a sql database named balance with two column one as customername and and another as obbalance now i had binded all the customer name to the combobox now what i have to do is wen user selects a customername from the combobox the textbox should show the obbalance of the selected?
View 1 RepliesI have a problem with my project. here is the problem:
My code for login is as follows:
dim conn as SqlConnection = New SqlConnection("Data Source.................)
dim cmd as SqlCommand = New SqlCommand("Loguser",conn)
cmd.CammandType = CommandType.StoredProcedure
[CODE]...
Now the error i get is that "there is a datareader associate with this connection that need to be closed"
I have multiple documents stored in Attachment data type in Access database. UsingDataReader, I need to read multiple attachments along with their file name and store them on the file system
View 1 RepliesMy application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data
my vb.net code is as follow:
Imports System.Data
Imports System.Data.SqlClient
Public Class XtraForm1
[CODE]............
I m also pasting the demo picture.
I am trying to retrieve the data from EXCEL 2003 spreadsheet from row 8 onwards because from Row 1 to Row 7 the row is merged columns from A1 to K1, A2 to K2, A3 to K3, A4 to K4, A5 to K5, A6 to K6, A7 to K7.
View 28 RepliesI have a program for school project that has input fields for Name, Address, City, State and Zip. I need to error check so that the fields are not empty.I have used If statements that check to see if the fields are empty and shows a message box if they are but if I leave the whole form empty and click the button that activates it, all the if statements go- one by one instead of pausing for the user to input the required data.How do I check for data and make the program stay there until the data is input? I have tried TRY/CATCH but it won't catch this type of error.
this is the
'This program computes customer's bills at the pizza shop for all combinations of
'crusts, toppings, sizes and discounts
Option Strict On
Public Class PizzaForm
[code].....
I tried this code to check if the data in textbox1 not equal to any data in column name, so insert the data that in the textboxes to the table1. Esle.. do another thing. But it didn't success with me.
Code:
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "DataBaseName.mdb "
[Code].....
i have publish data on data grid(in vb express 2010) and want to check for the data in each an every row. there are few columns and i want to check the string "OK" under "Status" column. if there is any "Not ok" found then need to prompt a message describing the details of whole row under.
View 4 Repliesi have a string (the letters will never be in the same order):
TFTADFDAAFDADADDAFFDTFFTDFTFTDTTAFDAFADTAAATFDTADAFFTFTDDFDAFFTAT
1) i know it is always going to 65 characters (no numbers)
2) it will only have the letters ADFT
i want to loop through each row of data and check if the data contains this.
System.Text.RegularExpressions.Regex.IsMatch()
i am working on a search feature for a program i am working on and i found a tutorial online that provides some insight but the actual code, after being modified to fit my aplication, does not work. i get two different errors as of right now, one that tells me "the value of type 'System.data.sqlclient.sqldatareader' cannot be converted to '1-dimensional array of system.data.sqlclient.sqldatareader" and the other that says"argument not specified for parameter 'array' of 'Public shared function... anyway i am kinda new to this and here is what i have so far. any advice?
Private Sub SearchOKButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SearchOKButton.Click
[Code]...
I have the following code which does what it's supposed to do:
objSQLCommand = New SqlCommand("select * from table1", objSQLConnection)
objSQLCommand.Connection.Open()
objSQLDataReader = objSQLCommand.ExecuteReader()
While objSQLDataReader.Read()
[Code]....
But I need to loop through the objSQLDataReader 1 more time. How would I do that?
I got the error message There is an open data reader associated with this command which needs to be closed first by using the following code:
myCommand = New SqlCommand("SELECT BookCode FROM tblBook",myConnection)
myReader = myCommand.ExceuteReader
While myReader.Read
[Code]...
how to check data if it is already in the database?
View 8 RepliesOn my form with my detailed layout of my database in textboxes i can change my data or add new record.
how can i verify if there was any changes to a record when the form is being closed or when my cancel button is pressed.
i want to create a message box that warns tha there hav been changes made should it be saved yes or no
i want to check the first record in the database and do updation. similarly i would like to check all the records one by one and do updation. iam using the sql database. In my vb.net applcn i have two tables "FATRAN " and "GLDetails".
[Code]...
This code works. i insert 3 string and then check if the database already save this code.if the first string does not exist it works well.but when 1 string "already exist" or found in the DB, all of the next string say its already in db even though it haven't. what should i do?
For count = 0 To strArr.Length - 1
If strArr(count).Contains("=") Then
str1 = strArr(count)
coun = str1.IndexOf("=")
str1 = str1.Substring(0, coun)
[Code]...
I have 2 checl boxes bol1 and bol2 and i stored a record after ticking one of them and now i want to make a function to retrive what i stored in the access data base in check boxs as well according to the ID. the table name is check_table and the columns names are "bol1 , bol2" the type is (yes,no).
View 3 RepliesI am copying sample.csv file's content into the new.csv file. But I need to add additional column in new.csv file which holds the default value as "Yes" for each row that exists in old file. Here is the code I have written.
Dim ioFile As New System.IO.StreamReader("C:sample.csv")
Dim ioLine As String
Dim ioLines As String[code].....
The first four columns ID,Name,Number,Amount are present in sample.csv.I am adding additional column Copied which should be "Yes" for each row.
If my Select statement finds data that matches the criteria, how do I get myReader (DataReader) to read each record when there are more then one record found?
Dim myReader As MySql.Data.MySqlClient.MySqlDataReader
myReader = myCommand.ExecuteReader()
If myReader.Read() Then
[code]....
I am trying to tag of some words.There are 5 tag word in my database. but only the first record is coming.i want to
my codes
Public Function tags(ByVal ID As Integer) As String
[code].....
my html code in gridview <%#tags(Container.DataItem("ID"))%>
Hey Friend i am using a form with a *combobox*in which the items i have taken from the
sqldatabase named as balance and that sqldatabase have two columns one is customername and the
another is obbalance now .
In the form i had binded all the customer names from the table and now i have a textbox i want to do is
when the user selects the combobox.selected item any one customer name i need to display the obbalance of the selected customer in tat textbox
[Code]...
two DataReader in one TreeView ?
