Record Set (Databases) [RESOLVED]

[jordan23]

I have the following code and I need help with recordset. How do I retireve the data??? Thanks.

			string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data.mdb";
 			
			OleDbConnection connDatabase = new OleDbConnection(strConn); 
			connDatabase.Open();
			string DatQuery;


			DatQuery = "[Name] = '" + cboData.Text.Trim() + "' OR [Output] = '" 
			+ cboData.Text.Trim() + "'";

[DeadEyes]

one way

OleDbDataReader myDataReader = null;

    OleDbConnection myOleDbConnection = new OleDbConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northwind;provider=sqloledb");
    OleDbCommand myOleDbCommand = new OleDbCommand("SELECT EmployeeID, LastName, FirstName, Title, ReportsTo FROM Employees", myOleDbConnection);

    try
    {
      myOleDbConnection.Open();
      myDataReader = myOleDbCommand.ExecuteReader();

      Console.Write("EmployeeID" + "\t");
      Console.Write("Name" + "\t");
      Console.Write("Title" + "\t");
      Console.Write("ReportsTo" + "\n");

      // Always call Read before accessing data.
      while (myDataReader.Read())
      {
        Console.Write(myDataReader.GetInt32(0) + "\t");
        Console.Write(myDataReader.GetString(2) + " " + myDataReader.GetString(1) + "\t");
        Console.Write(myDataReader.GetString(3) + "\t");
        if (myDataReader.IsDBNull(4))
          Console.Write("N/A\n");
        else
          Console.Write(myDataReader.GetInt32(4) + "\n");
      }
    }
    catch(Exception e)
    {
      Console.Write(e.ToString());
    }
    finally
    {
      // Always call Close when done reading.
      if (myDataReader != null)
        myDataReader.Close();

      // Close the connection when done with it.
      if (myOleDbConnection.State == ConnectionState.Open)
        myOleDbConnection.Close();
    }

[jordan23]

I don't really understand your code. Is there a way to use my but just add the read part?? I am a newbie. sorry.

[DeadEyes]

put your query into the OleDBCommand object

OleDBCommand cmd = new OleDBCommand(DatQuery,connDatabase);

then create an OleDBDataReader to read the results

OleDbDataReader reader = cmd.ExecuteReader();

you can now loop thru this reader to get your results

while(reader.Read())
 {
   Console.WriteLine( reader[0].ToString());
 }
 //close reader
 reader.Close();

[jordan23]

I am getting these errors -

(947): The type or namespace name 'OleDBCommand' could not be found (are you missing a using directive or an assembly reference?)

(948): The type or namespace name 'cmd' could not be found (are you missing a using directive or an assembly reference?)

[DeadEyes]

make sure you have the following:

using System;
using System.Data;
using System.Data.OleDb;

and check the case OleDbCommand as opposed to OleDBCommand

[jordan23]

It was the case sensitive part. I am having problems with my SQL statement but I am working on that. Thanks again for your help.

[DeadEyes]

no problems,
with regards to getting your sql right, before sending it to be processed write it to the screen so you can see if it looks right.

[jordan23]

I used your advice and got it work perfectly!!! Thanks again.