.NET GENES

Out of boredom, I came upon a class named CustomPagination in MVCContrib that that implements IPagination , IEnumerable and other interfaces that you can customize your paging needs.Here's the class definition: namespace MvcContrib.Pagination { public class CustomPagination <T> : IPagination<T>, IPagination, IEnumerable<T>, IEnumerable { public CustomPagination(IEnumerable<T> dataSource, int pageNumber, int pageSize, int totalItems); public int FirstItem { get ; } public bool HasNextPage { get ; } public bool HasPreviousPage { get ; } public int LastItem { get ; } public int PageNumber { get ; } public int PageSize { get ; } public int TotalItems { get ; } public int TotalPages { get ; } public IEnumerator<T> GetEnumerator(); } } I found an article in this blog( http://lsd.luminis.eu ) on how to use the CustomPagination class that r

Hello! Assuming in your MS Excel Worksheet you have thousands of cells that contains url and you want them to be a hyperlink. It can be done manually, but tedious. Another solution is to write a VBA (Visual Basic for Applications) Script to do that for you using the Sub procedure below that will convert an Excel cell content to hyperlink. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Sub ChangeCellsToHyperlinks() Dim rng As Range Dim ctr As Integer Dim range_name As String ctr = 2 'starting cell to change Do While ctr <= 10000 'end cell range Set rng = ActiveSheet.Range( "A" & ctr) rng.Parent.Hyperlinks.Add Anchor:=rng, Address:=rng With rng.Font .ColorIndex = 25 .Underline = xlUnderlineStyleSingle End With ctr = ctr + 1 Loop End Sub That's it!

When I applied a new template to blogger, the category label count disappears. So, I searched google and found this site on blogger tricks that shows how to customize labels. http://dummies.bloggertipsandtricks.com/ So, I applied it in the expression expr:href='data:label.url'. <a expr:href= 'data:label.url' ><data:label.name/></a> Then, I applied the trick to show the label count. <a expr:href= 'data:label.url' ><data:label.name/></a> <span dir= 'ltr' >(<data:label.count/>)</span> Cheers!

Assuming you have a connection string that points to an Entity Framework object. And in your connection class, you pass the connection string to the Entity Framework constructor below: customerEntity = new Database1Entities(_connectionString); You encountered an error Keyword not supported: "data source". The solution is presented here: Keyword not supported data source initializing entity framework context It suggests to replace the &quot word with single quote (') character. So, in this case, I used Regex to perform replace operation. return Regex.Replace(ConfigurationManager.ConnectionStrings[key].ToString(), @"&quot" , "'" , RegexOptions.IgnoreCase);

There's a weird scenario when retrieving table names from a specific database, upon querying, using connection.Open() in C#, an error such as "Unknown database 'database_name'" shows in the exception object. I was simply checking the database name using MySQL Browser and found out that the database name starts with a space. So, after thinking about it, I decided to modify the app.config and changed the value of the connection string by enclosing the name with single quotes to include the space character of the database name. Not working app.config setting: <add key= "try" value= "server=127.0.0.1;database=database_v1;Uid=james;pwd=pass123;" /> Working app.config setting with database name enclosed in single quotes: <add key= "try" value= "server=127.0.0.1;database=' database_v1';Uid=james;pwd=pass123;" /> Note: This fix is applied towards database names that starts/ends with space. Cheers! Th

Referencing a remote validation can be a pain in the arse since several javascript errors will pop up such as stated in the title. So, in order to remove those unwanted script errors in ASP.NET MVC 2.0, use the solution below. <script src= "<%= Url.Content(" ~/Scripts/MicrosoftAjax.debug.js ") %>" type= "text/javascript" ></script> <script src= "<%= Url.Content(" ~/Scripts/MicrosoftMvcValidation.debug.js ") %>" type= "text/javascript" ></script> <script src= "../../Scripts/RemoteValidationScript.js" type= "text/javascript" ></script> Note: RemoteValidationScript.js is an external Validation javascript file. The referencing of scripts should be in order to avoid null or property not found javascript exceptions(RemoteValidationScript should be referenced last). You may also use (../../Scripts/MicrosoftAjax.debug.js) for long method. Reference: Sys

Hi, In a scenario where in you want to pass a GUID object to an Action Parameter, the parameter might contain a null value. Since Guid is not nullable, you can't simply just pass it to an action parameter because Action parameters require nullable and reference types. You might encounter an error like this: An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter Assuming you have an aspx view below: <div> <% Html.Grid(Model).Columns (c => { c.For(m => m.Price); c.For(m => m.ProductName); c.For(m => m.ProductID); c.For( "View Person" ).Named( "" ).Action(m => { %> <td> <%= Html.ActionLink( "View Person" , "ProductDetail" , "Home" , new { @id = m.ProductID.ToString() }) %> </td> <% }); %> <% }).Render(); %> </div> and an action

Hi, There's a post in codeproject that will host a datagridview in a combobox. It is in vb.net and I converted it to C#. I made some changes on the custom controls to retrieve the datagridview selected row. This was not provided in the author's post, so I made some changes myself. In total, the control was purely awesome. So, here's the C# equivalent. I won't be posting all the codes since the custom control is posted in codeproject. I'll be posting the main class instead. Credits: Niemand25 of Lithuania using System; using System.Collections.Generic; using System.ComponentModel; using System.Drawing; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using System.Reflection; namespace MyGridComboBoxCSharp { [ToolboxItem(true)] [ToolboxBitmap(typeof(ComboBox))] [DefaultBindingProperty("SelectedValue")] [LookupBindingProperties("DataSource", "

Greetings, Formatting display output of dates in asp.net mvc should work using String.Format() with custom date formatting criteria. However, applying String.Format() in asp.net ascx view does not display the desired format that I want. Example markup: @Html.TextBoxFor(model => model.HireDate, String.Format( "{0:g}" , Model.HireDate)) Given Date Input: 2/6/2013 12:00:00 AM Desired Output should be with time portion removed: 2/6/2013 Solution: The trick to display the desired format was to decorate a display format attribute in my model class HireDate property: private DateTime hDay; [DisplayName("Hire Date")] [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")] public DateTime HireDate { get { if (hDay == DateTime.MinValue) { return DateTime.Today; } else return hDay; } set { if ( value == DateTime.MinValue) { hDay = DateTime.

Here's a cool way to clean Large XML files with invalid xml characters. Note: Stream from is the original xml file, while Stream to is the new xml file with invalid characters removed. private void Copy(Stream from , Stream to) { TextReader reader = new StreamReader( from ); TextWriter writer = new StreamWriter(to); writer.WriteLine(CleanInvalidXmlChars(reader.ReadToEnd())); writer.Flush(); } public static string CleanInvalidXmlChars( string text) { string re = @"[^\x09\x0A\x0D\x20-\xD7FF\xE000-\xFFFD\x10000-x10FFFF]" ; return Regex.Replace(text, re, "" ); } Source: http://social.msdn.microsoft.com/Forums/ Post: Invalid character returned from webservice