Telerik Forums
UI for ASP.NET AJAX Forum
0 answers
536 views

I have an autocomplete on my page that is bound to a sqldatasource.  Not sure why it is not working the progress meter just spins and spins.  The reason i think its with bootstrap is because if i take the control and the sqldatasource to a blank page, it works?  I dont get an error so its hard to diagnose.  Please take a look at my code and tell me where the conflict is.  Thank You

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
 
 
<style>
         .numberCircle {
   border-radius: 50%;      
 
   width: 36px;
   height: 36px;
   line-height: 36px;
   vertical-align:middle;
   margin: 5px;
   background: #fff;
   border: 2px solid #666;
   color: #666;
   position: absolute;
    left: -50px;
   text-align: center;
   font: 28px Arial, sans-serif;
}
        .required {
            color: #e31937;
            font-family: Verdana;
            margin: 0 5px;
        }
 
        .field-validation-error {
            color: #e31937;
            font-weight: bold;
        }
</style>
 
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
 <asp:Literal ID="distID" runat="server" Text=""></asp:Literal>
    <asp:Literal ID="error" runat="server" Text=""></asp:Literal>
    <h4>Use this option to add a single student.  This is an ideal option prior to printing scan sheets and when only a few students need to be addedd.  If you
        already printed and distributed the scan sheets you need to print out a blank scan sheet and add the student responses directly into Remark. Please click here for more information on how to that. </h4>
    <br />
            <div class="container">
    <div class="btn-group btn-toggle">
        <asp:Button ID="btnElementary" CssClass="btn btn-primary" runat="server" Text="Elementary" OnClick="btnElementary_Click" ViewStateMode="Enabled" CausesValidation="False" />
        <asp:Button ID="btnSecondary" CssClass="btn btn-default" runat="server" Text="Secondary" OnClick="btnElementary_Click" ViewStateMode="Enabled" CausesValidation="False" />
    </div>
 
                  <br />
    <br />
</div>
  <div class="col-lg-6">
        <div class="numberCircle">1</div>
    </div
<div class="container">
        <div class="jumbotron">          
        <div class="row">
         <div class="form-group-lg">           
<div class="col-lg-2">     
<div class="form-group">
  <label class="col-2 col-form-label">Student ID</label>
  <div class="col-10">
    <input class="form-control" runat="server" type="text" value="" id="StudentID">
     <div class="collapse">
          <asp:RequiredFieldValidator ID="STUvalid" ValidationGroup="validSTU" runat="server" ErrorMessage="Student ID Required" Display="None" ControlToValidate="StudentID">
          </asp:RequiredFieldValidator>
          <asp:RequiredFieldValidator ID="STUValidSecondary" ValidationGroup="validSecondary" runat="server" ErrorMessage="Student ID Required" Display="None" ControlToValidate="StudentID">
          </asp:RequiredFieldValidator>
          </div>
  </div>
</div>
<div class="form-group">
  <label for="example-search-input" class="col-2 col-form-label">Student Name</label>
  <div class="col-10">
    <input class="form-control" runat="server" type="text" value="" id="Name">
    <div class="collapse">
          <asp:RequiredFieldValidator ID="stuNameValid" ValidationGroup="validSTU" runat="server" ErrorMessage="Student Name Required" Display="None" ControlToValidate="Name">
          </asp:RequiredFieldValidator>
          <asp:RequiredFieldValidator ID="stuNameValidSecondary" ValidationGroup="validSecondary" runat="server" ErrorMessage="Student Name Required" Display="None" ControlToValidate="Name">
          </asp:RequiredFieldValidator>
     </div>
  </div>
</div>
<div class="form-group">
  <label for="example-email-input" class="col-2 col-form-label">School ID</label>
  <div class="col-10">
      <asp:TextBox ID="tbSchoolID" runat="server" CssClass="form-control input-lg" TextMode="Number"></asp:TextBox
       <div class="collapse">
          <asp:RequiredFieldValidator ID="SchoValid" ValidationGroup="validSTU" runat="server" ErrorMessage="School ID Required" Display="None" ControlToValidate="tbSchoolID">
          </asp:RequiredFieldValidator>
          <asp:RequiredFieldValidator ID="SchoValidSecondary" ValidationGroup="validSecondary" runat="server" ErrorMessage="School ID Required" Display="None" ControlToValidate="tbSchoolID">
          </asp:RequiredFieldValidator>
     </div>
  </div>
</div>
<div class="form-group">
  <label for="example-url-input" class="col-2 col-form-label">Grade</label>
  <div class="col-10">
      <asp:DropDownList ID="ddlGrade"  CssClass="btn btn-default dropdown-toggle btn-lg" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlGrade_SelectedIndexChanged">
            <asp:ListItem class="dropdown-header">
                Grade
            </asp:ListItem>
          <asp:ListItem Text="K" Value="0"/>
          <asp:ListItem>1</asp:ListItem>
          <asp:ListItem>2</asp:ListItem>
          <asp:ListItem>3</asp:ListItem>
          <asp:ListItem>4</asp:ListItem>
          <asp:ListItem>5</asp:ListItem>
          <asp:ListItem>6</asp:ListItem>
          <asp:ListItem>7</asp:ListItem>
          <asp:ListItem>8</asp:ListItem>
          <asp:ListItem>9</asp:ListItem>
          <asp:ListItem>10</asp:ListItem>
          <asp:ListItem>11</asp:ListItem>
          <asp:ListItem>12</asp:ListItem>
      </asp:DropDownList>
  </div>
</div>
</div>
<div class="col-lg-2">
 
    </div>
 
 
<div class="col-lg-2">
 
<div class="form-group">
  <label for="example-tel-input" class="col-2 col-form-label">Ethnicity</label>
  <div class="col-10">
     <div class="col-10">
      <asp:DropDownList ID="ddlRace"  CssClass="btn btn-default dropdown-toggle btn-lg" runat="server">
          <asp:ListItem Enabled="False">-- Select Ethnicity --</asp:ListItem>
          <asp:ListItem Text="White" Value="WHT"/>
          <asp:ListItem Text="African American" Value="AA"/>
          <asp:ListItem Text="Hispanic" Value="HIS"/>
          <asp:ListItem Text="Asian" Value="Asian"/>
          <asp:ListItem Text="Other" Value="Other"/>
      </asp:DropDownList>
  </div>
  </div>
</div>
<div class="form-group">
  <label for="example-password-input" class="col-2 col-form-label">Language Fluency</label>
  <div class="col-10">
      <asp:DropDownList ID="ddlLF"  CssClass="btn btn-default dropdown-toggle btn-lg" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlLF_SelectedIndexChanged">
            <asp:ListItem class="dropdown-header">
                LF
            </asp:ListItem>
          <asp:ListItem Text="English Only" Value="EO"/>
          <asp:ListItem Text="English Learner" Value="EL"/>
          <asp:ListItem Text="IFEP" Value="IFEP"/>
          <asp:ListItem Text="RFEP" Value="RFEP"/>
      </asp:DropDownList>
  </div>
</div>
<div class="form-group"  id="LFlevel" runat="server">
  <label for="example-password-input" class="col-2 col-form-label">CELDT Level</label>
   <div class="col-10">
      <asp:DropDownList ID="ddlLF_level"  CssClass="btn btn-default dropdown-toggle btn-lg" runat="server">
           <asp:ListItem class="dropdown-header">
                Level
            </asp:ListItem>
          <asp:ListItem Text="Begining" Value="1"/>
          <asp:ListItem Text="Early Intermediate" Value="2"/>
          <asp:ListItem Text="Intermediate" Value="3"/>
          <asp:ListItem Text="Early Advanced" Value="4"/>
          <asp:ListItem Text="Advanced" Value="5"/>
      </asp:DropDownList>
  </div>
</div>
<div class="form-group">
  <label for="example-number-input" class="col-2 col-form-label">Special Education</label>
  <div class="col-10">
      <asp:DropDownList ID="ddlSped"  CssClass="btn btn-default dropdown-toggle btn-lg" runat="server">
           <asp:ListItem class="dropdown-header">
                SPED
            </asp:ListItem>
          <asp:ListItem Text="Yes" Value="Y"/>
          <asp:ListItem Text="No" Value=""/>
      </asp:DropDownList>
  </div>
</div>
<div class="form-group">
  <label for="example-datetime-local-input" class="col-2 col-form-label">US Entry Date</label>
  <div class="col-10">
      <telerik:RadDatePicker Skin="Bootstrap" ID="RDusDate" runat="server"></telerik:RadDatePicker>
 
  </div>
</div>
</div>
 
<div class="col-lg-2">
 
</div>
     
<div class="col-lg-2" id="DIVelemTeacher" runat="server">
    <div class="form-group">
  <label for="example-email-input" class="col-2 col-form-label">Elemtary Teacher</label>
  <div class="col-10">
      <telerik:RadAutoCompleteBox ID="ELEMautoTeacher" runat="server" Skin="Bootstrap" InputType="Text" DataSourceID="sqlTeacher" DataTextField="teacher" DataValueField="teacher" Filter="StartsWith" EmptyMessage="Start typing"></telerik:RadAutoCompleteBox>
      
  </div>
</div>
    </div>
        <%--  ---VALIDATION------%>
    <div class="col-lg-2" >
         <div class="form-group">
            <asp:ValidationSummary ID="ValidationSummary1" ValidationGroup="validSTU" CssClass="field-validation-error" DisplayMode="BulletList"   runat="server" />
         <asp:ValidationSummary ID="ValidationSummary2" ValidationGroup="validSecondary" CssClass="field-validation-error" DisplayMode="BulletList"   runat="server" />
         </div>       
    </div>
        <%------ END ------%>
        </div>
       </div>     
            <br />
            <br />
            <asp:Button ID="btnStudent" ValidationGroup="validSTU" CssClass="btn btn-primary" runat="server" Text="Add Student" OnClick="btnStudent_Click" />       
   </div
   </div>
     <div id="target" runat="server" class="hidden">
           <div class="col-lg-6">
        <div class="numberCircle">2</div>
    </div>
        <%-- ---BEGIN SECONDARY PERIODS-----%>
 
     <div class="container">
        <div class="jumbotron">      
                    <div class="form-inline">
                              <asp:DropDownList ID="ddlPeriod" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Period
                            </asp:ListItem>
                                <asp:ListItem>1</asp:ListItem>
                                <asp:ListItem>2</asp:ListItem>
                                <asp:ListItem>3</asp:ListItem>
                                <asp:ListItem>4</asp:ListItem>
                                <asp:ListItem>5</asp:ListItem>
                                <asp:ListItem>6</asp:ListItem>
                                <asp:ListItem>7</asp:ListItem>
                              </asp:DropDownList>                        
                        <asp:TextBox ID="tbTeacherName1" runat="server" Width="175px"  CssClass="form-control input-lg" placeholder="Teacher Name" ></asp:TextBox>
                            <div class="collapse">
                              <asp:RequiredFieldValidator ID="p1Teacher" ValidationGroup="validSecondary" runat="server" ErrorMessage="Period Teacher Name Required" Display="None" ControlToValidate="tbTeacherName1">
                              </asp:RequiredFieldValidator>
                            </div>
                        <asp:TextBox ID="tbTeacherID1" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="TeacherID"></asp:TextBox>
                            <div class="collapse">
                              <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ValidationGroup="validSecondary" runat="server" ErrorMessage="Period Teacher ID Required" Display="None" ControlToValidate="tbTeacherID1">
                              </asp:RequiredFieldValidator>
                            </div>            
                        <asp:TextBox ID="tbCourse1" runat="server" CssClass="form-control input-lg" Width="175px" placeholder="Course Name"></asp:TextBox>
                            <div class="collapse">
                              <asp:RequiredFieldValidator ID="RequiredFieldValidator2" ValidationGroup="validSecondary" runat="server" ErrorMessage="Course Name Required" Display="None" ControlToValidate="tbCourse1">
                              </asp:RequiredFieldValidator>
                            </div>
                        <asp:TextBox ID="tbCourseID1" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="Course ID"></asp:TextBox>
                            <div class="collapse">
                              <asp:RequiredFieldValidator ID="RequiredFieldValidator3" ValidationGroup="validSecondary" runat="server" ErrorMessage="Course ID Required" Display="None" ControlToValidate="tbCourseID1">
                              </asp:RequiredFieldValidator>
                            </div>                   
                        <asp:DropDownList ID="ddlDept1" runat="server" CssClass="dropdown-toggle btn-lg" height="45px">
                           <asp:ListItem class="dropdown-header">
                                Dept
                            </asp:ListItem>
                                <asp:ListItem>ELA</asp:ListItem>
                                <asp:ListItem>Math</asp:ListItem>
                                <asp:ListItem>Hist</asp:ListItem>
                                <asp:ListItem>SCI</asp:ListItem>
                              </asp:DropDownList>
 
                        <asp:Button ID="btnPeriod1" ValidationGroup="validSecondary" runat="server" CssClass="btn btn-primary pull-right" Text="Insert this class" OnClick="btnPeriod1_Click" />
                        <br />
                      
       <div id="radio-group1" class="btn-group" data-toggle="collapse" data-target="#period2" aria-expanded="false" aria-controls="collapseExample">
                <h4>  <span class="glyphicon glyphicon-plus-sign" ></span> Add Another Class  </h4>
                    <br />                                     
        </div>
                    </div>
              <%--NEW PERIOD--%>
 
            <div class="collapse" id="period2">
                    <div class="form-inline">
                              <asp:DropDownList ID="ddlPeriod2" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Period
                            </asp:ListItem>
                                <asp:ListItem>1</asp:ListItem>
                                <asp:ListItem>2</asp:ListItem>
                                <asp:ListItem>3</asp:ListItem>
                                <asp:ListItem>4</asp:ListItem>
                                <asp:ListItem>5</asp:ListItem>
                                <asp:ListItem>6</asp:ListItem>
                                <asp:ListItem>7</asp:ListItem>
                              </asp:DropDownList>                        
                        <asp:TextBox ID="tbTeacherName2" runat="server" Width="175px"  CssClass="form-control input-lg" placeholder="Teacher Name"></asp:TextBox>
          
                        <asp:TextBox ID="tbTeacherID2" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="TeacherID"></asp:TextBox>
              
                        <asp:TextBox ID="tbCourse2" runat="server" CssClass="form-control input-lg" Width="175px" placeholder="Course Name"></asp:TextBox>
 
                        <asp:TextBox ID="tbCourseID2" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="Course ID"></asp:TextBox>
                     
                        <asp:DropDownList ID="ddlDept2" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Dept
                            </asp:ListItem>
                                <asp:ListItem>ELA</asp:ListItem>
                                <asp:ListItem>Math</asp:ListItem>
                                <asp:ListItem>Hist</asp:ListItem>
                                <asp:ListItem>SCI</asp:ListItem>
                              </asp:DropDownList>                       
                        <asp:Button ID="btnPeriod2" runat="server" ValidationGroup="validSecondary" CssClass="btn btn-primary pull-right" Text="Insert this class" OnClick="btnPeriod2_Click" Enabled="False" />
                           <div id="radio-group2" class="btn-group" data-toggle="collapse" data-target="#period3" aria-expanded="false" aria-controls="collapseExample">
                                    <h4>  <span class="glyphicon glyphicon-plus-sign" ></span> Add Another Class  </h4>
                                        <br />                                     
                            </div>
                    </div>
                </div>
 
         <%--  ----------- NEW PERIOD-----------%>
               <div class="collapse" id="period3">
                    <div class="form-inline">
                              <asp:DropDownList ID="ddlPeriod3" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Period
                            </asp:ListItem>
                                <asp:ListItem>1</asp:ListItem>
                                <asp:ListItem>2</asp:ListItem>
                                <asp:ListItem>3</asp:ListItem>
                                <asp:ListItem>4</asp:ListItem>
                                <asp:ListItem>5</asp:ListItem>
                                <asp:ListItem>6</asp:ListItem>
                                <asp:ListItem>7</asp:ListItem>
                              </asp:DropDownList>                        
                        <asp:TextBox ID="tbTeacherName3" runat="server" Width="175px"  CssClass="form-control input-lg" placeholder="Teacher Name" ></asp:TextBox>
          
                        <asp:TextBox ID="tbTeacherID3" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="TeacherID"></asp:TextBox>
              
                        <asp:TextBox ID="tbCourse3" runat="server" CssClass="form-control input-lg" Width="175px" placeholder="Course Name"></asp:TextBox>
 
                        <asp:TextBox ID="tbCourseID3" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="Course ID"></asp:TextBox>
                     
                        <asp:DropDownList ID="ddlDept3" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Dept
                            </asp:ListItem>
                                <asp:ListItem>ELA</asp:ListItem>
                                <asp:ListItem>Math</asp:ListItem>
                                <asp:ListItem>Hist</asp:ListItem>
                                <asp:ListItem>SCI</asp:ListItem>
                              </asp:DropDownList>
                         
                     <asp:Button ID="btnPeriod3" runat="server" CssClass="btn btn-primary pull-right" Text="Insert this class" OnClick="btnPeriod3_Click" />
                           <div id="radio-group3" class="btn-group" data-toggle="collapse" data-target="#period4" aria-expanded="false" aria-controls="collapseExample">
                                    <h4>  <span class="glyphicon glyphicon-plus-sign" ></span> Add Another Class  </h4>
                                        <br />                                     
                            </div>
                    </div>
                </div>
 
              <%--  ----------- NEW PERIOD-----------%>
               <div class="collapse" id="period4">
                    <div class="form-inline">
                              <asp:DropDownList ID="ddlPeriod4" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Period
                            </asp:ListItem>
                                <asp:ListItem>1</asp:ListItem>
                                <asp:ListItem>2</asp:ListItem>
                                <asp:ListItem>3</asp:ListItem>
                                <asp:ListItem>4</asp:ListItem>
                                <asp:ListItem>5</asp:ListItem>
                                <asp:ListItem>6</asp:ListItem>
                                <asp:ListItem>7</asp:ListItem>
                              </asp:DropDownList>                        
                        <asp:TextBox ID="tbTeacherName4" runat="server" Width="175px"  CssClass="form-control input-lg" placeholder="Teacher Name" ></asp:TextBox>
          
                        <asp:TextBox ID="tbTeacherID4" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="TeacherID"></asp:TextBox>
              
                        <asp:TextBox ID="tbCourse4" runat="server" CssClass="form-control input-lg" Width="175px" placeholder="Course Name"></asp:TextBox>
 
                        <asp:TextBox ID="tbCourseID4" runat="server" CssClass="form-control input-lg" Width="115px" placeholder="Course ID"></asp:TextBox>
                     
                        <asp:DropDownList ID="ddlDept4" runat="server" CssClass="btn btn-default dropdown-toggle btn-lg">
                           <asp:ListItem class="dropdown-header">
                                Dept
                            </asp:ListItem>
                                <asp:ListItem>ELA</asp:ListItem>
                                <asp:ListItem>Math</asp:ListItem>
                                <asp:ListItem>Hist</asp:ListItem>
                                <asp:ListItem>SCI</asp:ListItem>
                              </asp:DropDownList>
                        <asp:Button ID="btnPeriod4" runat="server" CssClass="btn btn-primary pull-right" Text="Insert this class" OnClick="btnPeriod4_Click" />
                        <br />
                      
                    </div>
                </div>
 
         </div>
 
    </div
                  
    </div>
 
    <br />
    <br />
    <br />
 
   <script>
            $('.glyphicon').click(function () {
            $(this).toggleClass('glyphicon glyphicon-plus-sign').toggleClass('glyphicon glyphicon-minus-sign');
        });
    </script>
 
    
     
    <asp:SqlDataSource ID="sqlTeacher" runat="server" ConnectionString="<%$ ConnectionStrings:MyMatrixConnectionString %>" ProviderName="<%$ ConnectionStrings:MyMatrixConnectionString.ProviderName %>" SelectCommand="SELECT DISTINCT teacher FROM CRS">
        <SelectParameters>
            <asp:SessionParameter Name="DistrictID" SessionField="DistrictID" />
        </SelectParameters>
    </asp:SqlDataSource>
 
</asp:Content>

 

 

namespace Matrix_Builder
{
    public partial class addStudent : System.Web.UI.Page
    {
        MembershipUser username = Membership.GetUser();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                LFlevel.Visible = false;
                //period.Visible = false;
                //distID.Text = Session["DistrictID"].ToString();
            
        }
 
        protected void btnStudent_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                int dID = 0;
                var DistrictID = Session["DistrictID"];
                dID = Convert.ToInt32(DistrictID);
 
                //GET MEMBERSHIP USERNAME!
                string storeProc = "sp_InsertSTU";
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
                conn.Open();
                DateTime dt = Convert.ToDateTime(RDusDate.SelectedDate);
                string temp = dt.ToShortDateString();
 
                try
                {
                    SqlCommand cmd = new SqlCommand(storeProc, conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@DistrictID", dID));
                    cmd.Parameters.Add(new SqlParameter("@username", username.ToString()));
                    cmd.Parameters.Add(new SqlParameter("@schoolID", tbSchoolID.Text));
                    cmd.Parameters.Add(new SqlParameter("@PID", StudentID.Value));
                    cmd.Parameters.Add(new SqlParameter("@Student_Name", Name.Value));
                    cmd.Parameters.Add(new SqlParameter("@grade", ddlGrade.SelectedValue.ToString()));
                    cmd.Parameters.Add(new SqlParameter("@ethnicity", ddlRace.SelectedValue.ToString()));
                    cmd.Parameters.Add(new SqlParameter("@LF", ddlLF.SelectedValue.ToString()));
                    cmd.Parameters.Add(new SqlParameter("@CELDT_LVL", ddlLF_level.SelectedValue.ToString()));
                    cmd.Parameters.Add(new SqlParameter("@SPED", ddlSped.SelectedValue.ToString()));
                    cmd.Parameters.Add(new SqlParameter("@US_entry_date", temp));
                    cmd.ExecuteScalar();
                    conn.Close();
 
                    distID.Text = "Student Demographic Data Successfully Inserted";
                }
 
                catch (Exception ex)
 
                {
                    error.Text = ex.Message;
                }
            }
 
            if (btnElementary.CssClass == "btn btn-primary" & Page.IsValid)
            {
                string Tname = ELEMautoTeacher.Text;
                string teachID = "";
                string course = ELEMautoTeacher.Text;
                string courseID = ddlGrade.SelectedValue;
                string period = "E";
                string dept = ddlGrade.SelectedValue;
                string user = username.ToString();
                var DistrictID = Session["DistrictID"].ToString();
                var studentID = StudentID.Value;
                var schoolID = tbSchoolID.Text;
 
                Dictionary<string, string> testdir = new Dictionary<string, string>
                        {
                            {"@username",user },
                            {"@DistrictID",DistrictID },
                            {"@teacher",Tname },
                            {"@TeacherID", teachID },
                            {"@CO", course },
                            {"@CN", courseID },
                            {"@period", period },
                            {"@PID", studentID },
                            {"@schoolID", schoolID },
                            {"@dept", dept }
                        };
                string testconnectString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
 
                SQLMethod("sp_InsertCRS", testconnectString, testdir, btnPeriod1);
            }
        }
 
        protected void ddlGrade_SelectedIndexChanged(object sender, EventArgs e)
        {
            int i = Int32.Parse(ddlGrade.SelectedValue);
            if (i > 6)
            {
                btnElementary.CssClass = "btn btn-default";
                btnSecondary.CssClass = "btn btn-primary";
                target.Attributes["class"] = "";
                DIVelemTeacher.Visible = false;
            }
            else
            {
                btnElementary.CssClass = "btn btn-primary";
                btnSecondary.CssClass = "btn btn-default";
                target.Attributes["class"] = "collapse";
                DIVelemTeacher.Visible = true;
            }
        }
 
        protected void ddlLF_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlLF.SelectedValue == "EL")
            {
                LFlevel.Visible = true;
            }
            else
            {
                LFlevel.Visible = false;
            }
             
        }
 
        protected void btnElementary_Click(object sender, EventArgs e)
        {
            if (sender == btnSecondary)
            {
                btnElementary.CssClass = "btn btn-default";
                btnSecondary.CssClass = "btn btn-primary";
                target.Attributes["class"] = "";
                DIVelemTeacher.Visible = false;
            }
 
            if (sender == btnElementary)
            {
                btnElementary.CssClass = "btn btn-primary";
                btnSecondary.CssClass = "btn btn-default";
                target.Attributes["class"] = "collapse";
                DIVelemTeacher.Visible = true;
            }
        }
 
        protected void btnSecondary_Click(object sender, EventArgs e)
        {          
                btnElementary.CssClass = "btn btn-primary";
                target.Attributes["class"] = "collapse";           
        }
 
        protected void btnPeriod1_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                 
                string Tname = tbTeacherName1.Text;
                string teachID = tbTeacherID1.Text;
                string course = tbCourse1.Text;
                string courseID = tbCourseID1.Text;
                string period = ddlPeriod.SelectedValue;
                string dept = ddlDept1.SelectedValue;
                string user = username.ToString();
                var DistrictID = Session["DistrictID"].ToString();
                var studentID = StudentID.Value;
                var schoolID = tbSchoolID.Text;
 
                Dictionary<string, string> testdir = new Dictionary<string, string>
                {
                    {"@username",user },
                    {"@DistrictID",DistrictID },
                    {"@teacher",Tname },
                    {"@TeacherID", teachID },
                    {"@CO", course },
                    {"@CN", courseID },
                    {"@period", period },
                    {"@PID", studentID },
                    {"@schoolID", schoolID },
                    {"@dept", dept }
                    
                };
                string testconnectString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
 
                SQLMethod("sp_InsertCRS", testconnectString, testdir, btnPeriod1);
 
            }
        }
 
        protected void btnPeriod2_Click(object sender, EventArgs e)
        {
            string Tname = tbTeacherName2.Text;
            string teachID = tbTeacherID2.Text;
            string course = tbCourse2.Text;
            string courseID = tbCourseID2.Text;
            string period = ddlPeriod2.SelectedValue;
            string dept = ddlDept2.SelectedValue;
 
            string user = username.ToString();
            var DistrictID = Session["DistrictID"].ToString();
            var studentID = StudentID.Value;
            var schoolID = tbSchoolID.Text;
             
 
            Dictionary<string, string> testdir = new Dictionary<string, string>
                {
                    {"@username",user },
                    {"@DistrictID",DistrictID },
                    {"@teacher",Tname },
                    {"@TeacherID", teachID },
                    {"@CO", course },
                    {"@CN", courseID },
                    {"@period", period },
                    {"@PID", studentID },
                    {"@schoolID", schoolID },
                    {"@dept", dept }
 
                };
 
            string testconnectString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
 
            SQLMethod("sp_InsertCRS", testconnectString, testdir, btnPeriod2);
        }
 
        public void SQLMethod(string storeProc, string connectString, Dictionary<string, string> dir, Button btn)
        {
 
            SqlConnection conn = new SqlConnection(connectString);
            conn.Open();
 
            try
            {
                SqlCommand cmd = new SqlCommand(storeProc, conn);
                cmd.CommandType = CommandType.StoredProcedure;
                foreach (KeyValuePair<string, string> keyValue in dir)
                {
                    cmd.Parameters.Add(new SqlParameter(keyValue.Key, keyValue.Value));
                }
 
                cmd.ExecuteScalar();
                conn.Close();
 
                btn.Text = "Success";
                btn.CssClass = "btn btn-info pull-right";
                btn.Enabled = false;
 
            }
            catch (Exception ex)
            {
                distID.Text = ex.Message;
            }
        }
 
        protected void btnPeriod3_Click(object sender, EventArgs e)
        {
            string Tname = tbTeacherName3.Text;
            string teachID = tbTeacherID3.Text;
            string course = tbCourse3.Text;
            string courseID = tbCourseID3.Text;
            string period = ddlPeriod3.SelectedValue;
            string dept = ddlDept3.SelectedValue;
 
            string user = username.ToString();
            var DistrictID = Session["DistrictID"].ToString();
            var studentID = StudentID.Value;
            var schoolID = tbSchoolID.Text;
 
 
            Dictionary<string, string> testdir = new Dictionary<string, string>
                {
                    {"@username",user },
                    {"@DistrictID",DistrictID },
                    {"@teacher",Tname },
                    {"@TeacherID", teachID },
                    {"@CO", course },
                    {"@CN", courseID },
                    {"@period", period },
                    {"@PID", studentID },
                    {"@schoolID", schoolID },
                    {"@dept", dept }
 
                };
 
            string testconnectString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
 
            SQLMethod("sp_InsertCRS", testconnectString, testdir, btnPeriod3);
        }
 
        protected void btnPeriod4_Click(object sender, EventArgs e)
        {
            string Tname = tbTeacherName4.Text;
            string teachID = tbTeacherID4.Text;
            string course = tbCourse4.Text;
            string courseID = tbCourseID4.Text;
            string period = ddlPeriod4.SelectedValue;
            string dept = ddlDept4.SelectedValue;
 
            string user = username.ToString();
            var DistrictID = Session["DistrictID"].ToString();
            var studentID = StudentID.Value;
            var schoolID = tbSchoolID.Text;
 
 
            Dictionary<string, string> testdir = new Dictionary<string, string>
                {
                    {"@username",user },
                    {"@DistrictID",DistrictID },
                    {"@teacher",Tname },
                    {"@TeacherID", teachID },
                    {"@CO", course },
                    {"@CN", courseID },
                    {"@period", period },
                    {"@PID", studentID },
                    {"@schoolID", schoolID },
                    {"@dept", dept }
 
                };
 
            string testconnectString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
 
            SQLMethod("sp_InsertCRS", testconnectString, testdir, btnPeriod4);
        }
 
 
    }
Kristopher
Top achievements
Rank 1
 asked on 14 Mar 2017
2 answers
97 views

In the latest versions of the Google Chrome browser, I am having an issue with the background images upon cursor hover for child RadPanelItems.

I took the code sample below from the telerik website example, and the only edits from the original source were that I removed the ImageUrl properties from the child elements.

http://demos.telerik.com/aspnet-ajax/panelbar/examples/overview/defaultcs.aspx

Does anybody have a workaround for this? It seems to work fine in Internet Explorer and Firefox, just recent versions of Chrome seem to display oddly.

Thanks in advance!

<telerik:RadPanelBar runat="server" ID="RadPanelBar1">
    <Items>
        <telerik:RadPanelItem Text="Mail" ImageUrl="images/mail.gif" Expanded="True">
            <Items>
                <telerik:RadPanelItem Text="Personal Folders" />
                <telerik:RadPanelItem Text="Deleted Items" />
                <telerik:RadPanelItem Text="Inbox" />
                <telerik:RadPanelItem Text="My Mail" />
                <telerik:RadPanelItem Text="Sent Items" />
                <telerik:RadPanelItem Text="Outbox" />
                <telerik:RadPanelItem Text="Search Folders" />
            </Items>
        </telerik:RadPanelItem>
        <telerik:RadPanelItem Text="Contacts" ImageUrl="images/contacts.gif">
            <Items>
                <telerik:RadPanelItem Text="My Contacts" />
                <telerik:RadPanelItem Text="Address Cards" />
                <telerik:RadPanelItem Text="Phone List" />
                <telerik:RadPanelItem Text="Shared Contacts" />
            </Items>
        </telerik:RadPanelItem>
        <telerik:RadPanelItem Text="Tasks" ImageUrl="images/tasks.gif">
            <Items>
                <telerik:RadPanelItem Text="My Tasks" />
                <telerik:RadPanelItem Text="Shared Tasks" />
                <telerik:RadPanelItem Text="Active Tasks" />
                <telerik:RadPanelItem Text="Completed Tasks" />
            </Items>
        </telerik:RadPanelItem>
        <telerik:RadPanelItem Text="Notes" ImageUrl="images/notes.gif">
            <Items>
                <telerik:RadPanelItem Text="My Notes" />
                <telerik:RadPanelItem Text="Notes List" />
                <telerik:RadPanelItem Text="Shared Notes" />
                <telerik:RadPanelItem Text="Archive" />
            </Items>
        </telerik:RadPanelItem>
        <telerik:RadPanelItem Text="Folders List" ImageUrl="images/folderList.gif">
            <Items>
                <telerik:RadPanelItem Text="My Client.Net" />
                <telerik:RadPanelItem Text="My Profile" />
                <telerik:RadPanelItem Text="My Support Tickets" />
                <telerik:RadPanelItem Text="My Licenses" />
            </Items>
        </telerik:RadPanelItem>
    </Items>
</telerik:RadPanelBar>
Joe
Top achievements
Rank 2
 answered on 14 Mar 2017
4 answers
288 views
Building my grid dynamically, getting this error all of a sudden and it's testing my patience. Please help...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
    'Initialize Session Variables
    Session("CarrierID") = CarriersDD.SelectedValue
    Session("TransactionID") = itemTransDD.SelectedValue
    Session("InOrOut") = "0"
 
    If Session("pageSize") = "" Then
        Session("pageSize") = "50"
    End If
 
    Me.PlaceHolder1.Controls.Clear()
 
    PopulateGridOnPageInit()
 
    'Dim grid As RadGrid = CType(PlaceHolder1.FindControl("RadGrid1"), RadGrid)
    'Dim filter As RadFilter = CType(PlaceHolder1.FindControl("gridFilter"), RadFilter)
 
End Sub
 
Protected Sub PopulateGridOnPageInit()
 
    If Not itemTransDD.SelectedValue = "" Then
 
        displayResults.InnerHtml = ""
 
        Dim ConnString As String = ConfigurationManager.ConnectionStrings(Session("connString")).ConnectionString
        Dim conn As SqlConnection = New SqlConnection(ConnString)
 
        conn.Open()
 
        '***** Display Labels and Data above data grid *****'
        Dim tblDisplayData As DataTable = New DataTable
 
        Dim displaycmd As SqlCommand = New SqlCommand("tdw_spDisplayPendingRateDataMaster", conn)
        displaycmd.Parameters.AddWithValue("TransactionID", Session("TransactionID"))
        displaycmd.Parameters.AddWithValue("CarrierID", Session("CarrierID"))
 
        displaycmd.CommandType = CommandType.StoredProcedure
 
        Dim MySQLreader As SqlDataReader
        MySQLreader = displaycmd.ExecuteReader()
 
        Dim maxRead As Integer = MySQLreader.FieldCount - 1
        MySQLreader.Read()
        If MySQLreader.HasRows Then
            For z As Integer = 0 To maxRead
                If MySQLreader.GetName(z).ToString() = "Eff Date" Then
                    displayResults.InnerHtml += "<span style='width:150px; margin-left:20px;'><b>" + MySQLreader.GetName(z).ToString() + " -</b> " + Format(MySQLreader(z), "Short Date") + "</span>"
                Else
                    displayResults.InnerHtml += "<span style='width:150px; margin-left:20px;'><b>" + MySQLreader.GetName(z).ToString() + " -</b> " + MySQLreader(z).ToString() + "</span>"
                End If
 
 
                'Check for InOrOut field value
                If MySQLreader.GetName(z).ToString() = "In Or Out" Then
                    Session("InOrOut") = MySQLreader(z).ToString()
                End If
            Next
 
            transItemDisplay.Visible = True
            itemTransDD.Visible = True
            CarriersDD.Visible = True
            btnAccept.Visible = True
            btnReject.Visible = True
            lblExport.Visible = True
            mngBtnExcel.Visible = True
            mngBtnPDF.Visible = True
            btnClearFilters.Visible = True
 
        Else
            displaymsg.InnerHtml = "There are currently no rates for you to review."
 
 
        End If
        conn.Close()
        '***** End of display label data *****'
 
        Dim RadGrid1 As RadGrid = New RadGrid
 
        AddHandler RadGrid1.Init, AddressOf RadGrid1_Init
        AddHandler RadGrid1.ItemCommand, AddressOf RadGrid1_ItemCommand
        AddHandler RadGrid1.PageSizeChanged, AddressOf RadGrid1_PageSizeChanged
        'AddHandler RadGrid1.ItemCreated, AddressOf RadGrid1_ItemCreated
        'AddHandler RadGrid1.ItemDataBound, AddressOf RadGrid1_ItemDataBound
        AddHandler RadGrid1.PageSizeChanged, AddressOf RadGrid1_PageSizeChanged
        AddHandler RadGrid1.PdfExporting, AddressOf RadGrid1_PdfExporting
        AddHandler RadGrid1.GridExporting, AddressOf RadGrid1_GridExporting
 
        RadGrid1.ID = "RadGrid1"
        RadGrid1.Width = Unit.Percentage(100)
        RadGrid1.AllowPaging = True
        RadGrid1.MasterTableView.PagerStyle.Mode = GridPagerMode.NextPrevNumericAndAdvanced
        RadGrid1.MasterTableView.AllowCustomPaging = False
        RadGrid1.MasterTableView.VirtualItemCount = "1000"
        RadGrid1.MasterTableView.PagerStyle.Position = GridPagerPosition.TopAndBottom
        RadGrid1.PageSize = 50
        RadGrid1.AllowSorting = True
        RadGrid1.AllowFilteringByColumn = True
        RadGrid1.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric
        RadGrid1.PagerStyle.Position = GridPagerPosition.TopAndBottom
        RadGrid1.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None
        RadGrid1.MasterTableView.CommandItemStyle.BackColor = Color.LightGray
        RadGrid1.MasterTableView.CommandItemStyle.ForeColor = Color.Black
        RadGrid1.MasterTableView.AllowFilteringByColumn = True
        RadGrid1.ExportSettings.ExportOnlyData = True
        RadGrid1.AutoGenerateColumns = False
        RadGrid1.Skin = "Sitefinity"
        RadGrid1.BorderStyle = BorderStyle.None
        RadGrid1.MasterTableView.HeaderStyle.ForeColor = Color.White
        RadGrid1.MasterTableView.EnableColumnsViewState = True
        RadGrid1.MasterTableView.PageSize = Session("pageSize")
        RadGrid1.MasterTableView.ExpandCollapseColumn.Visible = False
        RadGrid1.MasterTableView.AllowMultiColumnSorting = True
        RadGrid1.GroupingSettings.CaseSensitive = False
        RadGrid1.EnableViewState = True
        RadGrid1.MasterTableView.TableLayout = GridTableLayout.Auto
 
 
 
        '***** Get and Display Grid Data *****'
        conn.Open()
        Dim dtPendingRates As DataTable = New DataTable
 
        Dim cmd As SqlCommand = New SqlCommand("tdw_spDisplayPendingRateDataDetail", conn)
        cmd.Parameters.AddWithValue("TransactionID", Session("TransactionID"))
        cmd.Parameters.AddWithValue("CarrierID", Session("CarrierID"))
        cmd.Parameters.AddWithValue("InOrOut", Session("InOrOut"))
 
        cmd.CommandType = CommandType.StoredProcedure
 
        Dim adapter As New SqlDataAdapter(cmd)
        adapter.SelectCommand.CommandTimeout = 300
 
        adapter.Fill(dtPendingRates)
 
        If dtPendingRates.Columns.Count > 0 Then
            Dim name(dtPendingRates.Columns.Count) As String
            Dim i As Integer = 0
            For Each column As DataColumn In dtPendingRates.Columns
                Dim boundColumn As GridBoundColumn = New GridBoundColumn
                RadGrid1.MasterTableView.Columns.Add(boundColumn)
                boundColumn.DataField = column.ColumnName
                boundColumn.HeaderText = column.ColumnName
                'boundColumn.AndCurrentFilterFunction = GridKnownFunction.Contains
                boundColumn.ShowFilterIcon = True
                boundColumn.AutoPostBackOnFilter = True
 
 
 
                If column.ColumnName = "Discount" Then
                    Session("HasDiscountFld") = column.ColumnName
                End If
 
            Next
 
            Dim showHideMinFlag As Boolean = False
            Dim showHideRateFlag As Boolean = False
 
            'Compare data in Mimimum/Minimum New & Rate/RateNew
            'If they are the same, hide the new column
            For Each row As DataRow In dtPendingRates.Rows
                If Session("HasDiscountFld") = "Discount" Then
                    'Do Nothing
                    Dim min As String = row.Item("Minimum").ToString
                    Dim minNew As String = row.Item("Minimum New").ToString
 
                    If min <> minNew Then
                        showHideMinFlag = True
                    End If
 
                Else
                    Dim min As String = row.Item("Minimum").ToString
                    Dim minNew As String = row.Item("Minimum New").ToString
 
                    Dim rate As String = row.Item("Rate").ToString
                    Dim rateNew As String = row.Item("Rate New").ToString
 
                    If rate <> rateNew Then
                        showHideRateFlag = True
                    End If
 
 
                    If min <> minNew Then
                        showHideMinFlag = True
                    End If
 
 
 
                End If
                
            Next
 
            If Session("HasDiscountFld") <> "Discount" Then
                '*** Show or hide fields based on comparison between fields completed above.
                If showHideMinFlag = True Then
                    RadGrid1.MasterTableView.GetColumn("Minimum New").Visible = True
                Else
                    RadGrid1.MasterTableView.GetColumn("Minimum New").Visible = False
                End If
 
                If showHideRateFlag = True Then
                    RadGrid1.MasterTableView.GetColumn("Rate New").Visible = True
                Else
                    RadGrid1.MasterTableView.GetColumn("Rate New").Visible = False
                End If
            End If
 
 
            Session("HasDiscountFld") = ""
 
            RadGrid1.DataSource = dtPendingRates
        End If
 
        conn.Close()
 
 
        Try
            Me.PlaceHolder1.Controls.Add(RadGrid1)
        Catch ex As Exception
 
        End Try
 
        displaymsg.InnerHtml = "The following rate transactions are waiting to be approved. Please select a transaction and click "View" to view its details. <asp:HyperLink ID='HyperLink1' runat='server'>View all rates for this carrier.</asp:HyperLink>"
 
    Else
        Dim RadGrid1 As RadGrid = New RadGrid
 
        RadGrid1.ID = "RadGrid1"
 
        Try
            'Me.PlaceHolder1.Controls.Add(RadGrid1)
        Catch ex As Exception
 
        End Try
 
        displaymsg.InnerHtml = "<h2>There are currently no rates for you to review.</h2>"
        If Not Session("userCarrierName") = "" Then
            lblCompany.Text = Session("userCarrierName")
        End If
 
    End If
 
    If Session("userRole") = "TDW Admin" Then
        btnAccept.Visible = False
        btnReject.Visible = False
    End If
 
End Sub
 
Protected Sub CarriersDD_SelectedIndexChanged(sender As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs) Handles CarriersDD.SelectedIndexChanged
    ' Display Carrier Name on screen
    lblCompany.Text = CarriersDD.SelectedItem.Text
 
    Dim oldGrid As RadGrid
    oldGrid = PlaceHolder1.FindControl("RadGrid1")
    Try
        PlaceHolder1.Controls.Remove(oldGrid)
    Catch ex As Exception
 
    End Try
 
    Dim oldFilter As RadFilter
    oldFilter = PlaceHolder1.FindControl("gridFilter")
    Try
        PlaceHolder1.Controls.Remove(oldFilter)
    Catch ex As Exception
 
    End Try
 
    ' Store CarrierID in a session variable to access in application
    Session("CarrierID") = CarriersDD.SelectedValue
    GetItemTransDD.DataBind()
End Sub
 
Protected Sub itemTransDD_SelectedIndexChanged(sender As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs) Handles itemTransDD.SelectedIndexChanged
    ' Store TransactionID in a session variable to access in application
    Session("TransactionID") = itemTransDD.SelectedValue
 
    Dim oldGrid As RadGrid
    oldGrid = PlaceHolder1.FindControl("RadGrid1")
    Try
        PlaceHolder1.Controls.Remove(oldGrid)
    Catch ex As Exception
 
    End Try
 
    Dim oldFilter As RadFilter
    oldFilter = PlaceHolder1.FindControl("gridFilter")
    Try
        PlaceHolder1.Controls.Remove(oldFilter)
    Catch ex As Exception
 
    End Try
 
    PopulateGridOnPageInit()
End Sub
 
Protected Sub CarriersDD_DataBound(sender As Object, e As EventArgs) Handles CarriersDD.DataBound
    Dim combo As RadComboBox = CarriersDD
    Try
        CarriersDD.Items(0).Selected = True
 
        lblCompany.Text = CarriersDD.SelectedItem.Text
 
        ' Store CarrierID in a session variable to access in application
        Session("CarrierID") = CarriersDD.SelectedValue
        GetItemTransDD.DataBind()
    Catch ex As Exception
 
    End Try
    If Session("CarrierID") = "" Then
        CarriersDD.Visible = False
    Else
        CarriersDD.Visible = True
    End If
End Sub
 
Protected Sub itemTransDD_DataBound(sender As Object, e As EventArgs) Handles itemTransDD.DataBound
    ' Store TransactionID in a session variable to access in application
    Session("TransactionID") = itemTransDD.SelectedValue
 
    Dim oldGrid As RadGrid
    oldGrid = PlaceHolder1.FindControl("RadGrid1")
    Try
        PlaceHolder1.Controls.Remove(oldGrid)
    Catch ex As Exception
 
    End Try
 
    Dim oldFilter As RadFilter
    oldFilter = PlaceHolder1.FindControl("gridFilter")
    Try
        PlaceHolder1.Controls.Remove(oldFilter)
    Catch ex As Exception
 
    End Try
 
    If Session("TransactionID") = "" Then
        itemTransDD.Visible = False
        transItemDisplay.Visible = False
    Else
        itemTransDD.Visible = True
        transItemDisplay.Visible = True
    End If
 
    PopulateGridOnPageInit()
End Sub
 
Private Sub RadGrid1_Init(ByVal sender As Object, ByVal e As System.EventArgs)
    Dim grid As RadGrid = Me.PlaceHolder1.FindControl("RadGrid1")
 
    Dim menu As GridFilterMenu = grid.FilterMenu
    Dim i As Integer = 0
    While i < menu.Items.Count
        If menu.Items(i).Text = "DoesNotContain" Then
            menu.Items(i).Text = "Does Not Contain"
            i = i + 1
        ElseIf menu.Items(i).Text = "StartsWith" Then
            menu.Items(i).Text = "Starts With"
            i = i + 1
        ElseIf menu.Items(i).Text = "EndsWith" Then
            menu.Items(i).Text = "Ends With"
            i = i + 1
        ElseIf menu.Items(i).Text = "EqualTo" Then
            menu.Items(i).Text = "Equal To"
            i = i + 1
        ElseIf menu.Items(i).Text = "NotEqualTo" Then
            menu.Items(i).Text = "Not Equal To"
            i = i + 1
        ElseIf menu.Items(i).Text = "GreaterThan" Then
            menu.Items(i).Text = "GreaterThan"
            i = i + 1
        ElseIf menu.Items(i).Text = "LessThan" Then
            menu.Items(i).Text = "Less Than"
            i = i + 1
        ElseIf menu.Items(i).Text = "GreaterThanOrEqualTo" Then
            menu.Items(i).Text = "Greater Than Or Equal To"
            i = i + 1
        ElseIf menu.Items(i).Text = "LessThanOrEqualTo" Then
            menu.Items(i).Text = "Less Than Or Equal To"
            i = i + 1
        ElseIf menu.Items(i).Text = "NotBetween" Then
            menu.Items(i).Text = "Not Between"
            i = i + 1
        ElseIf menu.Items(i).Text = "IsEmpty" Then
            menu.Items(i).Text = "Is Empty"
            i = i + 1
        ElseIf menu.Items(i).Text = "NotIsEmpty" Then
            menu.Items(i).Text = "Is Not Empty"
            i = i + 1
        ElseIf menu.Items(i).Text = "IsNull" Then
            menu.Items(i).Text = "Is Null"
            i = i + 1
        ElseIf menu.Items(i).Text = "NotIsNull" Then
            menu.Items(i).Text = "Is Not Null"
            i = i + 1
        Else
            i = i + 1
            'menu.Items.RemoveAt(i)
        End If
    End While
End Sub
 
Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As GridCommandEventArgs)
    Dim grid As RadGrid = Me.PlaceHolder1.FindControl("RadGrid1")
 
    If e.CommandName = RadGrid.FilterCommandName Then
        Dim filterPair As Pair = CType(e.CommandArgument, Pair)
        Dim colName As String = filterPair.Second.ToString()
        grid.MasterTableView.GetColumn(colName).HeaderStyle.BackColor = Color.DarkSlateGray
    End If
End Sub
 
Public Sub btnExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs)
    Dim url As String = "export_pendingrates.aspx"
 
    ClientScript.RegisterStartupScript(Me.GetType(), "OpenWin", "<script>openNewWin('" & url & "')</script>")
 
End Sub
 
Protected Sub btnPDF_Click(ByVal sender As Object, ByVal e As System.EventArgs)
    Dim url As String = "exportPDF_pendingrates.aspx"
 
    ClientScript.RegisterStartupScript(Me.GetType(), "OpenWin", "<script>openNewWin('" & url & "')</script>")
End Sub
 
Protected Sub RadGrid1_PdfExporting(ByVal sender As Object, e As GridPdfExportingArgs)
    e.RawHTML = "<div><img src='../../Images/tdwlogo-sm.png'/></div><div style='text-align:center; color: #000; font-weight: bold;'>TDW Web Portal - Pending Rates</div><hr/>" + e.RawHTML + "<div style='text-align:center'><hr/>Exported on " + Date.Today + "</div>"
End Sub
 
Protected Sub RadGrid1_GridExporting(ByVal sender As Object, e As GridExportingArgs)
    If e.ExportType = ExportType.Excel Then
        'Set colspan on customText to 8 to account for fields being exported from Grid
        Dim customText As String = "<table><tr style='background-color:#D0D0D0; text-align:center; font-weight:bold;'><td colspan='8'>TDW Web Portal - Active Rates - Exported on " + Date.Today + "</td></tr></table>"
        e.ExportOutput = e.ExportOutput.Replace("<body>", "<body>" + customText)
    End If
End Sub
 
Protected Sub btnAccept_Click(sender As Object, e As EventArgs) Handles btnAccept.Click
    'Approve/Accept Rates for Carrier
    Dim ConnString As String = ConfigurationManager.ConnectionStrings(Session("connString")).ConnectionString
    Dim conn As SqlConnection = New SqlConnection(ConnString)
 
    conn.Open()
 
    Dim cmd As SqlCommand = New SqlCommand("tdw_spApprovePendingRate", conn)
    cmd.Parameters.AddWithValue("TransactionID", Session("TransactionID"))
    cmd.Parameters.AddWithValue("CarrierID", Session("CarrierID"))
    cmd.Parameters.AddWithValue("Username", My.User.Name)
 
    cmd.CommandType = CommandType.StoredProcedure
 
    Dim dr As SqlDataReader
    dr = cmd.ExecuteReader
 
    If dr.RecordsAffected Then
        Response.Redirect("pendingratechanges.aspx")
 
    End If
    conn.Close()
 
    'RadWindowManager1.RadAlert("Postback from asp button on " + DateTime.Now.ToString(), 300, 110, "Action Result", Nothing)
End Sub
 
<WebMethod()> _
Public Shared Function RejectRates(ByVal comments As String) As Boolean
    'Javascript calls this Function after user has entered comments for rejecting rates
    'Exec's SP to reject selected rates
 
 
    Dim ConnString As String = ConfigurationManager.ConnectionStrings(HttpContext.Current.Session("connString")).ConnectionString
    Dim conn As SqlConnection = New SqlConnection(ConnString)
 
    conn.Open()
 
    Dim cmd As SqlCommand = New SqlCommand("tdw_spRejectPendingRate", conn)
    cmd.Parameters.AddWithValue("TransactionID", HttpContext.Current.Session("TransactionID"))
    cmd.Parameters.AddWithValue("CarrierID", HttpContext.Current.Session("CarrierID"))
    cmd.Parameters.AddWithValue("Username", My.User.Name)
    cmd.Parameters.AddWithValue("RejectReason", comments)
 
    cmd.CommandType = CommandType.StoredProcedure
 
    Dim dr As SqlDataReader
    dr = cmd.ExecuteReader
 
    If dr.RecordsAffected Then
        conn.Close()
        Return True
    Else
        conn.Close()
        Return False
    End If
 
End Function
 
Protected Sub RadGrid1_PageSizeChanged(ByVal sender As Object, ByVal e As GridPageSizeChangedEventArgs)
    Session("pageSize") = e.NewPageSize.ToString
    'sender.CurrentPageIndex = e.NewPageSize
End Sub
 
Protected Sub btnClearFilters_Click(sender As Object, e As System.Web.UI.ImageClickEventArgs) Handles btnClearFilters.Click
    Dim grid As RadGrid = Me.PlaceHolder1.FindControl("RadGrid1")
 
    For Each column As GridColumn In grid.MasterTableView.Columns
        column.CurrentFilterFunction = GridKnownFunction.NoFilter
        column.CurrentFilterValue = String.Empty
        column.HeaderStyle.BackColor = Color.FromArgb(26, 176, 157)
    Next
 
    grid.MasterTableView.FilterExpression = String.Empty
    grid.MasterTableView.Rebind()
End Sub
Md
Top achievements
Rank 1
 answered on 14 Mar 2017
3 answers
215 views
Hello.

To develop some features in our application we need to get and set caret position (i.e. distance from the beginning of the text or smth like that). It was mentioned by Telerik team in this four-years-old thread that RadEditor did not provide API to get/set caret position.

The only thing we actually need to do is to restore the caret position in design mode after some parts of content are changed (i.e., global reformatting of some keywords). So we store caret position, then some chunks are replaced, then updated HTML is set, and then we set restore caret position.

We have managed to do that in IE using TextRange (such a hack), but it is a really time consuming challenge to get this work properly in all other major browsers.

Browser compatibility is the reason why we use Telerik components. So I hope something have moved further in this area during these four years.

Regards,
Olexandr Vynnychenko
IntraNote a/s
Rumen
Telerik team
 answered on 14 Mar 2017
7 answers
209 views

Hi, now in firefox 52 the radEditor is getting disabled, this is my code:

        <telerik:RadEditor Style="min-width: 95%" ID="txt" runat="server" Width="95%" Height="210px" ContentAreaMode="Iframe" >
        </telerik:RadEditor>

I realized that when we change the contentareamode to div, it allows my to paste correctly, but in my case when i use "iframe" option, it doesn't allow.

 

 

Rumen
Telerik team
 answered on 14 Mar 2017
0 answers
79 views

Hi,

please provide a working sample for RadComboBox with checkboxes in batch editing - how to get and how to set values, both on client and server.

Thank you,
Catalin

Cata
Top achievements
Rank 1
 asked on 14 Mar 2017
1 answer
141 views

Hello

I have a dropdowntree that is updated using a treelist.

I wish when I check a line in my treelist check the corresponding value in the dropdowntree.
But also uncheck the old value.

I use this for

dropdowntree.get_entries().clear()

This method works the first time but if I check a value a second time it no longer works.

I have that :
Dropdowntree.get_entries().count() = 0

Ludovic
Top achievements
Rank 1
 answered on 14 Mar 2017
2 answers
120 views

I would like to apply a class on the  <tool name="InsertUnorderedList" /> , <tool name="InsertOrderedList" />

 

Is there a way to subscribe to tool events to apply the classes when working with the tools.xml? We are using the Rad Editor for content blocks and would like to apply classes according on the ul and ol tags. 

 

If we are to use JS function where would the JS file be located to be available to subscribe to the events fired by Rad Editor

Rumen
Telerik team
 answered on 14 Mar 2017
4 answers
261 views
Is there anyway I can override the InsertUnorderedList command's value to add a class of "mainlist" to the <ul> tag?

Our designer has set the css up so that the only unordered lists that get bullets are <ul>'s with that class.

Is there anyway I can change the value of the HTML that is about to get inserted before it gets inserted? I don't want to change any of the logic of the insert, just the HTML.

Thanks.
Rumen
Telerik team
 answered on 14 Mar 2017
13 answers
491 views

Hi,

I am trying to stop the default mouse over tool tip for an appointment appearing over the top of the right click menu (see attached).

I have tried changing the z-index of the right click menu but this has no made no difference, is there any way to force the tooltip to appear under the right click menu?

Thanks

Gavin.

Sameer
Top achievements
Rank 1
 answered on 14 Mar 2017
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?