I would like to retrieve a single column of about 800 rows in a table and save these values in an array so as to reference them later on. How can I do it? I tried:
[code]...
And it didn't work. The col1 is of type Int64 and so is the array prev_ob(). Please let me know how I can save it to an array.
Got an array, why cant I save dataread info to array pos?
While myDataReader.Read()
' txtPhone.Text =
Tempstr(i) = myDataReader.Item("Phone").ToString + vbCrLf[code].....
apparently Object reference not set to an instance of an object.
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
how you would go about saving information(username, password, security questions) in a notepad, so it can be retrieved after a program closes. i'm making a log in program in my class, but we haven't done this, so when the program closes, everything is gone. rather annoying, to have to make a accounts each time i'm testing it.
View 6 Repliesis that instead of receiving data from one row and assigning it to the same array Im receiving data from multiple rows, but the information is the same because its from the same one column from the database. The error I keep getting is 'index out of bounds of array'
here is the code
What it does is it loops through once and retrieves the first value from the db then it throw the exception when it goes to retrieve the second value.
Dim qBkNum As String = "SELECT BookingNum FROM Bookings WHERE BookingID = '1'"
Dim bkNum(5) As String
Try
[Code].....
I want to load all of the LOCATIONS in the Location table to a Combobox and then for any found locations (in another table) to be deleted from that combobox. Im using a Array list, but can't get the Data reader to write to the Array list.
Dim SQL As String = ""
Dim Reader As OleDbDataReader
Dim i As Integer = 0
Dim LocationArray As ArrayList = Nothing
[Code]...
How do I load data from a datatable into an array.
Dim
dtDataTable As New System.Data.DataTable
dtDataTable = dsStaffHoursWorked.vwGroupProjHoursDate
Dim DRs = dtDataTable.Select("enddate = '05/14/05'")
How can I fill this Percentage array with Sql data reader..
Dim StudentID As Integer = Me.ComboBox1.SelectedValue
Dim Percentage() As Integer
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Database
[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 am using a datareader to pull data from my database. I store the data in a multidimensional array in a seperate class file. I access the values in the array from a form through properties.The problem I am having is when I run the project as I step through the code I can see the values being added to the array but when access it from a string property it shows up as string System.String[,]. I would like to have my array transposed accross the listview under the corresponding column. below is the code I am using.
[Code]...
I 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 a 2d array of data that I have performed the sum of the individual column of the 2d array. I want to send the results to a datagridview and also will like to have the result as a 1d or 2d array.
Below is sample of my code
Dim Array1(,) as double
Array1(0, 0) = 5
Array1(0, 1) = 7
[code].....
Can I save an array into my .bin file then read the array again just like a string or Integer??
View 2 RepliesI want to compare two array and save the miss match character into 3rd array.
View 1 Repliesso im trying to do this project, and it gives me a a data file, and asks me to use stream reader to put it in the combobox, and when i click the selected items from the combo box, it fills in the textbox's with other information i retrieved from the datafile...Does anybody know the solution?? heres what i have so far(option strict must be on) Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
this gets all the Item names from the data file to appear on the combobox... now if i knew how to get the other information to appear in the textbox's when i clicked on it,
I have this list (Just a typical .net list) and I am adding a bunch of UI Items into it, the list is then taken for a Sub which goes through it with .getenumarator and While loop. Now the question is how are my items retrieved from this list?
View 2 RepliesI tried the following code which doesn't throw an error but it doesn't show as well in textboxes:
Try
cnobj = con.cn
cmd.Connection = cnobj
[code].....
I'm trying to check if a bit retrieved from database is true or false but i have always the error IndexOutOfRangeException no matter how i get the value.
[Code]...
I would like to read values set in a string that's retrieved from the Web, I've already got the string in a string called Webdata.The string is like so...
"Info" {
"Name" {
"Name1""Value1"
[code]....
I need to set Value1, Value2, Value3 as strings that I can use.
I retrieved data from access in vb10 between two dates and here is the code for dat:
Imports System.Data.OleDb
Public Class Form4
Dim con As OleDbConnection
[code].....
I have a database in my app which loads and displays some information on a form by binding the Comboboxes and Textboxes. However, I need to get some of the other values from the database for calculations before they are displayed on the form and I can't seem to find out how to do this.I could bind a couple of Textboxes to the database and then use those values to calculate, but it doesn't seem like a very efficient way of doing things.The dataset is created using the wizard and the controls are linked in the UI.
Please bear with me, I'm still a noob.
I am retrieving Images in a Picture Box at runtime using the following code.
Public Class Form1
Dim myDir As String = "C:Users rujadeDesktop" '-- my folder for images
Dim x, y As Single ' the coordinates of the 'next' image to add
Dim pic As Image
[code]....
I wanted to add more functionality to allow user to increase the size of images that have been retrieved in the Picture Box. How to do so?
In VB.Net how does one call a Parameterised function name retrieved from a table?
My Parameterised Function Name is below
procTextToDBTemp(Application.StartupPath & "" & strFileName)
from above function i Stored procTextToDBTemp into the SQL Table How can call that function in the Vb.net How can i do that?
I'm using VS 2010 and MySQL 5.5. I've got a data grid view displaying the results of queries entered by the user, shown below. It works; the trouble is that if there's an image in the results, you'll only see a cell-sized very long thin strip of it.
So I want to a) resize any images to a reasonable thumbnail height (say, 100 pixels, naturally maintaining aspect ratio) when displaying them, and b) resize the row to fit them.[code]...
I'm trying to find a way to have the DataContext available from within Entities.
I want to do something like this:
partial public class MyEntity
public DataContext as MyDataContext
private sub OnLoaded()
[Code]....
I've Created a Table in my Database "T_OPTIONS"
my table looks like this.[code]...
I am trying to select multiples rows from a database table and insert the text into several "label" controls. For example, if the database search returns 5 results. then insert the first row's text into label 1, the second row's text into label 2, and so on. The number of rows will be variable. I was thinking of a while statement. I am having a problem understanding how to even seperate multiple rows from a query in VB. Would using an array for the query results be the right way to go? row one would be row(0), row two's text would be row(1), etc.
View 6 Repliesi have this code which i am using to retrieve image stored in image data type from sql database into a picture box.This code works well but i have just realize something which will not help me if left unattended.When ever i retrieve an image it write some file with a numeric name into my bin folder.I do not know how and the importance of that file written there. Even though it work perfectly for me.It means that if i am to retreive about 500 photograph within an hour, then i will get chunck of these file in my bin folder with will affect me because it take some space.please help me fix this problem
This is the code
Dim barrImg() As Byte
Dim cmdSelect As New SqlCommand("select Photograph from Personal where MyID=@ID", connect)
[Code].....
I have a datatable which has 5 column. It is possible to copy only its 2 column in and save it into new datatable.I used this code but it copies all the 5 column
Code:
Dim qry As DataTable = (From obj In temptable Where obj.Item("Column1") = 0 _
Select obj).CopyToDataTable
i used this one but it is not supported
Code:
Dim qry As DataTable = (From obj In temptable Where obj.Item("Column1") = 0 _
Select obj.item("Column1"), obj.item("Column2")).CopyToDataTable
Recently I retrieved code of my project EXE file. And it was almost same with 100s of errors. So my question is Is career in .NET is safe? And is our code safe? Can this be done with other languages?
View 3 Replies