SELECT a.ship_date ,a.judge_flag from ship_pallet_info a inner join ship_request_info b on a.ship_request_no = b.ship_request_no where a.ship_date between :date1 and :date2 and a.judge_flag= :judgement; and same query in ASP.NET like this but does not return any value: <pre lang="vb">code.OCon.Close() code.OCon.Open() Dim cmd As New OracleCommand("SELECT * from ship_pallet_info a inner join ship_request_info b on a.ship_request_no = b.ship_request_no where a.ship_date between :date1 and :date2 and a.judge_flag = :judge", code.OCon) cmd.Parameters.Add(New OracleParameter("date1", txtPeriod_1.Text)) cmd.Parameters.Add(New OracleParameter("date2", txtPeriod_1.Text)) cmd.Parameters.Add(New OracleParameter("judge", txtPeriod_1.Text)) Dim dt As New DataTable Dim da As New OracleDataAdapter(cmd) da.Fill(dt) gvShippingStatus.DataSource = dt gvShippingStatus.DataBind()</pre>
txtPeriod_1.Text
date1
date2
judge
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)