C#

deanpugh wrote:

I was originally using a datareader but because i look at the team table and then search the players table, it wouldnt let me open more than one datareader at a time and wanted me to close any existing ones, which I couldnt do because I needed to go back to it.

deanpugh wrote:

when you do a select on a datatable, can you specify which column you want to search in? Are the expressions the same as sqlquerys?

ArrayList al = new ArrayList();<br />
for( int i = 0; i< 10; i++)<br />
al.Add(new Label());<br />
// now I have two objects in the array...<br />
((Label)al[0]).Location = new Point(100,100);<br />
((Label)al[1]).Location = new Point(100,200);<br />
...<br />
((Label)al[9]).Location = new Point(100,200);

ArrayList al = new ArrayList();<br />
for( int i = 0; i< 10; i++)<br />
{<br />
  Label oLabel = new Label();<br />
  al.Add(new Label());<br />
  this.Controls.Add(oLabel);<br />
}<br />
// now I have two objects in the array...<br />
((Label)al[0]).Location = new Point(100,100);<br />
((Label)al[1]).Location = new Point(100,200);<br />
...<br />
((Label)al[9]).Location = new Point(100,200);

Select Image from Customer where Id = @Id<br />
Insert Into Customer (Image) values(@Image)<br />
Update Customer set Image = @image where Id = @Id

MemoryStream m = new MemoryStream;<br />
m.Write(imageBytes);<br />
Image.FromStream(m);<br />
....

private System.Windows.Forms.OpenFileDialog openFileDialog;<br />
string sPath = "";<br />
DialogResult dr = openFileDialog.ShowDialog(this);<br />
            <br />
if (dr == DialogResult.OK)<br />
{<br />
  sPath = openFileDialog.FileName;<br />
}