Exemplo n.º 1
0
    protected void onItemSelecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        string asin = Request.QueryString["asin"];

        // Assign asin to select parameter
        e.Command.Parameters["@asin"].Value = asin;
    }
Exemplo n.º 2
0
 protected void sqlcompanySearch(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (String.IsNullOrEmpty(txtCname.Text))
     {
         e.Cancel = true;
     }
 }
Exemplo n.º 3
0
 protected void DSCDSyndicate_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (TheSessions.IsAdmin)
         e.Command.CommandText = "SELECT [SyndicateId], [Syndicate] FROM [CDSyndicate]";
     else
         e.Command.CommandText = "SELECT [SyndicateId], [Syndicate] FROM [CDSyndicate] WHERE SyndicateId = " + TheSessions.SyndicateId;
 }
    protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        if (sessionMemberCard.IsAdmin)
        {
            e.Command.CommandText = @"SELECT [MemberId], [MemberName], [closed],
            (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = TBLAllMember.SyndicateId) AS Syndicate,
            (SELECT SubCommitte FROM CDSubCommitte WHERE SubCommitteId = TBLAllMember.SubCommitteId) AS SubCommitte
             FROM [TBLAllMember]";
        }
        else
        {
            if (sessionMemberCard.usersub == sessionMemberCard.UserSubType.SubType)
            {
                e.Command.CommandText = @"SELECT [MemberId], [MemberName], [closed],
            (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = TBLAllMember.SyndicateId) AS Syndicate,
            (SELECT SubCommitte FROM CDSubCommitte WHERE SubCommitteId = TBLAllMember.SubCommitteId) AS SubCommitte
             FROM [TBLAllMember] WHERE closed = False AND userin = " + sessionMemberCard.UserID;

            }
            else if(sessionMemberCard.usersub == sessionMemberCard.UserSubType.SubSyn)
            {
                e.Command.CommandText = @"SELECT [MemberId], [MemberName], [closed],
            (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = TBLAllMember.SyndicateId) AS Syndicate,
            (SELECT SubCommitte FROM CDSubCommitte WHERE SubCommitteId = TBLAllMember.SubCommitteId) AS SubCommitte
             FROM [TBLAllMember] WHERE closed = False AND SyndicateId = " + sessionMemberCard.SyndicateId;
            }

        }
    }
    protected void dsTasks_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        string qryCat = Request.QueryString["cid"];
        string qrySubCat = Request.QueryString["scid"];
        string qryServ = Request.QueryString["ser"];
        string qrySec = Request.QueryString["sec"];
        string qryEmp = Request.QueryString["eid"];
        string qrySta = Request.QueryString["sta"];
        string qryRev = Request.QueryString["rev"];
        string qryCom = Request.QueryString["com"];
        string qryRec = Request.QueryString["rec"];
        string qrySort = Request.QueryString["srt"];
        string qryDdline = Request.QueryString["dl"];

        //Before passing all those query string parameters wrap those bad boys in wildcards if they're empty, if not set each control value and border colour

        if (qryCat != null)
        { dropCategory.SelectedValue = qryCat; dropCategory.BorderColor = Color.Black; SelectSubCategory(); }
        else { e.Command.Parameters["@category"].Value = "%" + e.Command.Parameters["@category"].Value + "%"; }

        if (qrySubCat != null)
        { dropSubcategory.SelectedValue = qrySubCat; dropSubcategory.BorderColor = Color.Black; }
        else { e.Command.Parameters["@subcat"].Value = "%" + e.Command.Parameters["@subcat"].Value + "%"; }

        if (qryServ != null)
        { dropService.SelectedValue = qryServ; dropService.BorderColor = Color.Black; }
        else { e.Command.Parameters["@service"].Value = "%" + e.Command.Parameters["@service"].Value + "%"; }

        if (qrySec != null)
        { dropSection.SelectedValue = qrySec; dropSection.BorderColor = Color.Black; SelectEmployee(); }
        else { e.Command.Parameters["@section"].Value = "%" + e.Command.Parameters["@section"].Value + "%"; }

        if (qryEmp != null)
        { dropEmployee.SelectedValue = qryEmp; dropEmployee.BorderColor = Color.Black; }
        else { e.Command.Parameters["@employee"].Value = "%" + e.Command.Parameters["@employee"].Value + "%"; }

        if (qrySta != null)
        { dropStatus.SelectedValue = qrySta; dropStatus.BorderColor = Color.Black; }
        else { e.Command.Parameters["@status"].Value = "%" + e.Command.Parameters["@status"].Value + "%"; }

        if (qryRev != null)
        { dropReview.SelectedValue = qryRev; dropReview.BorderColor = Color.Black; }
        else { e.Command.Parameters["@review"].Value = "%" + e.Command.Parameters["@review"].Value + "%"; }

        if (qryCom == "1")
        { chkCom.Checked = true; chkCom.ForeColor = Color.Maroon; }
        else { e.Command.Parameters["@committee"].Value = "%" + e.Command.Parameters["@committee"].Value + "%"; }

        if (qryRec == "1")
        { chkRec.Checked = true; chkRec.ForeColor = Color.Maroon; }
        else { e.Command.Parameters["@recurring"].Value = "%" + e.Command.Parameters["@recurring"].Value + "%"; }

        if (qryDdline == "1")
        { chkDeadline.Checked = true; chkDeadline.ForeColor = Color.Maroon; }
        else { chkDeadline.Checked = false; }

        if (qrySort != null)
        { dropSort.SelectedValue = qrySort; }
    }
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     //        if (sessionMaintenance.MaintenanceIsAdmin)
     //        {
     //            e.Command.CommandText = @"SELECT Maintenance.MaintenanceId, Maintenance.MaintenanceDate, Maintenance.maddres, Maintenance.mclosed, Users.realname, Maintenance.read_code FROM
     //            (Maintenance LEFT OUTER JOIN Users ON Maintenance.UserID = Users.UserID)";
     //        }
 }
Exemplo n.º 7
0
 protected void departmentDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     DropDownList buDropDownList = (DropDownList)NfteDetailsView.FindControl("buDropDownList");
     DropDownList deptDropDownList = (DropDownList)NfteDetailsView.FindControl("deptDropDownList");
     if (deptDropDownList != null)
     {
         e.Command.Parameters["@bu_id"].Value = buDropDownList.SelectedValue;
     }
 }
Exemplo n.º 8
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     //SELECT studentcode FROM download WHERE (id_prog = ?)
     string dbpath = MCDownloadCenter.LoginDatabasePath.Substring(0, MCDownloadCenter.LoginDatabasePath.Length - 4);
     e.Command.CommandText = string.Format(@"SELECT studentcode, downdate,
     (SELECT stu_name FROM {0}.student WHERE stu_code = download.studentcode) AS stu_name,
     (SELECT alsofof_name FROM alsofof WHERE alsofof_code = (SELECT alsofof_code FROM {0}.student_t WHERE stu_code = download.studentcode AND asase_code = (SELECT MAX(asase_code) FROM {0}.student_t))) AS alsofof_name,
     (SELECT faslname FROM fasl WHERE faslcode = (SELECT fasl_code FROM {0}.student_t WHERE stu_code = download.studentcode AND asase_code = (SELECT MAX(asase_code) FROM {0}.student_t))) AS name_al_fasl
     FROM download WHERE (id_prog = {1})", dbpath, Request.QueryString["id"]);
 }
Exemplo n.º 9
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (!TheSessions.IsAdmin)
     {
         e.Command.CommandText = @"SELECT [MemberId], [MemberName] FROM [TBLMembers] WHERE ([SyndicateId] = " + TheSessions.SyndicateId + ") order by MemberName";
     }
     else
     {
         e.Command.CommandText = @"SELECT [MemberId], [MemberName] FROM [TBLMembers] WHERE ([SyndicateId] = ?) order by MemberName";
     }
 }
Exemplo n.º 10
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (sessionMemberCard.IsAdmin)
     {
         e.Command.CommandText = @"SELECT tblestefa.MemberId, tblestefa.SyndicateId, tblestefa.SubCommitteId,
         tblestefa.MemberName, tblestefa.resoon, tblestefa.datein, CDSyndicate.Syndicate,
         CDSubCommitte.SubCommitte FROM ((tblestefa LEFT OUTER JOIN
         CDSubCommitte ON tblestefa.SubCommitteId = CDSubCommitte.SubCommitteId) LEFT OUTER JOIN
         CDSyndicate ON tblestefa.SyndicateId = CDSyndicate.SyndicateId)";
     }
 }
Exemplo n.º 11
0
 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     //使用SqlDataSourceSelectingEventArgs的Command属性获取当前的命令对象。
     //然后使用命令对象的Parameters集合来获取参数值。
     if ((int)e.Command.Parameters[0].Value == 7)
     {
         //如果参数值为7,则停止查询的执行
         e.Cancel = true;
     }
        // e.Command.CommandText = "select * from product";
 }
Exemplo n.º 12
0
    protected void UserProfileDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        // Get a reference to the currently logged on user
        MembershipUser currentUser = Membership.GetUser();

        // Determine the currently logged on user's UserId value
        Guid currentUserId = (Guid)currentUser.ProviderUserKey;

        // Assign the currently logged on user's UserId to the @UserId parameter
        e.Command.Parameters["@UserId"].Value = currentUserId;
    }
Exemplo n.º 13
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (sessionRetirementWeb.SubCommitteId != null)
     {
         e.Command.CommandText = string.Format(@"SELECT [rid], [sonid], [sonname], [SyndicateId], [SubCommitteId], [sarfnumber], [remark], [membername] FROM [stopsarf]
     WHERE SyndicateId = {0} AND SubCommitteId = {1}", sessionRetirementWeb.SyndicateId, sessionRetirementWeb.SubCommitteId);
     }
     else
     {
         e.Command.CommandText = string.Format(@"SELECT [rid], [sonid], [sonname], [SyndicateId], [SubCommitteId], [sarfnumber], [remark], [membername] FROM [stopsarf] WHERE SyndicateId = {0}", sessionRetirementWeb.SyndicateId);
     }
 }
Exemplo n.º 14
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (sessionRetirementWeb.SubCommitteId != null)
     {
         e.Command.CommandText = string.Format(@"SELECT [memberid], [membername], [sarfno], [SyndicateId], [SubCommitteId], [useredit], [dateedit], [delmember], [remm] FROM [tblwarasa]
     WHERE SyndicateId = {0} AND SubCommitteId = {1}", sessionRetirementWeb.SyndicateId, sessionRetirementWeb.SubCommitteId);
     }
     else
     {
         e.Command.CommandText = string.Format(@"SELECT [memberid], [membername], [sarfno], [SyndicateId], [SubCommitteId], [useredit], [dateedit], [delmember], [remm]
     FROM [tblwarasa] WHERE SyndicateId = {0}", sessionRetirementWeb.SyndicateId);
     }
 }
Exemplo n.º 15
0
	protected void sourceEmployees_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
	{
		if ((string)e.Command.Parameters["@City"].Value == "(Choose a City)")
		{
			// Do nothing.
			e.Cancel = true;
		}
		else if ((string)e.Command.Parameters["@City"].Value == "(All Cities)")
		{
			// Manually change the command.
			e.Command.CommandText = "SELECT * FROM Employees";
		}
	}
Exemplo n.º 16
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (TheSessionsDownloadCenter.IsAdmin)
     {
         e.Command.CommandText = @"SELECT id_prog, code_al_fasl, alsofof_code, id_type_prog, name_prog, date_up, Description, ExternalLink, link FROM center ";
     }
     else
     {
         e.Command.CommandText = string.Format(@"SELECT id_prog, code_al_fasl, alsofof_code, id_type_prog, name_prog, date_up, Description, ExternalLink, link
         FROM center
         WHERE alsofof_code = " + TheSessionsDownloadCenter.alsofof_code);
     }
     DSData.DataBind();
 }
Exemplo n.º 17
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (TheSessions.IsAdmin)
     {
         e.Command.CommandText = @"SELECT TBLMembers.MemberId, TBLMembers.MemberName, TBLMembers.cardr, TBLMembers.dater, CDSyndicate.Syndicate FROM
         (TBLMembers LEFT OUTER JOIN CDSyndicate ON TBLMembers.SyndicateId = CDSyndicate.SyndicateId) ORDER BY TBLMembers.datein";
     }
     else
     {
         e.Command.CommandText = String.Format(@"SELECT TBLMembers.MemberId, TBLMembers.MemberName, TBLMembers.cardr, TBLMembers.dater, CDSyndicate.Syndicate
         FROM (TBLMembers LEFT OUTER JOIN CDSyndicate ON TBLMembers.SyndicateId = CDSyndicate.SyndicateId)
         WHERE TBLMembers.SyndicateId = {0} ORDER BY TBLMembers.datein", TheSessions.SyndicateId);
     }
 }
Exemplo n.º 18
0
 protected void DSData_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (TheSessions.IsAdmin)
     {
         e.Command.CommandText = @"SELECT [CompanionId], [CompanionName], [MemberId], (SELECT MemberName FROM TBLMembers WHERE MemberId = TBLCompanion.MemberId) AS MemberName,
         CompanionImage, (SELECT CompanionType FROM CDCompanionType WHERE CompanionTypeId = TBLCompanion.CompanionTypeId) AS CompanionType, cardr,
         (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = (SELECT MemberSyndicateId FROM TBLMembers WHERE MemberId = TBLCompanion.MemberId)) AS SyndicateMem,
         (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = (SELECT SyndicateId FROM TBLMembers WHERE MemberId = TBLCompanion.MemberId)) AS Syndicate
         FROM [TBLCompanion]";
     }
     else
     {
         e.Command.CommandText = @"SELECT [CompanionId], [CompanionName], [MemberId], (SELECT MemberName FROM TBLMembers WHERE MemberId = TBLCompanion.MemberId) AS MemberName,
         CompanionImage, (SELECT CompanionType FROM CDCompanionType WHERE CompanionTypeId = TBLCompanion.CompanionTypeId) AS CompanionType, cardr,
         (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = (SELECT MemberSyndicateId FROM TBLMembers WHERE MemberId = TBLCompanion.MemberId)) AS SyndicateMem,
         (SELECT Syndicate FROM CDSyndicate WHERE SyndicateId = (SELECT SyndicateId FROM TBLMembers WHERE MemberId = TBLCompanion.MemberId)) AS Syndicate
         FROM [TBLCompanion] WHERE EXISTS (SELECT SyndicateId FROM TBLMembers WHERE userin = ? AND MemberId = TBLMembers.MemberId)";
     }
 }
Exemplo n.º 19
0
 protected override void OnSelecting(SqlDataSourceSelectingEventArgs e)
 {
     currentSelectParameters = e.Command.Parameters;
     base.OnSelecting(e);
 }
Exemplo n.º 20
0
 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     WriteMessage();
 }
Exemplo n.º 21
0
 protected void SDS_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@IP"].Value = Request.UserHostAddress;
 }
Exemplo n.º 22
0
 protected void AccessDB_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 23
0
 protected void SqlDataSource_ReqType_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 24
0
 protected void izozoDS_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 25
0
 protected void jobstatus_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 26
0
 protected void sdsMaster_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@Name"].Value         = txtFindName.Text;
     e.Command.Parameters["@CustomerType"].Value = ddlFindCustomerType.SelectedValue;
     e.Command.Parameters["@Gender"].Value       = ddlFindGender.SelectedValue;
 }
Exemplo n.º 27
0
    protected void cardDdlSql_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }
Exemplo n.º 28
0
 protected void sdsMaster_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@Name"].Value = txtFindName.Text;
 }
Exemplo n.º 29
0
 protected void ProfileDS_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@UserId"].Value = user_id;
 }
 protected void Joint2DataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
 protected void Curr_Names_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 32
0
 protected void exportsDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 33
0
 protected void sqlCadastrarProcurador_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 34
0
 protected void SqlMealPlan_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 35
0
 protected void dsRegions_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 36
0
 protected void sdsRecognition_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     //Empty
 }
 protected void UserPostCommentDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@PostId"].Value = postId;
 }
 protected void sqlCustomers_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
 protected void sqldatasource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
 protected void SDSSDegress2013_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 41
0
 protected void SqlDschitietdon_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 42
0
 protected void sdsMaster_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@BranchID"].Value     = ddlFindBranch.SelectedValue;
     e.Command.Parameters["@ContractNo"].Value   = txtFindContractNo.Text;
     e.Command.Parameters["@CustomerName"].Value = txtFindCustomerName.Text;
 }
Exemplo n.º 43
0
    protected void Program_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }
        protected void SqlDataSource_Elite_uspBMcBEARCashFlowManager_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            String inv   = "";
            String loc   = "";
            String dept  = "";
            String dp    = "";
            String cmp   = "";
            String pay   = "";
            String mthd  = "";
            String cur   = "";
            String src   = "";
            String ofc   = "";
            String vid   = "";
            String vname = "";
            String bc    = "";

            if (Request["inv"] != null)
            {
                inv = Request["inv"].ToString();
            }
            if (Request["bc"] != null)
            {
                bc = Request["bc"].ToString();
            }
            if (Request["loc"] != null)
            {
                loc = Request["loc"].ToString();
            }
            if (Request["dept"] != null)
            {
                dept = Request["dept"].ToString();
            }
            if (Request["dp"] != null)
            {
                dp = Request["dp"].ToString();
            }
            if (Request["cmp"] != null)
            {
                cmp = Request["cmp"].ToString();
            }
            if (Request["pay"] != null)
            {
                pay = Request["pay"].ToString();
            }
            if (Request["mthd"] != null)
            {
                mthd = Request["mthd"].ToString();
            }
            if (Request["cur"] != null)
            {
                cur = Request["cur"].ToString();
            }
            if (Request["src"] != null)
            {
                src = Request["src"].ToString();
            }
            if (Request["ofc"] != null)
            {
                ofc = Request["ofc"].ToString();
            }
            if (Request["vid"] != null)
            {
                vid = Request["vid"].ToString();
            }
            if (Request["vname"] != null)
            {
                vname = Request["vname"].ToString();
            }


            e.Command.CommandTimeout = 0;
            if (utility.GetIsDeptUser())
            {
                e.Command.Parameters.Add(new SqlParameter("@deptUser", "1"));
            }
            if (!utility.GetLocation().Equals("All") && !utility.GetLocation().Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@location", utility.GetLocation()));
            }
            if (!utility.GetDepartment().Equals("All") && !utility.GetDepartment().Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@department", utility.GetDepartment()));
            }
            if (!dp.Equals("All") && !dp.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@deptPriority", dp));
            }
            if (!cmp.Equals("All") && !cmp.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@cmPriority", cmp));
            }
            if (!pay.Equals("All") && !pay.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@payFlag", pay));
            }
            if (!mthd.Equals("All") && !mthd.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@paymentMethod", mthd));
            }
            if (!inv.Equals("All") && !inv.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@invoiceNumber", inv));
            }
            if (!bc.Equals("All") && !bc.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@barcode", bc));
            }
            if (!cur.Equals("All") && !cur.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@currency", cur));
            }
            if (!src.Equals("All") && !src.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@source", src));
            }
            if (!ofc.Equals("All") && !ofc.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@office", ofc));
            }
            if (!vid.Equals("All") && !vid.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@vendorId", vid));
            }
            if (!vname.Equals("All") && !vname.Equals(""))
            {
                e.Command.Parameters.Add(new SqlParameter("@vendorName", vname));
            }
        }
Exemplo n.º 45
0
 /// <summary>
 /// Sets the SQL Parameters which set the column order in the stored procedure
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void SqlDataSource_Elite_uspBMcBEARBillTracker_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.CommandTimeout = 0;
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode1(), "1"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode2(), "2"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode3(), "3"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode4(), "4"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode5(), "5"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode6(), "6"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode7(), "7"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode8(), "8"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode9(), "9"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode10(), "10"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode11(), "11"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode12(), "12"));
     e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode13(), "13"));
 }
Exemplo n.º 46
0
 protected void olapSQLSource_OnSelecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.CommandTimeout = ConfigHelper.CommandTimeout;
 }
Exemplo n.º 47
0
 protected void sdsURLsForRaveFormSummaries_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.CommandTimeout = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["SQLCommandTimeout"].ToString());
 }
Exemplo n.º 48
0
 protected void Unnamed1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
 protected void dsPSST_PERSON_HIS_Address_ListView_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 50
0
 protected void SqlPests_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
 protected void SqlDataAlmuerzo_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 52
0
 protected void CheckSqlSelecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 53
0
 protected void dsListView_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 54
0
 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.CommandTimeout = 0;
 }
Exemplo n.º 55
0
 protected void SQLDS_RGet_PLANID_INFO_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 56
0
 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@c_ID"].Value = (string)Session["uid"];
 }
Exemplo n.º 57
0
 protected void SqlDataSourceEstimacao_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters[0].Value = Session["userID"];
 }
 protected void Code_A_Desc_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }
Exemplo n.º 59
0
 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     e.Command.Parameters["@SupervisorID"].Value = HttpContext.Current.User.Identity.Name.ToString();
 }
 protected void SqlDataSource1_Selecting1(object sender, SqlDataSourceSelectingEventArgs e)
 {
 }