Quản lý website nghe nhạc xem videos ASP.net
5.716 lượt xem;
1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Web;
5 using System.Web.UI;
6 using System.Web.UI.WebControls;
7 using System.Data.SqlClient;
8 using System.Configuration;
9 using System.IO;
10
11 public partial class User : System.Web.UI.Page
12 {
13 public string act;
14 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SVR"].ConnectionString);
15 protected void Page_Load(object sender, EventArgs e)
16 {
17 act = null;
18 if (Request.QueryString.HasKeys())
19 {
20 act = Request.QueryString["cmd"].ToString();
21 }
22 string imL = null;
23 if (Session["DangNhap"] != null)
24 {
25 string insertquery = "Select * From UserDaTa Where TenDangNhap ='" + Session["DangNhap"] + "'";
26 con.Open();
27 SqlCommand cmd = new SqlCommand(insertquery, con);
28 SqlDataReader dr = cmd.ExecuteReader();
29 while (dr.Read())
30 {
31 imL = dr["Hinh"].ToString();
32 Lab_ten.Text = dr["HoTen"].ToString();
33 Lab_taikhoan.Text = dr["TenDangNhap"].ToString();
34 Lab_pass.Text=dr["MatKhau"].ToString();
35 Lab_ngaysinh.Text = dr["NamSinh"].ToString();
36 Lab_gioitinh.Text=dr["GioiTinh"].ToString();
37 Lab_chungminh.Text = dr["CMT"].ToString();
38 Lab_mail.Text = dr["Email"].ToString();
39 }
40 con.Close();
41 string imgL = "img_user/" + imL;
42 Image11.ImageUrl = imgL;
43 }
44 else
45 Response.Redirect("Login.aspx");
46 }
47 protected void btn_tenmoi_Click(object sender, EventArgs e)
48 {
49 con.Open();
50 string updatequery = "Update UserDaTa Set HoTen =N'" + txt_tenmoi.Text + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
51 SqlCommand cmd = new SqlCommand(updatequery, con);
52 cmd.ExecuteNonQuery();
53 con.Close();
54 Response.Redirect("User.aspx");
55
56 }
57 protected void btn_pass_Click(object sender, EventArgs e)
58 {
59 con.Open();
60 string updatequery = "Update UserDaTa Set MatKhau =N'" + txt_pass.Text + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
61 SqlCommand cmd = new SqlCommand(updatequery, con);
62 cmd.ExecuteNonQuery();
63 con.Close();
64 Response.Redirect("User.aspx");
65 }
66 protected void btn_ngaysinh_Click(object sender, EventArgs e)
67 {
68 string th = Drop_thang.SelectedValue.ToString();
69 string ng = Drop_ngay.SelectedValue.ToString();
70 string nam = txt_namsinh.Text;
71 string ns = th + "/" + ng + "/" + nam;
72 con.Open();
73 string updatequery = "Update UserDaTa Set NamSinh =N'" + ns + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
74 SqlCommand cmd = new SqlCommand(updatequery, con);
75 cmd.ExecuteNonQuery();
76 con.Close();
77 Response.Redirect("User.aspx");
78 }
79 protected void btn_gioitinh_Click(object sender, EventArgs e)
80 {
81 string gioitinh = Drop_Gioitinh.SelectedValue.ToString();
82 con.Open();
83 string updatequery = "Update UserDaTa Set GioiTinh =N'" + gioitinh + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
84 SqlCommand cmd = new SqlCommand(updatequery, con);
85 cmd.ExecuteNonQuery();
86 con.Close();
87 Response.Redirect("User.aspx");
88 }
89 protected void btn_chungminh_Click(object sender, EventArgs e)
90 {
91 con.Open();
92 string updatequery = "Update UserDaTa Set CMT =N'" + txt_chungminh.Text + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
93 SqlCommand cmd = new SqlCommand(updatequery, con);
94 cmd.ExecuteNonQuery();
95 con.Close();
96 Response.Redirect("User.aspx");
97 }
98 protected void btn_mail_Click(object sender, EventArgs e)
99 {
100 string email = txt_mail.Text;
101 string mail = Drop_mail.SelectedValue.ToString();
102 string m = email + "@" + mail;
103 con.Open();
104 string updatequery = "Update UserDaTa Set Email =N'" + m + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
105 SqlCommand cmd = new SqlCommand(updatequery, con);
106 cmd.ExecuteNonQuery();
107 con.Close();
108 Response.Redirect("User.aspx");
109 }
110 }
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Web;
5 using System.Web.UI;
6 using System.Web.UI.WebControls;
7 using System.Data.SqlClient;
8 using System.Configuration;
9 using System.IO;
10
11 public partial class User : System.Web.UI.Page
12 {
13 public string act;
14 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SVR"].ConnectionString);
15 protected void Page_Load(object sender, EventArgs e)
16 {
17 act = null;
18 if (Request.QueryString.HasKeys())
19 {
20 act = Request.QueryString["cmd"].ToString();
21 }
22 string imL = null;
23 if (Session["DangNhap"] != null)
24 {
25 string insertquery = "Select * From UserDaTa Where TenDangNhap ='" + Session["DangNhap"] + "'";
26 con.Open();
27 SqlCommand cmd = new SqlCommand(insertquery, con);
28 SqlDataReader dr = cmd.ExecuteReader();
29 while (dr.Read())
30 {
31 imL = dr["Hinh"].ToString();
32 Lab_ten.Text = dr["HoTen"].ToString();
33 Lab_taikhoan.Text = dr["TenDangNhap"].ToString();
34 Lab_pass.Text=dr["MatKhau"].ToString();
35 Lab_ngaysinh.Text = dr["NamSinh"].ToString();
36 Lab_gioitinh.Text=dr["GioiTinh"].ToString();
37 Lab_chungminh.Text = dr["CMT"].ToString();
38 Lab_mail.Text = dr["Email"].ToString();
39 }
40 con.Close();
41 string imgL = "img_user/" + imL;
42 Image11.ImageUrl = imgL;
43 }
44 else
45 Response.Redirect("Login.aspx");
46 }
47 protected void btn_tenmoi_Click(object sender, EventArgs e)
48 {
49 con.Open();
50 string updatequery = "Update UserDaTa Set HoTen =N'" + txt_tenmoi.Text + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
51 SqlCommand cmd = new SqlCommand(updatequery, con);
52 cmd.ExecuteNonQuery();
53 con.Close();
54 Response.Redirect("User.aspx");
55
56 }
57 protected void btn_pass_Click(object sender, EventArgs e)
58 {
59 con.Open();
60 string updatequery = "Update UserDaTa Set MatKhau =N'" + txt_pass.Text + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
61 SqlCommand cmd = new SqlCommand(updatequery, con);
62 cmd.ExecuteNonQuery();
63 con.Close();
64 Response.Redirect("User.aspx");
65 }
66 protected void btn_ngaysinh_Click(object sender, EventArgs e)
67 {
68 string th = Drop_thang.SelectedValue.ToString();
69 string ng = Drop_ngay.SelectedValue.ToString();
70 string nam = txt_namsinh.Text;
71 string ns = th + "/" + ng + "/" + nam;
72 con.Open();
73 string updatequery = "Update UserDaTa Set NamSinh =N'" + ns + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
74 SqlCommand cmd = new SqlCommand(updatequery, con);
75 cmd.ExecuteNonQuery();
76 con.Close();
77 Response.Redirect("User.aspx");
78 }
79 protected void btn_gioitinh_Click(object sender, EventArgs e)
80 {
81 string gioitinh = Drop_Gioitinh.SelectedValue.ToString();
82 con.Open();
83 string updatequery = "Update UserDaTa Set GioiTinh =N'" + gioitinh + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
84 SqlCommand cmd = new SqlCommand(updatequery, con);
85 cmd.ExecuteNonQuery();
86 con.Close();
87 Response.Redirect("User.aspx");
88 }
89 protected void btn_chungminh_Click(object sender, EventArgs e)
90 {
91 con.Open();
92 string updatequery = "Update UserDaTa Set CMT =N'" + txt_chungminh.Text + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
93 SqlCommand cmd = new SqlCommand(updatequery, con);
94 cmd.ExecuteNonQuery();
95 con.Close();
96 Response.Redirect("User.aspx");
97 }
98 protected void btn_mail_Click(object sender, EventArgs e)
99 {
100 string email = txt_mail.Text;
101 string mail = Drop_mail.SelectedValue.ToString();
102 string m = email + "@" + mail;
103 con.Open();
104 string updatequery = "Update UserDaTa Set Email =N'" + m + "' Where TenDangNhap ='" + Session["DangNhap"] + "'";
105 SqlCommand cmd = new SqlCommand(updatequery, con);
106 cmd.ExecuteNonQuery();
107 con.Close();
108 Response.Redirect("User.aspx");
109 }
110 }