Particular Column Values Data in a row

C# Corner

Ramco Ramco

4y768.NET

I have below code & how i can get particular Column values in each row while looping. For e.g Student Mobile No etc

List objStudent = bALTraining.GetSelectedStudents(Convert.ToInt32(hdfTId.Value));

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishvjit Shinde4y ago

Accepted answer

var values = (from t in dt.AsEnumarable() // dt is your data table
             select t[ColumnName]).ToList().ForEach(your expression );


 or try normal way 

 foreach(DataRow drow in dt.Rows)
 {
      string value = drow[columnname].ToString();
 }

Vishal Joshi4y ago

Hello

You can try the below LINQ query to pass a particular column cell value to each rows cell

var objStudent = students.Where(t=> t.ID == Id && t.Name != null).Select(x => new Student 
            { 
                ID = x.ID,
                Name = x.Name,
                MobileNo = "XXXXX-XXXXX"
            });