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();
}
}
}
