Filtering Field/Column in DataTable
I was having a problem when I have the same datatable and one datagrid but I want to display different field on the grid for different report and I want to use AutoGenerateColumn = true in…
-
-
Set Default value with clear text for input type=”password”
Normally we have two text boxes which is user name and password. On the first load of the page we want to set the default value of user name text box becoming ‘username’ and set the…
-
Temporary View using Common Table Expression In Sql server 2005
In this post, I will discuss on how to optimize join. Based on my experience. When you join record you need to join as fewer as possible otherwise it will result in performance. And please make…
-
Error System.NotSupportedException: The given path’s format is not supported
I got this exception when i tried to uploading a file to a web and try to save it as a different name System.NotSupportedException: The given path’s format is not supported. at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath)…
-
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…