예제 #1
0
    private void uptonext()
    {
        cn.Open();



        SqlCommand cmd1 = cn.CreateCommand();

        cmd1.CommandType = CommandType.Text;
        cmd1.CommandText = "select *from videos where id='" + Request.QueryString["id"] + "' ";
        cmd1.ExecuteScalar();
        DataSet        ds1 = new DataSet();
        SqlDataAdapter da1 = new SqlDataAdapter(cmd1);

        da1.Fill(ds1);

        SqlCommand cmd2 = cn.CreateCommand();

        cmd2.CommandType = CommandType.Text;

        cmd2.CommandText = "select *from videos where category like '%" + ds1.Tables[0].Rows[0]["category"].ToString() + "%'";
        cmd2.ExecuteScalar();
        DataSet        ds2 = new DataSet();
        SqlDataAdapter da2 = new SqlDataAdapter(cmd2);

        da2.Fill(ds2);

        Repeater3.DataSource = ds2;
        Repeater3.DataBind();
        cn.Close();
    }
 private void llenarvista()
 {
     Repeater3.DataSource = ord.Consultarordenesencuro();
     Repeater3.DataBind();
     Repeater4.DataSource = ord.Consultarordenescerradas();
     Repeater4.DataBind();
 }
예제 #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //DataSet is an in-memory cache of data retrieved from a data source
        //step 1: create Dataset with a GET method
        DataSet datathriller     = GetDataThriller();
        DataSet datafiction      = GetDataFiction();
        DataSet datapaperbacks   = GetDataPaperbacks();
        DataSet datayoungreaders = GetDataYoungReaders();
        DataSet datateens        = GetDataTeens();

        //DataSource is used to pull the data from the database and populate them
        //step 8: pull data using DataSource
        Repeater1.DataSource = datathriller;
        Repeater2.DataSource = datafiction;
        Repeater3.DataSource = datapaperbacks;
        Repeater4.DataSource = datayoungreaders;
        Repeater5.DataSource = datateens;

        //step 9: bind the data to the repeater
        Repeater1.DataBind();
        Repeater2.DataBind();
        Repeater3.DataBind();
        Repeater4.DataBind();
        Repeater5.DataBind();
    }
예제 #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["pid"] != null)
        {
            Session["pid"] = null;
        }



        SqlDataAdapter adp = new SqlDataAdapter("select * from products order by newid()", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
        DataSet        ds  = new DataSet();

        adp.Fill(ds, 0, 9, "products");
        Repeater1.DataSource = ds;
        Repeater1.DataBind();
        Repeater1.DataBind();


        SqlDataAdapter adp2 = new SqlDataAdapter("select * from products order by newid()", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
        DataSet        ds2  = new DataSet();

        adp2.Fill(ds2, 0, 4, "products");

        Repeater2.DataSource = ds2;
        Repeater2.DataBind();

        SqlDataAdapter adp3 = new SqlDataAdapter("select * from products order by newid()", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
        DataSet        ds3  = new DataSet();

        adp3.Fill(ds3, 0, 4, "products");
        Repeater3.DataSource = ds3;
        Repeater3.DataBind();
    }
예제 #5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            DataSetTableAdapters.TBLHAKKIMDATableAdapter dt = new DataSetTableAdapters.TBLHAKKIMDATableAdapter();
            Repeater1.DataSource = dt.HakkimdaListele();
            Repeater1.DataBind();

            DataSetTableAdapters.TBLDENEYIMTableAdapter dtDeneyim = new DataSetTableAdapters.TBLDENEYIMTableAdapter();
            Repeater2.DataSource = dtDeneyim.DeneyimListesi();
            Repeater2.DataBind();

            DataSetTableAdapters.TBLEGITIMTableAdapter dtEgitim = new DataSetTableAdapters.TBLEGITIMTableAdapter();
            Repeater3.DataSource = dtEgitim.EgitimListesi();
            Repeater3.DataBind();

            DataSetTableAdapters.TBLHOBILERTableAdapter dtHobiler = new DataSetTableAdapters.TBLHOBILERTableAdapter();
            Repeater5.DataSource = dtHobiler.HobilerListele();
            Repeater5.DataBind();

            DataSetTableAdapters.TBLODULLERTableAdapter dtOdul = new DataSetTableAdapters.TBLODULLERTableAdapter();
            Repeater6.DataSource = dtOdul.OdulListesi();
            Repeater6.DataBind();

            DataSetTableAdapters.TBLYETENEKLERTableAdapter dtYetenek = new DataSetTableAdapters.TBLYETENEKLERTableAdapter();
            Repeater4.DataSource = dtYetenek.YetenekListesi();
            Repeater4.DataBind();

            DataSetTableAdapters.TBLHAKKIMDATableAdapter dtFotograf = new DataSetTableAdapters.TBLHAKKIMDATableAdapter();
            Repeater8.DataSource = dtFotograf.HakkimdaListele();
            Repeater8.DataBind();
        }
예제 #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Login())
            {
                if ((Request.QueryString["id1"] != null && Request.QueryString["id1"].Length != 0))
                {
                    Repeater1.DataSource = DatabaseConnection.SecureCreateDataset("SELECT COMPANYNAME, EMAIL, SHIPMENTEMAIL, WAREHOUSEEMAIL FROM BASE_COMPANIES WHERE EMAIL<>'' AND ID=@ID", new DbSqlParameter("@ID", int.Parse(Request.QueryString["id1"]).ToString()));
                }
                if ((Request.QueryString["id2"] != null && Request.QueryString["id2"].Length != 0))
                {
                    Repeater2.DataSource = DatabaseConnection.SecureCreateDataset("SELECT NAME, SURNAME, EMAIL FROM BASE_CONTACTS WHERE EMAIL<>'' AND ID=@ID", new DbSqlParameter("@ID", int.Parse(Request.QueryString["id2"]).ToString()));
                }
                if ((Request.QueryString["id3"] != null && Request.QueryString["id3"].Length != 0))
                {
                    Repeater3.DataSource = DatabaseConnection.SecureCreateDataset("SELECT NAME, SURNAME, COMPANYNAME, EMAIL FROM CRM_LEADS WHERE EMAIL<>'' AND ID=@ID", new DbSqlParameter("@ID", int.Parse(Request.QueryString["id3"]).ToString()));
                }
                Repeater1.DataBind();
                Repeater2.DataBind();
                Repeater3.DataBind();

                if (Repeater1.Items.Count == 0 && Repeater2.Items.Count == 0 && Repeater3.Items.Count == 0)
                {
                    Info.Text = Root.rm.GetString("NoMail");
                }
            }
        }
예제 #7
0
        protected void dsCart_OnLoad(object sender, EventArgs e)
        {
            DataTable cart = Session["cart_items"] as DataTable;

            Repeater3.DataSource = cart;
            Repeater3.DataBind();
        }
예제 #8
0
    public void databind()
    {
        try
        {
            int     c   = 1;
            string  str = "select top 10 * from product where _special_offer=" + c + "";
            DataSet ds  = DB.dataSet(str);
            Repeater4.DataSource = ds.Tables[0];
            Repeater4.DataBind();
            /*----------------- hot--------------*/

            string  str2 = @"select * from product where _id
                      in (select top 10 _product_id from orderdetail group by _product_id order by sum(_product_count) )";
            DataSet ds2  = DB.dataSet(str2);
            Repeater2.DataSource = ds2;
            Repeater2.DataBind();
            /*----------------- time--------------*/
            string  str3 = "select top 10 * from product order by _id desc";
            DataSet ds3  = DB.dataSet(str3);
            Repeater3.DataSource = ds3.Tables[0];
            Repeater3.DataBind();
        }
        catch
        {
        }
    }
예제 #9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string cookiename = null;
                try
                {
                    //通过存入的cookie来判断是否登录过
                    FormsAuthenticationTicket ticke = null;
                    string user = Request.Cookies["user"].Value;
                    ticke        = FormsAuthentication.Decrypt(user);
                    cookiename   = ticke.Name;
                    lblogin.Text = "欢迎您!" + cookiename;
                }
                catch (Exception)
                {
                    if (cookiename == null)
                    {
                        lblogin.Text = "还没登陆,请登录!";
                    }
                }

                //登录完成,右上角显示临时购物车
                Repeater3.DataSource = BLL.UserBLL.CartList(cookiename);
                Repeater3.DataBind();

                //购物车数量
                num = BLL.UserBLL.CountNum(cookiename);

                //分类展示
                Repeater1.DataSource = BLL.UserBLL.CategoryList();
                Repeater1.DataBind();
            }
        }
예제 #10
0
        public void SetSameFamous()
        {
            DataSet m_ds = AstroBiz.GetInstance().GetSameFamous(m_astro);

            if (m_ds != null && m_ds.Tables.Count == 15)
            {
                SortedList m_star  = PublicValue.GetAstroStar();
                DataTable  m_stars = new DataTable();
                m_stars.Columns.Add("starname");
                m_stars.Columns.Add("gong");
                for (int i = 0; i < 10; i++)
                {
                    DataRow m_dr = m_stars.NewRow();
                    m_dr["starname"] = m_star[i + 1];
                    m_dr["gong"]     = m_astro.Stars[i].Gong;
                    m_stars.Rows.Add(m_dr);
                }



                for (int i = 5; m_star.Count > 5;)
                {
                    m_star.RemoveAt(i);
                }

                ViewState["samefamous"] = m_ds;
                Repeater1.DataSource    = m_star;
                Repeater1.DataBind();

                Repeater3.DataSource = m_stars;
                Repeater3.DataBind();
            }
        }
예제 #11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var bloglar = from s in db.TBLBLOCG.ToList()
                          orderby s.BLOGID descending
                          select s;

            if (!IsPostBack)
            {
                lGetBlog();
            }
            var bloglarRight = (from s in db.TBLBLOCG
                                orderby s.BLOGID descending
                                select s).Take(5).ToList();

            Repeater3.DataSource = bloglarRight;
            Repeater3.DataBind();

            var category = db.TBLCATEGORY.ToList();

            Repeater2.DataSource = category;
            Repeater2.DataBind();

            var commRight = (from c in db.TBLCOMMENT
                             orderby c.CMTID descending
                             select c).Take(5).ToList();

            RepSonComment.DataSource = commRight;
            RepSonComment.DataBind();
        }
예제 #12
0
        private void bindApp()
        {
            DataView dvApp = Epoint.MisBizLogic2.DB.ExecuteDataView("select AppGuid,AppName from RG_Application order by OrderNum desc");

            Repeater3.DataSource = dvApp;
            Repeater3.DataBind();
        }
예제 #13
0
        protected void search_btn3_Click(object sender, EventArgs e)
        {
            string        connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
            SqlConnection conn    = new SqlConnection(connStr);

            //string sql = "select no رقم_القائمة ,   CONVERT(DATE , date, 102) تاريخ ,type, work ملاحظة ,FORMAT([money], 'C', 'en-us')   المبلغ ,FORMAT([money], 'N', 'en-us')         from  [e_work]  where(CONVERT(DATE , date, 102)   between '" + date1.Value + "'  and '" + date2.Value + "') and type =N'" + cmbTypes.SelectedValue + "'";


            string sql = "SELECT  type ,  FORMAT(sum(money), 'C', 'en-us') AS المبلغ  , FORMAT(sum(money), 'N', 'en-us') AS المبلغ1 FROM   e_work where( [date] between '" + date1.Value + "'  and '" + date2.Value + "') GROUP BY type";



            SqlDataAdapter adap = new SqlDataAdapter(sql, conn);
            DataTable      dt   = new DataTable();

            adap.Fill(dt);

            Repeater3.DataSource = dt;
            Repeater3.DataBind();

            double total = 0;

            foreach (DataRow row in dt.Rows)
            {
                double x = Convert.ToDouble(row[1].ToString().Replace("$", ""));
                total += x;
            }
            lblTotal3.Text    = Math.Round(total, 2).ToString() + "$";
            lblDateFrom3.Text = date1.Value;
            lblDateTo3.Text   = date2.Value;

            report1.Visible = false;
            report2.Visible = false;
            report3.Visible = true;
        }
예제 #14
0
 public void llenarProyectos()
 {
     mod_gi.idGrupoInvestigacion = Session["IdGrupo_pag"].ToString();
     DT_Grupo             = mod_grupo.consultarProyectosAct(mod_gi);
     Repeater3.DataSource = DT_Grupo;
     Repeater3.DataBind();
 }
예제 #15
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            txtwuliao.Text = "";
            txtFModel.Text = "";
            string  FNumber  = txtFNumber_xx.Text;
            string  FName    = txtFName_xx.Text;
            string  FModel   = txtFModel_xx.Text;
            decimal Amount   = string.IsNullOrEmpty(txtAmount_xx.Text) ? 0 : Convert.ToDecimal(txtAmount_xx.Text);
            decimal Price    = Convert.ToDecimal(txtPrice_xx.Text);
            decimal Total    = string.IsNullOrEmpty(txtTotal_xx.Text) ? 0 : Convert.ToDecimal(txtTotal_xx.Text);
            int     FInterID = Convert.ToInt32(danju_no.Text);

            if (Total > 0)
            {
                //新增物料
                string sql = string.Format(@"insert into fahuodan_wl(FNumber,FName,FModel,Amount,Price,Total,FInterID) 
                VALUES('{0}','{1}','{2}',{3},{4},{5},{6})", FNumber, FName, FModel, Amount, Price, Total, FInterID);
                SqlHelper1.ExecteNonQueryText(sql, null);
                //Response.Write("<script>alert('物料添加成功!');location='javascript:history.go(-1);'</script>");
                txtwuliao.Focus();
                //查询物料显示在表3
                sql = string.Format(@"select FName,FModel,Amount,Price,Total from fahuodan_wl where FInterID={0} order by Id desc", FInterID);
                DataTable dt = SqlHelper1.getTable(sql, null);
                Repeater3.DataSource = dt;
                Repeater3.DataBind();
            }
            else
            {
                Response.Write("<script>alert('金额为零,请点击金额计算按钮!');location='javascript:history.go(-1);'</script>");
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            DataSet1TableAdapters.HAKKIMDATableAdapter dt = new DataSet1TableAdapters.HAKKIMDATableAdapter();
            Repeater1.DataSource = dt.HakkımdaListele();
            Repeater1.DataBind();


            DataSet1TableAdapters.DENEYIMTableAdapter dt1 = new DataSet1TableAdapters.DENEYIMTableAdapter();
            Repeater2.DataSource = dt1.DeneyimListele();
            Repeater2.DataBind();

            DataSet1TableAdapters.EGITIMTableAdapter dt2 = new DataSet1TableAdapters.EGITIMTableAdapter();
            Repeater3.DataSource = dt2.EgitimListesi();
            Repeater3.DataBind();

            DataSet1TableAdapters.YETENEKLERTableAdapter dt3 = new DataSet1TableAdapters.YETENEKLERTableAdapter();
            Repeater4.DataSource = dt3.YetenekListele();
            Repeater4.DataBind();

            DataSet1TableAdapters.HOBILERTableAdapter dt4 = new DataSet1TableAdapters.HOBILERTableAdapter();
            Repeater5.DataSource = dt4.HobiListesi();
            Repeater5.DataBind();

            DataSet1TableAdapters.KONFERANSTableAdapter dt5 = new DataSet1TableAdapters.KONFERANSTableAdapter();
            Repeater6.DataSource = dt5.KonferansListele();
            Repeater6.DataBind();
        }
예제 #17
0
        public void RoomDataBind()
        {
            string           constr = ConfigurationManager.ConnectionStrings["HotelConString"].ConnectionString;
            SQLiteConnection con    = new SQLiteConnection(constr);

            con.Open();

            string            query = "select room.id,roomtype,info,charge,customer.name,customer.id as customerid from room,customer  where room.customer_id=customer.id;";
            SQLiteCommand     cmd   = new SQLiteCommand(query, con);
            SQLiteDataAdapter sda   = new SQLiteDataAdapter(cmd);
            DataTable         dt    = new DataTable();

            sda.Fill(dt);
            Repeater1.DataSource = dt;
            Repeater1.DataBind();
            query = "select id,roomtype,info,charge from room where customer_id is NULL;";
            SQLiteCommand     cmd2 = new SQLiteCommand(query, con);
            SQLiteDataAdapter sda2 = new SQLiteDataAdapter(cmd2);
            DataTable         dt2  = new DataTable();

            sda2.Fill(dt2);
            Repeater3.DataSource = dt2;
            Repeater3.DataBind();

            con.Close();
        }
예제 #18
0
        protected void OnUpdate(object sender, EventArgs e)
        {
            //Find the reference of the Repeater Item.
            RepeaterItem item          = (sender as LinkButton).Parent as RepeaterItem;
            int          ID            = int.Parse((item.FindControl("lblID") as Label).Text);
            string       subject       = (item.FindControl("txtSubj") as TextBox).Text.Trim();
            string       homework      = (item.FindControl("txtHomework") as TextBox).Text.Trim();
            var          checkHomework = (from c in db.Homeworks where c.ID.Equals(ID) select c).FirstOrDefault();

            checkHomework.Subject   = subject;
            checkHomework.Homework1 = homework;
            db.SubmitChanges();
            Repeater1.DataBind();
            Repeater2.DataBind();
            Repeater3.DataBind();
            Repeater4.DataBind();
            Repeater5.DataBind();
            Repeater6.DataBind();
            Repeater7.DataBind();
            Repeater8.DataBind();
            Repeater8.DataBind();
            Repeater9.DataBind();
            Repeater10.DataBind();
            Repeater11.DataBind();
            Repeater12.DataBind();
            Repeater13.DataBind();
            Repeater14.DataBind();
            Repeater15.DataBind();
        }
예제 #19
0
        protected void OnDelete(object sender, EventArgs e)
        {
            //Find the reference of the Repeater Item.
            RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
            int          ID   = int.Parse((item.FindControl("lblID") as Label).Text);

            var checkHomework = (from c in db.Homeworks where c.ID.Equals(ID) select c).FirstOrDefault();

            db.Homeworks.DeleteOnSubmit(checkHomework);
            db.SubmitChanges();
            Repeater1.DataBind();
            Repeater2.DataBind();
            Repeater3.DataBind();
            Repeater4.DataBind();
            Repeater5.DataBind();
            Repeater6.DataBind();
            Repeater7.DataBind();
            Repeater8.DataBind();
            Repeater8.DataBind();
            Repeater9.DataBind();
            Repeater10.DataBind();
            Repeater11.DataBind();
            Repeater12.DataBind();
            Repeater13.DataBind();
            Repeater14.DataBind();
            Repeater15.DataBind();
        }
예제 #20
0
    protected void bindElit()
    {
        DataTable dt = b_Ask.Sel("Elite=1", "ID desc", null);

        Repeater3.DataSource = dt;
        Repeater3.DataBind();
    }
예제 #21
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         using (var db = new CstwebEntities())
         {
             var se1 = from it in db.news
                       where it.@class == 14
                       orderby it.time descending
                       select it;
             Repeater1.DataSource = se1.Take(7).ToList();
             var se2 = from it in db.news
                       where it.@class == 1
                       orderby it.time descending
                       select it;
             Repeater2.DataSource = se2.Take(7).ToList();
             var se3 = from it in db.news
                       where it.@class == 4
                       orderby it.time descending
                       select it;
             Repeater3.DataSource = se3.Take(7).ToList();
             Repeater1.DataBind();
             Repeater2.DataBind();
             Repeater3.DataBind();
         }
     }
 }
예제 #22
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = Session["user"].ToString();

        ArrayList names = new ArrayList {
            "@user"
        };
        ArrayList values = new ArrayList {
            Session["user"].ToString()
        };

        DataSet ds = Database.RunSP("sp_icons_selectSome", names, values);


        Repeater1.DataSource = ds;
        Repeater1.DataBind();
        //Response.Write(Session["user"]);

        ArrayList names1  = new ArrayList {
        };
        ArrayList values1 = new ArrayList {
        };
        //this is the table from the recommended sites
        DataSet ds1 = Database.RunSP("sp_Rec_selectAll", names1, values1);

        Repeater2.DataSource = ds1;
        Repeater2.DataBind();

        Repeater3.DataSource = ds1;
        Repeater3.DataBind();

        Repeater4.DataSource = ds1;
        Repeater4.DataBind();
    }
예제 #23
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            int id;
            if (!int.TryParse(Request.QueryString["id"], out id))
            {
                Response.Redirect("~/MediaCenter.aspx");
            }
            Database db   = new Database();
            Lang     lang = new Lang();
            db.AddParameter("@lang", lang.getCurrentLang());
            DataTable dt = db.ExecuteDataTable("select top(3) * from SocialEvent where lang=@lang Order by id desc");
            Repeater2.DataSource = dt;
            Repeater2.DataBind();

            db.AddParameter("@lang", lang.getCurrentLang());
            dt = db.ExecuteDataTable("select top(3) * from news where lang=@lang Order by id desc");
            Repeater1.DataSource = dt;
            Repeater1.DataBind();

            db.AddParameter("@lang", lang.getCurrentLang());
            db.AddParameter("@id", id);
            dt = db.ExecuteDataTable("select * from news where lang=@lang and id=@id");
            Repeater3.DataSource = dt;
            Repeater3.DataBind();

            if (dt.Rows.Count == 0)
            {
                Response.Redirect("~/MediaCenter.aspx");
            }
        }
    }
예제 #24
0
    /// <summary>
    /// 工程项目考核汇总表
    /// </summary>
    private void Bindgcxmkhhzb()
    {
        string  strsql = "select * from tunnel_newstype where IsDel=0 and parentid=21";
        DataSet das    = Tunnel.Data.DbHelperSQL.Query(strsql);

        if (das.Tables[0].Rows.Count > 0)
        {
            Repeater10.DataSource = das;
            Repeater10.DataBind();
            Repeater10.Visible = true;
            string  strsql2 = "select top " + gettop(8 - das.Tables[0].Rows.Count) + " * from tunnel_index where typeid=21 and del=0 and IsDel=0 order by setdate desc ";
            DataSet das2    = Tunnel.Data.DbHelperSQL.Query(strsql2);
            Repeater3.DataSource = das2;
            Repeater3.DataBind();
        }
        else
        {
            string  strsql2 = "select top 8 * from tunnel_index where typeid=21 and del=0 and IsDel=0 order by setdate desc";
            DataSet das2    = Tunnel.Data.DbHelperSQL.Query(strsql2);
            Repeater3.DataSource = das2;
            Repeater3.DataBind();
            Repeater3.Visible  = true;
            Repeater10.Visible = false;
        }
    }
예제 #25
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
         StuNum          = new CourseManege().QueryStuNum(CourseId);
         coursename.Text = (new CourseManege().queryCourseById(CourseId)).CourseName;
         List <Model.Class> clalist = new CourseManege().queryClassByCourseId(CourseId);
         string             ClassId;
         foreach (Model.Class Class in clalist)
         {
             ClassId = Class.ClassId;
             ddlclass.Items.Add(ClassId);
         }
         List <Students> stulist = new StudentManage().queryStudentByCourseId(CourseId);
         foreach (Students stu in stulist)
         {
             stu.KqNum = new KqManage().queryStuKqNum(stu.StuId, CourseId);
             stu.HwNum = new HomeworkManage().queryStuHwNum(stu.StuId, CourseId);
         }
         Repeater1.DataSource = stulist;
         Repeater1.DataBind();
         List <Homework> HwList = new HomeworkManage().queryAllHKByTea(CourseId);
         DataList2.DataSource = HwList;
         DataList2.DataBind();
         List <KQ> KqList = new KqManage().queryAllKq(CourseId);
         Repeater2.DataSource = KqList;
         Repeater2.DataBind();
         List <JXGG> gglist = new GGManage().LookJXGG(CourseId);
         Repeater3.DataSource = gglist;
         Repeater3.DataBind();
     }
 }
예제 #26
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string strQuery = "";

        if (Request.QueryString["Id"] != null)
        {
            strQuery = Request.QueryString["Id"].ToString();
        }

        Call_Database ChapelDB = new Call_Database();

        Repeater1.DataSource = ChapelDB.dbChapelBuilding;
        Repeater1.DataBind();

        Repeater2.DataSource = ChapelDB.dbHarmonyWall;
        Repeater2.DataBind();

        Repeater3.DataSource = ChapelDB.dbHopeWall;
        Repeater3.DataBind();

        Repeater4.DataSource = ChapelDB.dbFaithWall;
        Repeater4.DataBind();

        Repeater5.DataSource = ChapelDB.dbGraceWall;
        Repeater5.DataBind();

        Repeater6.DataSource = ChapelDB.dbPeaceWall;
        Repeater6.DataBind();

        Repeater7.DataSource = ChapelDB.dbChairsBenches;
        Repeater7.DataBind();
    }
예제 #27
0
        protected void Page_Load(object sender, EventArgs e)
        {
            DataSet1TableAdapters.HakkimdaTableAdapter dt = new DataSet1TableAdapters.HakkimdaTableAdapter();
            Repeater1.DataSource = dt.HakkimdaListele();
            Repeater1.DataBind();


            DataSet1TableAdapters.DeneyimlerTableAdapter dt2 = new DataSet1TableAdapters.DeneyimlerTableAdapter();
            Repeater2.DataSource = dt2.DeneyimListesi();
            Repeater2.DataBind();

            DataSet1TableAdapters.EgitimTableAdapter dt3 = new DataSet1TableAdapters.EgitimTableAdapter();
            Repeater3.DataSource = dt3.EgitimListele();
            Repeater3.DataBind();

            DataSet1TableAdapters.OdullerimTableAdapter dt4 = new DataSet1TableAdapters.OdullerimTableAdapter();
            Repeater4.DataSource = dt4.OdullerimListele();
            Repeater4.DataBind();

            DataSet1TableAdapters.HobilerimTableAdapter dt5 = new DataSet1TableAdapters.HobilerimTableAdapter();
            Repeater5.DataSource = dt5.HobilerListele();
            Repeater5.DataBind();

            DataSet1TableAdapters.YeteneklerimTableAdapter dt6 = new DataSet1TableAdapters.YeteneklerimTableAdapter();
            Repeater6.DataSource = dt6.YeteneklerimDoldur();
            Repeater6.DataBind();
        }
예제 #28
0
        protected void LinkButton1_Command(object sender, CommandEventArgs e)
        {
            string cookiename = null;

            try
            {
                //再用户添加购物车时,先判断用户有没有登录,如果没有登录则跳转至登录页面,再进行添加购物车操作
                FormsAuthenticationTicket ticke = null;
                string user = Request.Cookies["user"].Value;
                ticke      = FormsAuthentication.Decrypt(user);
                cookiename = ticke.Name;
            }
            catch (Exception) {
                Response.Redirect("account.aspx");
            }
            if (cookiename != null)
            {
                //有cookie则进行添加购物车操作
                string    id       = e.CommandArgument.ToString();
                DataTable data     = BLL.UserBLL.QueryInfo(id);
                string    name     = data.Rows[0]["Name"].ToString();
                string    newImage = "../" + data.Rows[0]["NewImage"];
                decimal   newPrice = Convert.ToDecimal(data.Rows[0]["Newprice"]);
                BLL.UserBLL.AddToCart(newImage, name, newPrice, cookiename);

                Repeater3.DataSource = BLL.UserBLL.CartList(cookiename);
                Repeater3.DataBind();

                num = BLL.UserBLL.CountNum(cookiename);
            }
        }
예제 #29
0
        protected void Page_Load(object sender, EventArgs e)
        {
            DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
            Repeater1.DataSource = dt.HakkımdaListele();
            Repeater1.DataBind();

            DataSet1TableAdapters.TBLDENEYIMTableAdapter dt2 = new DataSet1TableAdapters.TBLDENEYIMTableAdapter();
            Repeater2.DataSource = dt2.DeneyimListesi();
            Repeater2.DataBind();

            DataSet1TableAdapters.TBLEGITIMTableAdapter dt3 = new DataSet1TableAdapters.TBLEGITIMTableAdapter();
            Repeater3.DataSource = dt3.EgitimListesi();
            Repeater3.DataBind();

            DataSet1TableAdapters.TBLYETENEKLERTableAdapter dt4 = new DataSet1TableAdapters.TBLYETENEKLERTableAdapter();
            Repeater4.DataSource = dt4.YetenekListesi();
            Repeater4.DataBind();

            DataSet1TableAdapters.TBLHOBILERTableAdapter dt5 = new DataSet1TableAdapters.TBLHOBILERTableAdapter();
            Repeater5.DataSource = dt5.HobiListesi();
            Repeater5.DataBind();

            DataSet1TableAdapters.TBLKULUPLERTableAdapter dt6 = new DataSet1TableAdapters.TBLKULUPLERTableAdapter();
            Repeater6.DataSource = dt6.KuluplerListesi();
            Repeater6.DataBind();

            DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt7 = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
            Repeater7.DataSource = dt7.HakkımdaListele();
            Repeater7.DataBind();
        }
 private void worker_ListBoxInBlackListEvent(List <DataClassString4> listForShow)
 {
     if (RadioButtonList1.SelectedValue == "1")
     {
         Repeater3.DataSource = listForShow;
         Repeater3.DataBind();
     }
 }