How to insert data into sql server database from the foreach loop elements using C#.NET?

Question

0.00/5 (No votes)

See more:

I have fetched the elements from the web page in a web browser control. I am using foreach and nested loops loop to match each element. Now I want to save each value into database one by one according to records on page. But every time it is saving only last record data multiple times. Please help out.

My code is:

C#

  dynamic div_classes = webBrowser1.Document.Body.GetElementsByTagName("div");
 foreach (HtmlElement d in div_classes)
            {
            dynamic d1 = webBrowser1.Document.Body.GetElementsByTagName("td");
             foreach (HtmlElement td in d1)
                {
                    if (td.GetAttribute("className") == "personName")
                    {
                        personName = td.InnerText;
                        //txtName.Text = personName;
                    }
                }
                 if (d.GetAttribute("id") == "title")
                {
                    persontitle = d.InnerText;
                 
                }
               // multiple values
            }
}

Where should I call my function "Save_to_DB()" to insert all values to database in a loop?

Thanks in advance.

Posted 24-Jun-14 23:39pm

Member 10872859

Updated 25-Jun-14 0:03am

King Fisher

v3

Add a Solution

Comments

Tanuj Rastogi 25-Jun-14 6:06am

Currently, from where you are calling "Save_to_DB()" method? Do you want to save values at 'div' level or 'td' level ?

Bernhard Hiller 25-Jun-14 6:09am

And more important: how does your "save-to-db-method" look like?

Vedat Ozan Oner 25-Jun-14 6:45am

collect all data in a list. then send this list to your save method. if your list is too big to hold in the memory, then you can process a record as soon as you fetch it from the html page. many many options.

[no name] 25-Jun-14 7:12am

Put your function call inside the loop where you want to call it.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2014-06-25T01:11:00

Solution 1

This should be obvious but you'll need to save to the database inside your foreach loop so that each record gets saved to the database.

Posted 25-Jun-14 1:11am

ZurdoDev

_Asif_ · Answer 2 · 2014-06-25T01:26:00

To be precise you should do following

dynamic div_classes = webBrowser1.Document.Body.GetElementsByTagName("div");
 foreach (HtmlElement d in div_classes)
            {
            dynamic d1 = webBrowser1.Document.Body.GetElementsByTagName("td");
             foreach (HtmlElement td in d1)
                {
                    if (td.GetAttribute("className") == "personName")
                    {
                        personName = td.InnerText;
                        //txtName.Text = personName;
                    }
                }
                 if (d.GetAttribute("id") == "title")
                {
                    persontitle = d.InnerText;
                 
                }
               Save_to_DB();
            }
}

Member 10872859 · Answer 3 · 2014-06-25T19:08:00

Solution 3

Thanks for your answers.

I have already place the function to insert elements to the database at the same place but I am stuck at a very strange thing.

Every time it is inserting the data of last record of the page instead of showing each record.
Multiple data but of last record in repitition.

Posted 25-Jun-14 19:08pm

Member 10872859

Updated 25-Jun-14 19:09pm

v2

Comments

_Asif_ 26-Jun-14 1:20am

solutions are not meant for comments, please either improve your question or add comments.