Blog

CRUD Operation with ASP.NET MVC and EFCodeFirst Part-2

In the previous post I have already explained How we can list data from database easily with the help of EFCodeFirst . In this post I am going to explain How we can complete Create,Edit,Delete and Details operations within 10 minutes. So let’s first Start with Create a new Customer.I am going use same example

Complex type in EFCodeFirst

I have already written a few blog post about EF Code first and it’s features following is a complete list of blog posts. Entity framework code first and inheritance- Table Per Type Entity Framework code first and Inheritance–Table per hierarchy Entity Framework Code First migrations Different way of mapping with EFCodeFirst Different way of creating

how to exeute stored procedure with partmeter in asp.net 1.1(

Following are the stored procedure that will get transaction data from database and fill it in to the sql adapter and data set. it has four parameter. SqlAdpt=new SqlDataAdapter(“sp_getTransactionData”,this.Con); SqlAdpt.SelectCommand.CommandType= System.Data. CommandType.StoredProcedure; SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter(“@boid”,System.Data.SqlDbType.NVarChar,16) ); SqlAdpt.SelectCommand.Parameters[“@boid”].Value= boid.Trim().ToString(); SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter(“@firstdate”,System.Data.SqlDbType.SmallDateTime,4)); SqlAdpt.SelectCommand.Parameters[“@firstdate”].Value= firstdate.Trim().ToString(); SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter(“@lastdate”,System.Data.SqlDbType.SmallDateTime,4)); SqlAdpt.SelectCommand.Parameters[“@lastdate”].Value= lastdate.Trim().ToString(); SqlAdpt.Fill(dt,table); SqlApdt=SQL Data Adpater dt=Sql Dataset Happy Programming

ASP.NET White Papers

In new version of Microsoft asp.net site Microsoft has launched the asp.net white papers which will help us to install and configure asp.net in our computers. It contains white papers with following different categories.. ASP.NET Security White papers Forms Authentication User Input Data Validation Code Access Security Communications Security Cryptography Installation and Setup White papers