Web programming – Page 5

25Jan 2013 by Ruben Canton No Comments

Restoring DB in SQL Server executing a query command

I was having a problem trying to restore a DB from a backup with the error message "Error 3154: The backup set holds a backup of a database other than the existing database.". I finally found how to make it executing a manual query instead than trying to use SQL Server menu options. To execute the query you need to open a Query and execute it from Master, not from the db to restore. [sourcecode language="sql" wraplines="false"] ALTER DATABASE MyDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE MyDatabaseName FROM DISK = 'MyDatabaseName.bak' WITH REPLACE [/sourcecode] The fix consists on using that "WITH REPLACE" sentence. Note: The page where I got the query sets the backup file using "c:/Filename.bak" but my SQL Server was configured to look into C:/Program Files/SQL Server/.../backups/…

23Jan 2013 by Ruben Canton 3 Comments

Handling brute force attacks with Umbraco

Web programming, Web security

If we want our Umbraco website to block users in case there is a brute force attack for an id we can do this: Add 2 properties to your member type: locked [true, false] and failedLogins [Numeric]. Add the following properties to your UmbracoMembershipProvider key inside webcofig (notice the values are the same as the aliases of the properties we just created): umbracoLockPropertyTypeAlias="locked" umbracoFailedPasswordAttemptsPropertyTypeAlias="failedLogins" maxInvalidPasswordAttempts="3" passwordAttemptWindow="30" Your webconfig should look something like this: [sourcecode language="xml" wraplines="false"] <add name="UmbracoMembershipProvider" type="umbraco.providers.members.UmbracoMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="MyMemberType" passwordFormat="Hashed" umbracoLockPropertyTypeAlias="locked" umbracoFailedPasswordAttemptsPropertyTypeAlias="failedLogins" maxInvalidPasswordAttempts="3" passwordAttemptWindow="30" /> [/sourcecode] The rest is handled by Umbraco. You also have a couple of properties to set how many times before a block and how much time the user is blocked. You can use the property defaultMemberTypeAlias to set your memberType alias…

22Jan 2013 by Ruben Canton No Comments

Guide for using GridViews in .Net

Web programming

Giving it a source of data to display: DataSource property To make GridViews show some data, you need to feed them with a source with that data first. That source is called DataSource and the GridView has a property to bind it: [sourcecode language="csharp" wraplines="false"] gridProducts.DataSource = getSomeSourceFromAroundThere(); [/sourcecode] The source can be a Data type using ADO like a DataReader or a DataTable in a DataSet, but it can also be a group of objects like an Array of Strings or a Collection (List, Dictionary, ...) of objects, even IEnumerables can be used. I'm going to try to show most of the examples using an ADO source and a Collection source: [sourcecode language="csharp" wraplines="false"] //Using DataReader IDataReader rd = MyNamespace.Users.getUsersReader(); gridUsers.DataSource = rd; gridUsers.DataBind(); //Using ADO DataTable DataTable tb…

25May 2012 by Ruben Canton No Comments

Adding helping boxes using jQuery ui plugin

Web design, Web programming

Once you have installed jQuery and Jquery UI, we can add some helpBox divs to our html like this: [sourcecode language="html" wraplines="false"] <asp:TextBox ID="txtInformation" runat="server" TextMode="MultiLine" Rows="5" CssClass="desc required" ></asp:TextBox> <div class="helpBox">This is a helping box.</div> [/sourcecode] Then set a javascript to position the boxes and show them only on focusing the previous item: [sourcecode language="js" wraplines="false"] function setHelpingBoxes() { $('.helpBox').each(function () { $(this).position({ of: $(this).prev(), my: "left center", at: "right center", offset: "10 0" }); $(this).hide(0); $(this).prev().focus(function () { $(this).next().show(300); }); $(this).prev().focusout(function () { $(this).next().hide(200); }); }); } [/sourcecode] And finally, don't forget to add the styles! [sourcecode language="css" wraplines="false"] .helpBox{width: 150px;padding:5px;position: absolute;display: block;right: 0;background-color: #bcd5e6;text-align: center;} [/sourcecode]

10May 2012 by Ruben Canton No Comments

Object Oriented Programming with JavaScript

Web programming

JavaScript is a powerful and old language that was not thought to work with objects, though, we can make it a bit object oriented implementing our own objects and classes like this: Create a class To make a class we can directly build it a constructor and inside it place all the class properties and methods like this: [sourcecode language="js" wraplines="false"] function CreateMyObject() { //Here all the stuff } [/sourcecode] Adding public and private variables You can make a public variable using the keyword this. [sourcecode language="js" wraplines="false"] function CreateMyObject() { this.publicVar = 'Im public'; var privateVar = 'Im private'; } [/sourcecode] (more…)

27Apr 2012 by Ruben Canton 1 Comment

Using the UpdateProgress in .Net AJAX

Web programming

When updating a part of page using ajax with UpdatePanels, you may want to show the user that the request is being done so he can wait until it is done and not send more asynchronous requests to the server. Placing the UpdateProgress inside the UpdatePanel If you want to make it clear and easy that the UpdateProgress belongs to an UpdatePanel you can place it inside the UpdatePanel ContentTemplate tag and that will do it. The UpdateProgress content will be shown when a request is made and hidden when finished. [sourcecode language="html" wraplines="false"] <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Always"> <ContentTemplate> <asp:Button ID="btnAtUpdatePanel2" runat="server" Text="Change" onclick="btnAtUpdatePanel2_Click" /> <asp:Label ID="lbAtUpdatePanel2" runat="server" Text="Initial Text"></asp:Label> <asp:UpdateProgress ID="UpdateProgress1" runat="server"> <ProgressTemplate>Loading...</ProgressTemplate> </asp:UpdateProgress> </ContentTemplate> </asp:UpdatePanel> [/sourcecode] (more…)

24Apr 2012 by Ruben Canton No Comments

Guide for using .Net UpdatePanels

Web programming

The first thing to do for using an UpdatePanel is to add a ScriptManager to the page. You can only add one and you need at least one, so you can add it to the MasterPage or just to the page using AJAX (notice the ScriptManager will add some extra scripts to your page making it slower). You can also use a ScriptManagerProxy, but that's another story, let's focus on UpdatePanels. Adding a basic UpdatePanel To add a basic UpdatePanel that will refresh without refreshing all the page and speed up your website just add this to your code after having added a ScriptManager: [sourcecode language="html" wraplines="false"] <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:Button ID="BTNChangeText" runat="server" Text="Change" onclick="BTNChangeText_Click" /> <asp:Label ID="lbText" runat="server" Text="Initial Text"></asp:Label> </ContentTemplate> </asp:UpdatePanel> [/sourcecode] And this other to your…

08Mar 2012 by Ruben Canton No Comments

Agile principles

Web programming

Simplicity Years ago when I was a student, I remember how we thought a complex code was done by someone who knew a lot and a way of showing yourself was to write pretty complex code lines no one even you weeks later could understand. Simplicity means even an external programmer to the project should be able to understand what it does in a quick sight, if that happens, you will also be able to do that and that will help you with maintenance. Should I care about external programmers? There is a saying in Programming World that, if you became indispensable in your company, maybe because your codes are impossible to handle, you will never be fired. First of all, you will never be indispensable, it may cost more…

02Mar 2012 by Ruben Canton No Comments

Images handler with resizing options in C#.Net

Web programming

First have a look at my post for how to make an Images Handler. And from there, let's continue. The idea is that if I request something like these: http://localhost:54086/images/v/?img=500667&w=540 http://localhost:54086/images/v/?img=500667&h=200 http://localhost:54086/images/v/?img=500667&w=540&maxh=90 http://localhost:54086/images/v/?img=500667&w=540&h=200&maxh=90&maxw=100 It will resize my image to the size I set and also, it will check the size limit for heights or widths so the resulting resized image doesn't break our layout. Adding some params to resize the image Lets add the querystring params to the handler: [sourcecode language="csharp" wraplines="false"] public const String PARAM_WIDTH = "w"; public const String PARAM_HEIGHT = "h"; public const String PARAM_MAXWIDTH = "maxw"; public const String PARAM_MAXHEIGHT = "maxh"; [/sourcecode] And a condition method: [sourcecode language="csharp" wraplines="false"] private Boolean NeedsToBeResized(Image img) { // If one of the params comes most probably Ill need…

28Feb 2012 by Ruben Canton No Comments

Uploading an image to database in C#

Web programming

1. Placing the FileUpload object First, we need to set the FileUpload object, we will use the one .Net gives us: [sourcecode language="html" wraplines="false"] <asp:FileUpload ID="myFile" runat="server" /> [/sourcecode] That was easy :) 2. Getting the file from the FileUpload object 2.1 Checking the uploaded file is an image Before going on, I want to show you this useful function you will need later: [sourcecode language="csharp" wraplines="false"] public Boolean IsImage(HttpPostedFile pf) { Boolean res = false; switch (pf.ContentType) { case "image/gif": case "image/jpeg": case "image/jpg": case "image/bmp": case "image/png": case "image/pjpeg": case "image/x-png": res = true; break; default: res = false; break; } if (!res) { //If the filetype doesnt work i try with the extension: switch (Path.GetExtension(pf.FileName)) { case "gif": case "jpeg": case "jpg": case "bmp": case "png": res…

24Feb 2012 by Ruben Canton No Comments

Validate forms in client side using jQuery

Web programming, Web security

There is a quick way for validating forms if you are using jQuery. 1. Download the validation plugin You need to download the jQuery Validate plugin. Alternatively you can make a call to the online version from your code. 2. Add the plugin to your website I presume you are yet using the latest jQuery library and you don't need any explanation on how to use it, then, just add another reference to the plugin in your code so you can use it: [sourcecode language="html" wraplines="false"] <script src='Scripts/jquery.-1.7.1.min.js' type='text/javascript'></script> <script src='Scripts/jquery.validate.min.js' type='text/javascript'></script> [/sourcecode] 3. Make a call to validation Now, if you just want to validate a form using default validation you only need to make a call to this function: [sourcecode language="html" wraplines="false"] <script type="text/javascript" language="javascript"> $(document).ready(function () {…

20Feb 2012 by Ruben Canton No Comments

Building your Authentication system in .Net4.0

Web programming, Web security

By default, .Net applications offer a prebuilt authentication system that you can use to give some privacy to your website in case its a small one. But, in case you pretend to use your existing DB with its existing users table and your existing conditions you may want to build your own authentication system. Most of these can be built using a standard .Net format which Im going to show: Web.config User Class Authentication Cookie Login Page Accesing the User Object from any Page Web.config Let's start talking about the webconfig file, since as its name indicates, its the file were the site configuration resides and then the best place to configure the site authentication. You can of course build your own manual system just setting something at the master…

17Feb 2012 by Ruben Canton No Comments

How to get a string in MD5 in C#.Net

Web programming, Web security

Here it is: [sourcecode language="csharp" wraplines="false"] public static String getInMD5(String inputString) { byte[] input = Encoding.UTF8.GetBytes(inputString); byte[] output = MD5.Create().ComputeHash(input); StringBuilder sb = new StringBuilder(output.Length); for (int i = 0; i < output.Length; i++) { sb.Append(output[i].ToString("X2")); } return sb.ToString(); } [/sourcecode] You may need this too: [sourcecode language="csharp" wraplines="false"] using System.Text; using System.Security.Cryptography; [/sourcecode]

16Feb 2012 by Ruben Canton 29 Comments

How to fix error “Changes are not allowed while code is running” in .Net

Web programming

If you have tried to modify your back code in .Net when your application is running and found this annoying message: Forcing you to stop debugging, edit, start debugging again. Then here's a solution: 1. Stop running your app. 2. Go to Tools > Options > Debugging > Edit and Continue 3. Disable "Enable Edit and Continue". If you find that Visual Studio doesn't alert you that files have changed and that confuses you when debugging do this: 1. Go to Tools > Options > Debugging 2. Enable "Require source files to exactly match the original version". Now run your application again and feel free to edit while you run the application, you will have to rebuild it in case you want to check the code though.

06Feb 2012 by Ruben Canton No Comments

The impressive impress.js

Web design, Web programming

I've just dicovered the library impress.js which is an amazing tool for presentations beating those you get with PowerPoint just using CSS3. It only works in the most up to date browsers but, aren't desktop presentation tools also requiring an specialized software? You need to use Chrome, Safari or Firefox 10 to visualize it but that's far more easy to get and install than other products. You can see a demo here. As soon as you have one of the newest browsers, if not, you can at least read it. Superb :) So sad you cannot use it to impress ALL your visitors yet, but you can at least impress in a conference.

Category: Web programming