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();
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

[Marina]

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

"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl...

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();
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

[Alvin Bruney [MVP]]

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
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl...

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();
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

[Viktor Popov]

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

"Marina" <so*****@nospam.com> wrote in message
news:#x**************@TK2MSFTNGP10.phx.gbl...

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

"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl...

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();
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

[Viktor Popov]

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

"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
news:Oa**************@TK2MSFTNGP12.phx.gbl...

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
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl...

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();
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

[Viktor Popov]

I have done it:)
Thanks!
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eD**************@TK2MSFTNGP10.phx.gbl...

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();
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.