public SearchPage() { this.InitializeComponent(); ListVideo = new ObservableCollection <Models.Video>(); ListChanel = new ObservableCollection <Models.Chanel>(); ListPlaylist = new ObservableCollection <Models.Playlist>(); conn = new Models.SqlConnection(); conn.LoadDatabase(); }
public ListVideo() { this.InitializeComponent(); conn = new Models.SqlConnection(); VideoLiked = new ObservableCollection <Models.Video>(); VideoPlaylist = new ObservableCollection <Models.Video>(); conn.LoadDatabase(); this.GetLikedVideo(); }
private void loadLoai() { lblID.Text = " ID của bạn: " + Session["userid"].ToString(); Models.SqlConnection cn = new Models.SqlConnection(); DataTable dt = new DataTable(); string query = String.Format("SELECT fullname,email,phone,birthdate,uWardid,uDistrictid,uProvinceid FROM accountUser WHERE userid =" + "'" + Session["userid"].ToString() + "'"); dt = cn.getData(query); foreach (DataRow item in dt.Rows) { txtFullnaem.Text = item["fullname"].ToString(); txtPhone.Text = item["phone"].ToString(); txtEmail.Text = item["email"].ToString(); txtBirthdate1.Text = item["birthdate"].ToString(); txtDistrictID.Text = item["uDistrictid"].ToString(); txtWardID.Text = item["uWardid"].ToString(); txtProvinceID.Text = item["uProvinceid"].ToString(); } // txtFullnaem.Text = "cc"; }