Before some time I have blogged about Python tools in Visual Studio and explained how we install python tools with visual studio and start developing python application with the one of greatest editor in class Visual Studio. In this post we are going to learn how we can create a python application in Visual Studio.
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
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
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
Copyright @2024 Dotnetjalps