Is there anyway to check the validity of a query string before performing SQL data filtering. I mean my detailsview page is expecting a querystring with numeric values, however, if someone tries to send string or huge number or any invalid data the page will crush!! Even if you send a valid data of a record that doesn't exist anymore the page will still be accessible. I need to enable users to access that page only if there is data display, thanks in advance.
Checking validity of query string before performing SQL filtering of detailsview
152 Views Asked by Saajid Akram At
1
There are 1 best solutions below
Related Questions in ASP.NET
- Create an IIS web request activity light
- Writing/Overwriting to specific XML file from ASP.NET code behind
- What is the point of definnig Asp.net Intrinsic Objects In different places and what is the different betwen them?
- Deleting Orphans with Fluent NHibernate
- IOrderedEnumerable to vb.net IOrderedEnumerable Conversion
- Entity Framework Code First with Fluent API Concurrency `DbUpdateConcurrencyException` Not Raising
- Getting deeply embedded XML element values
- What is best way to check if any of the property of object is null or empty?
- NuGet - Given a type name or a DLL, how can I find the NuGet package?
- ASP-MVC Code-first migrations checkbox not active
- How do i add onclient click to my jquery button
- Jquery: Change contents of <select> tag dynamically
- Retrieving data from Oracle database
- ASP.NET: Fill Textbox field upon dropdownlist selection by user
- Why web API return 404 when deploy to IIS
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in QUERY-STRING
- How do I reload an ASP page with a new querystring?
- Display details on specific user using rest web service, queryparam
- Flask - how to get query string parameters into the route parameters
- How to get query string values in JavaScript containing special characters?
- ZF2 paginator with query string
- Query String isn't showing all value
- How to tell Express NOT to parse the query string of the request?
- Web API 2.2, Is there an easy way to update the HttpRequestMessage's QueryString in a DelegatingHandler?
- How do I set/read a query string when using the router in aurelia?
- Cakephp 3.0, get id from URL when using on IFrame
- New Google Maps query string syntax for a marker
- Jersey, @QueryParam List<String>
- Is there any way to convert JSON String to query String in android?
- org.apache.cxf.interceptor.Fault: null while invoking public java.lang.String JaxRS server
- use url for generated pages, no query string
Related Questions in DETAILSVIEW
- Hide attribute in Kartik DetailView Yii 2
- How to send details of excel data in Detailview
- Unable to make value fields editable after clicking on a link button
- Get the value of a BoundField from a DetailsView
- changing DetailsViewMode on Page_Load event
- ASP.NET - hiding BoundField input
- ASP.NET 4.5 GridView and DetailsView
- How to add a tooltip to Boundfields in a Detailsview, but only if color of column has changed
- Checking validity of query string before performing SQL filtering of detailsview
- ASP C# CheckBox within DetailsView
- 'AnonymousUser' object is not iterable - accessing to views by anonymous and authenticateds users
- DetailsView How to retrieve a DataKeyNames after an item has been inserted
- Object reference not set to an instance of an object
- I want to apply a regularexpressionvalidator to selective fields in DetailsView ASP.NET 2.0 VB
- How do I set a detail view's title from the selected row?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
In the Page_Load event you check the query string with the
IsNumeric()function or any other pattern matching methods(Regex, etc...) and if it does not pass then Redirect to a diff page.