|
Hi. I am an excellent VB programmer but a poor web programmer. I am trying to get some data off a grid on a web page into a vb app and I am having a terrible time doing it. The site also requires an id and password. The site is http://ctmls.mlxchange.com/ and I'm using VB 6 on Vista.
I don't care what form I get the data in but its not in the source when I view it or save the page. It looks like it is coming from javascript.
I think it changes pages in frames because the address never changes, but the display does. That's why I don't think I can use winsock. Inet doesn't work. I can browse to the page fine with the webBrowser control and see the data.
Here's how I get the data on the screen:
1. Type in URL; go to site
2. Login to site, frame changes
3. Click "Search" from menu, frame changes
4. Type in some criteria, click results
5. Frame loads with a grid with data on I need to get into VB
Here is what the screen looks like after the data is retrieved (with sensitive data blocked out). http://www.marvelousware.com/images/Form.jpg[^]
The Userid is not mine, I am using it to write this program for the owner.
What property(s) or method(s) will return data? Can it be in innerHTML or outerHTML? Or someplace else?
Can I find out what script is getting the data and run it?
What is a proxy? Can a proxy pass the data through? Can it be done in VB?
Otherwise I will have to write OCR code to pull the data off the screen. That doesn't seem like the smartest way, or easiest way.
any help is appreciated, I'll buy a book if anyone knows one that WILL solve this problem.
Thank you.
|
|
|
|
|
Looks as though the HTML is being served up by an ASP script into an iFrame (well at least from the homepage anyway). If this is the case then you will not be able to run the script. But if you look at the source of the iFrame (src attribute) and navigate to it you might be able to see the HTML when viewing source.
|
|
|
|
|
Thanks for the quick reply.
I looked at the source from the IFRAME ()[^]
I found nothing. I tried to navigate to it and didn't even see the logon text boxes. It seems to only work as an inline frame.
Does the data have to be in the HTML? And if not, where else can it come from?
|
|
|
|
|
Did you look at the iFrame source for the homepage or the datagrid page?
And yes, the datagrid in question will almost definately be presented using HTML (the other option is Flash but It doesn't look like Flash to me).
|
|
|
|
|
I looked at the IFRAME source on the homepage, this is what i found:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--
-- UserData.asp
--
-- This page acts as a host page to all the user data that will be used by the application
--
-- IMPORTANT: This page MUST reside in a static folder (e.g. outside 5.0.05.46) as user data
-- is only available in the same directory. If we move this file to a different directory,
-- previously saved user data would be lost.
--
-- IMPORTANT: The page using UserData must not contain a frame named "frameUserData"
--
-- Setup:
-- 1. Include UserData.js
-- <script language="javascript" src="/5.0.05.46/Include/UserData.js"></script>
-- 2. Create the iframe that contains this page. There are two ways of doing this.
-- a) Through javascript. Call CreateUserDataFrame() once before using
-- any other functions in UserData.js
--
-- or
--
-- b) Through html. Have the following html iframe:
-- <iframe src="/Tools/UserData.asp" id="frameUserData" style="display: none;" />
--
-- Usage:
--
--
-->
<HTML xmlns="http://www.w3.org/1999/xhtml" >
<HEAD>
<TITLE>User Data Utility - Host Page</TITLE>
</HEAD>
<BODY style="behavior: url('#default#userData');">
</BODY>
</HTML>
I don't know where it goes next. I tried running the following code when I get to the page:
Private Function PrintDomBegin(hDoc As HTMLDocument) As Long
Dim str As String
Dim str2 As String
Dim ElemColl As Object
'Dim ElemColl As HTMLElementCollection
If Not hDoc Is Nothing Then
frmDetail.List2.Clear
Set ElemColl = hDoc.getElementsByTagName("HTML")
str = PrintDom(ElemColl, str2, 0, 0)
frmDetail.Text1 = str
End If
'PrintDomBegin = ElemColl.Count
End Function
Private Function PrintDom(ByVal ElemColl As Object, ByRef ReturnStr As String, ByVal lngDepth As Long, lngIndex As Long) As String
Dim str As String
Dim strKey As String
Dim strElemName As String
Dim Elem As HTMLDTElement
For Each Elem In ElemColl
lngIndex = lngIndex + 1
strKey = "F: " & Trim(CStr(mlngFrameIndex)) & " - D: " & Trim(CStr(lngDepth)) & " #" & Trim(CStr(lngIndex))
mcol.Add Elem, strKey
'frmDetail.List1.AddItem strKey
strElemName = Elem.getAttribute("ID")
If strElemName = "" Then
strElemName = "" & Elem.getAttribute("name")
If strElemName = "" Then
strElemName = "<no name>"
End If
End If
'If strElemName = "txtLogin" Then Debug.Print Elem.outerHTML
str = Space(lngDepth * 4)
str = str & (strElemName & ": " & Elem.tagName & "(Level " & lngDepth & ")")
ReturnStr = ReturnStr & str & vbCrLf
frmDetail.List2.AddItem str
frmDetail.List2.ItemData(frmDetail.List2.NewIndex) = mlngFrameIndex * 1000000 + lngDepth * 1000 + lngIndex
frmDetail.lblItems = "Count = " & frmDetail.List2.ListCount
If (Elem.canHaveChildren) Then
PrintDom Elem.children, ReturnStr, lngDepth + 1, lngIndex
End If
str = ""
Next
PrintDom = ReturnStr
End Function
I can't get it to work with ElemColl decalred as HTMLElementCollection, but I don't think that it would make much difference. I then searched all the ElemColl objects' properties of .innerHTML, innerText, outerHTML & outerText and can't find anything that is in the grid. I don't know if tis helps, but the grid isn't completely populated when it first comes up, some data is there (that I can't find) but scroll down a little bit and it loads more rows.
Can data be on the screen and not accessable?
Does getElementsByTagName("HTML") return ALL the HTML?
Is there somewhere else I can look?
I don't know what I am missing and where.
|
|
|
|
|
Sorry, but without being able to see the source for the actualy page where the datagrid sits it's just to difficult for mw to help you. Maybe someone more experienced would be able to help?
You may better off posting on the Web Development board and asking how you can get to the HTML for the datagrid which you believe is in an iFrame. Once you have the HTML then ask here how to get the data out.
|
|
|
|
|
Thanks for the help. I'll repost it.
|
|
|
|
|
Hi There,
I have an Application of Laboratory Management.
In this i have created multiple pages to take the results of the tests that has been performed for the patient.
Supposidly, there are 2 Blood Tests out of 10 , 3 Urine Tests out of 8, 2 Stool Tests out of 10.
All these have different Pages and Different Tables to get store.
Now what i want is to print only the tests that have been performed having correct format of print.
I do not know how many Labels i have to use for the display and then print the same page. This will be decided at runtime.
If possible can you plz tell me how to Create a Scrolling Page in VB and Print the same.
Regards,
Kaushal Arora
|
|
|
|
|
Kaushal Arora wrote: Now what i want is to print only the tests that have been performed having correct format of print.
I do not know how many Labels i have to use for the display and then print the same page. This will be decided at runtime.
Why not just use a PDF document, fill in the fields propertly from your code, then display that on your form. The exact same document can be printed from your code or from another PDF reader without modification.
You'd need a 3rd party library to work with the PDF document, something like PDF.NET[^].
|
|
|
|
|
I have to Build a Dynamic Page. How can i do this?
|
|
|
|
|
What do you mean by saying 'dynamic page' a dynamicly created Windows Form or a page created using GDI+ or what else? Your question looks to me like a attempt to let others do your work.
Regards: Didi
|
|
|
|
|
hi,
:laugh:
i have develop new applictaion. ihave create new instance in sqlserver "systemname\instance". this instance not connected, but defalut instance is connected.  what is the problem.........
|
|
|
|
|
Without seeing your code and connection string, it's nearly impossible to tell you what the problem is.
|
|
|
|
|
Hi,
I had some problem with CR which I had posted earlier.
I needed to access a database in LAN environment...it works fine, accept some of the reports.
The solution I got is I need to give the connection information for the report.
I got the following code....
With crConnectionInfo
.ServerName = "YOUR SERVER NAME"
.DatabaseName = "YOUR DATABASE NAME"
.UserID = "YOUR DATABASE USERNAME"
.Password = "YOUR DATABASE PASSWORD"
End With
Now I just want to know what will be my server name, for access database?
Normally, what I used to do is::: I have the database in one server....and i access it through my connection string as follows
provider=......data source=\\MyServer\c:\aa\db1.mdb....;
So in this case...what will be the server name and database name?....Should I give server name as MyServer and database as c:\aa\db1.mdb?
Or should I give the full database path in DatabaseName like i used to do earlier(\\MyServer\c:\aa\db1.mdb).
Please help me out
-----------------------------
I am a beginner
|
|
|
|
|
Hi guys,
I'm supposed to develop a procedure to send SMS from a VB6 app. I have done a lot of research on this. Have information but I honestly dont know what is the major things to do in such an app.
I do not want to connect my phone to my PC, I really just want to send any cell number(regardless the network) to the procedure and have an sms sent 2 that number.
Please assist.
Thanks
|
|
|
|
|
|
Hi
I am looking for a way, to add another shortcut to Windows.
Ctrl-C does copy to clipboard
Ctrl-V does paste from the clipboard
I am looking to add another shortcut - e.g Ctrl-W - that will do the following:
1 - get the last entry from the clipboard
2 - add CRLF
3 - append to it the selected text
4 - copy it back to the clipboard
I am not a Windows developer. I only know VBA.
can someone help on this issue? I saw many posts on the web asking for COPY-APPEND to the clipboard but could not find any solution.
Actually I need it on IE only, But I saw that many are looking for this shortcut to be part of Windows.
Is it so complicated ?
many thanks for any help !!!
|
|
|
|
|
You can use Clipboard.Setdata while Pressing Key CTRL + W.
or Use Sendkeys({CTRL} + C ) while pressing CTRL + W key.
If you can think then I Can.
|
|
|
|
|
thanks for reply but I think I missed you.
Do I need to program it?
I would like to have this copy-append as part of windows. Not in my application.
link ctrl-c, ctr-v let us have ctrl-? to append what's selected to the last clipboard.
hope I am clear.
thanks again
|
|
|
|
|
In the key down event use the e argument to get the details of the key press combination
Then use your own suggestions
1 use the clipboard object to get the data into a var
2 clear the clipboard
3 add crlf to the var
4 add the selected text to the var
5 set the text into the clipboard object
6 informa the user it is ready for pasting.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Just wondering?
Are you still looking? The replies didn't quite enlighten me. I think one was talking about javascript, because of the usage of "var". Sure, you could do it with javascript, on a website... But what about OS-wide.
I don't know, does anyone have an answer, if not let's think about it!
|
|
|
|
|
I wrote a small program in vb.net that calls an external process.
I wanted to share this application between 40 users so I putted the content of the dir DEBUG (visual studio express 2008) into a shared folder and I used caspol to make it Trusted.
What I call in my app is an exe of a platform (PEBL) [http://pebl.sourceforge.net/battery.html] and I use it to execute some proprietary (PEBL) files.
What is STRANGE is this:
-if I share the same application on a shared dir and each client click on it executing the software I am not able to launch the external software for more than a single pc at time.
- IF I use a different publish for my vb.net application (that is, for K users, K different local(or remote) copies of my application, I am able to execute the same process contemporaneously
WHY THIS?
What I see is that if I use a single application shared on a common path [ for clear advantages of centralization] (example: just what you see in "debug" ] on a shared dir the process called does not allow for another client to execute the same external program. IS IT CORRECT? why should I use 40 different copies of my sw with 40 people?
IS IT CORRECT to share the same apps simply coping what includerd in debug?
|
|
|
|
|
HI Nico can you go through my code and see if you can help me on this
|
|
|
|
|
Hi
I've create a check box array, want to display a message box - moment the user clicks the 3rd check box
Private Sub step19() ' Action Item PGR
Dim conns1 As New ADODB.Connection
Dim rss1 As New ADODB.Recordset
Dim idexs1 As Integer
Dim sss1 As String
''On Error GoTo errorHandler
conns1.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & App.Path & "\EPMTDB.mdb;" & _
"Uid=;Pwd=;"
Set rss1 = New ADODB.Recordset
rss1.CursorType = adOpenKeyset
rss1.LockType = adLockPessimistic
rss1.Open "select * from StepSI", conns1
idexs1 = 0
For i = 0 To 2
Check(i).Visible = True
Next
For i = 0 To 2
Check(i).Caption = rss1!APGR
rss1.MoveNext
Next
' here I need the code, when the user click on 2nd check box gets the message box
For i = 3 To 9
Check(i).Visible = False
Next
rss1.Close
conns1.Close
End Sub
modified on Wednesday, May 27, 2009 8:09 PM
|
|
|
|
|
Where is this sub being called from? It would appear that it's just setting some values for your checkboxes, it's not handling the on click event of any checkbox.
You would need something like
private sub chkbox2_click (ByVal sender As Object, ByVal e As System.EventArgs) Handles chkbox2.Click
msgbox "you clicked checkbox 2"
end sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
