Calculate SQL Server row size for a table

SQL Server > Scripts > Row Size

create table ##RowSize (tableName nvarchar(50), rowSize int)

exec sp_msforeachtable 'INSERT INTO ##RowSize Select ''?'' As tableName, SUM(c.Length) from dbo.SysColumns c where c.id = object_id(''?'') '

select * from ##RowSize order by rowSize  desc

drop table ##RowSize

Remove database SQL Server with sp_dbremove

SQL Server > System Stored Procedures > sp_dbremove

Removes a database.

Example

EXEC sp_dbremove HR;

Write, read XML to memory stream using XmlWriter and XmlReader C#

C# > XML > XmlWriter

XmlWriter  writes XML data to a file, stream,, text reader, or string.
It is fast, noncached and forward only.

Example
Write/read XML to memory stream.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Xml;

namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            MemoryStream stream = new MemoryStream();

            XmlWriter writer = XmlWriter.Create(stream);

            writer.WriteStartDocument();

            writer.WriteStartElement("Root");

            writer.WriteElementString("Child", "1");

            writer.WriteEndElement();

            writer.WriteEndDocument();

            writer.Flush();

            writer.Close();

            stream.Position = 0; // Resets the position to 0 so we can read.

            XmlReader reader = XmlReader.Create(stream);

            while (reader.Read())

            {

                //

            }

            reader.Close();

        }

    }

}

Select DataTable rows with where LINQ C#

C# > LINQ > Where

Where filters a sequence of values based on a predicate. 

Example

Select DataTable rows with where.

DataTable dt = new DataTable();

dt.Columns.Add("name", typeof(string));

dt.Rows.Add("john");

dt.Rows.Add("dan");

var filteredRows = dt.Rows

                  .Cast<DataRow>()

                  .Where(r => r["name"] == "dan").ToList();

Create new directory with DirectoryInfo C#

C# > Files > DirectoryInfo Class

Use this class for create, move and enumerating directories and subdirectories. 

Example 

Create new directory

DirectoryInfo directoryInfo = new DirectoryInfo(@"c:\Yourdir");

try

{

if (!directoryInfo.Exists)

       {

              directoryInfo.Create();

       }

}

catch (Exception ex)

{

MessageBox.Show("DirectoryInfo error: {0}", ex.ToString());

}

finally { }

Get Directory Size C#

C# > IO  > FileInfo > Length

Get the size of the file in bytes. 

Example

Get Directory Size C#

public long DirectorySize(DirectoryInfo dir)

{

       long size = 0;

       foreach (FileInfo file in dir.GetFiles())

       {

              size += file.Length;

       }

      foreach (DirectoryInfo directory in dir.GetDirectories())

       {

              size += DirectorySize(directory);

       }

       return size;

 }

DirectoryInfo dir = new DirectoryInfo(@"C:\Temp");

long size = DirectorySize(dir);

C# Capture Screen to PictureBox

C# > Drawing > Capture Screen

Bitmap printscreen = new Bitmap(Screen.PrimaryScreen.Bounds.Width, Screen.PrimaryScreen.Bounds.Height);

Graphics graphics = Graphics.FromImage(printscreen as Image);

graphics.CopyFromScreen(0, 0, 0, 0, printscreen.Size);

using (MemoryStream s = new MemoryStream())

{

printscreen.Save(s, System.Drawing.Imaging.ImageFormat.Bmp);

       picCapture.Size = new System.Drawing.Size(this.Width, this.Height);

       picCapture.Image = Image.FromStream(s);

}

XmlDocument C# Example

C# > XML > XmlDocument

Represents an XML document.

Example

XmlDocument doc = new XmlDocument();

doc.Load(xmlfile);

NetworkChange Class C#

C# > System.Net > NetworkInformation > NetworkChange

Use this class to receive notification when the IP address of a network interface changes.
Changes can appears when:

• disconnect network cable
• out of range of a wireless Local Area Network
• hardware failure

Events:

• NetworkAvailabilityChanged

C# NetworkInformation NameSpace

C# > System.Net > NetworkInformation

Provides access to network address information and traffic data.

Classes

• NetworkChange

ReadAllBytes C# Example

C# > Files > File Class > ReadAllBytes

Opens, reads the contents of the file into a byte array, and then closes the file.

Example

Read bytes from jpg file and display to PictureBox.

var bytes = File.ReadAllBytes("D:\\Pics\\1.jpg");

pictureBox1.Image = Image.FromStream(new System.IO.MemoryStream(bytes));

C# File Class

C# > Files > File Class

Use the File class for:

• copy, move, rename, create, open, delete to a single file at a time. 
• get and set file attributes.

All File methods are static.

Methods

• ReadAllBytes
• OpenText
• AppendText
• Move

IsNumeric equivalent in LINQ example

C# > LINQ > IsNumeric

IsNumeric equivalent in LINQ example.

double value;

var total = (from DataRow dr in dataTable.Rows

                where double.TryParse(dr["value"], out value)

                select Convert.ToDouble(dr["value"])).Sum();

Dependency Injection C# Example

C# > Patterns > Dependency Injection 

Dependency injection promotes loose coupling of components by passing dependencies to an object rather than having an object instantiate its own dependencies.(http://www.blackwasp.co.uk/DependencyInjection.aspx)

• Autofac
• Autofac modules

       

Example

        public interface ITruck

        {

            void Go(double distance);

        }

        public class Truck : ITruck

        {

            public double Consumption{ get; set; }

            public void Go(double distance)

            {

                double necessary_fuel = Consumption * distance;

            }

        }

        public interface IRoute

        {

            void AddTruck(ITruck dependency);

        }

        public class Route : IRoute

        {

            ITruck _truck;

            public double Distance { get; set; }

            public void AddTruck(ITruck truck)

            {

                _truck = truck;

            }

            public void TruckGo()

            {

                _truck.Go(Distance);

            }

        }

            Route route = new Route();

            route.Distance = 100;

            Truck truck = new Truck();

            truck.Consumption = 20;

           

            route.AddTruck(truck);

            route.TruckGo();

C# System.Security AccessControl

C# > System.Security > AccessControl

With AccessControl you can control, access and audit security related actions on securable objects.

• AuthorizationRuleCollection 

C# > System.Security

C# > System.Security

• NET Framework security system
• provide access to authentication
• provide crytographic services
• control access to operations based on policy
• rights management of application-created content

Classes

• AccessControl

Dynamic Type C# Example

C# > Types > dynamic

The dynamic enables bypass compile-time type checking. These operations are resolved at run time. 

Example

dynamic dyn = 1;

object obj = 1;

var dyn_type = dyn.GetType(); // System.Int32

var obj_type = obj.GetType(); // System.Int32

dyn = dyn + 1; //Ok

obj = obj + 1; // Error    1      Operator '+' cannot be applied to operands of type 'object' and 'int'