Depressed. . PostBack issues

reuental

if (! IsPostBack)
{
Ranch
string strConn = "Data Source = cnshangh601p; uid = accpac; pwd = accpac; Initial Catalog = ELSH";
SqlConnection sqlcn = new SqlConnection (strConn);
sqlcn.Open ();
SqlCommand selectCmd2 = new SqlCommand ("Select * From ReportUser where UserType = 2", sqlcn);
SqlDataReader dr2;
dr2 = selectCmd2.ExecuteReader ();
while (dr2.Read ())
{
UserList.Items.Add (new ListItem (dr2 ["UserName"]. ToString (), dr2 ["LogName"]. ToString ()));
}
dr2.Close ();
sqlcn.Close ();

The list items in my program are directly formed using the above code,
Control specified autopostback
I am good at executing the program when changing the list options,
result. . . .
Each time the option is changed, the list is repeated with the results of the above procedure. . That's the part of the while statement. . No matter how you change the program. . .
Ranch
}

fanfan1980

UserList.Items.Clear ()

// Clear options before adding

wgfxman

Before while ("if (! IsPostBack) {" after) clear UserList

fanfan1980

dr2 = selectCmd2.ExecuteReader ();
UserList.Items.Clear (); // Newly added

while (dr2.Read ())
{
UserList.Items.Add (new ListItem (dr2 ["UserName"]. ToString (), dr2 ["LogName"]. ToString ()));
}

reuental

Added is useless

It doesn't matter how you add it. Like a bug
Only execute the while statement, and ignore all others

fanfan1980

impossible

reuental

I also think it's impossible, and that's what happened now. . .
I followed it. After postback, no statement was executed at all,
The control itself has more content.

waxiaoning

Code elsewhere

zhouyin1981

Does lz add code to the code after double-clicking UserList?

t0112405

It may be executed twice, that is, the event is triggered twice!?