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

Anton Nijus

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

7 Replies

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

rajendra singh8y ago
[email protected]

But you were showing data in screenshot.
+1
Anton Nijus8y ago
DB is fresh, not yet stared anything there...
if u can provide ur mail id ?
+1
rajendra singh8y ago
Please share the db script as well.
+1
Anton Nijus8y ago
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.
+1
rajendra singh8y ago
Please share the code if possible.
+1
Anton Nijus8y ago
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.
+1
rajendra singh8y ago
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.
+1