Retrieve data from Dataset

You like,Please answer me
Have a happy coding.
http://dotnet--solutions.blogspot.in

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

 SqlCommand cmd = new SqlCommand("select * from leavereminder", db.sqlcon);

        SqlDataAdapter adp = new SqlDataAdapter(cmd);

        Dataset ds = new Dataset();

        adp.Fill(ds);

        if (ds.Rows.Count > 0)

        {

         //square bracket contains the column name whose value u want to retrieve

            if (ds.Rows[0]["status"].ToString() == "pending")

            {

               string femail= ds.Rows[0]["email"].ToString();

                string name = ds.Rows[0]["name"].ToString();

                

                sendmail(ds.Rows[0]["email"].ToString(), ds.Rows[0]["name"].ToString());

            }

            else if (dt.Rows[0]["status"].ToString() == "approved")

            {

                sendmail(dt.Rows[0]["email"].ToString(), dt.Rows[0]["name"].ToString());

            

            }

        

        }