private void load_invoice_info(string invoice_no)
{
string query_date = "Select purchase_date from firoz_center.tbl_purchase where invoice_no='" + this.textBoxOld.Text + "';";
string query_amount = "Select net_amount from firoz_center.tbl_purchase where invoice_no='" + this.textBoxOld.Text + "';";
if (this.dbc.Select_Date(query_date).Equals(""))
{
MessageBox.Show("Check Again!!!");
}
string date = dbc.Select_Date(query_date);
string amount = dbc.SelectSingle(query_amount);
this.textBoxDate.Text = date;
this.textBoxAmount.Text = amount;
}