Record/Row Filter in DataTable
When I have a smaller rows return from my sql stored procedure, I tend to think of not recreating another stored procedure to do filtering or to use optional parameter. My idea is to do filtering…
-
-
ORDER BY in UNION
I was having a problem this morning in using a ORDER BY in UNION Clause. The solution is to use keyword of “TOP 100 PERCENT” on the related ORDER BY SELECT query. CREATE PROCEDURE MyAPLRank @MemberID…
-
Casting DataItem in repeater to strongly typed dataset
Most of the time when you use repeater, you want to be able to cast the datasource/dataitem, you don’t really want to do DataBinder.Eval(e.Item.DataItem, “Description”) but you want to do row.Description. It’s not hard to do…
-
How to filter and sort in Dataset
Here is the way to filter or to sort dataset and then you can bind into your datagrid If intEventID = 0 Then ds = DataAccess.Events.GetAllEventsByRegionID(Me.radStartDate.SelectedDate, Me.radEndDate.SelectedDate, intRegionID, intVenueID) Else ds = DataAccess.Events.GetEventByIDDS(intEventID) End If ‘this…
-
Get current page name in ASP.NET
In order to get current page name , we need to get it from server variables of “ScriptName” but that’s not enough since it will bring up the whole path. you need to use System.IO in…
-
XML http object cross browser
I believe this will be useful for everyone who wants to implement AJAX manually and make it compatible cross browser. // cross-browser method to retrieve an XMLHttp object for asynchronous requests & responses function GetHTTPRequest() {…
-
SYS is undefined in AJAX Update Panel
I tried to implement AJAX on my website by using AJAX extension on visual studio .NET. I tried to drag update panel to my page and I’ve put my button event handler to the trigger collection…
-
Set/Find item in Dropdownlist based on its list item value in ASP.NET
this is a very simple trick on how to select an item in pre binding/pre populated dropdown list from database in asp.net, you can use “FindByValue” method from dropdown list to return you a list item…