private void BindGrdView()
{
Snlg_DBConnect vt = new Snlg_DBConnect(true);
string sqlSorgu = string.Format(@"SELECT * FROM snlg_V1.TblUrunResim WHERE UrunId={0} ORDER BY Sira ASC", Request.QueryString["uid"].ToString());
GrdSiralama.DataSource = vt.DataTableOlustur(sqlSorgu, System.Data.CommandType.Text);
GrdSiralama.DataBind();
}
private void BindGrdView()
{
Snlg_DBConnect vt = new Snlg_DBConnect(true);
string sqlSorgu = string.Format(@"select * from snlg_V1.TblResimGaleriResimlerApp WHERE GId={0} ORDER BY Sira ASC", Request.QueryString["gid"].ToString());
GrdSiralama.DataSource = vt.DataTableOlustur(sqlSorgu, System.Data.CommandType.Text);
GrdSiralama.DataBind();
}
public void BindGrvd(string id)
{
Snlg_DBConnect vt = new Snlg_DBConnect(true);
string sqlSorgu = string.Format("SELECT * FROM snlg_V1.TblReferansApp WHERE KtgId = {0} ORDER BY Sira ASC", DDLKtg.SelectedValue);
GrdSiralama.DataSource = vt.DataTableOlustur(sqlSorgu, System.Data.CommandType.Text);
GrdSiralama.DataBind();
}
private void BindGrdView()
{
Snlg_DBConnect vt = new Snlg_DBConnect(true);
string sqlSorgu = string.Format(@"SELECT TblProjeAltBilgiApp.ProjeAltId, TblProjeAltBilgiApp.Sira, TblProjeAltBilgiDetay.Baslik,
TblProjeAltBilgiApp.Gorunurluk, TblProjeAltBilgiDetay.SeoUrl
FROM snlg_V1.TblProjeAltBilgiApp INNER JOIN
snlg_V1.TblProjeAltBilgiDetay ON TblProjeAltBilgiApp.ProjeAltId = TblProjeAltBilgiDetay.ProjeAltId INNER JOIN
snlg_V1.TblProjeDetay ON TblProjeAltBilgiApp.ProjeId = TblProjeDetay.ProjeId
WHERE (TblProjeAltBilgiDetay.Dil = {0}) ORDER BY TblProjeAltBilgiApp.Sira ASC", Snlg_ConfigValues.defaultLangId);
GrdSiralama.DataSource = vt.DataTableOlustur(sqlSorgu, System.Data.CommandType.Text);
GrdSiralama.DataBind();
}
protected void DDLKtg_SelectedIndexChanged1(object sender, EventArgs e)
{
if (DDLKtg.SelectedIndex != 0)
{
sirala.Visible = true;
Snlg_DBConnect vt = new Snlg_DBConnect(true);
string sqlSorgu = string.Format(@"SELECT TblUrunApp.UrunId, TblUrunApp.Sira, TblUrunDetay.UrunAd,TblUrunApp.Resim AS DefaultResim,TblUrunApp.Fiyat,
TblUrunApp.Gorunurluk, TblUrunApp.UrunKodu
FROM snlg_V1.TblUrunApp INNER JOIN
snlg_V1.TblUrunDetay ON TblUrunApp.UrunId = TblUrunDetay.UrunId INNER JOIN
snlg_V1.TblUrun_Kategori ON TblUrunApp.UrunId = TblUrun_Kategori.UrunId
WHERE (TblUrunDetay.Dil ={0}) AND (TblUrun_Kategori.KtgId ={1})
ORDER BY TblUrunApp.Sira ASC" , Snlg_ConfigValues.defaultLangId, DDLKtg.SelectedValue);
GrdSiralama.DataSource = vt.DataTableOlustur(sqlSorgu, System.Data.CommandType.Text);
GrdSiralama.DataBind();
}
else
{
GrdSiralama.DataSource = null;
GrdSiralama.DataBind();
sirala.Visible = false;
}
}
protected void DDLKtg_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
sirala.Visible = true;
Snlg_DBConnect vt = new Snlg_DBConnect(true);
string sqlSorgu = string.Format(@"SELECT TblProjeApp.ProjeId, TblProjeApp.Sira, TblProjeDetay.Baslik,
TblProjeApp.Aktif, TblProjeApp.ProjeUrl
FROM snlg_V1.TblProjeApp INNER JOIN
snlg_V1.TblProjeDetay ON TblProjeApp.ProjeId = TblProjeDetay.ProjeId LEFT OUTER JOIN
snlg_V1.TblProje_Kategori ON TblProjeApp.ProjeId = TblProje_Kategori.ProjeId
WHERE(TblProjeDetay.Dil = {0}) AND(TblProje_Kategori.KtgId ={1}) ORDER BY TblProjeApp.Sira ASC", Snlg_ConfigValues.defaultLangId, DDLKtg.SelectedValue);
GrdSiralama.DataSource = vt.DataTableOlustur(sqlSorgu, System.Data.CommandType.Text);
GrdSiralama.DataBind();
}
catch (Exception)
{
GrdSiralama.DataSource = null;
GrdSiralama.DataBind();
sirala.Visible = false;
}
}
