How do i read the all the values with for loop / Linq

Question

Please refer the screenshot of my C#. I have taken my result in data object, i wanna save the final values into the database. Each has SubItems and if subitems has values inside i wanna loop and take the values untill sub items reaches no values

rajendra singh · Answer

singhrajendra747@gmail.com But you were showing data in screenshot.

Anton Nijus · Answer

DB is fresh, not yet stared anything there... if u can provide ur mail id ?

rajendra singh · Answer

Please share the db script as well.

Anton Nijus · Answer

public static void ParserListener() { SqlConnection conn = new SqlConnection("Data Source=172.16.1.12; Database = VehicleDispatch; User ID = sa; Password = abc123?"); string SelQuery = ""; SelQuery = " select ID,LogData from tbl_Listener_Data where IsParsed=0 "; SqlCommand cmd1 = new SqlCommand(SelQuery, conn); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(cmd1); sda.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { int Pid = Convert.ToInt32(dr["ID"]); var text = dr["LogData"].ToString(); try { var bytes = StringToBytes(text); object data; data = DecodeTcpData(bytes); foreach (var items in data) { foreach (var subitem in items.SubItems) { Console.WriteLine(subitem); } } Console.ReadKey(); //TreeView.Items.Clear(); //TreeView.Items.Add(data); } catch (Exception e) { Console.WriteLine(e); } } } Above code, i will be calling that funtion into y main function.

rajendra singh · Answer

Please share the code if possible.

Anton Nijus · Answer

Hi, Thanks for your valuable answer, I have conversion error and i cant use subitems from the data. Are u sure 2 for loop is enough to achieve this? Please find the attached screenshot. your help will be much appreciated.

rajendra singh · Answer

Hi Anton, You will have to use nested loop please check below. foreach(var item in data) { //Insert master record here and save master record id foreach(var subitem in data.subItems) { //Save record in child table with record id } } Hope this will help. Please accept this answer if you found this helpful.