Quote:
I need also to add more filters like this
And kod Like '" & txttrfirma.Text & "%' order by datumdos,grupa,proizvod,firma"
All you need to do is to add another parameter
sql1 = "SELECT * FROM tblpromet WHERE (datumdos BETWEEN ? AND ? ) AND (kod Like ?%);"
da1 = New OleDb.OleDbDataAdapter(sql1, con)
da1.SelectCommand.Parameters.AddWithValue(" min", DateTimePicker1.Value)
da1.SelectCommand.Parameters.AddWithValue(" max", DateTimePicker2.Value)
da1.SelectCommand.Parameters.AddWithValue(" kod", txttrfirma.Text)
da1.Fill(ds, " PrometBase" )
Note, that you can't add sort order through the parameters. You need to define order in your command:
sql1 = "SELECT * FROM tblpromet WHERE (datumdos BETWEEN ? AND ? ) AND (kod Like ?%) ORDER BY datumdos, grupa, proizvod, firma;"