Dim strDate As String = Now.ToString("yyyy-MM-dd", System.Globalization.DateTimeFormatInfo.InvariantInfo)
TextBox1.Text = strDate
TextBox2.Text = strDate
Dim conn As New OracleConnection("Data Source=192.168.3.101/DBA;User Id=DBA;Password=DBA;")
conn.Open()
sqlOrder = "SELECT * FROM customer
sqlOrder &= " WHERE DATESTART >= to_date('" & TextBox1.Text & "','yyyy-MM-dd') "
sqlOrder &= " AND DATAESTART <= to_date('" & TextBox2.Text & "','yyyy-MM-dd') "
da = New OracleDataAdapter(sqlOrder, conn)
da.Fill(ds, "customer")
If ds.Tables("customer").Rows.Count <> 0 Then
GridView1.DataSource = ds.Tables("customer")
GridView1.DataBind()
End If