Developer Trinkets and Whatnots

Using SQL to Quickly Build Classes for Your Applications

briana@virtual-essentials.com — Sat, 13 Mar 2010 18:57:00 GMT

I was playing around yesterday SQL cursors and began to play with a query to see what I could do with it. Before long, I had written some code that could produce VB.NET Classes for my database tables. This query is by no way complete or guaranteed to produce production quality code, but more to show you a concept and a good place to get started producing the class code you could potentially use. I know there are many good code generators out there, and this isn’t meant to compete with those…just a fun, innovative use for SQL. Feel free to post back with your enhancements and let me know what you think.

More...

How to Utilize AjaxToolKit with DotNetNuke Portals

briana@virtual-essentials.com — Tue, 24 Mar 2009 16:38:07 GMT

Integrating the AjaxToolkit into DotNetNuke modules is super easy. But, can be frustrating if you're not sure how. Find out how to Ajax enable your modules in less than 5 minutes now!

The only difference between a regular web page and a DNN module control using the AjaxToolkit is that you DO NOT place a ScriptManager on the DNN UserControl. Instead you must modify the definition of the module like this:

Go to: Host >> Module Definitions

Edit the Module you want to Ajax Enable:

Find the control you want to ajax enable and edit the definition:

Click the "Supports Partial Rendering" checkbox:

What this will do is place a ScriptManager on the page for you. If you place a ScriptManager on the page, you will receive an error stating that you have multiple controls on the page with the same ID. By checking this box, DNN knows to automatically wrap your module with a ScriptManager to avoid any conflicts.

If you need programmatic access to the ScriptManager you can access it via CodeBehind like this:

Dim sm As ScriptManager = ScriptManager.GetCurrent(Page)

sm.EnablePageMethods = True

And that's it. Very Easy!

Combine C# and VB.Net Code Easily in Your Web Application

briana@virtual-essentials.com — Fri, 20 Mar 2009 19:14:57 GMT

If you've ever stumbled across a great piece of code that you wanted to integrate into your web app, but found it in the language that your NOT currently coding in,

there's an easy way to use it without having to rewrite the code in your current application's language.

In the web application file directory, create an additional folder for the other language. See in the image below that I have a folder for C# files and another for

VB.NET files.

Then, in your web.config modify the section so that it shows both of these elements. You should only have one of these initially reflecting the language you're coding in.


    
        "vb;vbs;visualbasic;vbscript" type="Microsoft.VisualBasic.VBCodeProvider,

System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" extension=".vb" warningLevel="4">
            "CompilerVersion" value="v3.5"/>
            "OptionInfer" value="true"/>
            "WarnAsError" value="false"/>
        
        "c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider,

System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">
            "CompilerVersion" value="v3.5"/>
            "WarnAsError" value="false"/>

Then, under the  section add a directoryName for the App_Code folders you created. One for each language type.   
    


"true" strict="false">
....
      
          "myVBCode"/>
            "myCSCode"/>
        
....

And that's it. Compile, browse and your done. Voila!

Very easy, huh?

Download Files via FTP with VB.NET

briana@virtual-essentials.com — Wed, 19 Nov 2008 23:03:05 GMT

With the help of the .NET framework, it is simple to download files via FTP sessions programmatically. In this example, I am going to download a stylesheet from my FTP directory and display it in the console window. You'll see how easy it is to begin using FTP in your programs.

More...

Fix the Name ‘ConfigurationManager’ is Not Declared Error

briana@virtual-essentials.com — Wed, 19 Nov 2008 20:36:57 GMT

If you are working on a project in Visual Studio and are presented with the error: Name 'ConfigurationManager' is not declared you can easily resolve the error with a couple mouse clicks.

More...

Create a GridView Programmatically and Access Templated Controls

briana@virtual-essentials.com — Sun, 16 Nov 2008 00:46:00 GMT

...But, if you want to create a drop down list instead of a textbox in the gridview you can easily do this. Click on the smart tag for the gridview and go to click on "Edit Columns". Find the column that you want to change from a textbox and click on "Convert this field into a TemplateField". Close the box and return to the smart tag options and click on "Edit Templates" Any columns that you have turned into templateFields will show up as on option in the new view (you may have to click on the smart tag again). Each templated column will have a view for the Item {read only/default view}, Edit {what you see when the grid view is in edit mode...you can make things read only, or invisible here if you don't want them to be seen in edit mode}, also templates for Insert {insert view of the gridview insert mode}, the Footer and Header also.

More...

Quick Variable Troubleshooting

briana@virtual-essentials.com — Wed, 12 Nov 2008 03:03:09 GMT

While surfing the web, I found the most useful little snippet of code that can help quickly troubleshoot and track down session and application variables. Just throw the code on an .aspx page and view in browser while you have your application running. A little F5 here and there and you can easily keep up with what's going on with your session and application level variables.

More...

Manage Connection Strings Easily

briana@virtual-essentials.com — Tue, 11 Nov 2008 00:05:00 GMT

It doesn't take long for a web.config file to get large and hard to read. But, there is one thing you can do to make managing multiple connection string a snap. Best of all, you can do this in less than 60 seconds.

More...

Adding a ToolTip to a MousedOver GridView Row Easily

briana@virtual-essentials.com — Thu, 23 Oct 2008 07:04:00 GMT

I just wanted to share one quick and easy way to add a tooltip to a mouseover on a gridView. To show you how, I created a simple .aspx page with the following code (NOTE: this page was created using a simple query from the core DotNetNuke database. You can replace with a simple select statement from Northwind or whatever database you wish. I just use DNN and that's what this site is for, so why not...)

More...

Find Out What Your Site Looks Like in 57 Browsers With a Single Click

briana@virtual-essentials.com — Wed, 22 Oct 2008 02:55:00 GMT

Here's a quick tip for any of you out there who are dealing with CSS and website layout hell due to all the browsers and their different rendering of our hard work. Check out BrowserShots.org, enter your URL and select the browsers that you want to see render your site. You'll have to wait a few minutes while it collects the info, but you needed to get something to drink anyway, right?

More...