Abhi's den...
The piece of code which nobody cracked...
-
Creating a secure SQL server login - CHECK_EXPIRATION & CHECK_POLICY
In SQL Server you can create users using T-SQL or using the options provided by SQL Server Management Studio.
-
Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.
Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486)
-
Calling Web Services in classic ASP
Last day my colleague asked me the provide her a solution to call the Web service from classic ASP. (Yes Classic ASP. still people are using this :D )
-
Extension Methods - add methods to class
-
DataTable to Dictionary using LINQ
Sometimes we have to create generic dictionary from the values in datatable. Usually we will loop through all the rows in the datatable and add the relevant keys to dictionary object
-
Anonymous types for dummies
Anonymous types are used to define strong types without defining the type. Anonymous types are strongly typed and checked at compile time. It provides a convenient way to encapsulate a set of read-only properties into a single object without having to first explicitly define a type. Anonymous types are reference types that derive directly from object. The compiler gives them a name although your application cannot access it. From the perspective of the common language runtime, an anonymous type is no different from any other reference type, except that it cannot be cast to any type except for object. This type is widely used by LINQ, because LINQ returns dynamically-shaped data, whose type is determined by the LINQ queryTo understand better look at the following codestatic void Main(string[] args){string[] names = { "Abhi1", "abhi", "abhi11","george", "bush", "britney","gandhi", "David" };IEnumerable<string> varAnnoyType = from str in names//following code also valid//var varAnnoyType = from str in names// orderby str//foreach (string strname in varAnnoyType)Console.WriteLine(strname);Console.ReadLine();}anonymous type is an object which supports IEnumerable interface.In the above example an array of names is created (took the array collection from msdn) , anIEnumerable<string> type is created, see the keyword like from used to iterate eact item in collection, orderby clause orders (without LINQ imagine the dictionaries , temp variables and other techniqies used to sort items now this is really cool). You can add a Where clause also before the select keyword. If any conditions are specified then select will retrieve only those items which satisfies the where clause.var varAnnoyType = from str in namesThe for each iteration can be written like the following also.foreach (var strname in varAnnoyType)Console.WriteLine(strname);If two or more anonymous types have the same number and type of properties in the same order, the compiler treats them as the same type and they share the same compiler-generated type information.An anonymous type has method scope. To pass an anonymous type, or a collection that contains anonymous types, outside a method boundary, you must first cast the type to object. However, this defeats the strong typing of the anonymous type. If you must store your query results or pass them outside the method boundary, consider using an ordinary named struct or class instead of an anonymous type.Anonymous types cannot contain unsafe types as properties.Because the Equals and GetHashCode methods on anonymous types are defined in terms of the Equals and GetHashcode of the properties, two instances of the same anonymous type are equal only if all their properties are equal. -
LINQ for dummies - an overview
-
Difference between a constant and readonly variables/fields : (constant vs readonly)
-
using LINQ retrieve top N rows
Now how to retrieve the rows between N1 & N2, just use the skip function along with Take as shown below
-
Viewstate error : 12031
Few days ago I was asked to look into an issue. In our application we have created dynamic grids to show data from database. This ASPX page was Ajax enabled. Moreover all the rows of the grid were in edit mode ie. the normal controls like textbox,dropdowns etc were displayed in all the rows. This grid was Paginated. But for the past few days the paging was not working.