Response.Redirect("default.aspx");

				try
				{
					if (sqlCnn.State == ConnectionState.Open)
						sqlCnn.Close();

					sqlCnn.Open();
					SqlDataReader dr = null;

					SqlParameter[] arParams = new SqlParameter[ 1 ];
					arParams[ 0 ] = new SqlParameter("@pk", SqlDbType.VarChar,  11 ); 
					arParams[ 0 ].Value = txtFizIpasniekPersKods.Text;

					dr = SqlHelper.ExecuteReader(sqlCnn, "_pusPA_getKlientsFizInfoByPK", arParams);
					int i =  0 ;
					while (dr.Read())
					{
						i++;
					}
					dr.Close();
					sqlCnn.Close();

					if (i ==  1 )
					{
						if (sqlCnn.State == ConnectionState.Open)
							sqlCnn.Close();

						sqlCnn.Open();
						dr = null;

						arParams = new SqlParameter[ 1 ];
						arParams[ 0 ] = new SqlParameter("@pk", SqlDbType.VarChar,  11 ); 
						arParams[ 0 ].Value = txtFizIpasniekPersKods.Text;

						dr = SqlHelper.ExecuteReader(sqlCnn, "_pusPA_getKlientsFizInfoByPK", arParams);
						while (dr.Read())
						{
							txtFizIpasniekID.Text = dr[ 0 ].ToString();
							txtFizIpasniekVards.Text = dr[ 1 ].ToString();
							txtFizIpasniekUzvards.Text = dr[ 2 ].ToString();
							clsControls.GenerateDdlPilseta(ddlFizIpasniekAdresePilseta, dr[ 3 ].ToString());
							txtFizIpasniekAdreseIela.Text = dr[ 4 ].ToString();
							txtFizIpasniekPastaIndekss.Text = dr[ 5 ].ToString();
							txtFizIpasniekTalrunis.Text = dr[ 6 ].ToString();
							txtFizIpasniekAdreseID.Text = dr[ 7 ].ToString();

							if ((txtFizTuretVards.Text != "") && (txtFizTuretUzvards.Text != "") && (txtFizTuretPersKods.Text != ""))
							{
								txtFizNemVardsUzvards.Text = txtFizTuretVards.Text + " " + txtFizTuretUzvards.Text;
								txtFizNemPersKods.Text = txtFizTuretPersKods.Text;
							}
							else
							{
								txtFizNemVardsUzvards.Text = dr[ 1 ].ToString() + " " + dr[ 2 ].ToString();
								txtFizNemPersKods.Text = txtFizIpasniekPersKods.Text;
							}
						}
						dr.Close();
					}
					else if (i >  1 )
					{
						Response.Redirect("default.aspx");
					}
				}
				catch (Exception exc)
				{
					string a = exc.Message;
				}
				finally 
				{
					RecalcPolApdrPremia();
				}