C#

OleDbCommand cmd = new OleDbCommand(myConnection, 
    "SELECT id, dataColumn1, dataColumn2, etc FROM myTable WHERE id = ?")
cmd.Parameters.Add(id);
OleDbDataReader reader = cmd.ExecuteReader();
int id = reader.GetInt32(0);
string myValue = reaser.GetString(1); // etc.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

// Create and Open the connection to the database
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
myConnection.Open();
 
// Define the command to send to the database.
OleDbCommand cmd = new OleDbCommand(myConnection,
     "SELECT id, dataColumn1, dataColumn2, etc FROM myTable WHERE id = ?");
cmd.Parameters.Add(id);
 
// Execute the commend, requesting a reader object to get the results.
OleDbDataReader reader = cmd.ExecuteReader();
 
// Get the results from the reader 
int id = reader.GetInt32(0);
string myValue = reaser.GetString(1); // etc.
 
// Close the connection.
myConnection.Close();

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

class Dal
{
    private string connectionString;
    public Dal()
    {
        connectionString = ConfigurationSettings.AppSettings["connectionString"];
    }
 
    private SqlConnection Connection
    {
        get
        {
            return new SqlConnection(connectionString);
        }
    }
 
    // Example of returning a single row.
    public Hashtable GetMyData()
    {
        // Some code that accesses the database and gets the data through a datareader
        // see previous forum post for an example.
        Hashtable result = new Hashtable();
        for(int i=0; i<myDataReader.FieldCount;i++)
        {
            string columnName = myDataReader.GetName(i);
            object columnValue = myDataReader.GetObject(i);
            result[columnName] = columnValue;
        }
        return result
    }
}

Dal dal = new Dal();
Hashtable data = dal.GetMyData();
// Do something with data (e.g. populate controls)

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

public class DS_Company<br />
{<br />
  OdbcConnection conn = new OdbcConnection("ConnectionString");<br />
  string strSQL;<br />
		<br />
  public DS_Company()<br />
  {<br />
  conn.Open(); //opens the database connection<br />
  }<br />
	<br />
  public DataSet GetID(string strID)<br />
  {<br />
  strSQL = " SELECT ";  //standard SQL command<br />
  strSQL += " * ";  //selects all the data in the table<br />
  strSQL += " FROM Table";  //what table you are aiming at<br />
  strSQL += " WHERE IDnumber='"+ strID +"'";  //gets data according to what ID you specify			<br />
<br />
  DataSet ds = new DataSet(); //creates a storage for your data<br />
  OdbcDataAdapter adpDS = new OdbcDataAdapter(strSQL,conn);  <br />
  adpDS.Fill(ds); //fills your dataset with the data<br />
  return ds; //passes the dataset to you main form<br />
  }<br />
}<code><br />
<br />
hope that helps <br />
<br />
Kampai!!!

string[] price = new string[number_of_elements];

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

<br />
price = new string[oraDR.Count];   //or Lenght or size, I think it's in there somewhere :-)<br />
while(oraDR.Read())<br />
{ <br />
try<br />
{<br />
price[counter] = oraDR["last_done_price"].ToString(); // <-- error here..<br />
}<br />
catch (NullReferenceException nre)<br />
{<br />
MessageBox.Show(nre.Message);<br />
}<br />