Visual Basic

dan neely wrote:

IF you don't even know all the right questions to ask, you're probably not the right person to be doing the actual research either.

NasimKaziS wrote:

Reference to a non-shared member requires object reference."

NasimKaziS wrote:

preferenceValueField

 Dim DBConnectionString As String = ""<br />
 Dim MyTableName As String = ""<br />
 Dim MyCommandText As String = ""<br />
 Dim MyReader As System.Data.OleDb.OleDbDataReader<br />
 Dim DBCommand As New System.Data.OleDb.OleDbCommand<br />
 Dim DBConnection As System.Data.OleDb.OleDbConnection<br />
 Dim MyDataSet As DataSet<br />
<br />
 'Call some helper functions.<br />
 DBConnection = GetConnection()<br />
 DBConnectionString = GetConnectionString()<br />
<br />
 'Set connection and open<br />
 DBConnection.ConnectionString = DBConnectionString<br />
 DBConnection.Open()<br />
<br />
 'Set command.<br />
 MyTableName = DBTableName.ToString()<br />
 MyCommandText = " select * from " & MyTableName & " "<br />
 DBCommand.CommandText = MyCommandText<br />
<br />
 'Get a data reader.<br />
 MyReader = DBCommand.ExecuteReader()<br />
<br />
‘Populate your combo with MyReader<br />
While MyReader.Read<br />
MyCombo.Items.Add(MyReader("FieldName"))<br />
End While

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    'T1 is March 20 2007, at 19:45
    Dim t1 As New Date(2007, 3, 20, 19, 45, 0)
    'T2 is March 21 2007, at 8:53
    Dim t2 As New Date(2007, 3, 21, 8, 53, 0)
    'The timespan is 13:08...which is correct
    MsgBox(t2.Subtract(t1).ToString())
End Sub