7 Replies - 470 Views - Last Post: 07 January 2020 - 02:02 PM Rate Topic: -----

#1 bpece   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 05-February 17

How to read datagrid cell on web

Posted 06 January 2020 - 11:25 PM

I am trying to read first cell of datagrid on web and write to the listbox. I made it run some of the scripts that I found from the different sources ( youtube or forums) on internet but it didnt work.

I m not a coder so I dont have any knowledge about software development .Can anyone tell me that what should be the right codes ?

Here is my codes and screencaps of gridview. Once I run the codes the value return as "System.Windows.Forms.HtmlElement"

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
    Dim ListItemOne As HtmlElement = Me.WebBrowser1.document.GetElementById("ctl00_MainContent_MainGridView").GetElementsByTagName("td")(1)
    ListBox1.Items.Add(ListItemOne)
End Sub


Posted Image

Posted Image

Is This A Good Question/Topic? 0
  • +

Replies To: How to read datagrid cell on web

#2 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15477
  • View blog
  • Posts: 62,007
  • Joined: 12-June 08

Re: How to read datagrid cell on web

Posted 07 January 2020 - 08:13 AM

Out of curiosity, which website?
Was This Post Helpful? 0
  • +
  • -

#3 bpece   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 05-February 17

Re: How to read datagrid cell on web

Posted 07 January 2020 - 11:47 AM

View Postmodi123_1, on 07 January 2020 - 03:13 PM, said:

Out of curiosity, which website?

This is not actually website . That link is interface of warehouse management system database..
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15477
  • View blog
  • Posts: 62,007
  • Joined: 12-June 08

Re: How to read datagrid cell on web

Posted 07 January 2020 - 12:01 PM

Mkay.. so why wouldn't you be pulling the data from the database?

I apologize, I didn't take into account the 'no programming experience'.

Being this is your database for your warehouse you would request a _connection string_ from the powers that be, and your vb.net app then queries the DB directly. It is more direct, more accurate, the right way to do it, and doesn't have the hassle of web scraping your own site.

This post has been edited by modi123_1: 07 January 2020 - 12:08 PM

Was This Post Helpful? 0
  • +
  • -

#5 bpece   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 05-February 17

Re: How to read datagrid cell on web

Posted 07 January 2020 - 01:30 PM

View Postmodi123_1, on 07 January 2020 - 07:01 PM, said:

Mkay.. so why wouldn't you be pulling the data from the database?

I apologize, I didn't take into account the 'no programming experience'.

Being this is your database for your warehouse you would request a _connection string_ from the powers that be, and your vb.net app then queries the DB directly. It is more direct, more accurate, the right way to do it, and doesn't have the hassle of web scraping your own site.


Firstly thank you for interested with topic.Second thing is the database of system not reachable by user. You can only read the values with interface.

Do you have any opinion about my code ?
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15477
  • View blog
  • Posts: 62,007
  • Joined: 12-June 08

Re: How to read datagrid cell on web

Posted 07 January 2020 - 01:42 PM

What do you mean it "the database of system not reachable by user"? You said the website was for your warehouse database. Have you actually tried to send the information up the chain of helpdesk?
Was This Post Helpful? 0
  • +
  • -

#7 bpece   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 05-February 17

Re: How to read datagrid cell on web

Posted 07 January 2020 - 01:59 PM

View Postmodi123_1, on 07 January 2020 - 08:42 PM, said:

What do you mean it "the database of system not reachable by user"? You said the website was for your warehouse database. Have you actually tried to send the information up the chain of helpdesk?


I meant that WMS (warehouse management system) system is constructed by 3rd partner company. İn fact WMS is high level software of conveyor system in warehouse.The 3rd partner delimitated the database to reaching it.
Was This Post Helpful? 0
  • +
  • -

#8 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15477
  • View blog
  • Posts: 62,007
  • Joined: 12-June 08

Re: How to read datagrid cell on web

Posted 07 January 2020 - 02:02 PM

Mkay.. so you do not have the DB on premise then? Have you pinged this mysterious company for an API or found a SDK on their developer specific portal?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1