How do i take specific coloumns from the datarow[]

Help
1

Hi,

I have a data table called DT_ConverterOP.I am selecting the records based on the project id.Its retuaning as a data row as DataRow_Result.Now i want specific coloumns from the data row(DataRow_Result) .How to get it.Can you please help me here

image
image1190×660 30.5 KB

2

Hello @cheersrpa

Try use this

DtColumnsSpecific = DataRow_Result.Defaultview.totable(false, “Name of SpecificColumn1”, “Name of SpecificColumn2”)

3

Hi @cheersrpa

Select returns an array of Data Rows. If you can access a simple column in a data table like this:
yourDataTable.Rows(0).Item("columnName")
Then you can access the array item like this:
yourDataTable.Select("your select string")(0).Item("columnName")