Dropdown list doesnt have the values

Jun 2 2006 2:15 AM
hi all,

in my web form i have one dropdown box i am fill this DD from the database field called forename.database contains data in this field but my drop down doent have any values after my page loaded.

my code:

private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here

Ajax.Utility.RegisterTypeForAjax(typeof(WebForm1));

if(! Page.IsPostBack)

{

Data data=new Sample111Data.Data();

data.ConnectionToOracle();

Countries.DataSource =GetCountries();

States.DataSource=GetStates();

}

}

public DataTable GetCountries()

{

DataTable countries=new DataTable();

string sqlstring="select forename from people";

string con1 = ConnectionToOracle();

//OracleCommand cmd = new OracleCommand(sqlstring,con);

OracleDataAdapter da = new OracleDataAdapter(sqlstring,con1);

da.Fill(countries);

return countries;

}could you please tell me y its not having the data?

regards 
Ram:)