Can we assign a particular dataset column value to a variable

Question

I have a data set dsProcesses which returns some rows & columns.Now i need to store into a string all the data present in one particular column[Process-ID] of this data set.Can any one of u please suggest in a detailed way.

Answer 1

Yes you can

String str = DataSet.Tables[0].Rows[RowIndex]["ColumnNameOrIndex"].ToString();
String str = DataSet.Tables["TableName"].Rows[0]["ColumnName"].ToString();

Take a look at Here

Answer 2

This code will create comma delimited string with the data from that column

        for (int i = 0; i < dsProcesses.Tables[0].Rows.Count; i++)
        {
            strprocessid = strprocessid + dsProcesses.Tables[0].Rows[i]["ProcessID"].ToString() + ",";
         }
        strprocessid = strprocessid.TrimEnd(',');