very strange problem

[Viktor Popov]

Hi,

When I place the following coede in Page_Load method it doesn't populate the
DropDownList and when I place it in Button1_Click method and I push the
button after the page is loaded the DropDownList is populated. What I should
do in order to populate the DropDownList when I reach this WebForm by link
from another WebForm?


SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial
Catalog=Estate; User ID=blek; Password=banderas");

SqlDataAdapter dad = new SqlDataAdapter ("SELECT
blek.TypeOffer.OfferID,blek.TypeOffer.TypeOffer FROM blek.TypeOffer", conn);

conn.Open();

dad.SelectCommand.ExecuteNonQuery();

DataTable table=new DataTable();

dad.Fill(table);

DropDownList2.DataSource=table;

DropDownList2.DataValueField = "OfferID";

DropDownList2.DataTextField = "TypeOffer";

DropDownList2.DataBind();

msg.Text = table.Rows.Count.ToString();

conn.Close();

 

[Marina]

Maybe Page_Load method is not wired to the Load event to be its handler.

 

[Alvin Bruney [MVP]]

are you checking for page.ispostback in your pageload?

 

[Viktor Popov]

Thanks for the reply!
How could I check that or to wired the Page_Load to the Load event ?

 

[Viktor Popov]

Thanks for the reply
Yes, I use if (!Page.IsPostBack)
{
code
}

are you checking for page.ispostback in your pageload?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,

When I place the following coede in Page_Load method it doesn't populate
the
DropDownList and when I place it in Button1_Click method and I push the
button after the page is loaded the DropDownList is populated. What I
should
do in order to populate the DropDownList when I reach this WebForm by link
from another WebForm?


SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial
Catalog=Estate; User ID=blek; Password=banderas");

SqlDataAdapter dad = new SqlDataAdapter ("SELECT
blek.TypeOffer.OfferID,blek.TypeOffer.TypeOffer FROM blek.TypeOffer",
conn);

conn.Open();

dad.SelectCommand.ExecuteNonQuery();

DataTable table=new DataTable();

dad.Fill(table);

DropDownList2.DataSource=table;

DropDownList2.DataValueField = "OfferID";

DropDownList2.DataTextField = "TypeOffer";

DropDownList2.DataBind();

msg.Text = table.Rows.Count.ToString();

conn.Close();

 

[Viktor Popov]

I have done it
Thanks!

Hi,

When I place the following coede in Page_Load method it doesn't populate the
DropDownList and when I place it in Button1_Click method and I push the
button after the page is loaded the DropDownList is populated. What I should
do in order to populate the DropDownList when I reach this WebForm by link
from another WebForm?


SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial
Catalog=Estate; User ID=blek; Password=banderas");

SqlDataAdapter dad = new SqlDataAdapter ("SELECT
blek.TypeOffer.OfferID,blek.TypeOffer.TypeOffer FROM blek.TypeOffer", conn);

conn.Open();

dad.SelectCommand.ExecuteNonQuery();

DataTable table=new DataTable();

dad.Fill(table);

DropDownList2.DataSource=table;

DropDownList2.DataValueField = "OfferID";

DropDownList2.DataTextField = "TypeOffer";

DropDownList2.DataBind();

msg.Text = table.Rows.Count.ToString();

conn.Close();