Real Life Example for ASP.Net

 <connectionStrings>     <add name=" MainModel " connectionString="server=Localhost;database=dbMVCProject;Integrated Security = true;" providerName="System.Data.SqlClient"/> </connectionStrings> after adding your connection string in web.config  Open  Package Manager Console write : Install-Package EntityFramework After installation... Create the Class of collection of database tables In Class "MainModel". MainModel.cs ------ start ----------- using System.Data.Entity; // This for DbContext using System.ComponentModel.DataAnnotations; // this for DataAnnotations namespace MVCProject.Models {     public class MainModel : DbContext     {         public DbSet<tbl_product> tbl_product { get; set; }         public DbSet<tbl_SliderMaster> tbl_SliderMaster { get; set; }     }     public class tbl_product     { ...

 <connectionStrings>     <add name=" MainModel " connectionString="server=Localhost;database=dbMVCProject;Integrated Security = true;" providerName="System.Data.SqlClient"/> </connectionStrings> after adding your connection string in web.config  Open  Package Manager Console write : Install-Package EntityFramework After installation... Create the Class of collection of database tables In Class "MainModel". MainModel.cs ------ start ----------- using System.Data.Entity; // This for DbContext using System.ComponentModel.DataAnnotations; // this for DataAnnotations namespace MVCProject.Models {     public class MainModel : DbContext     {         public DbSet<tbl_product> tbl_product { get; set; }         public DbSet<tbl_SliderMaster> tbl_SliderMaster { get; set; }     }     public class tbl_product     { ...

Water Mark on File Type : PDF, JPEG, JPG, PNG, GIF, DOC, DOCX, XLS and XLSX Using C# --- On Click button for Convert -- -- start code -- string name = ""; name = "pdffile.pdf"; // Select File string FILEATTACHMENT = "../../Upload/Attachments/pdffile.pdf"; // Add Font family and Font Size. iTextSharp.text.Font f = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 25); Phrase p = new Phrase("Printed by " + user, f); if (ext == ".pdf" || ext == ".PDF") { string FilePath = FILEATTACHMENT.Replace(FILEATTACHMENT.Substring(0, 5), "~"); PdfReader pdfReader = new PdfReader(Server.MapPath(FilePath)); FileStream stream = new FileStream(Server.MapPath("~/Upload/PDFFolder/" + name), FileMode.OpenOrCreate); PdfStamper pdfStamper = new PdfStamper(pdfReader, stream);                    for (int pageIndex = 1; pageIndex <= pdfReader.NumberOfPages; pageIndex++)           ...

how to Replace null value with 0 Using C# //here we suppose that objDataTable have data collection as table now access this //datatable object. decimal  j = 0;  j = objDataTable.Rows[0]["Qty"] ==  DBNull .Value ? 0 :  Convert .ToDecimal(objDataTable.Rows[0]["Qty"]); NOTE :- //if   DBNull.value is null  then   "0 " else  "your code here")  // ? = then // : = else Thank You [Sumit Singh Shekhawat]

How to calculate SI (Simple Interest) using C# in Console Application _____________________ start _________________________ using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Oops_Concepts {     class Program     {         static void Main()         {             Program objProgram = new Program();             objProgram.GetSimpleInterest();             Console.Read();               }          public void GetSimpleInterest()         {             double principle, interst = 0;             int time = 0;                          Console.Write("Enter Principle Am...

Formula :  M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1] M = monthly mortgage payment P = the principal, or the initial amount you borrowed. i = your monthly interest rate. Your lender likely lists interest rates as an annual figure, so you’ll need to divide by 12, for each month of the year. So, if your rate is 5%, then the monthly rate will look like this: 0.05/12 = 0.004167. n = the number of payments, or the payment period in months. If you take out a 30-year fixed rate mortgage, this means: n = 30 years x 12 months per year, or 360 payments. ___________________________________  Start Code  _________________________________ using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Oops_Concepts {     class Program     {         static void Main(string[] args)         {             Program objProgram = new Program();   ...

Cookies is a small piece of information stored on the client machine. This file is located on client machines "C:\Document and Settings\Currently_Login user\Cookie" path.  Its is used to store user preference information like Username, Password,City and PhoneNo etc on client machines. We need to import namespace called  Systen.Web.HttpCookie before we use cookie. Type of Cookies? Persist Cookie - A cookie has not have expired time Which is called as Persist Cookie Non-Persist Cookie - A cookie has expired time Which is called as Non-Persist Cookie How to create a cookie?  Its really easy to create a cookie in the Asp.Net with help of Response object or HttpCookie Example 1 :             HttpCookie  userInfo =  new   HttpCookie ( "userInfo" );         userInfo[ "UserName" ] =  "Annathurai" ;         userInfo[ "UserColor"...