incorrect values and slowness

[jnash]

Hi there im using this code and whenever i input a date, i get all the entries in the table instead of the ones specified with the date, what am i doing, also loading can take over a minute, how can this be sped up i have 1.5gb's of RAM!!!!

 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        temp = TextBox1.Text
        ' Create the data adapter object pointing to the authors table
        da = New MySqlDataAdapter( _
              "SELECT * from tblTransactions where transDate =" & temp.ToString & "", TheConnection)

        ' Fill the DataSet
        ds = New DataSet("tblTransactions")
        da.Fill(ds)
        CrystalReportViewer1.ReportSource = report
    End Sub

 

[jnash]

sorted it realised i but the table string in the dataset as opposed to the dataadapter!!

 

[cjard]

take a read of the PQ link in my signature..