Search This Blog

Wednesday, March 18, 2015

Remove database SQL Server with sp_dbremove

SQL Server > System Stored Procedures > sp_dbremove

Removes a database.

Example

EXEC sp_dbremove HR;




Thursday, February 19, 2015

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();

        }
    }
}




Monday, February 16, 2015

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();




Wednesday, February 11, 2015

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 { }





Monday, February 2, 2015

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);








Monday, January 19, 2015

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);