@Ashutosh Singh, Mudassar
I will be having to SQL command which is
SELECT Ref_No as name, Job_Order_ID as value FROM Job_Order WHERE (Status <> 'JO_Completed') AND (Delivery_Date = @jaDate) ORDER BY Ref_No
and
SELECT Ref_No as name, Job_Order_ID as value FROM Job_Order WHERE (Status <> 'JO_Completed') ORDER BY Ref_No
Thank you for your reply.
protected void txtJADate2_TextChanged(object sender, EventArgs e) {
ddlNewJobOrder.DataSourceID = null;
if (txtJADate2.Text =="") {
ddlNewJobOrder.DataSource = NewJobOrderDS1;
} else {
ddlNewJobOrder.DataSource = NewJobOrderDS2;
} ddlNewJobOrder.DataBind();
}