Notes

VALİDASYON HATASI GİDİRME KOMUTU




using System.Data;
using System.Data.OleDb;

*************************
OTURUM AÇMA
*************************
OleDbConnection bag = new OleDbConnection();
bag.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/App_Data/osman.accdb"));
bag.Open();
OleDbCommand komut = new OleDbCommand("select admin_id,admin_pass from admin ", bag);
OleDbDataReader oku = komut.ExecuteReader();
while(oku.Read())
{


if (TextBox1.Text == oku[0].ToString() && TextBox2.Text == oku[1].ToString())
{

Session.Add("oturum",TextBox1.Text);
Response.Redirect("index.aspx");

}
else
{

Label1.Text=("Oturum Açma İşlemi Başarısız..");

}


}


bag.Close();


***************************************
OTURUM KONTROL ETTİRME
*************************************
OleDbConnection bag = new OleDbConnection();
bag.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/App_Data/osman.accdb"));
bag.Open();
if (Session["oturum"] == null)
{ Response.Redirect("login.aspx"); }

else
{
Label1.Visible = true;
Button1.Visible = true;
Label1.Text = (Session["oturum"].ToString());
}
bag.Close();

çıkış kod:
Session.Abandon();



**************************
ID YE GÖRE SİLMEK
***************************
{
OleDbConnection bag = new OleDbConnection();
bag.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/App_Data/osman.accdb"));

try
{
bag.Open();
OleDbCommand komut1 = new OleDbCommand("select admin_id from admin", bag);
OleDbDataReader oku = komut1.ExecuteReader();
while (oku.Read())
{
if (TextBox1.Text == oku[0].ToString())
{
OleDbCommand komut2 = new OleDbCommand("delete from admin where admin_id='" + TextBox1.Text + "'", bag);
komut2.ExecuteReader();
bag.Close();
Label1.Text = "İşlem Başarılı";
break;
}

else
Label1.Text = "Kayıt Bulunamadı";

}
}
catch
{ Label1.Text = "işlem başarısız"; }

}



*******************************
KAYIT EKLEME
*******************************
OleDbConnection bag = new OleDbConnection();
bag.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/App_Data/osman.accdb"));
bag.Open();

OleDbCommand komut = new OleDbCommand ("insert into admin(admin_id,admin_pass) values('"+TextBox1.Text+"','"+TextBox3.Text+"')",bag);
komut.ExecuteNonQuery();
Response.Redirect("login.aspx");

bag.Close();



************************
KAYIT GÜNCELLEME
***********************

bag.Open();


OleDbCommand sifre = new OleDbCommand("select admin_pass from admin where admin_id='" + Label2.Text + "'",bag);
OleDbDataReader oku = sifre.ExecuteReader();

while (oku.Read())
{
if (TextBox2.Text == oku[0].ToString())
{
OleDbCommand guncel = new OleDbCommand("update admin set admin_pass='" + TextBox3.Text + "' where admin_id='" + Label2.Text + "' and admin_pass='" + TextBox2.Text + "'", bag);
guncel.ExecuteNonQuery();
Label1.Text = "Şifre değiştirme işlemi başarılı";
bag.Close();
break;
}
else
{ Label1.Text = "Şifre değiştirme işlemi başarısız"; }




}



************************
OTURUM KONTROL
************************
if (Session["oturum"] == null)
{ Response.Redirect("login.aspx"); }

else
Label2.Text = Session["oturum"].ToString();
}



**********************
HESABIMI KAPAT
**********************
OleDbConnection bag = new OleDbConnection();
bag.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/App_Data/osman.accdb"));
bag.Open();
OleDbCommand komut1 = new OleDbCommand("select admin_id from admin", bag);
OleDbDataReader oku = komut1.ExecuteReader();
while (oku.Read())
{
if (Label2.Text == oku[0].ToString())
{
OleDbCommand komut2 = new OleDbCommand("delete from admin where admin_id='" + Label2.Text + "' ", bag);
komut2.ExecuteReader();
bag.Close();
Label1.Text = "Hesabınız sistemden silinmiştir. görüşmek üzere";
Response.Redirect("login.aspx");
break;
}
}


******************************
ÇİFT TEK BULLETE ITEM
******************************
double girilen = Convert.ToInt32(TextBox1.Text);
if (girilen % 2 == 0)
{ cift.Items.Add(TextBox1.Text); }

else if(girilen % 2 ==1)
{ tek.Items.Add(TextBox1.Text); }


***********
RANDOM
***********
Random kod = new Random();
Label1.Text = Convert.ToString(kod.Next(1, 10000));