50. how to retrieve particular column data in the data set or data table [Resolved]

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

        SqlDataAdapter adp = new SqlDataAdapter(cmd);

//create object for datable

        DataTable dt = new DataTable();

//fill it

        adp.Fill(dt);

//check for more then 0 rows

        if (dt.Rows.Count > 0)

        {

//status is my column name, here i have checked for the "pending" value

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

            {

//sending mechanism if satisfied condition

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

            }

        

        } 

Sqlconnection con = new sqlconnection(connectionstring);

string Query = "select columnname from tablename";

con .Open();		

SqlDataAdapter a = new SqlDataAdapter(Query,con);

 DataTable t = new DataTable();

a.Fill(t);

Thanks & Regards,
Santhi .V