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 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."
how to add, insert, delete and search data in vb 2008 using mysql databases.
View 1 RepliesMy question is How can i create insert,update,delete query by using class file and store procedure. This query is use for 3 tier.
View 2 RepliesI got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
i am a beginner level member of vs2008i had create a interface. In Daily Transec.vb form i cant insert, edit, delete, go prev and net data. already i had created a localdatabase as "Expense"need you help to complete itso this is request to u that plz chk the link file and complete the DailyTran.vb form. nothing else
View 2 RepliesI have the following code to create an array of serial ports.
[Code]...
I am using this code to Add rows to a SQL database, and it adds the row to the SQL database if column 7 is not null. After it adds the row to the SQL database, it deletes it from the Access Dataset, and updates the Access Database. Sometimes double rows seem to get inserted into the database, so I'm thinking there is an error in my logic somewhere here.
Dim rowcount As Integer = AccessDataSet.AccessTbl.Rows.Count
Dim y As Integer = 0
For x = 0 To rowcount - 1
txtRow = AccessDataSet.AccessTbl(y)
If IsDBNull(txtRow(7)) = False Then
[Code] .....
I need a way to delete the last element in an array when I don't know how big the array is.Basically I need the VB version of php array_pop, but nothing relevant seems to be appearing in search results.
View 2 RepliesI am trying to create a property of type string array (if this is possible).....and I seem to be lost.
I tried the following, but it says "String cannot be converted to '1-dimensional array of string'" at the return
Private _strZipList As String()
Public Property strZipList(ByVal i As Integer) As String()
Get
[Code].....
i can connect to only one Data Base with dataset in Visual Basic . but i want Have Dynamic connection to data base i mean in want to my appliction users have ablity to connect to any data base they want (For Example : Choose file from menu and then open and then Select any Data base.)
View 4 RepliesI want to create a class is it where I can do...
[code]...
How do I do this? Do i create a class and create a instance of CarData? but how do I add Color and Year etc to it?
I've been programming in VB.net for a while off and on, but never really had a need to use custom classes till now.I built a function in a module to populate a class, The class how ever is supposed to refer to one instance.I need to create an array of this class but the amount of instances needed is not always known.Works fine till the class goes to populate the class array.[code]It's probably something simple, I've just starred at it to long. Keep gettitng "Object reference not set to an instance of an object."
View 1 RepliesI have a class inside a class.I need to expose the properties of the 2nd class to other classes, therefore it is public.However, I do not wish other classes to be able to create instances of this 2nd class, it should only be instantitated from its parent class.I thought I could resolve this issue by making the constructor of the 2nd class private, but this even prevents the parent class from instantiating its child class! How can I work around this, do I have to make the constructor public and allow anybody to create an instance of the class?
View 3 RepliesI have been writing same code for insert, update, delete with LINQ over and over again. I want to have some sort of generic function for Insert, Update, Delete operation. I read a post here like the following :
public static void Insert<T>(T entity) where T : class
{
using (OrcasDB database = new OrcasDB())
[code].....
I have a small problem, classes and threading with classes. The problem I have is a dynamic array variable defined in class. In the code below, when error pauses the code, I can see the data in the correct form but I can't write rigth code that writes the data to richtextbox.
Public Class Form1
Public k() As Integer
Private Class zaratma
[CODE]....
i am working on the MSDN tutorials through virtual labs and am encountering a problem with the very first tutorial regarding consoles. I am required to create two notepad files: Module HelloWorld & Public Class Person which I have done without errors having triple checked them. When the files are created I compile the HelloWorld.vb file and a .exe is created
I follow the rest of the steps and encounter an error when i try to compile the Person.vb file using the line vbc Person.vb/t:library/out:HelloWorldLib.dll as i am getting the following errors:
vbc : Command line error BC2001 : file 'HelloWorld.vb/t:library/out:HelloWorldLib.dll' could not be found
vbc : Command line error BC2008 : no input sources specified
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 do I set up create Insert, Update and Delete commands for your a DataAdapter?I'm using a DataGridView to allow the user to view, change and delete data rows and would like to be able to save any changes made in the grid back to the database.The application is part of one I'm developing for our local school to write reports to report cards for the children.[code]
View 7 RepliesDoes this create a dynamic byte array?
Code:
Private m_renderedReport As Byte()()
Or this actually creates a structure?
Crystal Reports not showing after dynamic data insert.
View 4 RepliesI need some expert help in achieving this task. I have an xml file which will be emailed to me everyday. I need to loop through the xml and create tables in a database based on the xml nodes and their attributes. looking at the following xml fragment for example: Code:
So based on the above xml, I would have to create a Shipment table as a Parent with fields like ShipmentIdentifier. Then I would have to create an Event table with the ShipmentID as a foreign key and fields like Source, Code. Basically a field for each node. Then if there are columns in the table that are new, I would have to modify the table and add the column. I only have to create tables where there are child nodes or where the nodes have attributes.
I'm trying to create an array of checkboxes dynamically and also want to put event to those checkboxes. For example: I have a array of checkboxes - Chk1, Chk2. I want it to work this way: When I check Chk1, I want to disable Chk2, and when Chk1 is unchecked, Chk2 is enable, and vice versa.
[Code]....
i have problem on how to insert the data into the oracle database 10g using visual basic 2008
My coding is like at below:Dim cmd211 As OleDbCommand
cmd211 = New OleDbCommand("INSERT INTO STUDENT_DETAIL(STUD_ID,STUD_NAME) VALUES(@STUD_ID,@STUD_NAME)", con)
.Add("@STUD_ID", OleDbType.VarChar).Value = txt_studId.Text
i have a problem with the size of array i want to make a 2-Dimensional array with large size such as
[Code]....
I can access a module from code behind but not from the aspx page in inline VB code <% ... %>.
View 2 RepliesI'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].....
I am trying to Insert/Delete records in a MSSQL database based on if a checkbox is checked or unchecked. The checkbox is an item template in a datagrid, I can check/uncheck the checkbox but it doesn't do an insert or delete. Here is my code:
[Code].....
But then I get the error that the control chkmap has not been declared. I am confused as to how this needs to be declared, do I set a variable to the FindControl("chkmap") and then set it as variable.checked = true ?
Updates were easy but we don't know how to do the inserts and deletes even though we already have the DataAdapter .InsertCommand and .DeleteCommand defined and initialised.Currently the app allows the user to navigate through the Textboxes that are bound to the DataSource and the user can just change whatever is in the Textboxes before calling .Update
View 6 RepliesImports System
Imports System.Threading
Imports System.ComponentModel[code]....
how to declare "smsport" on class smscomms as public so that it can be access in class form1 or button1_click event.
