Visual Basic

Luc Pattyn wrote:

640bit systems

DaveAuld wrote:

640 wow, where can i get one of those?

DaveAuld wrote:

what would the maximum addressable memory be??

Try
            me.listView1.Items.Clear()
            Dim resultFound As Integer
            DBConnection.connect()
            Dim sql As String = "select * from MortgageDetails where Current_Date >= ? and Current_Date <= ?"
            Dim cmd As New OleDbCommand(sql, con)
            cmd.Parameters.AddWithValue("Current_Date", Convert.ToDateTime(txtDateFrom.Text))
            cmd.Parameters.AddWithValue("Current_Date", Convert.ToDateTime(txtDateTo.Text))

            Dim reader As OleDbDataReader = cmd.ExecuteReader
            While reader.Read
                Dim item As New ListViewItem(New String() {reader.GetInt32(0), reader.GetString(1), reader.GetString(2), _
                                                          reader.GetString(3), reader.GetString(4), reader.GetString(5), _
                                                          reader.GetDateTime(6), reader.GetInt32(7), reader.GetInt32(8)})
                me.listView1.Items.Add(item)
                resultFound += 1
            End While
            reader.Close()
            lblStatus.Text = resultFound & " record(s) found!"
            'Me.Close()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

cmd.Parameters.AddWithValue("[Current_Date]", Date.Parse(txtDateFrom.Text))
cmd.Parameters.AddWithValue("[Current_Date]", Date.Parse(txtDateTo.Text))

SELECT [Field1], [Field2], [Field3] FROM YourTable WHERE [Current_Date] BETWEEN @StartDate AND @EndDate

daemonsead2008 wrote:

I only want is to display the records only on the column1.

bobmc11 wrote:

Textbox.TEXT = format(1.0,"0.0")

txtBox1.Text = myNumber.ToString("c"); //c = currency

"[Current_Date]='" & txtCurrentDate.Text & "'"

"[Current_Date]=#" & Convert.ToDateTime(txtCurrentDate.Text).ToString("MM/DD/YYYY") & "#"