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!!!!
VB.NET:
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