Tuesday 8.16.11

using System;
using System.Data;
using System.Data.SqlClient;

namespace SetConnectionPoolingOptions
{
class Program
{

static void connection_StateChange(object sender, StateChangeEventArgs e)
{
Console.WriteLine("\tConnection.StateChange event occurred.");
Console.WriteLine("\tOriginalState = {0}", e.OriginalState.ToString());
Console.WriteLine("\tCurrentState = {0}", e.CurrentState.ToString());
}

static void Main(string[] args)
{
string sqlConnectString = @"Data Source=Alfred-PC\SQLExpress;" + "Integrated security=SSPI;Initial Catalog=AdventureWorks;";

SqlConnection connection = new SqlConnection();

//set up the event handler to detect connection state change
connection.StateChange += new StateChangeEventHandler(connection_StateChange);

//set the connection string with pooling options
connection.ConnectionString = sqlConnectString + "Connection Timeout=15;Connection Lifetime=0;" +
"Min Pool Size=0;Max Pool Size=100;Pooling=true;";

//output the connection string and open/close the connection
Console.WriteLine("Connection string = {0}", connection.ConnectionString);
Console.WriteLine("-> Open connection.");
Console.OpenStandardError();
Console.WriteLine("-> Close connection.");
connection.Close();

//Set the connection string with new pooling options
connection.ConnectionString = sqlConnectString + "Connection Timeout=30;Connection Lifetime=0;" + "Min Pool Size=0;Max Pool Size=200;Pooling=true;";

//output the connection string and open/close the conncetion
Console.WriteLine("\nConnection string = {0}", connection.ConnectionString);
Console.WriteLine("-> Open connection.");
connection.Open();
Console.WriteLine("-> Close connection.");
connection.Close();

Console.WriteLine("\nPress any key to continue.");
Console.ReadKey();
}
}
}

---

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


namespace DisplayConnectionPropertyDialog
{
public partial class Form1 : Form
{
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();

public Form1()
{
InitializeComponent();
propertyGrid1.SelectedObject = scsb;
}



private void Form1_Load(object sender, EventArgs e)
{

}

private void onPropertyValueChanged(object s, PropertyValueChangedEventArgs e)
{
connectString.Text = scsb.ConnectionString;
}

}
}

---

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Windows.Forms;

namespace ConsoleApplication1
{
class Program
{
//makes the program thread safe for COM
//in a multi-threaded program several threads execute simultaneously
//in a shared address space
[STAThread]
static void Main(string[] args)
{
OpenFileDialog dlgOpen = new OpenFileDialog();

if (dlgOpen.ShowDialog() == DialogResult.OK)
{
string s = dlgOpen.FileName;
Console.WriteLine("Filename " + s);
Console.WriteLine("Created at " + File.GetCreationTime(s));
Console.WriteLine("Accessed at " + File.GetLastAccessTime(s));
}
}
}
}

---

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Windows.Forms;


namespace ConsoleApplication1
{
class Program
{
[STAThread]
static void Main(string[] args)
{
OpenFileDialog dlgOpen = new OpenFileDialog();
if (dlgOpen.ShowDialog() == DialogResult.OK)
{
FileInfo fi = new FileInfo(dlgOpen.FileName);
Console.WriteLine("Filename " + fi.FullName);
Console.WriteLine("Created at " + fi.CreationTime);
Console.WriteLine("Accessed at " + fi.LastAccessTime);
}
}
}
}

---

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
StreamWriter writer = new StreamWriter(@"C:\inetpub\myfile.txt");
for (int i = 0; i < 5; i++)
{
writer.Write(i.ToString());
}
writer.Flush();
writer.Close();
foreach(string line in File.ReadAllLines(@"C:\inetpub\myfile.txt"))
{
Console.WriteLine(line);
}
}
}
}

---

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;

class MainClass
{
static void Main(string[] args)
{
string[] lines = new string[10];
for (int i = 0; i < 10; i++)
{
lines[i] = string.Format("This is line number {0}", i);
}

File.WriteAllLines(@"C:\inetpub\test.txt", lines);

foreach(string line in File.ReadAllLines(@"C:\inetpub\test.txt"))
{
Console.WriteLine(line);
}
}
}

---

#include
int main(void)
{
int age;
float assets;
char pet[30];

printf("Enter your age, assets, and favorite pet.\n");
scanf("%d %f", &age, &assets);
scanf("%s", pet);
printf("%d $%.2f %s\n", age, assets, pet);
return 0;
}