retrive value using OleDbDataReader

Question

hi,

Let us think my sql query is

  select customerDetials.custid,TestTable.col1 from CustomerDetails INNER JOIN TestTable  on CustomerDetails.custid=TestTables.custid where CustomerDetails.custid>0

I wanna use OleDbDataReader to retive rows of this .

I used this way

while (dataReader.Read()) { string str= dataReader["customerDetials.custid"].ToString();

}

but the prob is here join is thr so if i give column name like above its throwing me an exception and i cant use index or i cant change the sql query .So is there any way to retrieve the data using the column name

Answer 1

Have you tried using just

while (dataReader.Read()) { 
    string str= dataReader["custid"].ToString();    
}

Answer 2

I THINK what you want is...

string str = dataReader.GetInt32(0).ToString();

where the (0) refers to the zero-based ordinal position of the columns as in the query