asp.net+sql精品课程管理平台系统论文+源代码+答辩PPT 第5页

  SqlConnection cn = new SqlConnection();
                cn.ConnectionString = "Data Source=127.0.0.1;Initial Catalog=Excellent courses;uid=sa;pwd=";
                string str = "select onedhid,onedhname,onepic,state from main where twodhid=" + t1 + "and state=" + t2 + "";
                SqlDataAdapter rst = new SqlDataAdapter(str, cn);
                cn.Open();
                DataSet rdt = new DataSet();
                rst.Fill(rdt);
                repeater2.DataSource = rdt;
                repeater2.DataBind();

                string str2 = "select onedhname,onepic,ncontent,onedhid,state from main where  twodhid=" + id + "and state="+t2+""; 论文网http://www.youerw.com/

                SqlDataAdapter rst1 = new SqlDataAdapter(str2, cn);
                DataSet rdt1 = new DataSet();
                rst1.Fill(rdt1);
                repeater1.DataSource = rdt1;
                repeater1.DataBind();

                string str3 = "select onedhname,state from main where onedhid=" + id + "and state=" + t2 + "";
                SqlCommand cmd2 = new SqlCommand(str3, cn);

                SqlDataReader mysdr = cmd2.ExecuteReader();

                while (mysdr.Read())
                {
                    Label8.Text = mysdr["onedhname"].ToString();
                    Label6.Text = mysdr["onedhname"].ToString();
                }

                cn.Close();

                string id12 = Request.QueryString["id"] + "";
                SqlConnection cn1 = new SqlConnection();
                cn1.ConnectionString = "Data Source=127.0.0.1;Initial Catalog=Excellent courses;uid=sa;pwd=";论文网http://www.youerw.com/
                cn1.Open();
                string str1 = "select onedhname,onepic,ncontent,onedhid from main where  twodhid=" + id12 + "order by onedhid desc";

                SqlCommand cmd1 = new SqlCommand(str1, cn1);

                SqlDataReader mysdr2 = cmd1.ExecuteReader();

                while (mysdr2.Read())
                {
                    Label4.Text = "<br>" + mysdr2["ncontent"].ToString();
                    Label5.Text = mysdr2["onedhname"].ToString();
                    Label7.Text = mysdr2["onedhname"].ToString();

上一页  [1] [2] [3] [4] [5] 

asp.net+sql精品课程管理平台系统论文+源代码+答辩PPT 第5页下载如图片无法显示或论文不完整，请联系qq752018766