Logine (code normal)
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into tarik
values('"+TextBox1.Text+"','"+TextBox2.Text+"')";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = con;
cmd.ExecuteNonQuery();
Logine (code session)
Session["login"] = TextBox1.Text;
Session["password"] = TextBox2.Text;
if (Session["login"] == "tarik" && Session["password"] == "tarik")
{
Response.Redirect("tarik.aspx");
}
Logine + password :
HttpCookie x = new HttpCookie("a");
x.Values.Add("login", TextBox1.Text);
x.Values.Add("mp", TextBox2.Text);
Response.Cookies.Add(x);
x.Expires = DateTime.Now.AddHours(1);
recuper logine + password
HttpCookie x = new HttpCookie("a");
x = Request.Cookies["a"];
TextBox4.Text = x.Values.Get("login");
TextBox3.Text = x.Values.Get("mp");
Afficher IP :
TextBox1.Text = Request.ServerVariables["Remote_ADDR"];
Afficher langue :
TextBox6.Text = Request.ServerVariables["HTTP_Accept_language"];
messageBox ;
string a = TextBox7.Text.ToString();
Response.Write("<script> alert('" + a + "');</script>");
Nombre viisiteur :
Application_Start
{
Application["User "]=0;
}
Session_Start
{
Int a;
a=int.Parse(Application["nb_user"].ToString());
a=a+1;
Application["nb_user"]=a;
}
TextBox8.Text = Application["User"].ToString();
Telecharger fichier : (FileUpload1)
string a = Server.MapPath("uploads/");
string nomfichier;
if (FileUpload1.HasFile == true)
{
nomfichier = FileUpload1.FileName;
FileUpload1.SaveAs(a + nomfichier);
}
Page_Load
{
if (Page.IsPostBack == false)
{
charger();
}
}
SelectedIndexChanged
{
TextBox1.Text = GridView1.SelectedRow.Cells[3].Text;
TextBox2.Text = GridView1.SelectedRow.Cells[4].Text;
charger();
}
public void charger()
{
SqlConnection con = new
SqlConnection("server=.;database=gestion_peche;integrated security=true");
SqlDataAdapter da = new SqlDataAdapter("select * from poisson",con);
DataSet ds = new DataSet();
da.Fill(ds);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
}
RowEditing {
//pour editer
this.GridView1.EditIndex = e.NewEditIndex;
charger();
}
RowCancelingEdit {
//pour annulerl'edition
this.GridView1.EditIndex = -1;
charger();
}
RowDeleting
{
SqlConnection con = new
SqlConnection("server=.;database=gestion_peche;integrated security=true");
con.Open();
string t = GridView1.Rows[e.RowIndex].Cells[3].Text;
SqlParameter p = new SqlParameter("@num",int.Parse(t));
SqlCommandcmd = new SqlCommand("delete from poisson where
num_poisson=@num", con);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
con.Close();
charger();
}
RowUpdating
{
SqlConnection con = new
SqlConnection("server=.;database=gestion_peche;integrated security=true");
con.Open();
TextBox t1 = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0];
TextBox t2 = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0];
SqlParameter p1 = new SqlParameter("@num",int.Parse(t1.Text));
SqlParameter p2 = new SqlParameter("@nom",t2.Text);
SqlCommandcmd = new SqlCommand("update poisson set nom_poisson=@nom from
poisson where num_poisson=@num",con);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
charger();
}
}
foreach (GridViewRow g in GridView2.Rows)
{
CheckBox cb = (CheckBox)g.FindControl("CheckBox1");
if (cb.Checked == true)
{
int a = int.Parse(g.Cells[1].Text);
SqlConnection con = new
SqlConnection("server=.;database=gestion_peche;integrated security=true");
con.Open();
SqlParameter p = new SqlParameter("@num",a);
SqlCommand cmd = new SqlCommand("delete poisson from
poisson where num_poisson=@num", con);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
con.Close();
charger();
}
}
