private void BindDataList(string i) { string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString; using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "SELECT VIDEO_ID, VIDE0_TITLE,VIDEO_FOR_CLASS,VIDEO_SUBJECT FROM TBL_VIDEO_UPLOAD WHERE VIDEO_UPLOAD_TYPE ='TEACHER' AND USER_ID=@Id"; cmd.Parameters.AddWithValue("@Id", i); cmd.Connection = con; con.Open(); DataListvideo.DataSource = cmd.ExecuteReader(); DataListvideo.DataBind(); con.Close(); } } }
private void BindDataList() { string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString; using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "SELECT YOU_ID,YOUTUBE_TITLE,YOUTUBE_SUBJECT,YOUTUBE_CLASS,YOUTUBE_TEACHER_ID,YOUTUBE_LINK,YSTART,YEND FROM TBL_YOUTUBE_VIDEOS WHERE YOUTUBE_TEACHER_ID=@Id "; double I = Convert.ToDouble(userkey); cmd.Parameters.AddWithValue("@Id", I); cmd.Connection = con; con.Open(); DataListvideo.DataSource = cmd.ExecuteReader(); DataListvideo.DataBind(); con.Close(); } } }