how to create three tier web application using web services

Question

Sir

My question how to create three tier web application using web services in asp.net

not a three tier web application,because I know how to create three tier web application

But My question is how to create three tier web Application using web Services In asp.net 

so please give me exact answer my question step by step

 

thanks &regards

md abid 

Answer 1

Assuming all numeric columns are of type double, then try:

   foreach(DataRow dr in table1.Rows)

   {

      string colName = dr["Par Name"].ToString();

      if(table5.Columns.Contains(colName))

      {

         double lower = (double)dr["lower_limit"];

         double upper = (double)dr["upper_limit"];

         double min = table5.Rows.Cast<DataRow>().Min(r => r.Field<double>(colName));

             

         if (min >= lower)

         {

            double max = table5.Rows.Cast<DataRow>().Max(r => r.Field<double>(colName));

            if (max <= upper) table5.Columns.Remove(colName);

         }

      }

   }

or, if they're all strings, try:

   foreach(DataRow dr in table1.Rows)

   {

      string colName = dr["Par Name"].ToString();

      if(table5.Columns.Contains(colName))

      {

         double lower = double.Parse(dr["lower_limit"].ToString());

         double upper = double.Parse(dr["upper_limit"].ToString());

         double min = table5.Rows.Cast<DataRow>().Min(r => double.Parse(r.Field<string>(colName)));

             

         if (min >= lower)

         {

            double max = table5.Rows.Cast<DataRow>().Max(r => double.Parse(r.Field<string>(colName)));

            if (max <= upper) table5.Columns.Remove(colName);

         }

      }

   }

Answer 2

Thank you vulpes . works perfect only  thing is I had to remove the last three columns from table5 (Split , Die_id and normal inverse), since I am adding it later again no problem :)

Answer 3

Hi,
what basis u want to match the rows?? please explain little bit more.