Tools/WinSN5.0Ver.iso/PVb5.0/VB/TEMPLATE/FORMS/DATAGRID.FRM

Visual Basic Form | 1997-02-17 | 6.9 KB | 229 lines

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form frmDataGrid
   ClientHeight    =   4590
   ClientLeft      =   1650
   ClientTop       =   1545
   ClientWidth     =   6150
   LinkTopic       =   "Form1"
   ScaleHeight     =   4590
   ScaleMode       =   0  'User
   ScaleWidth      =   6150
   Begin VB.PictureBox picButtons
      Align           =   1  'Align Top
      Appearance      =   0  'Flat
      BorderStyle     =   0  'None
      ForeColor       =   &H80000008&
      Height          =   330
      Left            =   0
      ScaleHeight     =   330
      ScaleWidth      =   6150
      TabIndex        =   1
      TabStop         =   0   'False
      Top             =   0
      Width           =   6150
      Begin VB.CommandButton cmdClose
         Caption         =   "
(&C)"
         Height          =   330
         Left            =   4398
         TabIndex        =   5
         Tag             =   "&Close"
         Top             =   0
         Width           =   1437
      End
      Begin VB.CommandButton cmdFilter
         Caption         =   "
(&F)"
         Height          =   330
         Left            =   2924
         TabIndex        =   4
         Tag             =   "&Filter"
         Top             =   0
         Width           =   1462
      End
      Begin VB.CommandButton cmdSort
         Caption         =   "
(&S)"
         Height          =   330
         Left            =   1462
         TabIndex        =   3
         Tag             =   "&Sort"
         Top             =   0
         Width           =   1462
      End
      Begin VB.CommandButton cmdRefresh
         Caption         =   "
(&R)"
         Height          =   330
         Left            =   0
         TabIndex        =   2
         Tag             =   "&Refresh"
         Top             =   0
         Width           =   1462
      End
   End
   Begin VB.Data Data1
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      Height          =   300
      Left            =   2505
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   2175
      Visible         =   0   'False
      Width           =   1140
   End
   Begin MSDBGrid.DBGrid grdDataGrid
      Align           =   1  'Align Top
      Bindings        =   "datagrid.frx":0000
      Height          =   3645
      Left            =   0
      OleObjectBlob   =   "datagrid.frx":00CE
      TabIndex        =   0
      Top             =   330
      Width           =   6150
   End
Attribute VB_Name = "frmDataGrid"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim msSortCol As String
Dim mbCtrlKey As Integer
Sub cmdClose_Click()
    Unload Me
End Sub
Private Sub cmdFilter_Click()
    On Error GoTo FilterErr
    Dim recRecordset1 As Recordset, recRecordset2 As Recordset
    Dim sFilterStr As String
    If Data1.RecordsetType = vbRSTypeTable Then
        Beep
        MsgBox "
", 48
        Exit Sub
    End If
    Set recRecordset1 = Data1.Recordset                        '
    sFilterStr = InputBox("
    If Len(sFilterStr) = 0 Then Exit Sub
    Screen.MousePointer = vbHourglass
    recRecordset1.Filter = sFilterStr
    Set recRecordset2 = recRecordset1.OpenRecordset(recRecordset1.Type) '
    Set Data1.Recordset = recRecordset2                        '
    Screen.MousePointer = vbDefault
    Exit Sub
FilterErr:
    Screen.MousePointer = vbDefault
    MsgBox "
" & Err & "
" & Err.Description
End Sub
Private Sub cmdRefresh_Click()
    On Error GoTo RefErr
    Data1.Recordset.Requery
    Exit Sub
RefErr:
    MsgBox "
" & Err & "
" & Err.Description
End Sub
Private Sub cmdSort_Click()
    On Error GoTo SortErr
    Dim recRecordset1 As Recordset, recRecordset2 As Recordset
    Dim SortStr As String
    If Data1.RecordsetType = vbRSTypeTable Then
        Beep
        MsgBox "
", 48
        Exit Sub
    End If
    Set recRecordset1 = Data1.Recordset                        '
    If Len(msSortCol) = 0 Then
        SortStr = InputBox("
        If Len(SortStr) = 0 Then Exit Sub
    Else
        SortStr = msSortCol
    End If
    Screen.MousePointer = vbHourglass
    recRecordset1.Sort = SortStr
    '
    Set recRecordset2 = recRecordset1.OpenRecordset(recRecordset1.Type)
    Set Data1.Recordset = recRecordset2
    Screen.MousePointer = vbDefault
    Exit Sub
SortErr:
    Screen.MousePointer = vbDefault
    MsgBox "
" & Err & "
" & Err.Description
End Sub
Private Sub Form_Load()
    Dim bParmQry As Integer
    Dim qdfTmp As QueryDef
    On Error GoTo LoadErr
    '
    'gsDatabase
    '
    Data1.DatabaseName = gsDatabase
    'gsRecordSource
    '
    Data1.RecordSource = gsRecordsource
    Data1.RecordsetType = 1     '
    Data1.Options = 0
    Data1.Refresh
    If Len(Data1.RecordSource) > 50 Then
        Me.Caption = "SQL
    Else
        Me.Caption = Data1.RecordSource
    End If
    Exit Sub
LoadErr:
    MsgBox "
" & Err & "
" & Err.Description
    Unload Me
End Sub
Private Sub Form_Resize()
    On Error Resume Next
    If Me.WindowState <> 1 Then
        grdDataGrid.Height = Me.Height - (425 + picButtons.Height)
    End If
End Sub
Private Sub grdDataGrid_BeforeDelete(Cancel As Integer)
    If MsgBox("
", vbYesNo + vbQuestion) <> vbYes Then
        Cancel = True
    End If
End Sub
Private Sub grdDataGrid_BeforeUpdate(Cancel As Integer)
    If MsgBox("
", vbYesNo + vbQuestion) <> vbYes Then
        Cancel = True
    End If
End Sub
Private Sub grdDataGrid_HeadClick(ByVal ColIndex As Integer)
    '
    If Data1.RecordsetType = vbRSTypeTable Then Exit Sub
    '
 ctrl
    If mbCtrlKey Then
        msSortCol = "[" & Data1.Recordset(ColIndex).Name & "] desc"
        mbCtrlKey = 0 '
    Else
        msSortCol = "[" & Data1.Recordset(ColIndex).Name & "]"
    End If
    cmdSort_Click
    msSortCol = vbNullString '
End Sub
Private Sub grdDataGrid_MouseUp(Button As Integer, Shift As Integer, x As Single, Y As Single)
    mbCtrlKey = Shift
End Sub