12-05-17, 04:21 AM
PHP كود :
Dim sql = "SELECT * FROM [Table1] WHERE [Sex]=@sex AND [Birthday] BETWEEN @StartDate AND @EndpDate "
Dim da As New OleDbDataAdapter(sql, Con)
da.SelectCommand.Parameters.AddWithValue("@sex", cboSex.Text)
da.SelectCommand.Parameters.AddWithValue("@StartDate", DateTimePicker1.Value.Date)
da.SelectCommand.Parameters.AddWithValue("@EndpDate", DateTimePicker2.Value.Date)
Dim dt As New DataTable
da.Fill(dt)
dgvList.DataSource = dt
