protected void AuditMasterDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (AuditTrailType.Text == "")
         e.Cancel = true;
     else
         e.Command.Parameters["@Type"].Value = Convert.ToInt32(AuditTrailType.Text);
 }

 protected void WorkFlowDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     //if (Wf_ProcessId.Text == "")
     //    e.Cancel = true;
     //else
     //    e.Command.Parameters["@PRH_ProcessId_ProcessId"].Value = Wf_ProcessId.Text;
 }

		protected internal override IEnumerable ExecuteSelect (
						DataSourceSelectArguments arguments)
		{
			oleCommand = new OleDbCommand (this.SelectCommand, oleConnection);
			SqlDataSourceSelectingEventArgs cmdEventArgs = new SqlDataSourceSelectingEventArgs (oleCommand, arguments);
			OnSelecting (cmdEventArgs);
			IEnumerable enums = null; 
			Exception exception = null;
			OleDbDataReader reader = null;
			try {
				System.IO.File.OpenRead (dataSource.DataFile).Close ();
				oleConnection.Open ();
				reader = (OleDbDataReader)oleCommand.ExecuteReader ();
			
				//enums = reader.GetEnumerator ();
				throw new NotImplementedException("OleDbDataReader doesnt implements GetEnumerator method yet");
			} catch (Exception e) {
				exception = e;
			}
			SqlDataSourceStatusEventArgs statusEventArgs = 
				new SqlDataSourceStatusEventArgs (oleCommand, reader.RecordsAffected, exception);
			OnSelected (statusEventArgs);
			if (exception !=null)
				throw exception;
			return enums;			
		}						

 protected void AuditHeaderDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (Pid.Text == string.Empty)
         e.Cancel = true;
     else
         e.Command.Parameters["@ProcessId"].Value = Pid.Text;
 }

 protected void CatDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (PRI_PurchaseType.SelectedIndex == -1)
         e.Command.Parameters["@PurchaseType"].Value = DBNull.Value;
     else
         e.Command.Parameters["@PurchaseType"].Value = Convert.ToInt32(PRI_PurchaseType.Value);
 }

 protected void SysGrpDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (UserGroupId.Text == "")
         e.Command.Parameters["@UserGroupId"].Value = DBNull.Value;
     else
         e.Command.Parameters["@UserGroupId"].Value = Convert.ToInt32(UserGroupId.Text);
 }

 protected void WorkFlowDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (AliranKerja_ProcessId.Text == "")
         e.Cancel = true;
     else
         e.Command.Parameters["@LKH_ProcessId"].Value = AliranKerja_ProcessId.Text;
 }

 protected void AuditHeaderDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (Session["CurrVendorAuditProcessId"] == null)
         e.Cancel = true;
     else
         e.Command.Parameters["@ProcessId"].Value = Session["CurrVendorAuditProcessId"].ToString();
 }

 protected void AuditTrailDetailDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (Session["CurrOrgAuditNumber"] == null)
         e.Cancel = true;
     else
         e.Command.Parameters["@ProcessId"].Value = Session["CurrOrgAuditNumber"].ToString();
 }

 protected void GridView1_OnSelecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     int id;
     int.TryParse(Request["id"], out id);
     if (id < 1) id=0;
     e.Command.Parameters["@contestId"].Value = id.ToString(CultureInfo.InvariantCulture);
 }

 protected void WorkFlowDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (PEM_WFD_PEMH_RowId.Text == "")
         e.Cancel = true;
     else
         e.Command.Parameters["@PEM_WFD_PEMH_RowId"].Value = Convert.ToInt32(PEM_WFD_PEMH_RowId.Text);
 }

        protected void dbWorkers_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            //get user id
            MembershipUser usr = Membership.GetUser();
            Guid uid = (Guid)usr.ProviderUserKey;

            e.Command.Parameters["@UserId"].Value = uid;
        }

 protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (!((BasePage)this.Page).UserRole.Equals("Administrator"))
     {
         e.Cancel = true;
         this.GridView1.Visible = false;
     }
 }

        protected void SliderDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            string UploadLocation = ConfigurationManager.AppSettings["ImageUploadFolder"].ToString();
            string FileFullPath = Path.Combine(Server.MapPath(UploadLocation), string.Empty);

            e.Command.Parameters["@ProcessId"].Value = AK_ProcessId.Text;
            e.Command.Parameters["@PhysicalPath"].Value = ConfigurationManager.AppSettings["ImageUploadFolder"].ToString();
        }

        protected void ReturnDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            e.Command.Parameters["@PPD_ProcessId"].Value = RetProcessId.Text;

            if (RetRevision.Text != "")
                e.Command.Parameters["@PPD_Revision"].Value = Convert.ToInt32(RetRevision.Text);
            else
                e.Command.Parameters["@PPD_Revision"].Value = 0;
        }

        protected void WithdrawListDs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            e.Command.Parameters["@PPD_ProcessId"].Value = txtWithdrawProcessId.Text;

            if (txtWithdrawRev.Text != "")
                e.Command.Parameters["@PPD_Revision"].Value = Convert.ToInt32(txtWithdrawRev.Text);
            else
                e.Command.Parameters["@PPD_Revision"].Value = 0;
        }

        protected void dbScheduleSelect_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            //get logged in user id
            MembershipUser usr = Membership.GetUser();
            Guid uid = (Guid)usr.ProviderUserKey;

            //set the UserId parameter to current user for DB select
            e.Command.Parameters["@UserId"].Value = uid;
        }

        protected void sdsCreditSalesDateRange_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            //DateTime ukBeginDateTime = DateTime.Parse(txtBeginDate.Text, System.Globalization.CultureInfo.GetCultureInfo("en-gb"));
            //DateTime ukEndDateTime = DateTime.Parse(txtEndDate.Text, System.Globalization.CultureInfo.GetCultureInfo("en-gb"));

            //txtBeginDate.Text = (ukBeginDateTime).ToString("YYYY-MM-DD");

            //txtEndDate.Text = (ukEndDateTime).ToString("YYYY-MM-DD");
        }

        protected void uxJobSql_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            //get user id
            MembershipUser usr = Membership.GetUser();
            Guid uid = (Guid)usr.ProviderUserKey;

            //uxWorkerSql.SelectParameters.Add("@UserId", uid.ToString());
            e.Command.Parameters["@UserId"].Value = uid;
        }

 protected void MarksSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
 {
     if (cbxTerms.SelectedIndex == -1 || cbxTerms.SelectedValue == "0")
     {
         e.Command.Parameters["@TermMin"].Value = byte.MinValue;
         e.Command.Parameters["@TermMax"].Value = byte.MaxValue;
     }
     else e.Command.Parameters["@TermMin"].Value = e.Command.Parameters["@TermMax"].Value = byte.Parse(cbxTerms.SelectedValue);
 }