caglar3457
Öğrenci
- Katılım
- 28 Ağustos 2015
- Mesajlar
- 1
- Reaksiyon puanı
- 0
- Puanları
- 0
void sol()
{
DataTable dt = vt.GetDataTable("Select * from Departman");
ddlDep.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlDep.Items.Add(dt.Rows["Aciklama"].ToString());
ddlDep.Items.Value = dt.Rows["DepartmanId"].ToString();
}
}
protected void ddlDep_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable tablo = vt.GetDataTable("Select * from Kategori where DepartmanId=" + ddlDep.SelectedItem.Value);
ddlKat.Items.Clear();
for (int i = 0; i < tablo.Rows.Count; i++)
{
ddlKat.Items.Add(tablo.Rows["Aciklama"].ToString());
ddlKat.Items.Value = tablo.Rows["DepartmanId"].ToString();
}
}
protected void ddlKat_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataAdapter adp = new SqlDataAdapter("select * from Urun where KategoriId=@id", baglanti);
adp.SelectCommand.Parameters.AddWithValue("@id", ddlKat.SelectedValue);
baglanti.Open();
DataTable dt = new DataTable();
adp.Fill(dt);
ListView1.DataSource = dt;
ListView1.DataBind();
baglanti.Close();
}
}
- - - Mesaj Güncellendi - - -
son yazılan listview kodunda yanlışlık mı var acaba
{
DataTable dt = vt.GetDataTable("Select * from Departman");
ddlDep.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlDep.Items.Add(dt.Rows["Aciklama"].ToString());
ddlDep.Items.Value = dt.Rows["DepartmanId"].ToString();
}
}
protected void ddlDep_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable tablo = vt.GetDataTable("Select * from Kategori where DepartmanId=" + ddlDep.SelectedItem.Value);
ddlKat.Items.Clear();
for (int i = 0; i < tablo.Rows.Count; i++)
{
ddlKat.Items.Add(tablo.Rows["Aciklama"].ToString());
ddlKat.Items.Value = tablo.Rows["DepartmanId"].ToString();
}
}
protected void ddlKat_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataAdapter adp = new SqlDataAdapter("select * from Urun where KategoriId=@id", baglanti);
adp.SelectCommand.Parameters.AddWithValue("@id", ddlKat.SelectedValue);
baglanti.Open();
DataTable dt = new DataTable();
adp.Fill(dt);
ListView1.DataSource = dt;
ListView1.DataBind();
baglanti.Close();
}
}
- - - Mesaj Güncellendi - - -
son yazılan listview kodunda yanlışlık mı var acaba