Category: My Blog

  • Blog
  • Category: My Blog

Book:Developing More-Secure Microsoft® ASP.NET 2.0 Applications

Microsoft Press has this great book.this book includes… • Harden a Web server, operating system, communication protocol, and ASP.NET Validate input data with white listing, regular expressions, sand boxing, and other techniques •Understand design and security implications of various cryptography approaches•Integrate with Microsoft Windows security features such as impersonation, delegation and protocol transition•Implement Web farm,

Read More

How to install Robo3T(Formerly RobMongo) on Ubuntu

Robo3T formerly known as RobMongo is one of best GUI tools for the managing and querying MongoDB database. I have been using it quite often for creating applications with MongoDB and Node.js. Recently a new version made available but there were no instructions for installing it on Ubuntu. So I thought it would be a

Read More

Getting Started with NHibernate and ASP.NET MVC- CRUD Operations

In this post we are going to learn how we can use NHibernate in ASP.NET MVC application. ORMs(Object Relational Mapper) are quite popular this days. ORM is a mechanism to map database entities to Class entity objects without writing a code for fetching data and write some SQL queries. It automatically generates SQL Query for

Read More

Stored Procedure-Importing CSV Files into Table -SQL Server

Here is the Stored Procedure code for importing comma seperated CSV files to table. CREATE PROCEDURE [dbo].[sp_ImportScript]@filepath varchar(2000)ASBEGIN TRYdeclare @tmpsql varchar(3000)set @tmpsql=’BULK INSERT table’set @tmpsql=@tmpsql + ‘ FROM ”’ + @filepath + ””set @tmpsql=@tmpsql + ‘ WITH (FIRSTROW=2,FIELDTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘,ROWTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘)’EXEC(@tmpsql)select @@rowcountEND TRYBEGIN CATCHDECLARE

Read More

Copyright © 2026 Dotnetjalps