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:)