Ado.net - Move next,move previous,move last and move first

Thank you for posting at Dotnetfunda
[Administrator]

Thanks
Karthik
www.f5Debug.net

 SqlCommand Cmd = new SqlCommand();

            Cmd.Connection = Condb;

            Cmd.CommandType = CommandType.StoredProcedure;

            Cmd.CommandText = SProc;

            Open();



            // This is for adding the SqlParameters

            for (int i = 0; i < Param.Length; i++)

            {

                Cmd.Parameters.Add(Param[i]);

            }

            SqlDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);

            while(dr.read)

             {

                 // Do your code here..

             }



           

SqlCommand Cmd = new SqlCommand();

            Cmd.Connection = Condb;

            Cmd.CommandText = Sql;

            Cmd.CommandType = CommandType.Text;

            DataSet Ds = new DataSet();

            Open();

            for (int i = 0; i < Param.Length; i++)

            {

                Cmd.Parameters.Add(Param[i]);

            }

            SqlDataAdapter Sda = new SqlDataAdapter();

            Sda.SelectCommand = Cmd;

            Sda.Fill(Ds            // Loop through the Tables in the dataset you.)

-----
Suresh M