Pages
Categories
Archive
Keywords
Calender
<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
Blogroll
    Recent posts
    Recent comments

    None

    Getting record Identity with sql and oledb

    mark ,27. November 2009, 07:00

    _Command As Data.OleDb.OleDbCommand
    _Command.CommandText = “SELECT @@IDENTITY”

    Tags:
    Category: Visual Basic.Net
    E-mail   |     |   Comments (0)   |   Trackback

    Assign datasource to ComboBox

    mark ,27. November 2009, 06:59 

    Public Sub AddDataSource(ByVal sourceTable As DataTable, _
    ByVal valueMemeberColumnName As String, _
    ByVal displayMemberColumnName As String)
     
    If (Not sourceTable Is Nothing) Then
        Me.DataSource = sourceTable
    If (sourceTable.Columns.Count > 1) Then
        Me.ValueMember = valueMemeberColumnName
        Me.DisplayMember = displayMemberColumnName
    End If
    End If
    Tags:
    Category: Visual Basic.Net
    E-mail   |     |   Comments (0)   |   Trackback

    Inserting Date into MS Access Using DBFactory

    mark ,27. November 2009, 06:58

    If you are trying to insert date and time into MS Access with DbFactory, you will need to change the parameter type to single and convert the DateTime you are entering to YourDateTime.ToOADate()

    Tags:
    Category: MS Access | Visual Basic.Net
    E-mail   |     |   Comments (0)   |   Trackback