Out of Scope

[Dave]

The line below with nametest in it give out of scope when run. Why? There is
data in the table.

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

namespace DataFM_Access_Data
{

class AccessConv
{

[STAThread]
static void Main()
{
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=mmrs.mdb";
string strAccessSelect = "Select * from Customers";
DataSet myDataSet = new DataSet();
myDataSet.Tables.Add("Customers");
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
myAccessConn.Open();
OleDbCommand myAccessDataSetCmd = new
OleDbCommand(strAccessSelect,myAccessConn);
OleDbDataReader dtrAccess = myAccessDataSetCmd.ExecuteReader();
if (dtrAccess.Read())
{
string nameTest= dtrAccess["CompanyName"].ToString();
^gives out of scope?
}
myAccessConn.Close();
}

}
}
}

[Vadym Stetsyak]

Maybe it would be better to write
int custIdCol = dtrAccess.GetOrdinal("CompanyName");

while (dtrAccess.Read())
{
string nameTest= dtrAccess.GetString(custIdCol );
}
--
Vadym Stetsyak aka Vadmyst

"Dave" <Da**@discussions.microsoft.com> wrote in message
news:60**********************************@microsof t.com...

The line below with nametest in it give out of scope when run. Why? There is data in the table.

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

namespace DataFM_Access_Data
{

class AccessConv
{

[STAThread]
static void Main()
{
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=mmrs.mdb";
string strAccessSelect = "Select * from Customers";
DataSet myDataSet = new DataSet();
myDataSet.Tables.Add("Customers");
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
myAccessConn.Open();
OleDbCommand myAccessDataSetCmd = new
OleDbCommand(strAccessSelect,myAccessConn);
OleDbDataReader dtrAccess = myAccessDataSetCmd.ExecuteReader();
if (dtrAccess.Read())
{
string nameTest= dtrAccess["CompanyName"].ToString();
^gives out of scope?
}
myAccessConn.Close();
}

}
}
}

[Octavio Hernandez]

Dave,

Nothing seeems to be out of scope there. Maybe you try to access the
nameTest variable after closing the block:

if (dtrAccess.Read())
{
string nameTest= dtrAccess["CompanyName"].ToString();
}
Console.WriteLine(nameTest); // this would be 'out of scope'
Regards - Octavio

"Dave" <Da**@discussions.microsoft.com> escribió en el mensaje
news:60**********************************@microsof t.com... The line below with nametest in it give out of scope when run. Why? There
is
data in the table.

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

namespace DataFM_Access_Data
{

class AccessConv
{

[STAThread]
static void Main()
{
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=mmrs.mdb";
string strAccessSelect = "Select * from Customers";
DataSet myDataSet = new DataSet();
myDataSet.Tables.Add("Customers");
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
myAccessConn.Open();
OleDbCommand myAccessDataSetCmd = new
OleDbCommand(strAccessSelect,myAccessConn);
OleDbDataReader dtrAccess = myAccessDataSetCmd.ExecuteReader();
if (dtrAccess.Read())
{
string nameTest= dtrAccess["CompanyName"].ToString();
^gives out of scope?
}
myAccessConn.Close();
}

}
}
}