OleDbConnection con = new OleDbConnection(connection);
DataSet ds = new DataSet();
OleDbDataAdapter ad = new OleDbDataAdapter("select Tittle from smsstorage order by Tittle Asc", con);
ad.Fill(ds);
ddlsmsstorage.Items.Add("---Select---");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ddlsmsstorage.Items.Add(ds.Tables[0].Rows[i][0].ToString());
}
like this also we can add which field you want.............