How to add Dataset Rows stored into class variable through L

Mursaleen Hassan

How to Dataset Rows stored into scoop_Info class variables because i have a Crystal Report and i wants CR parameter get scoop_Info class variables data. Thanks

scoop_Token_Report crystal_Report = new scoop_Token_Report();
List _List = new List();
string query = "SELECT `name`, `quantity` FROM `tbl_scoop_customer` WHERE `odr_id` = 5";
DataSet ds = method_Class.method_Class.dataSet_Record(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
_List.Add(new scoop_Info
{
Quantity = Convert.ToInt16(dr["quantity"].ToString()),
Description = dr["name"].ToString(),
});
}

class scoop_Info
{
public int Quantity { get; set; }
public string Description { get; set; }
}

2 Replies

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

Sreekanth Reddy7y ago
Accepted answer
Hi Mursaleen,

scoop_Token_Report crystal_Report = new scoop_Token_Report();
List _List = new List;
string query = "SELECT `name`, `quantity` FROM `tbl_scoop_customer` WHERE `odr_id` = 5";
DataSet ds = method_Class.method_Class.dataSet_Record(query);
sccop_Info obj = new sccop_Info();
foreach (DataRow dr in ds.Tables[0].Rows)
{

obj.Quantity = Convert.ToInt16(dr["quantity"].ToString()),
obj.Description = dr["name"].ToString(),

_lst.Add(obj);

}
Now we can access data from "_lst";
foreach(var a in _list)
{
// a.quantity
// a.Description
}

Mark as answer, If it helps.
Thnk you.
Jenith Thakkar7y ago
Please check below logic to insert from dataset to list using one line

var scoop_InfoList = ds.Tables[0].AsEnumerable().Select(dataRow => new scoop_Info{Quantity = dataRow.Field("quantity"),Description = dataRow.Field("name")}).ToList();