SqlDataAdapter ada = new SqlDataAdapter();

            SqlCommand selectalladress = new SqlCommand();

            ada.SelectCommand = selectalladress;

            selectalladress.Connection = conn;

            DataTable dtalladress = new DataTable();

            selectalladress.CommandText = @"select distinct  nasp, ylic, ndom, nkorp, nkw from FRA where nasp is not null and ylic is not null and ndom is not null";

            //

            //

            //

            SqlDataAdapter ada2 = new SqlDataAdapter();

            SqlCommand selectalladress2 = new SqlCommand();

            ada2.SelectCommand = selectalladress2;

            selectalladress2.Connection = conn;

            DataTable dtalladress2 = new DataTable();

 

            selectalladress2.CommandText = @"select id from fra  where  nasp=@nasp and ylic=@ylic  and ndom=@ndom and nkorp=@nkorp and nkw=@nkw";

            SqlParameter nas = selectalladress2.Parameters.Add("@nasp", SqlDbType.VarChar);

            SqlParameter ulic = selectalladress2.Parameters.Add("@ylic", SqlDbType.VarChar);

            SqlParameter dom = selectalladress2.Parameters.Add("@ndom", SqlDbType.VarChar);

            SqlParameter nkorp = selectalladress2.Parameters.Add("@nkorp", SqlDbType.VarChar);

            SqlParameter nkw= selectalladress2.Parameters.Add("@nkw", SqlDbType.VarChar);

            //

           

            ada.Fill(dtalladress);

            foreach (DataRow rw in dtalladress.Rows)

            {

  

                nas.Value = rw[0].ToString();

                ulic.Value = rw[1].ToString(); ;

                dom.Value = rw[2].ToString();

                nkorp.Value = rw[3].ToString();

                nkw.Value =rw[4].ToString();

              

                ada2.Fill(dtalladress2);

                List<Int32> uniquefraid = new List<int>();

                foreach (DataRow rww in dtalladress2.Rows)

                {

                    uniquefraid.Add(Convert.ToInt32(rww[0]));

                }

 

  if (rw[3] == DBNull.Value & rw[4]==DBNull.Value)
                {
                    selectalladress2.CommandText = @"select id from fra  where  nasp=@nasp and ylic=@ylic  and ndom=@ndom and nkorp is null and nkw is null";

                }
                else if (rw[3] == DBNull.Value & rw[4] != DBNull.Value)
                {
                     selectalladress2.CommandText = @"select id from fra  where  nasp=@nasp and ylic=@ylic  and ndom=@ndom and nkorp is null and nkw=@nkw";
                }
                else if (rw[3] != DBNull.Value & rw[4] == DBNull.Value)
                {
                     selectalladress2.CommandText = @"select id from fra  where  nasp=@nasp and ylic=@ylic  and ndom=@ndom and nkorp=@nkorp and nkw is null";
                }
                else   selectalladress2.CommandText = @"select id from fra  where  nasp=@nasp and ylic=@ylic  and ndom=@ndom and nkorp=@nkorp  and nkw=@nkw";