How to perform insert,update,delete and nevigation query based using Vb.net ?

Imports System.Data.OleDb
Public Class dbBuilder
    Dim objcon As New System.Data.OleDb.OleDbConnection

(WindowsApplication1.My.Settings.db2_2010ConnectionString)
    Dim objadp As OleDbDataAdapter
    Dim ds As Data.DataSet
    Dim rec As Integer
    Dim flgAdd As Boolean


    Pri...............


(0)
By Swapnalee   Patil  in VB.Net  on 3/3/2015 10:16:42 PM   Read more...


How to use data reader in vb.net?

Dim objcon As New OleDb.OleDbConnection(WindowsApplication1.My.Settings.db2_2010ConnectionString)
        objcon.Open()
        Dim cmd As New OleDb.OleDbCommand("select * from emp", objcon)
        Dim dr As OleDb.OleDbDataReader = cmd.ExecuteReader()
        While (dr.Read())
         ...............


(0)
By Karan   Pande  in VB.Net  on 3/4/2015 2:16:48 AM   Read more...


perform insert,update,delete using type dataset in gridview

 

 

Public Class ModifyGridview
    Dim emptable As New DataSet1.empDataTable
    Dim adp As New DataSet1TableAdapters.empTableAdapter
    Private Sub ModifyGridview_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)

Handles MyBase.Load
        DataGridView1.DataSource = emptable<...............


(1)
By Karan   Pande  in VB.Net  on 3/4/2015 2:22:57 AM   Read more...


Perform Insert,Update,Delete Using Command Builder

Imports System.Data.OleDb
Public Class DB_CommandBuilder
    Dim objcon As New System.Data.OleDb.OleDbConnection(WindowsApplication1.My.Settings.db2_2010ConnectionString)
    Dim objadp As OleDb.OleDbDataAdapter
    Dim ds As Data.DataSet
    Dim objCommandBuilder As OleDb.OleDbCo...............

(1)
By Firdosh Jahan   Memon  in VB.Net  on 3/24/2015 3:07:28 AM   Read more...


Perform Insert,Update,Delete Using Type Dataset

Public Class frmTypeDataset

    Dim dtableEmp As New DataSet1.empDataTable
    Dim adp As New DataSet1TableAdapters.empTableAdapter()

    Dim flgAdd As Boolean
    Dim rec As Int32
    Dim o_eno, o_salary As Int32
    Dim o_ename, o_skill, o_address As String

    Priva...............


(1)
By Firdosh Jahan   Memon  in VB.Net  on 3/4/2015 2:39:20 AM   Read more...


Constructor in VB.Net

public class cons

dim a,b as integer

        public sub new() ''default constructor

            a=0

            b=0

            msgbox("a=+a.tostring()+"and b="+b.tostring())

       end sub

   &nb...............


(0)
By Daniel   Gamit  in VB.Net  on 3/24/2015 1:23:13 AM   Read more...


Queue and Stack

i) Queue uses a First-In-First-Out(FIFO) Algorithm.

ii) Stack uses a Last-In-First-Out(LIFO) Algorithm.

Method Of Queue:

i)Enqueue (Add an item)

ii)Dequeue (Remove the fitst item)

Eg.

Module ModuleStack

       sub main()

              Dim s As New Stack

           ...............


(0)
By Kuldip   Gamit  in VB.Net  on 4/2/2015 6:02:14 AM   Read more...


 Explain  Structured Error handling?

.Net introduced structured error handling using the Try....catch....finally block.

          The Syntax is as

                ...............


(0)
By pooja   kanojiya  in VB.Net  on 7/17/2015 10:19:44 AM   Read more...


Datacolumn class properties

 

property                                                     Description

  • allowdbnull                   &nbs...............

(0)
By amish   gamit  in VB.Net  on 3/24/2015 1:26:43 AM   Read more...


HashTable

A HashTable is a collection of key-value pairs implemented using a hash table algorithm.

Namespace : System.collections

Implementing Interfaces : ICollection,IDictionary

Characteristics:

i) Search is very fast.

ii) HashTables are big and fast.

iii) High Memory Usage.

iv) Type of Access is using the hash of a key value.

 

Example.

Module ModuleHashtable

        ...............


(0)
By Hemdeep   Gamit  in VB.Net  on 3/24/2015 1:47:17 AM   Read more...


ArrayList

The Arraylist is a collection class that models a dynamic array.whose size increases as required when new objects are added

to the  array.

Namespace                     :   System collections

Implementing interfaces:   Icollection,Ilist,Icloneable,Iconvertible

      (0)
By prerit   gamit  in VB.Net  on 3/24/2015 11:27:46 PM   Read more...



Interface

 

Interfaces,like classes, define a set of properties,methods,and events. But unlike classes,interfaces do not provide

implementation. They are implemented by classes,and defined as seprate entoties from classes.

      (0)
By Anjali   vaghela  in VB.Net  on 3/24/2015 10:31:00 PM   Read more...



About Sorted list In VB.NET...

A sorted list is a collection class that  holds a set of key-values pairs.

Namespace:System.Collection

Implementing Interface:ICollection,IDicyionary

 

Characteristics:

  1. A sorted list may not contain duplicate keys.A hash table can have duplicate keys.<...............

(0)
By Karan   Pande  in VB.Net  on 4/1/2015 2:06:14 AM   Read more...


Shadowing

The main purpose of shadowing is to protect the definition of your class members.

The base class might undetgo a change that creates an element with the same name as one you have already defined.

If this happens,the shadows modifier forces references through your class to be resolved to the member you defined,


(0)
By Rinkal   chaudhari  in VB.Net  on 3/24/2015 1:49:34 AM   Read more...


INHERITANCE

The inherits statement is used to declare a new class,called a derived class,based on an existing class,

known as a base class. derived classes inherit,and can extend,the properties,methods,events,fields,and

constants defined in the base class.

Rules for inheritance:
<...............


(0)
By Ravina   gamit  in VB.Net  on 3/24/2015 10:34:36 PM   Read more...


Overriding Properties and Methods in Derived classes


By Defualt, a derived class inherits methods from its base class.If an inherited property

or method needs to behave differently in the derived class it can be overridden; that is,

you can define a new implementation of the method in the derived class.

Th...............


(0)
By hetal   more  in VB.Net  on 3/24/2015 10:49:15 PM   Read more...


The MyBase Keyword

You can use the MyBase keyword to call methods in base class

When overriding methods in a derived class. 

The following list describes on using MyBase:

  • MyBase refers to the immediate base class and its inherited members.

(0)
By hetal   more  in VB.Net  on 3/24/2015 11:39:23 PM   Read more...


The MyClass Keyword

 The MyClass keyword allows you to call an Overridable method implemented in

Your class and make sure that implementation  of the method in this class is called rather than

An overridden method in a derived class.

 <...............


(0)
By hetal   more  in VB.Net  on 3/25/2015 12:36:23 AM   Read more...


sqlcommand builder

 

 

-->sqlcommandbuilder is a standalone class.

  • it is derived from system.data.sqlclient.sqlcommandbuilder.
  • creating a commandbuilder object is pretty simply.you pass a data adapter as an argument of the commandbuilder constructor.forexample://create a command build...............

(0)
By urvashi   thakor  in VB.Net  on 5/4/2015 5:50:40 AM   Read more...