private void mapCustomer(int Id)
{
string Query = "";
DataTable data = customer.GetbyId(Id);
if (data.Rows.Count > 0)
{
txtaddress.Text = data.Rows[0]["Address"].ToString();
txtcity.Text = data.Rows[0]["City"].ToString();
txtcode.Text = data.Rows[0]["Code"].ToString();
txtemailid.Text = data.Rows[0]["EmailId"].ToString();
txtmobileno.Text = data.Rows[0]["MobileNo"].ToString();
txtname.Text = data.Rows[0]["Name"].ToString();
txtpincode.Text = data.Rows[0]["Pincode"].ToString();
CustomerId = Convert.ToInt32(data.Rows[0]["Id"].ToString());
btnadd.Text = "&Update";
}
}