Override connection string in TableAdapter with web.config
I found this tip is very useful for me in my day to day coding. Sometimes you create a table adapter in dataset in Data layer project, everything works fine but you will start wondering how…
-
-
System.OutOfMemoryException in mscorlib.dll
I’ve got a problem when i tried to read some file in asp.net which is like 35mb large over the network. I also need this to be reliable since the file will be growing quickly within…
-
Provide Link to a file without showing the actual path in asp.net
Let’s say you have some file that allow people to download it but you don’t want to expose the actual path for security reason. Here is the way of doing it, You need to read the…
-
Getting the last day for each month in SQL server
This is the function in SQL server to get the last day for each month until the day that you define in a variable which is in this case is “@genDate”. I used this function to…
-
COMException (0x80040154): Retrieving the COM class factory for component with CLSID
I’ve got this error when i tried to deploy my service with .NET wrapper for VB6 component : System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} failed due to the following error:…
-
Get Selected Item with Gridview in ASP.NET
I was having a problem before to get selected item with grid view when you click edit button. After spending sometime researching on the internet. I found that we can get the item that you selected…
-
Dynamic array in VB/VB.NET/ASP
Time to go back to old school ASP, I found that i need to create an array that contains a list of languages from a table in database. I would like to make this array length…
-
How to clear a gridview
Normally, we would like to clear a gridview for various reason. I want the data to be cleared from grid view everytime user does the search and the grid view will be binded again if the…