How to insert update delete in Gridview Using LINQ with Lamda Expression in asp.net

What is Lamda Expression:-

A lambda expression is an anonymous function that you can use to create delegates or expression tree types. By using lambda expressions, you can write local functions that can be passed as arguments or returned as the value of function calls. Lambda expressions are particularly helpful for writing LINQ query expressions.

Description:-

               In this example we can create a CRUD operation with LINQ but not through simple query but with the use of Lamda Expression.

    by using lamda expression we can reduce the length of Query so your code is very shortly and you can easily do the operation rather than simple long query 

In Linq you have to First Create a one DBML File in which you have to Add a all Table that you have to use in a application so not need to Connecton. And also you have to add Namespace using System.Linq instead  of  using System.Data.SqlClient;

 
to show Example of insert,update,delete in gridview using WCF Service please click here WCF Service For Insert,update,Delete
             
to show Example of insert,update,delete in gridview using LINQ please click here insert,update,delete using Linq

to show Example of insert,update,delete in gridview using Naming Container please click here Naming Container for insert update Delete in Gridview

to show Example of insert,update,delete in gridview using Modal Popup please click here insert,update,delete in Modal Popup

 to show Example of insert,update,delete in gridview using Stored Procedure please click here insert,update,delete through stored Procedure

  to show Example of insert,update,delete in XML File and bind to Gridview please click here insert,upadte,delete in XML File

  to show Example of insert,update,delete in gridview using Three Tier Architecture please click here Three Tier Architecture For insert,update,Delete

so How to insert update Delete through Lamda Expression Query are as define below code...

How to insert update delete in Gridview through LINQ in asp.net

 

What Is LINQ:-

                 LINQ is a new feature available from .net version 3.0 and above. It called as LANQUAGE INTEGRATED QUERY there are different flavours of LINQ available like LINQ TO SQL, LINQ TO XML etc.. Taking advantage of LINQ you can query the collection as if you are querying from a database. 

Basic example
var users = from userVariable in studentCollection
select userVariable.ID;

Description:-

            In this example we simply Define How to Create insert update delete in gridview using LINQ. we all know the CRUD operation in Gridview through SQL is also easy but the Advantage of the LINQ is that you need not a connection and the length of code of CRUD operation is very shortly than an SQL query. 

     also the LINQ is language integrated query, you can easily perform all operation and very short time than SQL.

the CRUD operation Demo through SQL is also available click here CRUDinGridview

Send SMS to user Mobile in asp.net Send SMS in asp.net
Enter only Alphabet in TextBox Validation in Javascript for enter only Alphabet

Crystal reports example/sample in asp.net or Display Image in Report Fetch from Gridview

What is Crystal Report:-

Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources like SqlServer Oracle etc. Crystal Reports can access data from databases and can integrate this data from multiple databases within one Report using SqlServer Connectivity.

Description:-

we all know that very well Report is the main thing in each and every language. in many way people use report like Bill Generation etc..

                In this Example We can generate Report of Each row of Gridview When user is Click on Gridview Row. and also Note that we can not use the any table or database but main point is that we can  use XML file on which we can Bind data to gridview and perform CRUD operation on grid and Generate Report using CrystalReport.

          we all know that XML is also a one kind of Database and in XML that is very Difficult to perform a CRUD operation than an SQLServer database or other database.

     to perform operation in XML database first you have to open the file and you have to open it in write mode.

 in this Example we can also store the image in XML database and also Bind,edit,Delete image in gridview fetch from XML file. we also provide when user click on each record of gridview then this record is printed on the Crystal Report.

we also provide to generate Report of the Whole Record which are display in Gridview.

to show Example of insert,update,delete in gridview using WCF Service please click here WCF Service For Insert,update,Delete
             
Export Gridview Data to PDF File Transfer Gridview row to PDF File

Create/Generate Random or Unique Password Generate Password

Crystal Reports Display Images From Database in Asp.Net

Description:-

                 In this Example we define that how to Display Image in crystal Report Retrive From database.for example we have one record with name,address and third is it's Image. so that's type of data how we can Display in CrystalReport when user click on each row of Gridview The same record are display in Report and you can also navigate the record printing record in report.

In Simple you Bind the data in CrystalReport then it will Display Name of the Image not Image so avoid this Sitution we Have to Convert this Image in ByteArray If DataType of the Photo or Image Coloumn in database is String if DataType is Image then you did not Require to Covert into ByteArray Because It also Return ByteArray.

If Your Coloumn(photo,iamge etc..) Defines with String DataType then First You Have to Convert it into ByteArray. To Convert this Code is Here

public static byte[] ReadImageFile(string PostedFileName, string[] filetype)

    {

        bool isAllowedFileType = false;

        try

        {

            FileInfo file = new FileInfo(PostedFileName);

            strFile_Name = file.Name;

            foreach (string strExtensionType in filetype)

            {

                if (strExtensionType == file.Extension)

                {

                    isAllowedFileType = true;

                    break;

                }

            }

            if (isAllowedFileType)

            {

                FileStream fs = new FileStream(PostedFileName, FileMode.Open, FileAccess.Read);

                BinaryReader br = new BinaryReader(fs);

                byte[] image = br.ReadBytes((int)fs.Length);

                br.Close();

                fs.Close();

                return image;

            }

            return null;

        }

        catch (Exception ex)

        {

            throw ex;

        }

    }

To Call this Function Pass Parameter Like this

Byte[]  bt = ReadImageFile(s, new string[] { ".GIF", ".gif", ".jpg", ".bmp", ".jpeg" });

To Show How To Convert ByteArray to Image or Image to ByteArray Click this Link Convert ByteArray to Image And Image to ByteArray

Upload File and Bind to Gridview Upload and Bind Image to Gridview

AutoComplete TextBox Search Example Autocomplete Search in Ajax

Nested ModalPopupExtender with insert update delete operation in Asp.Net

What is Nested Popup:-

                                    A ModalPopup inside other ModalPopup is Called a Nested Popup. In this Example we explain How to Create a nested Popup and Perform Insert and Delete Operation in this Popup.

Description:-

                        The ModalPopupExtender allows Users to Display Content of Element into the Popup. When Popup is Show at that popup is Display with HighLight and User are not allowed to do any other operation even the click on the other Control are not permitted.

You can provide OnShowing/OnHiding/OnHidden animations which are played when the modalPopupExtender  content is shown and hidden.

Property of the ModalPopupExtender:-

  TargetControlID - The ID of the  activates the modal popup.

  PopupControlID - The ID of the element to display as a modal popup like Button etc….

  BackgroundCssClass - The CSS class for Popup to apply to the background when the modal popup is displayed.

  DropShadow - True to automatically add a dropshadow to the modal popup.

  OkControlID - The ID of the element that dismisses the modal popup.

  OnOkScript - The script to run when the modal popup is dismissed using the element specified in OkControlID.

  CancelControlID - The ID of the Control that cancels the modal popup

  OnCancelScript - Script to run when the modal popup is dismissed with the CancelControlID

  PopupDragHandleControlID - The ID of the embedded element that contains the popup header/title which will be used as a drag handle

  X - The X coordinate of the top/left corner of the modal popup (the popup will be centered horizontally if not specified)

  Y - The Y coordinate of the top/left corner of the modal popup (the popup will be centered vertically if not specified)

  RepositionMode - The setting that determines if the popup needs to be repositioned when the window is resized or scrolled

Methods

• initialize() - Initializes the ModalPopupExtender behavior.
• dipose() – Disposes or End the ModalPopupExtender behavior.
• show() - Displays the element that is referenced by the PopupControlID property as a modalpopup dialog box.
• disableTab() - Changes the tab indexes so that tabbing moves the focus only through the modal dialog box.
• Remarks - In Internet Explorer 6, the disableTab method also hides the select elements.
• restoreTab() - Restores the tab indexes from the page.
• Remarks - In Internet Explorer 6, the restoreTab method also restores the select elements.
• hide() - Hides the modal popup.
• Returns - Returns a Boolean value that specifies whether the popup was hidden.

MVC Modalpopup For Insert,Update,Delete CRUD Operation in MVC ModalPopup

Bind Image in DataList Control Database Image bind to DataList

Paging in Repeator Control Paging/Custom Paging in Repeator Control

How to Perform Insert,Update,Delete in Gridview using Linq in asp.net

What Is LINQ:-

                 LINQ is a new feature available from .net version 3.0 and above. It called as LANQUAGE INTEGRATED QUERY there are different flavours of LINQ available like LINQ TO SQL, LINQ TO XML etc.. Taking advantage of LINQ you can query the collection as if you are querying from a database. 

Basic example
var users = from userVariable in studentCollection
select userVariable.ID;

Description:-

            In this example we simply Define How to Create insert update delete in gridview using LINQ. we all know the CRUD operation in Gridview through SQL is also easy but the Advantage of the LINQ is that you need not a connection and the length of code of CRUD operation is very shortly than an SQL query.

     also the LINQ is language integared query, you can easily perform all operation and very short time than SQL.

the CRUD operation Demo through SQL is also available click here CRUDinGridview

to show Example of how to send SMS in Asp.Net click here Send SMS to user in asp.net

to show Example of How to send Email to user in asp.net click here send Email in asp.Net

to show Example of How to Export Gridview Data to PDF in asp.net Export Gridview Data to PDF