Posts

Donate

Create A New SQL Server Database Basing From A Renamed DB (mdf/ldf) Files

I recently created a copy of Northwind database and called it NorthwindBootstrap. This database has a built-in membership tables added to it. The copy includes both of mdf and ldf files. My next step is to create a new database based from the recently copied/renamed files in which I have no idea on how to do it. After doing some research, I stumbled upon a t-sql script based from my requirement. USE [master] GO CREATE DATABASE [NorthwindBootstrap] ON ( FILENAME = N 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NorthwindBootstrap.mdf' ), ( FILENAME = N 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NorthwindBootstrap.ldf' ) FOR ATTACH GO Cheers! :)

The specified cast from a materialized 'System.Int16' type to a nullable 'System.Int32' type is not valid In C#

Based from the issue, the fix is to check the database field against the view model class. In my case, the database field is smallint (nullable). So, the fix is to change the model code from int datatype: public int? StockOnHand { get ; set ; } To Int16 datatype: public Int16? UnitsInStock { get ; set ; } :-)

Draggable Is Not A Function In ASP.NET MVC

Image
Here's what I did in order to recognize the draggable function in one of my asp.net mvc page. 1. Add jquery-ui.js to scripts folder. 2. Bundle the js file in BundleConfig.cs 3. Render the bundled script in _Layout.cshtml. Cheers! :-)

Check If Images Are Not Rendered Correctly To The Browser Using JavaScript

Hello, Here's a function to hide divs if it's children specifically images does not render correctly to the browser or an error has occured. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 function ImageDivHandler() { $( "div.gallery" ).each( function () { if ($( this ).children().length == 0) { $( this ).hide(); } else { var img = $( this ).find( ".image-responsive" ); if (img != null || img != undefined ) { imgSrc = $( this ).find( ".image-responsive" ).attr( "src" ); if (imgSrc == "" || imgSrc == null || imgSrc == "null" ) { $( this ).find( ".image-responsive" ).closest( "div.gallery" ).hide(); } else { $( this ).find( ".image-responsive" ).error( function () { $( this ).closest( "div.gallery" ).hide();

jQuery Intellisense Not Working In External Javascript File Using Visual Studio 2013

Image
Hello, In order for the jQuery intellisense to work in Visual Studio 2013, perform the following steps. 1. Proceed by clicking Tools -> Options -> Text Editor -> JavaScript -> Intellisense -> References. 2. Change Reference Group to Implicit (Web)   By default a reference has been added to _references.js. If not, add a new reference file under Scripts folder. 3. Open _references.js file using your Visual Studio IDE or any text editor software. 4. Add reference path to jquery files (.js, .min.js, and .intellisense.js). 5. Close Visual Studio and Open it again. (I was struggling for hours as to why performing steps 1 through 4 didn't work. This step fixed the issue) Reference: jQuery intellisense not working in VS 2012 Regards, :)

ASP.NET WebForms Change GridView Sort Link Color

Image
Here's how to change the color of GridView SortLink using CSS. ASPX Markup 1 2 3 4 5 6 7 8 9 10 11 12 <asp:GridView ID= "GridVwPagingSorting" runat= "server" AutoGenerateColumns= "False" Font-Names= "Verdana" AllowPaging= "True" AllowSorting= "True" PageSize= "5" Width= "75%" OnPageIndexChanging= "PageIndexChanging" BorderColor= "#CCCCCC" BorderStyle= "Solid" BorderWidth= "1px" OnSorting= "Sorting" > <AlternatingRowStyle BackColor= "#BFE4FF" /> <PagerStyle BorderColor= "#CCCCCC" BorderStyle= "Solid" BorderWidth= "1px" /> <HeaderStyle CssClass= "gridViewHeader" /> <RowStyle Height= "20px" Font-Size= "13px" BorderColor= "#CCCCCC" BorderStyle= "Solid" BorderWidth= "1px" /> <

Alphabetical Paging in ASP.NET MVC (C#)

Image
Here's the C# version of Alphabetic Paging in VB.NET Posts: 1. Alphabetical Paging in ASP.NET MVC 2. Alphabetical-Paging-in-ASP-NET-MVC Source Code Solution Structure HtmlHelpers.cs using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Text; using System.Web.Mvc; namespace MVCAlphabeticPager.Helpers { public static class HtmlHelpers { public static HtmlString AlphabeticalPager( this HtmlHelper html, string selectedLetter, IEnumerable< string > firstLetters, Func< string , string > pageLink) { var sb = new StringBuilder(); var numbers = Enumerable.Range(0, 10).Select(i => i.ToString()); var alphabet = Enumerable.Range(65, 26).Select(i => (( char )i).ToString()).ToList(); alphabet.Insert(0, "All" ); alphabet.Insert(1, "0-9" ); var ul = new TagBuilder( "ul" );

Alphabetical Paging in ASP.NET MVC (VB.NET)

Image
   Here's a sample ASP.NET MVC 5 project using Alphabetical Paging concept of Mikesdotnetting. The revisions are made on the Model, User Interface, and the database used. I replaced Northwind db with Adventureworks. Solution Structure Sample Output The source code/files and instructions on how to create this project using Visual Studio 2013 are elaborated in VBForums code bank. Alphabetical Paging in ASP.NET MVC

Entity Framework Join Two Tables If The Foreign Key Is A Nullable Column

Image
Hello, When retrieving records by joining two tables wherein the foreign key of the referenced table is a nullable column, and you want to return all records from the primary table, with or without the matching rows in the right table, the query would be using left join rather than inner join. So in LINQ expression, rather than inner join, revise the query to left join as presented below. Show products with matching categories, disregarding other products without categories MVC View: Code: 1 2 3 4 5 6 7 8 9 10 11 model.Products .AddRange( ( from item in context.Products .Where(item => item.Name.Trim().StartsWith(selectedLetter)) join category in context.ProductSubcategories on item.ProductSubcategoryID equals category.ProductSubcategoryID select new ProductModel() { ProductName = item.Name, ProductID = item.ProductID, ProductNumber = item.ProductNumber, Color = ( string .IsNullOrEmpty(item.Color)) ? "NA" : item.Color, St

ASP.NET Web Forms Show Tooltip In Gridview Column

Here's how to show tooltip in an asp.net gridview column/cell on mouse hover. This option will set the Tooltip property of a particular gridview cell on RowDataBound event. C# Code: 1 2 3 4 5 6 7 8 protected void grdCustomers_RowDataBound( object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string str = e.Row.Cells[1].Text; e.Row.Cells[1].ToolTip = str; } }

Donate