Can we assign a particular dataset column value to a variable

Elena Glibart 2111 11 Dec 2014

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.

Elena Glibart

Other

2 Answers

Samuel Fernandes 12 Dec 2014

try this...

DataSet ds = //call your data
        string sMyData= string.Empty;
        foreach(DataRow dr in ds.Tables[0].Rows)
        {
            sMyData =sMyData + "," + dr["ProcessID"].ToString();
        }

Anonymous User 12 Dec 2014

Yes you can

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

forum

Can we assign a particular dataset column value to a variable

Can you answer this question?

2 Answers