What is ADO.NET

ADO.NET provides a set of components for creating distributed, data-sharing applications.

ADO.NET provides consistent access to data sources such as SQL Server and XML, and to data sources exposed through OLE DB and ODBC. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain.

Clear filters RadGrid Telerik

Telerik > RadGrid > Clear filter

foreach (var column in RadGrid1.MasterTableView.Columns)
{
         column.CurrentFilterFunction = GridKnownFunction.NoFilter;
         column.CurrentFilterValue = string.Empty;
}

RadGrid1.MasterTableView.FilterExpression = string.Empty;
RadGrid1.MasterTableView.Rebind();

Print directly RadGridView

Telerik > Windows Forms > RadGridView > Print directly 

radGridView1.Print();

Clear contents of a file c#

C# > Clear contents of a file

WriteAllText creates a new file, write the contents to the file, and then closes the file. If the target file already exists, it is overwritten.

Example

 System.IO.File.WriteAllText(filename, string.Empty);

Remove unused usings Visual Studio

Visual Studio > Remove Unused Usings

Right mouse click > Organize Usings

XDocument C# Example

C# > XML > System.Xml.Linq > XDocument

XDocument is an XML document.

Example

XDocument xDocument = new XDocument(

            new XElement("Hours",

                new XElement("Emp1", "0"),

                new XElement("Emp2", "25"),

                new XElement("Emp3", "40"),

                new XElement("Emp4", "30")

                )

            );

Create a new document by filtering data using Linq

XDocument doc = new XDocument(

           new XElement("Report",

                    from el in xDocument.Element("Hours").Elements()

                    where ((int)el) >=30

                    select el

                )

            );

Result contains two records:

default keyword c#

C# > Keywords > default

This keyword is used in two ways.

• default label in switch statement
• generics: the default value
• null for reference type
• 0 for value type