Monthly Archives: March 2015

How to use jQuery getJSON in ASP.NET MVC

In order to populate a dropdown control based on selection of another one, I used this code:

on controller I create the method below:

than on the view I used jQuery:

MS SQL How To Store a File into a blob field

If you need to store a file from your hard drive into a filed in MS Sql Server, you can run this code

UPDATE dbo.[Table] SET [Field]= (SELECT * FROM OPENROWSET(BULK N’C:fileName.PNG’,SINGLE_BLOB) rs)