ASP.NET

WHERE 1 = 1
 AND ((@uuid IS NULL OR qp.uuid Like '%' + @uuid + '%')
 AND (@callerlist IS NULL OR  qp.call_list_id Like '%' + @callerlist + '%')
 AND (@phone IS NULL OR cl.phone_number Like '%' + @phone + '%')
 AND (@start IS NULL OR startttime >= @start)
 AND (@Endd IS NULL OR endtime <= @Endd)
 AND (@calltype IS NULL OR c.id Like '%' + @calltype + '%')
 AND cl.phone_number IS NOT NULL)

<asp:TextBox id="date_start" style="width:150px;" class="form-control alignleft" runat="server" />

<asp:TextBox id="date_end" style="width:150px;" class="form-control alignleft" runat="server" />

Private Sub SearchCustomers()
     Dim constr As String = ConfigurationManager.ConnectionStrings("ppmtest").ConnectionString

     Using con As New SqlConnection(constr)

         Using cmd As New SqlCommand()

             Dim sql As String = "spGetLogs"
             cmd.CommandType = CommandType.StoredProcedure
             cmd.Parameters.AddWithValue("@uuid", suuid.Text)
             cmd.Parameters.AddWithValue("@callerlist", caller_list_id.Text)
             cmd.Parameters.AddWithValue("@phone", phonenumber.Text)
             cmd.Parameters.AddWithValue("@start", date_start.Text)
             cmd.Parameters.AddWithValue("@Endd", date_end.Text)
             cmd.Parameters.AddWithValue("@calltype", call_type.SelectedValue)
             'Response.Write(sql)
             'Response.End()
             cmd.CommandText = sql

             cmd.Connection = con
             Using sda As New SqlDataAdapter(cmd)
                 Dim dt As New DataTable()
                 sda.Fill(dt)
                 gvCustomers.DataSource = dt
                 gvCustomers.DataBind()

             End Using
         End Using
     End Using
 End Sub