[Rabeea Qbaha]

كود :

If sqlcon.State = ConnectionState.Closed Then
sqlcon.Open()
       End If
   
   Dim cmd As New sqlCommand("SELECT * FROM [EPH_VIEW_sales_d_total_inquiry] WHERE [txn_date] Between @date1 And @date2 ", sqlcon)
cmd.Parameters.AddWithValue("@date1", datetimepicker1.Value)
       cmd.Parameters.AddWithValue("@date2", datetimepicker2.Value)
   
   ds.Clear()
 

       adaptor = New sqlDataAdapter(cmd)
       adaptor.Fill(ds, "EPH_VIEW_sales_d_total_inquiry")

       sqlcon.Close()

       GV.DataSource = ds
       GV.DataMember = "EPH_VIEW_sales_d_total_inquiry"
       GV.Refresh()

GV هي ال datagridview