Read fast text file line by line C#

C# > Files > File Class > OpenText

Open text file for reading line by line.

Example

Read fast text file line by line C#

using (StreamReader sr = File.OpenText(@"c:\filename.txt"))

{

   while (!sr.EndOfStream)

   {

     sr.ReadLine();

    }
}

INSERT SQL Server Example

SQL Server > DML > INSERT

INSERT adds one or more rows to a table or a view.

• When insert data into a view, the view must reference exactly one base table in the FROM clause of the view. 
• When insert into a multi-table view you must use a column list that references only columns from one base table. 

Example

INSERT INTO Sales (ProductName, Price, [Date])
VALUES ('Product1', 200, GETDATE());

How to bind to a parent DataContext WPF

WPF > RelativeSource

IsEnabled="{Binding RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type UserControl}}, Path=DataContext.IsAPGCSourceFitted}"

Day VB.Net Example

VB.NET > Functions > Day

Day returns the day of the month as an integer between 1 and 31.

Example


Dim today As Integer = Microsoft.VisualBasic.DateAndTime.Day(Now)

C# Regex to match the words with dot

C# > Text > Regular Expressions > Split with dot


 string[] substrings = Regex.Split("test.regex.dot", @"\.");

Remove border Telerik RadGridView

Telerik > RadGridView > Remove border

radGridView1.GridViewElement.DrawBorder = false;

radGridView1.GridViewElement.GroupPanelElement.DrawBorder = false;

KeyNotFoundException Collection C# Example

Collections > Generic > KeyNotFoundException 

This is thrown when try to retrieve an element from a collection using a key that does not exist in that collection.

Example

   Dictionary<string, string> dict = new Dictionary<string, string>();

   dict.Add("key1","value1");

   try

   {

       string val = dict["key2"];

   }

   catch (KeyNotFoundException)

   {

       throw new KeyNotFoundException("KeyNotFoundException!");

   }