I declared made an array of my class like this
Dim
myClass(3) As Class1
Now when I try to enter data like this:
myClass(0).s = ("Test")
I get an error "Object reference not set to an instance of an object."
I am new in this forum, also new in VB.Net I need to create a public class for insert and delete data to database Public Class My_DBFunctions
[Code]...
I want to reading in a excel file and extract the sCodenumber sDescription ans the sStatus and store them in a array : StatusComposeArray(5200) As MyCompose. After this I need this array for comparing outside this class. But as can you see the array is defined inside the sub: ReadingIn_ExcelFilesCompose [Code]
View 2 RepliesI'm designing a small GUI Windows program that allow staff at a cinema to reserve seats for customers. There will be a total of 60 seats in the cinema. I have two classes in my program:-
1.) MainForm.vb - used for I/O actions and user interaction
2.) SeatManager.vb - used to hold and handle the background methods and functions that make the program work
Here is the code for my MainForm.vb class thusfar:-
Public Class MainForm
Private Const m_totalNumberOfSeats As Integer = 60
Private m_seatManager As SeatManager
[Code]....
Basically, when the program opens, the lstReservations list in the MainForm class will be populated with a total of 60 (m_totalNumberOfSeats) entries to represent 60 seats. Each of these seats will contain the index number from the array m_nameList; this index number (+1) will represent the seat number and then in the lstReservations list, after the seat number, I'd like it to contain the respective entry from the m_nameList array. As all entries will be held in RAM, when the GUI is opened, all m_nameList array entries will be empty. As the user uses the program, they can highlight a row in the lstReservations list and then use the GUI textboxes to enter the customer's name which will then be populated into the respective array entry.
how to, when the GUI opens, ensure that the lstReservations list takes all of the blank entries from the m_nameList array and from there, I can highlight a row to carry out further methods on?
I am trying to create an list or an array of a class.Here is my "Ingredient" class that I am trying to create a list of:[code]In my "recipe" class, I am want to create a list (or array) and I am drawing a big blank on how to do it. Can anyone point me in the right direction?
View 2 RepliesHow can i declare a public array of class instances, in Visual Basic 2008 express?
View 7 RepliesI have an array of pictureboxes in my form and i want to use the picture boxes in a class. I know you have to use a constructor for this but i'm not sure how to code it exactly. I have tried many things but it just does'nt want to work..here is the code of my array in the form and the constructor
Dim Deler As dealer Protected cardPlace_array() As PictureBox = {picDKaart1, picDKaart2, picDKaart3, picDKaart4, picDKaart5, picDKaart6, picDKaart7, _ picUKaart1, picUKaart2, picUKaart3, picUKaart4, picUKaart5, picDKaart6, picUKaart7}
[Code]...
My problem is when i insert new row from vb.net 2008 to table build by sql the process already done but i can't see new row in the table, this is my code
CODE:
First Steps I have a code to generate A I have another line of code that will generate another code from A (called B)
2nd Step I want in a table two columns, one for A one for B
I want the data A and B to be inserted in the database after the First Steps is done. Ex. line #1 of the table, B shud be the generated code for A.
I'm able to do the first step, but i don't know how i shud insert the data to the database?
how to insert data in XML using ado.net command object?
View 1 Replieshow to insert values from textboxs to access table. I am using jet.oledb connection and dataadapter & dataset for data manipulation.
here is the code that i used to insert values into access,but it is not working..
[Code]....
I have created a users database in access and included that database in the bin directory of my project. I have then created a connection to that database using the wizard in 2k8 express.What i need to be able to do is to insert usernames into the users table in the database. I am at a loss of where to start with this problem. Do i need to create a recordset or not? If so how do i write an sql query in VB2K8 to insert data into that recordset and then update the underlying database?
View 1 RepliesI have a problem regarding inserting many data into ms access.
View 2 Repliesfew fields are not text because I am getting an error - data type mismatch in creteria expression. I am using VB.net 2008 and Microsoft Access 2007. these are the columns I am not sure how to handle:
[Code]...
I can't seem to add data in my DatagridView by having set the Columns, this what my datagridView looks like:he combobox you see where filled by this
ReaderQuery("Select ChargType from ChargeType")
cmbCharge.Items.Clear()
While dr.Read
[code].....
my table is:
CREATE TABLE [dbo].[VarianceReport](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FN] [nvarchar](50) NOT NULL,
[Fdate] [nvarchar](50) NOT NULL,
[code]....
But inserted null value when all textbox is temp!?!How to resolve this problem and best way for this action?
INSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])
[code]....
In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008?
I'm quite new into the programming game, I've been working on this program for a few weeks now, and its coming along, but the method I searched for entering new rows of data into my table doesn't seem to update my tables after I try entering data. I have a feeling it may be something very simple that i am over looking.
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Handles Button4.Click
Dim conn As New SqlConnection("my datasource")
[code].....
how to add, insert, delete and search data in vb 2008 using mysql databases.
View 1 RepliesA c# class's single dimension byte array contains socket level instrument sensor data as per:
public static byte[] frameData
It's been a LONG time since I messed with VB, and I'm messing around with VB 2008 now.I'm trying to make a custom class with three variables,
ID (String)
Title (String)
Comments (Array of String)
[code]......
What is the difference between using the 'array' class in VB and just declaring an array like normal. In other words, what is the difference between:
Dim numOfTicketsPerDay As Array
Dim intNumOfTicketsPerDay(6)
As Integer
Is there any preference of when one should be used over another?
If I make the following array in a push button event and I want to put those array variables in a class array. How do I do that? I am just beginning to learn about classes in vb.net but I am having problems using classes and arrays.Is there any good tutorials on that subject.
[Code]...
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
I'm designing a small GUI Windows program that allow staff at a cinema to reserve seats for customers. There will be a total of 60 seats in the cinema. I have two classes in my program:-
1.) MainForm.vb - used for I/O actions and user interaction
2.) SeatManager.vb - used to hold and handle the background methods and functions that make the program work Here is the code for my MainForm.vb class thusfar:-
[Code]...
I have main class of Races with mulitple properties. One of those properties has been defined as another class Runners.
So I have a race with multiple runners and when I try to update the data i get an instantiation error.
For the life of me I can't get it to work.
This is what I am trying to do...
In the clsRace class I have defined :
PublicProperty clsRunner(ByVal index AsLong) As clsRunner
Get
[Code].....
I am New to <acronym title="Visual Basic">Vb</acronym>.Net. this is my first test. i try to create small address book. but i don't know what wrong. it compile perfect but when it run it give error and not work. is there any other way to add same class like in class inside array?
[Code]...
I've got a main form (Form1.vb) where I created some controls (with the Designer).I've created a class myTextBox, inheriting from TextBox, in myTextBox.vb.In the main form, I call procedures from myTextBox. The issue is, those procedures use values from the Form controls. So the class doesn't recognise them as initialised.What's the best solution for this?I think I could pass the object itself as a parameter but doing it on each call seems a bitredundant and it thickens the code.Is there any way to access the Form1 controls and objects directly from the myTextBox.vb class?
View 6 RepliesI have a class that I want to handle it's own events but still have the instance inherit it.for instance I want the event to display in a text box but from class level.[code]
View 12 Replies