Iron Speed

17 November, 2006

Asp.net Artical

17 November, 2006

Function Fix Line

11 October, 2006

</p>
<p>Function FixLine(varValue As Variant) As Variant<br />&nbsp;&nbsp;&nbsp; ' if varValue is Null, FixLine returns Null.<br />&nbsp;&nbsp;&nbsp; ' Otherwise, it returns the field value passed in<br />&nbsp;&nbsp;&nbsp; ' with a Cr/Lf on the end.<br />&nbsp;&nbsp;&nbsp; FixLine = varValue + vbCrLf<br />End Function</p>
<p>

 


MS Access Connection Method

25 January, 2006

 Dim 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