ASP.NET

Re: How to display certain records if user's search comes up empty?

14-Aug-14 6:20

Hello Experts,

We are building an app that allows users to make online reservations of our facility.

The code below is designed to allow users to perform a search by either specific date or by date range.

Users can also search by selecting a search option from the dropdownlist.

The way the code works currently, if user's search turns up nothing, then we get the following error message:

Object reference not set to an instance of an object.

Line 259: Dim lblcurrentpage As Label = DirectCast(gvrow.Cells(0).FindControl("CurrentPage"), Label)

Rather than the error message, w would like the code to work differently.

If user's search is successful, the results of his/her search is displayed.

If however, no data is found based on his or her search parameter, we would like to display one month's worth of results.

Is this possible?

Below is the current code we are using.

PHP

Private Sub showGrid()
    ' Set the value of the SearchString so it gets
    SearchString = txtSpecificDate.Text
    ViewSelect = Request("ViewBy")

    If ViewSelect = "" Or ViewSelect = "Range" Then
        ViewSelect = "Range"
    Else
        ViewSelect = "Specific"

    End If
    'Response.Write(ViewSelect)
    'Response.End()

    Dim strQuery As String
    Dim strSearch As String
    Dim receiveddate As String = txtSpecificDate.Text
    Dim fromdate As String = txtFromDate.Text
    Dim enddate As String = txtToDate.Text
    ' Dim dts As DateTime = DateTime.ParseExact(DateString, "MM/dd/yyyy", CultureInfo.InvariantCulture)
    'Protect against SQL Injection
    strSearch = Replace(receiveddate, "'", "''", 1, -1, 1)
    fromdate = Replace(fromdate, "'", "''", 1, -1, 1)
    enddate = Replace(enddate, "'", "''", 1, -1, 1)

    receiveddate = DateTime.Today.ToString("MM/dd/yyyy")
    fromdate = DateTime.Today.ToString("MM/dd/yyyy")
    enddate = "12/31/2050"
    ' first: Do we use AND or OR between clauses in the WHERE?
    Dim andors As String = ANDOR.SelectedValue

    'Response.Write(andors)
    'Response.End()

    ' and now build up the WHERE.

    'First, initialize where just to make sure it has nothing prior to our search
    Dim where As String
    where = ""

    Dim facilityT As DropDownList
    facilityT = FindControl("DropDownList1")
    If facilityT.SelectedValue <> "" Then
        If where <> "" Then where = where & andors
        where = " i.instructorName = '" & Replace(facilityT.SelectedValue, "'", "''") & "'"
    End If
    If ViewSelect = "Range" Then
        If where <> "" Then where = where & andors
        where = where & " CONVERT(VARCHAR(10), d.trainingDates, 101) >= '" & fromdate & "' AND CONVERT(VARCHAR(10),  d.trainingDates, 101) < '" & (enddate) & "'"
    End If
    If ViewSelect = "Specific" Then
        If where <> "" Then where = where & andors
        where = where & " CONVERT(VARCHAR(10), d.trainingDates, 101) = '" & strSearch & "' "
    End If
    'Response.Write(where)
    'Response.End()

    strQuery = "SELECT L.LocationId," & _
   "c.courseId, " & _
    "c.coursename, " & _
   "CASE WHEN L.Seating_Capacity - COALESCE(TS.TakenSeats,0) = 0 THEN 'Not Available' " & _
       " ELSE 'Available' END AS 'AvailableSeats'," & _
    "d.dateid, " & _
   " d.trainingDates, " & _
    "d.trainingtime, " & _
   " c.CourseDescription, " & _
   " i.instructorName, " & _
    "l.location " & _
  " FROM tblLocations L " & _
  " Inner Join tblCourses c on l.locationId = c.locationId " & _
  " Inner Join tblTrainingDates d on c.dateid=d.dateid " & _
 "  Inner Join tblCourseInstructor ic on c.courseId = ic.CourseId " & _
 "  Inner Join tblInstructors i on ic.instructorId = i.instructorId " & _
 "  OUTER APPLY (Select Count(*) TakenSeats " & _
 "  FROM tblTrainings T " & _
 "  where(L.LocationId = T.LocationId) " & _
 "  AND c.courseId = t.courseId) TS where " & where
    'Response.Write("DEBUG: " & strQuery & "<HR>")
    'Response.End()
    Dim cmd As New SqlCommand(strQuery)
    Dim dt As DataTable = GetData(cmd)

    If dt.Rows.Count = 0 Then

        message.Text = "No Records Found"
    End If

    GridView1.DataSource = dt
    GridView1.DataBind()
End Sub

Thanks a lot in advance for your assistance.

Richard Deeming14-Aug-14 6:45

Re: How to display certain records if user's search comes up empty?

14-Aug-14 6:45

samflex wrote:
'Protect against SQL Injection
strSearch = Replace(receiveddate, "'", "''", 1, -1, 1)
fromdate = Replace(fromdate, "'", "''", 1, -1, 1)
enddate = Replace(enddate, "'", "''", 1, -1, 1)

Don't do that! D'Oh! | :doh:

The only way to truly protect against SQL injection is to use a parameterized query. It's not even difficult:

VB.NET

Dim cmd As New SqlCommand("-placeholder-", conn)
Dim sb As New StringBuilder( *** BASE QUERY HERE, up to but not including the "where" keyword *** )

' Hard-code the acceptable values here:
Dim andors As String = IF(ANDOR.SelectedValue = "OR", " OR ", " AND ")
Dim startedWhere As Boolean = False

If facilityT.SelectedValue <> "" Then
    sb.Append(If(startedWhere, andors, " WHERE "))
    sb.Append("i.instructorName = @InstructorName")
    cmd.Parameters.AddWithValue("@InstructorName", facilityT.SelectedValue)
    startedWhere = True
End If

If ViewSelect = "Range" Then
    sb.Append(If(startedWhere, andors, " WHERE "))
    sb.Append("d.trainingDates Between @FromDate And @EndDate")
    cmd.Parameters.AddWithValue("@FromDate", Date.Parse(fromdate))
    cmd.Parameters.AddWithValue("@EndDate", Date.Parse(enddate))
    startedWhere = True
    
ElseIf ViewSelect = "Specific" Then
    sb.Append(If(startedWhere, andors, " WHERE "))
    sb.Append("d.trainingDates = @SpecificDate")
    cmd.Parameters.AddWithValue("@SpecificDate", Date.Parse(strSearch))
    startedWhere = True
End If

cmd.CommandText = sb.ToString()

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

samflex14-Aug-14 7:01

Re: How to display certain records if user's search comes up empty?

14-Aug-14 7:01

Hi Richard

Ever since I started posting here, you have save me a lot - Thank you very much.

Does your solution include the core question that I have about presenting one month's data if user's search turns up nothing?

Also, I am not sure I understand the difference between

PHP

Dim cmd As New SqlCommand("-placeholder-", conn)

and

PHP

Dim sb As New StringBuilder( *** BASE QUERY HERE, up to but not including the "where" keyword *** )

I know the sqlcommand(..) is this:

PHP

SELECT L.LocationId," & _
       "c.courseId, " & _
        "c.coursename, " & _
       "CASE WHEN L.Seating_Capacity - COALESCE(TS.TakenSeats,0) = 0 THEN 'Not Available' " & _
           " ELSE 'Available' END AS 'AvailableSeats'," & _
        "d.dateid, " & _
       " d.trainingDates, " & _
        "d.trainingtime, " & _
       " c.CourseDescription, " & _
       " i.instructorName, " & _
        "l.location " & _
      " FROM tblLocations L " & _
      " Inner Join tblCourses c on l.locationId = c.locationId " & _
      " Inner Join tblTrainingDates d on c.dateid=d.dateid " & _
     "  Inner Join tblCourseInstructor ic on c.courseId = ic.CourseId " & _
     "  Inner Join tblInstructors i on ic.instructorId = i.instructorId " & _
     "  OUTER APPLY (Select Count(*) TakenSeats " & _
     "  FROM tblTrainings T " & _
     "  where(L.LocationId = T.LocationId) " & _
     "  AND c.courseId = t.courseId) TS where "

but I don't understand what goes into the stringbuilder(...)

modified 14-Aug-14 13:14pm.

Richard Deeming14-Aug-14 7:28

Re: How to display certain records if user's search comes up empty?

14-Aug-14 7:28

The "-placeholder-" string in the SqlCommand constructor doesn't need to be changed. It's just there so that the command has some initial text which is obviously not a query. That text will be replaced later, once the full query has been built. (cmd.CommandText = sb.ToString())

The *** BASE QUERY HERE ... *** part needs to be the base query, up-to but not including the final "where" statement:

VB.NET

Dim sb As New StringBuilder("SELECT L.LocationId," & _
       "c.courseId, " & _
        "c.coursename, " & _
       "CASE WHEN L.Seating_Capacity - COALESCE(TS.TakenSeats,0) = 0 THEN 'Not Available' " & _
           " ELSE 'Available' END AS 'AvailableSeats'," & _
        "d.dateid, " & _
       " d.trainingDates, " & _
        "d.trainingtime, " & _
       " c.CourseDescription, " & _
       " i.instructorName, " & _
        "l.location " & _
      " FROM tblLocations L " & _
      " Inner Join tblCourses c on l.locationId = c.locationId " & _
      " Inner Join tblTrainingDates d on c.dateid=d.dateid " & _
     "  Inner Join tblCourseInstructor ic on c.courseId = ic.CourseId " & _
     "  Inner Join tblInstructors i on ic.instructorId = i.instructorId " & _
     "  OUTER APPLY (Select Count(*) TakenSeats " & _
     "  FROM tblTrainings T " & _
     "  where(L.LocationId = T.LocationId) " & _
     "  AND c.courseId = t.courseId) TS")

The code then appends the relevant filters to the StringBuilder instance to produce the final query.

As for returning one month's data if the search doesn't find anything, you'll need to modify the If dt.Rows.Count = 0 Then ... End If block to issue a new query to return the default data. Something like:

VB.NET

If dt.Rows.Count = 0 Then
    message.Text = "No matching records found."
    
    cmd.Parameters.Clear()
    cmd.Parameters.AddWithValue("@FromDate", Date.Today.AddMonths(-1))
    cmd.Parameters.AddWithValue("@EndDate", Date.Today)
    
    cmd.CommandText = "SELECT L.LocationId," & _
       "c.courseId, " & _
        "c.coursename, " & _
       "CASE WHEN L.Seating_Capacity - COALESCE(TS.TakenSeats,0) = 0 THEN 'Not Available' " & _
           " ELSE 'Available' END AS 'AvailableSeats'," & _
        "d.dateid, " & _
       " d.trainingDates, " & _
        "d.trainingtime, " & _
       " c.CourseDescription, " & _
       " i.instructorName, " & _
        "l.location " & _
      " FROM tblLocations L " & _
      " Inner Join tblCourses c on l.locationId = c.locationId " & _
      " Inner Join tblTrainingDates d on c.dateid=d.dateid " & _
     "  Inner Join tblCourseInstructor ic on c.courseId = ic.CourseId " & _
     "  Inner Join tblInstructors i on ic.instructorId = i.instructorId " & _
     "  OUTER APPLY (Select Count(*) TakenSeats " & _
     "  FROM tblTrainings T " & _
     "  where(L.LocationId = T.LocationId) " & _
     "  AND c.courseId = t.courseId) TS " & _
     " where d.trainingDates Between @FromDate And @EndDate"
    
    dt = GetData(cmd)
End If

You'll still need to modify the code which tries to find the "CurrentPage" label, in case the second query doesn't return any data either. There might not be a row, the row might not have any cells, or the cell might not contain a Label control called "CurrentPage"; any one of these things would cause your code to throw a NullReferenceException.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

samflex14-Aug-14 17:07

Re: How to display certain records if user's search comes up empty?

14-Aug-14 17:07

Hi Richard,

Thank you very much sir.

Your code is so elegant. I hope to get close to where you are one day.

I have pretty much put all the pieces together but I think I have things a bit mixed up because first, I commented out some lines that are throwing errors.

Second, when the page loads, I start paging, it starts showing some weird lines.

Can you see what I am doing wrong?

PHP

Private Sub showGrid()

    Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("conString").ConnectionString)
    ' Dim strQuery As String

    Dim cmd As New SqlCommand("-placeholder-", conn)
    Dim sb As New StringBuilder("SELECT L.LocationId," & _
           "c.courseId, " & _
            "c.coursename, " & _
           "CASE WHEN L.Seating_Capacity - COALESCE(TS.TakenSeats,0) = 0 THEN 'Not Available' " & _
               " ELSE 'Available' END AS 'AvailableSeats'," & _
            "d.dateid, " & _
           " d.trainingDates, " & _
            "d.trainingtime, " & _
           " c.CourseDescription, " & _
           " i.instructorName, " & _
            "l.location " & _
          " FROM tblLocations L " & _
          " Inner Join tblCourses c on l.locationId = c.locationId " & _
          " Inner Join tblTrainingDates d on c.dateid=d.dateid " & _
         "  Inner Join tblCourseInstructor ic on c.courseId = ic.CourseId " & _
         "  Inner Join tblInstructors i on ic.instructorId = i.instructorId " & _
         "  OUTER APPLY (Select Count(*) TakenSeats " & _
         "  FROM tblTrainings T " & _
         "  where(L.LocationId = T.LocationId) " & _
         "  AND c.courseId = t.courseId) TS")

    ' Hard-code the acceptable values here:
    Dim andors As String = If(ANDOR.SelectedValue = "OR", " OR ", " AND ")
    Dim startedWhere As Boolean = False

    If DropDownList1.SelectedValue <> "" Then
        sb.Append(If(startedWhere, andors, " WHERE "))
        sb.Append("i.instructorName = @InstructorName")
        cmd.Parameters.AddWithValue("@InstructorName", DropDownList1.SelectedValue)
        startedWhere = True
    End If

    If ViewSelect = "Range" Then
        sb.Append(If(startedWhere, andors, " WHERE "))
        sb.Append("d.trainingDates Between @FromDate And @EndDate")
        cmd.Parameters.AddWithValue("@FromDate", Date.Parse(txtFromDate.Text))
        cmd.Parameters.AddWithValue("@EndDate", Date.Parse(txtToDate.Text))
        startedWhere = True

    ElseIf ViewSelect = "Specific" Then
        sb.Append(If(startedWhere, andors, " WHERE "))
        sb.Append("d.trainingDates = @SpecificDate")
        cmd.Parameters.AddWithValue("@SpecificDate", Date.Parse(txtSpecificDate.Text))
        startedWhere = True
    End If

    cmd.CommandText = sb.ToString()

    ' Dim cmd As New SqlCommand(strQuery) 'This says cmd has already been declared
    Dim dt As DataTable = GetData(cmd)
    If dt.Rows.Count = 0 Then

        cmd.Parameters.Clear()
        cmd.Parameters.AddWithValue("@FromDate", Date.Today.AddMonths(-1))
        cmd.Parameters.AddWithValue("@EndDate", Date.Today)

        cmd.CommandText = "SELECT L.LocationId," & _
           "c.courseId, " & _
            "c.coursename, " & _
           "CASE WHEN L.Seating_Capacity - COALESCE(TS.TakenSeats,0) = 0 THEN 'Not Available' " & _
               " ELSE 'Available' END AS 'AvailableSeats'," & _
            "d.dateid, " & _
           " d.trainingDates, " & _
            "d.trainingtime, " & _
           " c.CourseDescription, " & _
           " i.instructorName, " & _
            "l.location " & _
          " FROM tblLocations L " & _
          " Inner Join tblCourses c on l.locationId = c.locationId " & _
          " Inner Join tblTrainingDates d on c.dateid=d.dateid " & _
         "  Inner Join tblCourseInstructor ic on c.courseId = ic.CourseId " & _
         "  Inner Join tblInstructors i on ic.instructorId = i.instructorId " & _
         "  OUTER APPLY (Select Count(*) TakenSeats " & _
         "  FROM tblTrainings T " & _
         "  where(L.LocationId = T.LocationId) " & _
         "  AND c.courseId = t.courseId) TS " & _
         " where d.trainingDates Between @FromDate And @EndDate"

        dt = GetData(cmd)
    End If

    GridView1.DataSource = dt
    GridView1.DataBind()

End Sub

Richard Deeming18-Aug-14 2:02

Re: How to display certain records if user's search comes up empty?

18-Aug-14 2:02

I can't see anything obviously wrong with your code. The line you've commented out would generate a compilation error, because the cmd variable is already defined towards the start of the method.

samflex wrote:
Second, when the page loads, I start paging, it starts showing some weird lines.

What do you mean by "weird lines"?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

samflex18-Aug-14 2:54

Re: How to display certain records if user's search comes up empty?

18-Aug-14 2:54

Sorry to keep bothering you sir and thanks for your continued assistance.

There are actually two problems that I discovered upon further testing.

1, when I select a date range with good dates - meaning dates that exist on our db, it doesn't capture them.

Instead, it displays the month values we elected to display if user's search turns up empty.

Same happens when I perform a search with specific date.

So, for some reason, the parameters are not working.

As for what I meant by weird lines, when I first run the app, it displays for instance 3 pages with a text that says, Viewing page 1 of 3. when I click page2, the text now displays Viewing page 2 of 3. However, the paging doesn't change to page 2. It still has page 1 highlighted (based on color I used).

When I attempt to click that page 2 again, I get this:

First ... Prev LinkButton LinkButton LinkButton Label LinkButton LinkButton LinkButton Next ... Last

The original code I posted wasn't doing this. It was paging perfectly only problem was that I wanted it to display one month's data if user's selection doesn't exist on the DB.

Richard Deeming18-Aug-14 7:15

Re: How to display certain records if user's search comes up empty?

18-Aug-14 7:15

What data-type are the dates stored as in your database? They should be either date, datetime2, or something similar.

As for the paging, you haven't posted any code relating to that.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

samflex18-Aug-14 8:04

Re: How to display certain records if user's search comes up empty?

18-Aug-14 8:04

data-type is datetime.

Here is the code for paging (kind of long sorry). Markup not included because I am not sure you want to see it.

PHP

    Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
        GridView1.PageIndex = e.NewPageIndex
        showGrid()
        GridView1.DataBind()
    End Sub
    Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As EventArgs)
        Dim gvrow As GridViewRow = GridView1.BottomPagerRow
        Dim lblcurrentpage As Label = DirectCast(gvrow.Cells(0).FindControl("CurrentPage"), Label)
        lblcurrentpage.Text = Convert.ToString(GridView1.PageIndex + 1)
        Dim page As Integer() = New Integer(6) {}
        page(0) = GridView1.PageIndex - 2
        page(1) = GridView1.PageIndex - 1
        page(2) = GridView1.PageIndex
        page(3) = GridView1.PageIndex + 1
        page(4) = GridView1.PageIndex + 2
        page(5) = GridView1.PageIndex + 3
        page(6) = GridView1.PageIndex + 4
        For i As Integer = 0 To 6
            If i <> 3 Then
                If page(i) < 1 OrElse page(i) > GridView1.PageCount Then
                    Dim lnkbtn As LinkButton = DirectCast(gvrow.Cells(0).FindControl("p" + Convert.ToString(i)), LinkButton)
                    lnkbtn.Visible = False
                Else
                    Dim lnkbtn As LinkButton = DirectCast(gvrow.Cells(0).FindControl("p" + Convert.ToString(i)), LinkButton)
                    lnkbtn.Text = Convert.ToString(page(i))
                    lnkbtn.CommandName = "PageNo"

                    lnkbtn.CommandArgument = lnkbtn.Text
                End If
            End If
        Next
        If GridView1.PageIndex = 0 Then
            Dim lnkbtn As LinkButton = DirectCast(gvrow.Cells(0).FindControl("LinkButton1"), LinkButton)
            lnkbtn.Visible = False
            lnkbtn = DirectCast(gvrow.Cells(0).FindControl("LinkButton2"), LinkButton)

            lnkbtn.Visible = False
        End If
        If GridView1.PageIndex = GridView1.PageCount - 1 Then
            Dim lnkbtn As LinkButton = DirectCast(gvrow.Cells(0).FindControl("LinkButton3"), LinkButton)
            lnkbtn.Visible = False
            lnkbtn = DirectCast(gvrow.Cells(0).FindControl("LinkButton4"), LinkButton)

            lnkbtn.Visible = False
        End If
        If GridView1.PageIndex > GridView1.PageCount - 5 Then
            Dim lbmore As Label = DirectCast(gvrow.Cells(0).FindControl("nmore"), Label)
            lbmore.Visible = False
        End If
        If GridView1.PageIndex < 4 Then
            Dim lbmore As Label = DirectCast(gvrow.Cells(0).FindControl("pmore"), Label)
            lbmore.Visible = False
        End If
    End Sub
    Private Sub lb_Command(ByVal sender As Object, ByVal e As CommandEventArgs)
        GridView1.PageIndex = Convert.ToInt32(e.CommandArgument) - 1
    End Sub
    Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

        If e.Row.RowType = DataControlRowType.Pager Then
            Dim gvr As GridViewRow = e.Row
            Dim lb As LinkButton = DirectCast(gvr.Cells(0).FindControl("p0"), LinkButton)
            AddHandler lb.Command, AddressOf lb_Command

            lb = DirectCast(gvr.Cells(0).FindControl("p1"), LinkButton)
            AddHandler lb.Command, AddressOf lb_Command
            lb = DirectCast(gvr.Cells(0).FindControl("p2"), LinkButton)
            AddHandler lb.Command, AddressOf lb_Command
            lb = DirectCast(gvr.Cells(0).FindControl("p4"), LinkButton)
            AddHandler lb.Command, AddressOf lb_Command
            lb = DirectCast(gvr.Cells(0).FindControl("p5"), LinkButton)
            AddHandler lb.Command, AddressOf lb_Command
            lb = DirectCast(gvr.Cells(0).FindControl("p6"), LinkButton)
            AddHandler lb.Command, AddressOf lb_Command
        End If
    End Sub
End Class

Richard Deeming18-Aug-14 8:38

Re: How to display certain records if user's search comes up empty?

18-Aug-14 8:38

There are two things missing from the top of your updated showGrid method which were in the original code:

VB.NET

SearchString = txtSpecificDate.Text
ViewSelect = Request("ViewBy")
If ViewSelect = "" Or ViewSelect = "Range" Then
    ViewSelect = "Range"
Else
    ViewSelect = "Specific"
End If

Also, since your dates are datetime, and your original code was only comparing the date part, you'll need to update the date filters:

VB.NET

If ViewSelect = "Range" Then
    sb.Append(If(startedWhere, andors, " WHERE "))
    sb.Append("(d.trainingDates >= @FromDate And d.trainingDates < DateAdd(day, 1, @EndDate))")
    cmd.Parameters.AddWithValue("@FromDate", Date.Parse(txtFromDate.Text))
    cmd.Parameters.AddWithValue("@EndDate", Date.Parse(txtToDate.Text))
    startedWhere = True

ElseIf ViewSelect = "Specific" Then
    sb.Append(If(startedWhere, andors, " WHERE "))
    sb.Append("(d.trainingDates >= @SpecificDate And d.trainingDates < DateAdd(day, 1, @SpecificDate))")
    cmd.Parameters.AddWithValue("@SpecificDate", Date.Parse(txtSpecificDate.Text))
    startedWhere = True
End If

I can't see any obvious reason for the paging issues. I'd probably be inclined to use a DataPager control[^] rather than custom LinkButton controls, but if your code worked with the old version of the showGrid method, it should work just as well with the new version.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

samflex18-Aug-14 10:55

Get original string from Guid

18-Aug-14 10:55

Thank you so much Richard for your generous assistance.

The search by date range is working really good now.

For some reason, it wouldn't work until I changed this line:

PHP

sb.Append("(d.trainingDates >= @FromDate And d.trainingDates < DateAdd(day, 1, @EndDate))")
    cmd.Parameters.AddWithValue("@EndDate", Date.Parse(txtToDate.Text))

to these lines:

PHP

sb.Append("(CONVERT(VARCHAR(10), d.trainingDates, 101) >= @FromDate And CONVERT(VARCHAR(10), d.trainingDates, 101) < @EndDate)")
           cmd.Parameters.AddWithValue("@FromDate", txtFromDate.Text)

But the search by specific date is not working. It is still display the entire month which suggests it is not recognizing the date value I am passing as valid.

Don't worry, I will work this one out.

You are incredible inspiration to me on how to be patient.

Thank you very much sir.

Note: It is still exhibiting the odd behavior of displaying the weird links I posted earlier.

AJAX control

murali_utr13-Aug-14 23:09

murali_utr

13-Aug-14 23:09

In my project using AJAX 4.5
ValidatorCalloutExtender and TextBoxWatermarkExtender controls used in project. following error occurred.

0x800a138f - JavaScript runtime error: Unable to get property 'UI' of undefined or null reference

I need help.

Thanks in advance.

Have A Nice Day!
Murali.M

Blog

Re: AJAX control

Kornfeld Eliyahu Peter13-Aug-14 23:18

Kornfeld Eliyahu Peter

13-Aug-14 23:18

It seems you missing some JavaScript code related to the Ajax Toolkit, however you will have to show us code/debug to see where and what exactly the problem...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Re: AJAX control

murali_utr14-Aug-14 18:00

murali_utr

14-Aug-14 18:00

please find the code

<%@ Page Language="VB" MasterPageFile="~/privatemaster.master" AutoEventWireup="false"
CodeFile="InfoSettings.aspx.vb" Inherits="InfoSettings" Title="Information settings" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="FredCK.FCKeditorV2" Namespace="FredCK.FCKeditorV2" TagPrefix="FCKeditorV2" %>
<asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server">

Master Information Setting

Information in this page are included in various parts of the site. Please provide
accurate information.

All fields marked * mandatory

<cc1:tabcontainer id="ClientTab" width="800px" runat="server"
="" activetabindex="0">
<cc1:tabpanel id="TabPanel1" runat="server" headertext="TabPanel1">
<headertemplate>
Company & Contact Info

<contenttemplate>

Information provided in this page will be included in Contact us page. The Company
name will be included in copyright declaration too.

<asp:panel id="pnlSaveCo" runat="server" defaultbutton="btnSaveCo">

Company Name*	<asp:textbox id="txtName" runat="server" width="250px" ="" validationgroup="valContact"> <asp:requiredfieldvalidator id="RFCName" runat="server" controltovalidate="txtName" ="" display="None" errormessage="Enter Client Name" setfocusonerror="True" validationgroup="valContact"> <cc1:validatorcalloutextender id="VceRFCName" runat="server" targetcontrolid="RFCName" ="" enabled="True">
Address*	<asp:textbox id="txtAddress" runat="server" height="75px" textmode="MultiLine" ="" width="250px" validationgroup="valContact"> <asp:requiredfieldvalidator id="rfAddress" runat="server" controltovalidate="txtAddress" ="" display="None" errormessage="Enter Address" setfocusonerror="True" validationgroup="valContact"> <cc1:validatorcalloutextender id="vcexAddress" runat="server" targetcontrolid="rfAddress" ="" enabled="True">
Contact Person*	<asp:textbox id="txtContactPerson" runat="server" width="250px" ="" validationgroup="valContact"> <asp:requiredfieldvalidator id="rfContactPerson" runat="server" controltovalidate="txtContactPerson" ="" display="None" errormessage="Enter Contact persons name" setfocusonerror="True" validationgroup="valContact"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender7" runat="server" targetcontrolid="rfContactPerson" ="" enabled="True">
Email Id (for display)*	<asp:textbox id="txtEmail" runat="server" width="200px" ="" validationgroup="valContact"> <asp:checkbox id="cbEmailDisplay" runat="server"> Display email id online <asp:requiredfieldvalidator id="RFEmail" runat="server" controltovalidate="txtEmail" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="Send"> <asp:regularexpressionvalidator id="REEmail" runat="server" controltovalidate="txtEmail" ="" display="None" errormessage="Enter valid email id" setfocusonerror="True" validationexpression="\w+([-+.']\w+)@\w+([-.]\w+)\.\w+([-.]\w+)*" validationgroup="valContact"> <cc1:validatorcalloutextender id="VceRFEmail" runat="server" enabled="True" targetcontrolid="RFEmail"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender31" runat="server" targetcontrolid="REEmail" ="" enabled="True">
Email Id * For receiving online enquiries and contact us emails	<asp:textbox id="txtEmailEnquiries" runat="server" width="200px" ="" validationgroup="valContact"> <asp:requiredfieldvalidator id="rfEmailenquiries" runat="server" controltovalidate="txtEmailEnquiries" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="Send"> <asp:regularexpressionvalidator id="reEmailenquiries" runat="server" controltovalidate="txtEmailEnquiries" ="" display="None" errormessage="Enter valid email id" setfocusonerror="True" validationexpression="\w+([-+.']\w+)@\w+([-.]\w+)\.\w+([-.]\w+)*" validationgroup="valContact"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender5" runat="server" enabled="True" targetcontrolid="rfEmailenquiries"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender6" runat="server" targetcontrolid="reEmailenquiries" ="" enabled="True">
Phone number*	<asp:textbox id="txtPhone" runat="server" width="200px" ="" validationgroup="valContact"> <asp:requiredfieldvalidator id="rfPhone" runat="server" controltovalidate="txtPhone" ="" display="None" errormessage="Enter Phone number" setfocusonerror="True" validationgroup="valContact"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender1" runat="server" targetcontrolid="rfPhone" ="" enabled="True">
Mobile number	<asp:textbox id="txtMobile" runat="server" width="200px" ="" validationgroup="valContact"> <asp:checkbox id="cbMobile" runat="server"> Display Mobile number online
<asp:button id="btnSaveCo" cssclass="mybutton" runat="server" text="Save" ="" validationgroup="valContact">

<cc1:tabpanel id="TabPanel2" runat="server" headertext="TabPanel1">
<headertemplate>
Search Engine optimization

<contenttemplate>

Search engine optimization is very essential for Web sites. Search engines primarily
give very high weightage for Title tag and Meta tags - Keywords & Description. Please
provide these to get good search engine visibility.

<asp:panel id="pnlSeo" runat="server" defaultbutton="btnSEO">

Title tag* Recommended upto 80 characters	<asp:textbox id="txtTitleTag" runat="server" width="450px" maxlength="300" validationgroup="Send"> <asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" controltovalidate="txtKeywords" ="" display="None" errormessage="Enter Keywords" setfocusonerror="True" validationgroup="Send"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender2" runat="server" targetcontrolid="rfKeywords" ="" enabled="True">
Description* Recommended upto 200 characters	<asp:textbox id="txtDesc" runat="server" height="50px" textmode="MultiLine" width="450px"> <asp:requiredfieldvalidator id="rfDesc" runat="server" controltovalidate="txtDesc" ="" display="None" errormessage="Please enter Description" setfocusonerror="True" validationgroup="Send"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender3" runat="server" targetcontrolid="rfDesc" ="" enabled="True">
Keywords* Recommended upto 250 characters & upto 20 keywords	<asp:textbox id="txtKeywords" runat="server" width="450px" height="50px" textmode="MultiLine" validationgroup="Send"> <asp:requiredfieldvalidator id="rfKeywords" runat="server" controltovalidate="txtKeywords" ="" display="None" errormessage="Enter Keywords" setfocusonerror="True" validationgroup="Send"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender4" runat="server" targetcontrolid="rfKeywords" ="" enabled="True">
<asp:button id="btnSEO" cssclass="mybutton" runat="server" text="Save" ="" validationgroup="valSeo">

<cc1:tabpanel id="TabPanel3" runat="server" headertext="TabPanel1">
<headertemplate>
Smtp settings

<contenttemplate>

To receive emails from contact us and enquiry page, you will need to provide your
email id, smtp host (ip address) and its password. Please provide the same here.

<asp:panel id="pnlSmtp" runat="server" defaultbutton="btnSaveSmtp">

Email Id * (for receiving enquiries and emails)	<asp:textbox id="txtSmtpEmail" runat="server" width="200px" ="" validationgroup="valSmtp"> <asp:requiredfieldvalidator id="rfsmtpemail" runat="server" controltovalidate="txtSmtpEmail" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="valSmtp"> <asp:regularexpressionvalidator id="resmtpemail" runat="server" controltovalidate="txtSmtpEmail" ="" display="None" errormessage="Enter valid email id" setfocusonerror="True" validationexpression="\w+([-+.']\w+)@\w+([-.]\w+)\.\w+([-.]\w+)*" validationgroup="Send"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender8" runat="server" enabled="True" ="" targetcontrolid="rfsmtpemail"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender11" runat="server" targetcontrolid="resmtpemail" ="" enabled="True">
STMP Host (IP/domain)*	<asp:textbox id="txtsmtphost" runat="server" width="200px" maxlength="300" ="" validationgroup="valSmtp"> <asp:requiredfieldvalidator id="rfsmtphost" runat="server" controltovalidate="txtsmtphost" ="" display="None" errormessage="Enter STMP host info" setfocusonerror="True" validationgroup="valSmtp"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender10" runat="server" targetcontrolid="rfsmtphost" ="" enabled="True">
Password*	<asp:textbox id="txtsmtppassword" textmode="Password" runat="server" width="200px" ="" validationgroup="valSmtp"> <asp:requiredfieldvalidator id="rfsmtppassword" runat="server" controltovalidate="txtsmtppassword" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="valSmtp"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender9" runat="server" enabled="True" ="" targetcontrolid="rfsmtppassword">
<asp:button id="btnSaveSmtp" cssclass="mybutton" runat="server" text="Save" ="" validationgroup="valSmtp">

<cc1:tabpanel id="TabPanel6" runat="server" headertext="TabPanel1">
<headertemplate>
Logo

<contenttemplate>

Please add your Logo to replace the top InstaCMS logo.

<asp:panel id="pnlLogo" runat="server" defaultbutton="btnLogo">

<asp:image id="imgLogo" runat="server" imageurl="~/images/logo.png">
Add / Change Logo Will be resized to maximum of 100px width & 80px height proportionately	<asp:fileupload id="fuLogo" runat="server">
<asp:button id="btnLogo" cssclass="mybutton" runat="server" text="Save Image">

<cc1:tabpanel id="TabPanel5" runat="server" headertext="TabPanel1">
<headertemplate>
Home Image

<contenttemplate>

If you want to use your own image instead of the default image in the home page, please upload the image below. The image will be resized automatically if the width is over 600px or the height of the image is over 225px.

<asp:panel id="pnlImage" runat="server" defaultbutton="btnSaveImage">

<asp:image id="imgHome" runat="server" imageurl="~/images/home_image.jpg">
Change Home page Image Will be resized to maximum of 600px width & 300px height proportionately	<asp:fileupload id="fuHomeImage" runat="server">
<asp:button id="btnSaveImage" cssclass="mybutton" runat="server" text="Save Image">

<cc1:tabpanel id="TabPanel4" runat="server" headertext="TabPanel1">
<headertemplate>
Change password

<contenttemplate>

Please use the form below to change your control panel login password. The user
email id will be the same and cannot be changed by you. If you want to change it,
please contact InstaCMS.

<asp:panel id="pnlPassword" runat="server" defaultbutton="btnPassword">

Enter Password*	<asp:textbox id="txtOldPassword" textmode="Password" runat="server" width="200px" ="" validationgroup="valPassword"> <asp:requiredfieldvalidator id="rfOldPassword" runat="server" controltovalidate="txtOldPassword" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="valPassword"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender15" runat="server" enabled="True" ="" targetcontrolid="rfOldPassword">
Enter new password*	<asp:textbox id="txtNewPassword" textmode="Password" runat="server" width="200px" ="" validationgroup="valPassword"> <asp:requiredfieldvalidator id="rftxtNewPassword" runat="server" controltovalidate="txtNewPassword" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="valPassword"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender12" runat="server" enabled="True" ="" targetcontrolid="rftxtNewPassword">
Confirm new Password*	<asp:textbox id="txtConfirmPassword" textmode="Password" runat="server" width="200px" ="" validationgroup="valPassword"> <asp:requiredfieldvalidator id="rfConfirmPassword" runat="server" controltovalidate="txtConfirmPassword" ="" display="None" errormessage="Enter Email Id" setfocusonerror="True" validationgroup="valPassword"> <cc1:validatorcalloutextender id="ValidatorCalloutExtender13" runat="server" enabled="True" ="" targetcontrolid="rfConfirmPassword">
<asp:button id="btnPassword" cssclass="mybutton" runat="server" text="Save" ="" validationgroup="valPassword">

Have A Nice Day!
Murali.M

Blog

Member 947380913-Aug-14 19:06

Member 9473809

13-Aug-14 19:06

Hi,
I have this result of Guid :
d926ef0d-07df-3c5b-2246-12e061f71be1

Now i wanna to get the main string that was converted to this Guid?

Ans : the result for this guid is : "0000000000"

now My Question is :
what is the main string that converted to this GUID :
fd7bd272-f7e8-1e57-0a82-e15b79694d25

thanks in advanced!

Bernhard Hiller13-Aug-14 21:57

Bernhard Hiller

13-Aug-14 21:57

A Guid is just a kind of 128bit number, nothing else. It is not at all a string.
If you have some strange algorithm for encoding or encrypting strings into a Guid, well, that's your own idea. We don't know how you do that. And consequently we cannot help you in reverting that strange process.

Kornfeld Eliyahu Peter13-Aug-14 22:27

Kornfeld Eliyahu Peter

13-Aug-14 22:27

You may talk about a hash? Can you show us the code generates those 'GUID'...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Richard MacCutchan13-Aug-14 22:28

Richard MacCutchan

13-Aug-14 22:28

See http://msdn.microsoft.com/en-us/library/System.Guid(v=vs.110).aspx[^].