protected void btnClear_Click(object sender, EventArgs e) { this.Session["PONumber"] = ""; this.Session["DCNumber"] = ""; btnSave.Enabled = false; btnDelete.Enabled = false; ddPONumber.Text = ""; ddPONumber.Enabled = true; ddPONumber.Visible = true; lblPONo.Visible = false; lblPONo.Text = ""; dpPODate.Date = DateTime.Today; dpDCDate.Date = Convert.ToDateTime(myFunc.GetServerTime()); ddDCNumber.Text = ""; ddDCNumber.Enabled = true; lblDCStatus.Text = ""; txtVendorCode.Text = ""; txtVendorName.Text = ""; txtVendorDCNo.Text = ""; txtRemarks.Text = ""; ResetDCItemsDataSet(); LoadGrid("", "", ""); string dcode = this.Session["DealerCode"].ToString(); SqlDataSourceDCLookup.SelectCommand = "select a.DCNo, convert(varchar(12),a.DCDate,103) as DCDate , a.PONo, b.VendorDesc,a.VendorDCNo from DCMaster a,Vendor b where a.VendorCode = b.VendorCode and a.DealerCode in ('" + dcode + "','AAAAA') and a.DelFlag = 'N' and a.VendorCode = b.VendorCode and a.DCNo Not IN (Select DCNo from GRNMaster Where DealerCode in ('" + dcode + "','AAAAA') and Delflag = 'N') "; ddDCNumber.DataBind(); ddPONumber.DataBind(); lblDCStatus.Text = ""; }