1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
Imports System.Data
Imports System.Data.Odbc
Imports System.IO
Imports System.Data.CommandBehavior
Imports Microsoft.VisualBasic
Module EDDYPHAN
Public Vmodif As Boolean
Public PCaisse, PDepot, PCodDepo, PCodcaiss, PVendeur As String
Public Pdate As Date
Public chain, chem, loginpastor As String
Public Ji, Mi, Ai, DE As String
Public daform, dadform, DARE, dapepe As OdbcDataAdapter
Public dsform, dsdfrm, Dsre, dspepe As New DataSet
Public daro, darod As DataRow
Public frm As New Article
Public cmup As OdbcCommandBuilder
Public eddy As OdbcCommand
Public eddyReader As OdbcDataReader
Public optParent, optexist, mlig As Boolean
Public etattick As New TCaisse
Public etaBroui As New brouillardSaise
Public etabrouicais As New BrouillardCaiss
Public frmet As New Rpt
Public cbod As New DataGridViewComboBoxColumn
Public txtgrid As New DataGridViewTextBoxColumn
Public formlist As New Form
Public optlistG, ord As String
Public valgrid, valgrid1, valgrid2, valgrid3, valgrid4, valgrid5, valgrid6, valgrid7, vdelai, gridaa, gridbb, grida, gridb, gridc, gridaf, gridafa, gridafb, gridT, lenCpte, subString As String
Public i, nb, j, K, longcpteR, longcpteG, A, B As Integer
Public optserv, optlist, optconnect As Boolean
Public Function CreateComboBoxColumn() _
As DataGridViewComboBoxColumn
Dim column As New DataGridViewComboBoxColumn()
With column
'.DataPropertyName = ColumnName.TitleOfCourtesy.ToString()
'.HeaderText = ColumnName.TitleOfCourtesy.ToString()
.DropDownWidth = 160
.Width = 90
.MaxDropDownItems = 3
.FlatStyle = FlatStyle.Flat
End With
Return column
End Function
Private Function Connexion()
Try
Dim cs As String = "Dsn=PREMICIA;Uid=sa;Pwd=Secundia84;"
Dim conn As New OdbcConnection(cs)
conn.Open()
Return conn
Catch tiex As TypeInitializationException
MsgBox("Type non initialisé: " + tiex.TypeName)
MsgBox("Message: " + tiex.InnerException.Message)
Catch ex As Exception
MsgBox("Autre exception: " + ex.Message)
End Try
Return Nothing
End Function
Sub main()
frconnexe.ShowDialog()
End Sub
End Module |
Partager