Simple LINQ Tutorial
I’ve started learning about LINQ because I need to keep up to date with the latest technology out there. I’ve created a simple Business Layer which interact directly with Linq to SQL(DBML). It includes Insert, Update,…
-
-
Using temp table and SQL stored procedure in Table Adapter
I was having a problem when adding a stored procedure into table adapter. The error was “Invalid object” of my temporary table name inside stored procedure. It’s a bit strange since what i thought the table…
-
File Stream/Stream response in AJAX Update Panel
Last few months, I got a problem to place a button to generate a CSV file in the update panel. I was having a problem related with response error. So what i did was to place…
-
Self Recursive Deleting On self foreign key sql server
I’ve been assigned a task to delete data from a table with a subtree structure which means the foreign key can be contained in another rows in the same table. It’s a self contained foreign key…
-
How to remove checked item in Checked Box List
At the moment, I’m learning towards win development. I got a very simple problem which is “Removing checked item on checked box list”. The first code below is throwing an error since you try to delete…
-
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…