C#

<br />
	public class SelectCommand<br />
	{<br />
		StringCollection columnNames = new StringCollection();<br />
		public SelectCommand(string selectQuery)<br />
		{<br />
			string[] tmp = selectQuery.Split(new char[]{','});<br />
			for (int i = 0; i < tmp.Length; i++)<br />
				columnNames.Add(tmp[i].Trim());<br />
		}<br />
<br />
		public DataTable ExecuteSelect(DataTable sourceTable)<br />
		{<br />
			DataTable dt = new DataTable(sourceTable.TableName);<br />
<br />
			DataColumn newCol;<br />
			foreach (DataColumn col in sourceTable.Columns)<br />
			{<br />
				if (columnNames.Contains(col.ColumnName))<br />
				{<br />
					newCol = new DataColumn(col.ColumnName, col.DataType, col.Expression);<br />
					dt.Columns.Add(newCol);<br />
				}			<br />
			}<br />
<br />
			DataRow newRow;<br />
			foreach (DataRow row in sourceTable.Rows)<br />
			{<br />
				newRow = dt.NewRow();<br />
				foreach (string colName in columnNames)<br />
				{<br />
					newRow[colName] = row[colName];<br />
				}<br />
				dt.Rows.Add(newRow);<br />
			}<br />
<br />
			return dt;<br />
		}<br />
	}<br />

Marc Clifton wrote:

why is the resulting file so darn big? BinaryFormatter seems to be a major misconception, except that the data itself is serialized in binary. However, all the tags and header stuff etc is all plain text!

Point rawCursorPosition = Cursor.Position;
Point clientCursorPosition = TreeView.PointToClient(rawCursorPosition);
TreeNode node = TreeView.GetNodeAt(clientCursorPosition) as TreeNode;	

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

naglbitur wrote:

protected override void OnPaint(PaintEventArgs e)
{
Graphics g = e.Graphics;
Pen p = new Pen(Color.Black, 2);
Point p2 = new Point(50, 70);
Point p3 = new Point(50,100);
g.DrawLine(p, p2, p3);
}

<code>
// After you create the form in your button click handler
f2.Paint += new new PaintEventHandler(f2_Paint);
.
.
.
private void f2_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
{
    Graphics g = e.Graphics;
    Pen p = new Pen(Color.Black, 2);
    Point p2 = new Point(50, 70);
    Point p3 = new Point(50,100);
    g.DrawLine(p, p2, p3);
}
</code>