The first thing you need to do when accessing data, of course is to create a connection to the database. For this entire tutorial, we’ll use SQL Server for the database, but it can be done with most OleDB databases also. Naturally, we’ll use/import the necessary namespaces (Sytem.Data and System.Data.SQLClient). In VB, we’ll use the […]
The ‘Path’ class, in System.IO is very useful and can save you a lot of time and work in getting what you need out of the path. In Classic ASP, using VBScript, with all the mid/left/right functions was a chore. Then, in ASP.Net, these were updated and a little easier, using the substring function. However, […]
If the code in your Source View seems unorganized and unreadable, there is a simple way, in Visual Studio, to format the text into a more readable format. What it actually does, is to create a hierarchical, tabbed view of your HTML. All you need to do is to highlight the text you need reformatted […]
REST (the initials) stand for : Representational State Transfer. REST is a service API which allows you to access services and data from various clients. To do this, you would specify a URL to some item, like a web page with xml in it, and get that item back, via an HTP ‘GET’ request, and […]
The string function ‘EndsWith’ is case-sensitive, even in VB.Net, so if you’re looking for a certain string (maybe the file extension, in a filename), you need to make sure you’re looking for the correct thing, since ‘xls’, with case-sensitivity, is different than ‘XLS’. So, if you’re function is looking for ‘xls’, you must make sure […]
If you already have any kind of button, whether it be a plain button, LinkButton, or Imagebutton, in a TemplateField, within a GridView, you can add ‘Select’ features to it, just as if you had added a ‘Select’ column. All you need to do is add ‘Select’ to the CommandName property. Then, anything you could […]
Did you know that, in your content pages, you can specify a certain MasterPage, depending on the browser that’s hitting your page (at least IE and FireFox). All you need to do is to add a section for each specific browser to your content page’s Page Directive, after creating a separate MasterPage for each browser: […]
When using DropdownLists and Listboxes, or any control which uses ‘selecteditem.text’ to get the selected item, the major reason for not getting the correct item is as follows. If you are binding the control at Page_load, you MUST surround the binding code with a page.ispostback/if/then statement inside the Page Load event.
Dynamic Data, in ASP.Net is the greatest thing since sliced bread, in my humble opinion. Using it, you can easily create really good SQL Server table Admin applications, to do all your CRUD work. And, for those of you who don’t know, CRUD stands for Create, Read, Update and Delete.
All Things DotNet Discussed – Winforms/ASP.Net/SharePoint/WPF