tag:blogger.com,1999:blog-6104185749662767834Thu, 23 Oct 2025 16:33:50 +0000ASP.NETOracle DatabaseJavaScriptASP.NET GridViewASP.NET ControlSQL Server 2005C#Oracle ErrorjqueryError HandlingDataTableASP.NET DesignOracle PL/SQL ProgrammingSQL ServerAjaxCSSDropdownListEmailListBoxObjectDataSourceVisual Studioasp.net DetailsViewdatabaseADO.NETASP.NET DeploymentASP.NET MVCBusiness Logic LayerData Access LayerDatabase TricksEclipseExceptionsFilesJAVANepalObject Relational DatabaseOracleOracle Interview QuestionsPositive ChangeSQLSocial WorkTOADUser ControlVisual Studio 2010Windows 7XMLHTTPasp.net hostingasp.net membership provideropen sourceperformanceplesk hostingvideoxmlExperiences of an C#, asp.net web application developer with SQL, jquery, xmlhttp://dotnetspidor.blogspot.com/noreply@blogger.com (Anonymous)Blogger92125tag:blogger.com,1999:blog-6104185749662767834.post-1538351274816238444Thu, 30 Jul 2015 12:28:00 +00002015-07-30T17:58:24.667+05:30ASP.NET MVCExceptionsI got following error: Exception Details: Microsoft.CSharp. RuntimeBinder.RuntimeBinderException: Cannot convert null to 'bool' because it is a non-nullable value type, today while referencing a .dll file and creating object of a class. I could hardly solve the issue by just looking into the stack trace. But I could back trace the changes I had made and point out the spot it occurred at. I http://dotnetspidor.blogspot.com/2015/07/cannot-convert-null-to-bool-because-it.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-7240231577394416098Wed, 29 Jul 2015 09:27:00 +00002015-07-29T15:00:02.056+05:30databaseDatabase TricksSQLSQL ServerIf you ever needed to convert datetime field to MMDDYY format in sql server, read on. I am going to present you a quick tips on how to get date or datetime field in sql server in MMDDYY format. Let's do it step by step. First of all I would like to remind you to learn how to convert date to different date string using Convert function of ms sql server. This will prepare background for the http://dotnetspidor.blogspot.com/2015/07/convert-datetime-to-mmddyy-format-in.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-6514298095905433103Wed, 13 Mar 2013 19:47:00 +00002013-03-15T09:11:33.396+05:30Object Relational DatabaseOracleOracle DatabaseOracle PL/SQL ProgrammingOracle is a modern and feature-full database that supports many features of an object relational database system. Oracle supports type definition, type inheritance, collection type, member function, nested table, association and aggregation relationships. In this article, I have implemented all features other than association and aggregation relationships. 1. Database Structure I have http://dotnetspidor.blogspot.com/2013/03/object-relational-database-features.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-1359459264153876271Mon, 18 Feb 2013 20:12:00 +00002013-02-19T15:23:09.425+05:30ASP.NETASP.NET GridViewC#DataTableResponding to a good demand from a lot of readers, I have now presented a way to create DataTable programmatically where rows accept html and hence they can be made clickable. Complementing to my previous post on creating DataTable programmatically in asp.net, this tips will bind DataTable to an asp.net GridView where one of the columns in each row contains clickable html anchor. Below is the http://dotnetspidor.blogspot.com/2013/02/add-clickable-rows-in-csharp-datatable.htmlnoreply@blogger.com (Anonymous)2tag:blogger.com,1999:blog-6104185749662767834.post-4370033291354461225Sat, 09 Feb 2013 15:29:00 +00002013-02-09T21:14:44.030+05:30C#Today I am presenting a quick tips on how to strip html from text using regular expression (with Regex class) in C#. In a scenario like presenting a blurb or summary of certain characters we may need to remove html tags from a html string (of news details, article details etc.). I have following function in my Helper library for the very problem. /// /// Strip out html tags from text http://dotnetspidor.blogspot.com/2013/02/strip-html-tags-and-extract-subset-of.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-908238657198351143Sat, 19 Jan 2013 09:49:00 +00002013-01-19T15:19:19.414+05:30EclipseJAVAFor a long time, I have remained asp.net web application developer. But as you prepare to bear the role of an academician also, how could you stick to only one programming framework or programming language? Yes, that has come to my life also. And I have growing appetite for learning more programming languages. JAVA undoubtedly brought about revolutions in so many fields. Oracle proudly declares http://dotnetspidor.blogspot.com/2013/01/learning-java-i-am-using-eclipse-ide.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-682064069180885600Fri, 18 May 2012 12:06:00 +00002013-02-22T21:16:27.443+05:30ASP.NETjqueryOften we are confused about how to read values set in asp.net HiddenField from jquery and use the values in the web form. Many-a-times we see the threads over the asp.net forums about the difficulties associated with reading asp.net HiddenField values. I have tried to give easy and fast way to read values and set values of hidden filed in asp.net using jquery. You may first download the latest http://dotnetspidor.blogspot.com/2012/05/read-hidden-field-value-in-aspnet-from.htmlnoreply@blogger.com (Anonymous)3tag:blogger.com,1999:blog-6104185749662767834.post-8006323220773322047Fri, 27 Apr 2012 04:01:00 +00002012-04-27T09:31:29.816+05:30ASP.NETSQL ServerJust a simple accidental error in asp.net web application's web.config file, and you see the following error: Expecting non-empty string for 'providerInvariantName' parameter. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: http://dotnetspidor.blogspot.com/2012/04/expecting-non-empty-string-for.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-8216650093536923443Fri, 20 Apr 2012 12:51:00 +00002012-04-20T18:24:35.287+05:30ASP.NETjqueryI have been using the jquery plugins for long. Many times I do need to implement facebook-like photo viewer in gallery pages. Similarly, mostly in admin pages of my asp.net web applications, I frequently us modal pop-ups for various purposes like ajax loading of content, iframe loading from other internal pages, confirmation and error show ups. Typically I used to go for separate plugins for the http://dotnetspidor.blogspot.com/2012/04/flexible-jquery-based-modal-box-or.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-2901456265386462857Thu, 12 Apr 2012 06:08:00 +00002012-04-12T11:46:31.748+05:30asp.net hostingplesk hostingI use plesk hosting for my company. An error I got (and shocked with it!) was that my domain was displaying the correct site with : http://mysitedomain.com But did not work with: http://www.mysitedomain.com Later it was traced that, by default the www was not included while creating the domain. So if you are creating a domain, don't forget to inlcude www (by checking a checkbox next to www). http://dotnetspidor.blogspot.com/2012/04/domain-without-www-not-working-from.htmlnoreply@blogger.com (Anonymous)1tag:blogger.com,1999:blog-6104185749662767834.post-2191413137900505482Thu, 22 Mar 2012 06:04:00 +00002012-03-22T11:41:31.867+05:30SQL ServerSQL Server 2005While restoring a database backup file in my hosting I was prompted with some error message regarding existing user in the database. So I decided to delete those users. But while trying to delete the users from my local sql sever management studio, error occurred. The database principal owns a schema in the database, and cannot be dropped. I tried out browsing the property of the user and http://dotnetspidor.blogspot.com/2012/03/database-principal-owns-schema-in.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-6059413402576665682Mon, 05 Mar 2012 09:12:00 +00002012-03-05T14:42:42.975+05:30          From sangam uprety   Executive Director at Time Infotech Nepal       I'd like to addhttp://dotnetspidor.blogspot.com/2012/03/invitation-to-connect-on-linkedin.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-4641212664469020801Tue, 07 Feb 2012 07:56:00 +00002012-02-07T13:27:17.220+05:30SQL Server 2005Windows 7If you started with sql server 2005 express editions in your windows vista or xp operating systems, you are sure to stumble while installing sql server 2005 express in windows 7. After having long time experience of sql server 2005 express in my windows vista, I just switched to windows 7 and tried same version of express in it. But it is not supported. You get the failure message sort of: This http://dotnetspidor.blogspot.com/2012/02/installing-sql-server-2005-express-in.htmlnoreply@blogger.com (Anonymous)2tag:blogger.com,1999:blog-6104185749662767834.post-1190485405906879955Fri, 30 Dec 2011 06:28:00 +00002011-12-30T12:04:58.767+05:30Positive ChangeSocial WorkA dream to provide solar and computer to a school in rural Nepal! It can be realized by your single vote. Please vote for it at Solar and Computers to a School in Rural Nepal Appeal from the dreamer - read below please. My dream is to help a school in an extremely remote village of Western Nepal to buy and install a solar system, batteries, inverters, computers and printers necessary for http://dotnetspidor.blogspot.com/2011/12/prove-that-programmers-too-can-be.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-3232553749343811098Tue, 27 Dec 2011 02:57:00 +00002011-12-30T12:00:30.277+05:30ASP.NETopen sourcevideoCamStudio a really useful desktop based software that you can use for recording anything that happens with your desktop. And the best part is it is distributed under GNU General Public License (GPL) license. Free to use for both commercial and non-commercial uses. So what are the uses? Let me recite the site itself: CamStudio is able to record all screen and audio activity on your computer http://dotnetspidor.blogspot.com/2011/12/camstudio-free-streaming-video-desktop.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-7500196072740062299Tue, 22 Nov 2011 10:42:00 +00002011-11-22T17:54:19.337+05:30ASP.NETjqueryMore often programmers need to work with dropdownlist or combobox using jquery. We need to manipulate the dropdownlist options using jquery scripting. And it is the case that almost always we don't remember how to implement jquery selector. And for all of my readers, who are enthusiastic programmers and/or designers, and for myself, I am discussing in this post the actions with jquery to http://dotnetspidor.blogspot.com/2011/11/working-with-dropdownlist-or-combobox.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-7188870713672225823Tue, 18 Oct 2011 12:36:00 +00002011-10-18T18:07:00.292+05:30Visual StudioVisual Studio 2010I just got irritated to see the file menu in visual studio 2010 missing. All other items of the menu, e.g. Edit, View, Refactor, Project, Build etc. were showing. Only mischievous was the File item. It would be of no value for me if only I could add new project in an existing project. But I couldn't find any such option. I had to workout to recover my lost menu item back. And the way is as http://dotnetspidor.blogspot.com/2011/10/missing-file-menu-in-visual-studio-2010.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-6300275390652378471Thu, 29 Sep 2011 08:03:00 +00002011-09-30T17:28:45.905+05:30ASP.NETASP.NET Controljquery When a user clicks a button and the response is slow, there are chances that user may click the button again. The scenario may occur both when the button postbacks synchronously or asynchronously. This type of multiple clicks could be prevented if we could just disable the button just after the first click and enable it again when the processing is done. This is quite easy to implement the task http://dotnetspidor.blogspot.com/2010/01/disable-button-in-asp-net-web-page-to.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-8044384311421082332Mon, 26 Sep 2011 09:32:00 +00002011-09-26T15:07:03.283+05:30databaseSQL Server 2005While publishing a website to the web server, I took backup of my database. Now I had abc.backup at my hand. Next step was to create a database in the sql server of my host. I did it. Then I uploaded the backup file to the server. When I tried to restore the database I got following error: Exclusive access could not be obtained because the database is in use This error normally discourages http://dotnetspidor.blogspot.com/2011/09/exclusive-access-could-not-be-obtained.htmlnoreply@blogger.com (Anonymous)2tag:blogger.com,1999:blog-6104185749662767834.post-6100470859909507558Thu, 22 Sep 2011 13:30:00 +00002011-09-22T19:37:21.780+05:30ASP.NETLast time I got the following error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. See in the image below the following config error, and also watch the config source. There is a duplicate 'system.web.extensions/scripting/scriptResourceHandler' section defined Root of the error I got the errorhttp://dotnetspidor.blogspot.com/2011/09/last-time-i-got-following-error-http.htmlnoreply@blogger.com (Anonymous)12tag:blogger.com,1999:blog-6104185749662767834.post-490032171265700827Fri, 16 Sep 2011 05:58:00 +00002011-11-07T13:32:14.742+05:30ASP.NETCSSMake your site impressive and standard by displaying favicon. This is a practice of branding also. See in the following image the red circled area at the top corner. The black filled square is the favicon of dotnetspidor: A dot net programming blog. You can see the favicons in almost all of the popular websites. So how to achieve this? First create a favicon image of your own. Visualize a greathttp://dotnetspidor.blogspot.com/2011/09/make-your-site-impressive-and-standard.htmlnoreply@blogger.com (Anonymous)4tag:blogger.com,1999:blog-6104185749662767834.post-4477698986625552499Sat, 03 Sep 2011 09:45:00 +00002011-09-22T19:40:33.843+05:30SQL Server 2005Sometimes there arises the need of deleting all stored procedures of a database. I came across the same situation when I was generating CRUD operations stored procedures via third party tool. I once changed a table and then had to regenerate all the stored procedures. So went on to find out the way. And ultimately stumbled at http://ctrlf5.net/?p=164. Here is how to delete all the stored http://dotnetspidor.blogspot.com/2011/09/delete-all-stored-procedures-of.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-5315076182965356097Thu, 11 Aug 2011 07:05:00 +00002011-08-11T12:42:47.964+05:30ASP.NETJavaScriptThere are ways to call client functions in a parent asp.net web page from the child window. This is very helpful in many ways: 1. You can refresh parent page after some updates from child pager 2. You can partially change parts of the parent page 3. You can control the behaviour of parent page from its child (even from iframe child page) Example? See the way you edit a section in your blogger http://dotnetspidor.blogspot.com/2011/08/frequent-question-on-parent-and-child.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-6104185749662767834.post-4279446810257854208Tue, 19 Jul 2011 07:44:00 +00002011-08-11T19:08:34.993+05:30ASP.NETC#JavaScriptLast time we talked about Refreshing the parent page from child window in asp.net using javascript. This technique is useful in many scenarios. (If you haven't been through How to open new window in asp.net using javscript and C-sharp, I would like to suggest to read the post thoroughly. After this you will clearly see why the stuff we are talking about in this post is important.) But programmershttp://dotnetspidor.blogspot.com/2011/07/refresh-parent-page-partially-from.htmlnoreply@blogger.com (Anonymous)1tag:blogger.com,1999:blog-6104185749662767834.post-1159833004301920364Thu, 14 Jul 2011 12:55:00 +00002011-08-11T19:09:08.444+05:30ASP.NETC#JavaScriptMuch often we open child windows from parent web page. In the child page we perform some activities, and later close the window. At the very time we may need to refresh the parent page so that changes made in the child window be reflected in the parent window. We can easily accomplish this using javascript in asp.net web page. Let me show the way using code snippets. If it is your iframe page, http://dotnetspidor.blogspot.com/2011/07/refresh-parent-page-from-child-window.htmlnoreply@blogger.com (Anonymous)12