Имеющий Что Сказать
Зарегистрирован:
05 January 2008
Сообщения: 84
Примеры кода: 0
|
Re: DropDownList сбразсывается значение. |
10 May 2008 12:33 |
|
|
|
|
вот как я делаю
if (!IsPostBack)
{
setcombo(ref conn);
}
else
{
try
{
if (Request.Form.Get("CheckBox1") == "on") CheckBox1.Checked = true;
else CheckBox1.Checked = false;
if (Request.Form.Get("CheckBox2") == "on") CheckBox2.Checked = true;
else CheckBox2.Checked = false;
if (Request.Form.Get("CheckBox3") == "on") CheckBox3.Checked = true;
else CheckBox3.Checked = false;
if (Request.Form.Get("CheckBox4") == "on") CheckBox4.Checked = true;
else CheckBox4.Checked = false;
if (Request.Form.Get("CheckBox5") == "on") CheckBox5.Checked = true;
else CheckBox5.Checked = false;
if (Request.Form.Get("CheckBox6") == "on") CheckBox6.Checked = true;
else CheckBox6.Checked = false;
if (Request.Form.Get("CheckBox7") == "on") CheckBox7.Checked = true;
else CheckBox7.Checked = false;
if (Request.Form.Get("CheckBox8") == "on") CheckBox8.Checked = true;
else CheckBox8.Checked = false;
if (Request.Form.Get("CheckBox9") == "on") CheckBox9.Checked = true;
else CheckBox9.Checked = false;
}
catch (Exception) { }
}
и функция
protected void setcombo(ref SqlConnection conn)
{
int interes = -1;
int zach = -1;
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Love Where (id_user = @id)", conn);
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@ID"].Value = Convert.ToInt32(Session["UserID"]);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["id_interes"] == DBNull.Value) interes = -1;
else interes = Convert.ToInt32(reader["id_interes"]);
}
reader.Close();
}
if (interes != -1)
{
SqlCommand cmd = new SqlCommand("SELECT id_mus FROM love_interes Where (id = @id)", conn);
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@ID"].Value = interes;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["id_interes"] == DBNull.Value) zach = -1;
else zach = Convert.ToInt32(reader["id_mus"]);
}
reader.Close();
}
if (zach != -1)
{
SqlCommand cmd = new SqlCommand("SELECT * FROM love_interes_mus Where (id = @id)", conn);
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@ID"].Value = zach;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["rus_pop"] == DBNull.Value) CheckBox1.Checked = false;
else
{
if (Convert.ToBoolean(reader["rus_pop"]) == true) CheckBox1.Checked = true;
if (Convert.ToBoolean(reader["rus_pop"]) == false) CheckBox1.Checked = false;
}
if (reader["eng_pop"] == DBNull.Value) CheckBox2.Checked = false;
else
{
if (Convert.ToBoolean(reader["eng_pop"]) == true) CheckBox2.Checked = true;
if (Convert.ToBoolean(reader["eng_pop"]) == false) CheckBox2.Checked = false;
}
if (reader["avtor_pesnia"] == DBNull.Value) CheckBox3.Checked = false;
else
{
if (Convert.ToBoolean(reader["avtor_pesnia"]) == true) CheckBox3.Checked = true;
if (Convert.ToBoolean(reader["avtor_pesnia"]) == false) CheckBox3.Checked = false;
}
if (reader["rus_rock"] == DBNull.Value) CheckBox4.Checked = false;
else
{
if (Convert.ToBoolean(reader["rus_rock"]) == true) CheckBox4.Checked = true;
if (Convert.ToBoolean(reader["rus_rock"]) == false) CheckBox4.Checked = false;
}
if (reader["bluz"] == DBNull.Value) CheckBox5.Checked = false;
else
{
if (Convert.ToBoolean(reader["bluz"]) == true) CheckBox5.Checked = true;
if (Convert.ToBoolean(reader["bluz"]) == false) CheckBox5.Checked = false;
}
if (reader["rap"] == DBNull.Value) CheckBox6.Checked = false;
else
{
if (Convert.ToBoolean(reader["rap"]) == true) CheckBox6.Checked = true;
if (Convert.ToBoolean(reader["rap"]) == false) CheckBox6.Checked = false;
}
if (reader["classic"] == DBNull.Value) CheckBox7.Checked = false;
else
{
if (Convert.ToBoolean(reader["classic"]) == true) CheckBox7.Checked = true;
if (Convert.ToBoolean(reader["classic"]) == false) CheckBox7.Checked = false;
}
if (reader["dance"] == DBNull.Value) CheckBox8.Checked = false;
else
{
if (Convert.ToBoolean(reader["dance"]) == true) CheckBox8.Checked = true;
if (Convert.ToBoolean(reader["dance"]) == false) CheckBox8.Checked = false;
}
if (reader["electro"] == DBNull.Value) CheckBox9.Checked = false;
else
{
if (Convert.ToBoolean(reader["electro"]) == true) CheckBox9.Checked = true;
if (Convert.ToBoolean(reader["electro"]) == false) CheckBox9.Checked = false;
}
}
reader.Close();
}
}
Я думаю правильно
WildWap.RU Найди друзей
Данное сообщение получено с сайта GotDotNet.RU
Последний раз редактировалось 10 May 2008 12:33
|
|