Error Get DataTable row information

Question

0.00/5 (No votes)

See more:

Hi,

I want to Get Row information for that i wrote code like this but it show the error

C#

DataTable dtBind = (DataTable)ViewState["dtBind"];
DataRow drow = dtBind.Select("Doc_Id=" + Doc_Id.ToString()+"AND DED_Id="+row.ToString());

the error is : cannot implicitly convert type 'System.Data.DataRow[]' to 'System.Data.DataRow'.

Posted 8-Oct-12 21:11pm

pranathis012

Add a Solution

Comments

Dinesh Ambaliya 9-Oct-12 3:26am

Use index of datarow like drow[0] or if you have to retrieve more than one record iterate through the datarow with for or foreach loop

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mario Majčica · Answer 1 · 2012-10-08T21:27:00

Try with:

C#

DataRow[] drows = dtBind.Select(string.Format("Doc_Id={0} AND DED_Id={1}", Doc_Id, row));

The fact is that Select method returns an array of DataRow objects. It means that the result of the select can be more than one.

You can easly that check if drows.Count > 0, ii means that he found something with that filter. Accessing the row is easy as drows[x] where x is a number of array element (which starts from 0).

Cheers

Bhushan Shah1988 · Answer 2 · 2012-10-08T21:31:00

Solution 2

Select method of Datatable returns an array of DataRow.
so you need to use following code.

C#

DataTable dtBind = (DataTable)ViewState["dtBind"];
DataRow[] drow = dtBind.Select("Doc_Id=" + Doc_Id.ToString()+"AND DED_Id="+row.ToString());

Posted 8-Oct-12 21:31pm

Bhushan Shah1988

Error Get DataTable row information

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Error Get DataTable row information

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us