Problem with for each statement

[Ravi Bhavnani]

Does ReturnFileIdentifiers() do what it's supposed to do? /ravi

This is your brain on Celcius Home | Music | Articles | Freeware | Trips ravib(at)ravib(dot)com

[kalaveer]

Yes it is returning all the strings properly.

[Christian Graus]

Then you're returning a collection of DataRows and you need to pull out the values that you need.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Martin 0]

Hello, Try to use a for loop, with an indexer!

for(int x=0;x < fileidentifiers.Length; x++)
{

as string;

if(actIdentifier.Equals(fileidentifier)
{

}

}

Hope it helps! All the best, Martin

[Sandeep Akhare]

kalaveer wrote:

System.Data.DataRow in the string identifier

what is your return statement in the ReturnFileIdentifiers(); function or while addding to the array of string you are not properly adding them in ReturnFileIdentifiers(); function

Thanks and Regards Sandeep If you want something you never had, do something you have never done!

[kalaveer]

Even this is not working by the way my ReturnFileIdentifiers code would be below string[] ReturnFileIdentifiers() { using (OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Warehouses_older\\Sample1_cat61.mdb")) { OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT MD_Metadata.FileIdentifier FROM MD_Metadata", connection); DataTable FileIDs = new DataTable(); adapter.Fill(FileIDs); string[] fileids = new string[FileIDs.Rows.Count]; for (int i = 0; i < FileIDs.Rows.Count; i++) fileids[i] = FileIDs.Rows[0].ToString(); return fileids; } }

[Guffa]

kalaveer wrote:

fileids[i] = FileIDs.Rows[0].ToString();

The ToString method of DataRow is inherited from the Object class, and returns the name of the data type. What is is that you are trying to read from the data table?

--- single minded; short sighted; long gone;

[Martin 0]

I think you whant to return the Item (FileIDs.Rows[0].Item) from the DataRow class. Don't you?

[sujithkumarsl]

i tried with your code but its working. i am pasting the code here please update using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace testApp { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private string[] ReturnFileIdentifiers() { string[] sample = { "sujith", "syam", "tharun" }; return sample; } private void button1_Click(object sender, EventArgs e) { string fileidentifier = "sujith"; string[] fileidentifiers = ReturnFileIdentifiers(); foreach (string identifier in fileidentifiers) if (identifier == fileidentifier) { MessageBox.Show("hi" + fileidentifier); } } } }

My small attempt...

[kalaveer]

But while debugging fileids contents are the string values of that perticual field contents which i queried using oledb command.

[kalaveer]

How to do so.

[Christian Graus]

The debugger is showing you the contents of the rows.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Christian Graus]

You have a collection of data rows. Do a foreach that recognises this fact. You can get items out of a data row by index or by name, using array notation.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )