C# Using LINQ Query compare the records with result of process array

Question

I have written following code to compare the records of DataSet (i.e.) record of one column. And I am getting following Exception:

ex:" Index was outside the bounds of the array."

  public void GetRunningTask()
  {
      // Process[] lstprocess = Process.GetProcesses();
      conn=new SqlConnection("Data Source=.; Initial Catalog='TTES'; Integrated Security=SSPI;");
      da=new SqlDataAdapter("Select AppName from LRNSetting", conn);
      ds=new DataSet();
      da.Fill(ds,"LRNSetting");

      // Process[] lstprocess = Process.GetProcesses();
      for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
      {
        Process[] lstprocess = Process.GetProcesses();
        // DataRow dr=ds.Tables[0].Rows.Cast<DataRow>().Single(row=>row["AppName"])

        var pro = from p in lstprocess
                 //where p.ProcessName.Contains("LRCDual")
                 //where p.ProcessName.Contains(ds.Tables[0].Rows[k].ItemArray)  //added temporary
                 where (p.ProcessName.Contains(ds.Tables[0].Rows[0].ItemArray[k].ToString()))
                 select p;
       }
  }

Hussein Khalil · Accepted Answer · 2015-05-18 04:56:56Z

2

Although you made the iteration on ds.Tables[0].Rows.Count but you are using the counter for ItemArray not for Rows as expected,

ds.Tables[0].Rows[0].ItemArray[k].ToString()

I suggest you to review your logic

answered May 18, 2015 at 4:56

Hussein Khalil

1,40111 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Satyavan Choure Over a year ago

where (p.ProcessName.Contains(ds.Tables[0].Rows[0].ItemArray[k].ToString())) //Here i want to compare the process Name getting from GetProcess with the database records where the records of dataset containing exe names(i.e. process names that i have putted mannunally).

Satyavan Choure Over a year ago

So , I would like to select those process that should also present in my database records otherwise.

Satyavan Choure Over a year ago

Eg. ConsoleApplication1.exe , ConsoleApplication2.exe these process are running in system and i have only record of "ConsoleApplication1" then it should select only this record.

Hussein Khalil Over a year ago

make another loop for the ItemArray, so your code will be like 'where (p.ProcessName.Contains(ds.Tables[0].Rows[k].ItemArray[m].ToString())) ' where 'm' is a new iteration variable that loops for all itemArrays in Row[k]

Enigmativity · Accepted Answer · 2015-05-18 07:26:11Z

You seem to have a few issues with your code. First up, as others have said, you are using index k with the bound k < ds.Tables[0].Rows.Count but you are using it against ds.Tables[0].Rows[0].ItemArray[k]. They are two different things.

You are better off not using indexes like this. You are using LINQ for part of your code, but you could use it for the rest.

Also you seem to not want to dispose of any of your disposable objects. You must ensure all disposables are disposed of.

So, try this:

using (var conn = new SqlConnection("Data Source=.; Initial Catalog='TTES'; Integrated Security=SSPI;"))
{
    using (var da = new SqlDataAdapter("Select AppName from LRNSetting", conn))
    {
        using (var ds = new DataSet())
        {
            da.Fill(ds,"LRNSetting");

            var appNames =
                ds
                    .Tables[0]
                    .Rows
                    .Cast<DataRow>()
                    .Select(x => x[0].ToString())
                    .ToArray();

            var pro =
                from p in Process.GetProcesses()
                where appNames.Any(x => p.ProcessName.Contains(x))
                select p;
        }
    }
}

Mrinal Kamboj · Accepted Answer · 2015-05-18 10:44:35Z

1

Simple Linq query, Make DataRowCollection enumerable, apply select to get list of given column with process name and compare with original process name:

lstprocess.Where(p=>ds.Tables[0].Rows.AsEnumerable.Select(row=>row["ColumnName"].ToString()).Contains(p.ProcessName))

edited May 18, 2015 at 10:44

answered May 18, 2015 at 6:08

Mrinal Kamboj

11.6k5 gold badges45 silver badges82 bronze badges

Comments

marc_s · Accepted Answer · 2024-02-11 15:03:27Z

1

You need to review your code.

You made the iteration on table's rows count but you are using the counter for ItemArray not for rows as expected.

Replace this code

var pro = from p in lstprocess
             //where p.ProcessName.Contains("LRCDual")
             //where p.ProcessName.Contains(ds.Tables[0].Rows[k].ItemArray)  //added temporary
             where (p.ProcessName.Contains(ds.Tables[0].Rows[0].ItemArray[k].ToString()))
             select p;

with this:

var pro = from p in lstprocess
             //where p.ProcessName.Contains("LRCDual")
             //where p.ProcessName.Contains(ds.Tables[0].Rows[k].ItemArray)  //added temporary
             where (p.ProcessName.Contains(ds.Tables[0].Rows[k].ItemArray['ColumnName'].ToString()))
             select p;

edited Feb 11, 2024 at 15:03

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 18, 2015 at 5:56

govinda

769 bronze badges

Comments

Conrad Lotz · Accepted Answer · 2015-05-18 05:02:07Z

0

Try

var pro = from p in lstprocess
          where (p.ProcessName.Contains(ds.Tables[0].Rows[k][0].ToString()))
          select p;

answered May 18, 2015 at 5:02

Conrad Lotz

8,9513 gold badges25 silver badges28 bronze badges

Comments

Ehsan Sajjad · Accepted Answer · 2015-05-18 05:12:23Z

0

You need to select data from current row on which loop is currently iterating. Also you may want to get data from a specific column so you need to specify column name like ds.Tables[0].Rows[k]["columnName"].ToString()). Replace "columnName" with actual column name.

var pro = from p in lstprocess
          //where p.ProcessName.Contains("LRCDual")
          //where p.ProcessName.Contains(ds.Tables[0].Rows[k].ItemArray)  //added temporary
          where (p.ProcessName.Contains(ds.Tables[0].Rows[k]["columnName"].ToString()))
          select p;

edited May 18, 2015 at 5:12

Ehsan Sajjad

62.6k16 gold badges113 silver badges171 bronze badges

answered May 18, 2015 at 5:00

Mairaj Ahmad

14.6k2 gold badges29 silver badges43 bronze badges

Comments

Hossein Narimani Rad · Accepted Answer · 2015-05-18 05:40:30Z

0

Using ItemArray[k] means you assumed you have k columns but as your code shows, you have k rows.

So This must be what you are looking for:

//Getting all table cells for every column and row as string
var tableValues = ds.Tables[0].AsEnumerable()
                              .SelectMany(i => i.ItemArray.Select(j => j.ToString()))
                              .ToList();

Process[] lstprocess = Process.GetProcesses();

var pro = from p in lstprocess
          where tableValues.Any(i => p.ProcessName.Contains(i))
          select p;

edited May 18, 2015 at 5:40

answered May 18, 2015 at 5:00

Hossein Narimani Rad

32.7k19 gold badges92 silver badges122 bronze badges

Collectives™ on Stack Overflow

C# Using LINQ Query compare the records with result of process array

7 Answers 7

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related