Inlägg

string[] files = Directory.GetFiles("C:\path", "Fil_*.xml");
FileInfo[] fi = new DirectoryInfo("C:\path").GetFiles("Fil_*.xml");

SELECT LEFT(u_Namn, 1) FROM Tabell1
UNION
SELECT LEFT(m_Namn, 1) FROM Tabell2;

// Väljer alla <value>-element
var x_query_values = from j in x_query.Elements("value") select j;

// Väljer alla <value>-element i det <dataset>-element du står på
var x_query_values = from j in post.Elements("value") select j;

XElement x_loadxml = XElement.Load("datasets.xml");
cl_DataSet[] ds = (from c in (from e in x_loadxml.Elements("dataset") select e)
				   select new cl_DataSet {
					   n_Date = int.Parse(c.Element("date").Value),
					   value = (from v in c.Elements("value") select double.Parse(v.Value)).ToArray()
				   }).ToArray();

SELECT table_users.username, table_company.companyname, MAX(table_logons.logontime)
FROM table_users INNER JOIN
table_logons ON table_users.username = table_logons.username INNER JOIN
table_company ON table_user.employedBy = table_company.companyname
GROUP BY table_users.username, table_company.companyname

using System;
using System.Diagnostics;
using System.IO;

namespace ReadProcessOutput {

	class Program {

		static void Main(string[] args) {

			ProcessStartInfo processStartInfo = new ProcessStartInfo(@program.exe);
			processStartInfo.UseShellExecute = false;
			processStartInfo.RedirectStandardError = true;

			Process process = new Process();
			process.StartInfo = processStartInfo;
			process.ErrorDataReceived += new DataReceivedEventHandler(Process_ErrorDataReceived);
			process.Start();

			process.BeginErrorReadLine();
			
			process.Close();
			Console.ReadKey();
		}

		static void Process_ErrorDataReceived(object sender, DataReceivedEventArgs e) {
			Console.WriteLine("> {0}", e.Data);
		}

	}

}

Console.ReadKey();

* {
	margin: 0;
	padding: 0;
}

Response.Write DateAdd("n", -10, Now())