public void find_customer_data()
{
String bill = Session["Bill_no_customer_page"].ToString();
DataTable dt = Select_Logic.find_remaining_customer_Data("tbl_remaining_customer", bill);
if (dt.Rows.Count == 0)
{
//set error message
Session["error_product_selling_page"] = "No Data Found";
Response.Redirect("home.aspx");
}
txt_current_gold_price.Enabled = false;
txt_customer_address.Text = dt.Rows[0]["c_address"].ToString();
txt_email_address.Text = dt.Rows[0]["c_email_address"].ToString();
txt_mobile_no.Text = dt.Rows[0]["c_mobile_no"].ToString();
txt_customer_name.Text = dt.Rows[0]["c_name"].ToString();
txt_purchase_date.Text = dt.Rows[0]["purchase_date"].ToString();
txt_total_amount.Text = dt.Rows[0]["remaining_amount"].ToString();
btn_ok.Enabled = false;
txt_unique_id2.Enabled = false;
grv_view_prod.Enabled = false;
Button5.Enabled = false;
grv_prod_selling.Enabled = false;
}