C#

...
Dept d = new Dept();                
while (datareader.Read())                
{
...

...
Dept d;
while (datareader.Read())                
{
   d = new Dept();
...

Dept d;
while (datareader.Read())                
{
   d = new Dept()

class Dept
{
    public static string Deptno;
    public static string Dname;
    public static string Loc;
    public string DNAME
    {
        get { return  Dname; }
        set { Dname = value; }
    }
    public string DEPTNO
    {
        get { return  Deptno; }
        set { Deptno = value; }
    }
    public string LOC
    {
        get { return  Loc; }
        set { Loc = value; }
    }
}

class Dept { 
      private static string Deptno;
      private static string Dname;
      private static string Loc; 
      public string DNAME { 
         get { return Dname; } 
         set { Dname = value; } 
      } 
      public string DEPTNO { 
         get { return Deptno; } 
         set { Deptno = value; } 
      } 
      public string LOC { 
         get { return Loc; } 
         set { Loc = value; } 
      } 
   }

ArrayList departments= new ArrayList();
Dept department;
while(reader.Read)
{
  department = new Dept();
  department.DName = reader["DepartmentName"] //or whatever name you have given your column
  department.DEPTNO = reader["DepartmentNumber"] //or whatever
  //...
  departments.Add(department);
}

department.Name;

private void InitializeComponent()
{
	this.label1 = new System.Windows.Forms.Label();
	this.SuspendLayout();
	// 
	// label1
	// 
	this.label1.BackColor = System.Drawing.Color.White;
	this.label1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
	this.label1.CausesValidation = false;
	this.label1.Font = new System.Drawing.Font("Arial", 9.75F, 
                              ((System.Drawing.FontStyle)
                               ((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), 
                               System.Drawing.GraphicsUnit.Point, ((byte)(0)));
	this.label1.ForeColor = System.Drawing.Color.DarkRed;
	this.label1.Location = new System.Drawing.Point(47, 128);
	this.label1.Name = "label1";
	this.label1.Size = new System.Drawing.Size(198, 24);
	this.label1.TabIndex = 0;
	this.label1.Text = "Loading program. Please wait...";
	this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
	// 
	// SplashPanel2
	// 
	this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
	this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
	this.BackColor = System.Drawing.Color.Lime;
	this.CausesValidation = false;
	this.ClientSize = new System.Drawing.Size(292, 273);
	this.Controls.Add(this.label1);
	this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
	this.MaximizeBox = false;
	this.MinimizeBox = false;
	this.Name = "SplashPanel2";
	this.ShowIcon = false;
	this.ShowInTaskbar = false;
	this.SizeGripStyle = System.Windows.Forms.SizeGripStyle.Hide;
	this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
	this.TransparencyKey = System.Drawing.Color.Lime;
	this.ResumeLayout(false);
}

John Simmons / outlaw programmer wrote:

BTW, if I use ShowDialog() to display it, calling Form.Close() does not dismiss the form (but calling Close() does work when I use Form.Show()).

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using System.Threading;


namespace DownloadablePlayer
{
	public partial class vPopcornPlayer : Form
	{
		BackgroundWorker m_splashWorker = new BackgroundWorker();

		//--------------------------------------------------------------------------------
		/// <summary>
		/// Shows the splash screen while the program initializes itself.
		/// </summary>
		private void ShowSplashScreen()
		{
			m_splashWorker.WorkerReportsProgress = false;
			m_splashWorker.WorkerSupportsCancellation = true;
			m_splashWorker.DoWork += new System.ComponentModel.DoWorkEventHandler(splashWorker_DoWork);
			m_splashWorker.RunWorkerAsync();
		}

		//--------------------------------------------------------------------------------
		/// <summary>
		/// Closes/disposes the splash screen.
		/// </summary>
		private void HideSplashScreen()
		{
			if (m_splashWorker.IsBusy)
			{
				m_splashWorker.CancelAsync();
				// give the worker a chance to stop
				Thread.Sleep(500);
			}
		}

		//--------------------------------------------------------------------------------
		private void splashWorker_DoWork(object sender,DoWorkEventArgs e)
		{
			BackgroundWorker thisWorker = sender as BackgroundWorker;

			SplashPanel2 splashPanel = new SplashPanel2();
			splashPanel.Show();

			while (!thisWorker.CancellationPending)
			{
				Thread.Sleep(500);
			}

			splashPanel.Close();
			splashPanel.Dispose();
		}

	}
}

John Simmons / outlaw programmer wrote:

I hate .Net

// Connection & DataAdapter initialization code should go here
// ...

OleDbCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "Insert Into Table(Col1, Col2, Col3) Values (?, ?, ?)";
dataAdapter.InsertCommand = insertCommand;

// ...