hello every one!!
i am running a program in which i am loading data set in datagridview by selecting date range, the thing that goes the other way is this that no data is coming out on the datagridview as per selection where as if i apply
"select * from 'table name'" every thing shows up.
i am forwarding the code, some one please help.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim str As String
cn = New OleDbConnection(con_str)
str = "select Transaction,Debit,Credit,Transaction_Date,Transaction_Details from AM_Table where Transaction_Date BETWEEN " & DateTimePicker1.Value.Date & " AND " & DateTimePicker2.Value.Date
cmd = New OleDbCommand(str, cn)
Dim dataadapter As OleDbDataAdapter = New OleDbDataAdapter(cmd)
Dim ds As DataSet = New DataSet()
DataGridView1.DataSource = ds.Tables(0)
Catch ex As Exception
can some help me soon.