sql select statment error - Help!

Question

Hi ,

i want to select and filter records by two columns.

In that One is date column in which i want records between two dates and the other column is a text field.

can anyone help please !

---

yogaraj

Answer 1

Hello yogaraj,

Can you please give us some more details, e.g. about the table structure, some sample datas and the result you want to get.
In the subject you mentioned an error; which error do you get and which SQL query did you used?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Thanks For Trying But I got the result.

            cmd = New OleDbCommand
            cmd.Connection = con
            cmd.CommandText = "Select sum(qty) as sums from " & ComboName2.SelectedItem.ToString & " where work = ? and «îF between ? and ?"
            cmd.Parameters.AddWithValue("name", ComboWorkName.Items(j).ToString)
            cmd.Parameters.AddWithValue("date1", arraydates(4))
            cmd.Parameters.AddWithValue("date2", arraydates(5))
            da = New OleDbDataAdapter(cmd)
Thanks again.

---

yogaraj

Answer 3

So you solved it on your own and it works now?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing