Iron Speed
17 November, 2006Function Fix Line
11 October, 2006
</p> <p>Function FixLine(varValue As Variant) As Variant<br /> ' if varValue is Null, FixLine returns Null.<br /> ' Otherwise, it returns the field value passed in<br /> ' with a Cr/Lf on the end.<br /> FixLine = varValue + vbCrLf<br />End Function</p> <p>
MS Access Connection Method
25 January, 2006Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\stcode.mdb;Persist Security Info=True;Jet OLEDB:Database Password=ilovemyindia"
Dim conn As New OleDb.OleDbConnection(connectionString)
Dim customersTableAdapter As New OleDb.OleDbDataAdapter("Select station, code from tblstCode", conn)
Dim customerTable As New DataTable()
customersTableAdapter.Fill(customerTable)
Me.TblStCodeBindingSource.Filter = "Station Like" & "'*" & Me.TextBox1.Text & "*'"
Me.TblStCodeBindingSource.DataSource = customerTable
DataGridView1.DataSource = Me.TblStCodeBindingSource
Posted by tahiramini
Posted by tahiramini
Posted by tahiramini