Need to connect & retrieve from SQL DB in aspx page using vbscript server side. I have an html page which I want to edit by adding information from a SQL database & display results on and in the html page (code below). Initially thought of using server side javascript but unsuccessful, can this be done using vbscript?
View 1 Replies
I write this code to connect to sql database and to retrieve data but its not working
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
My system is connected Trhough LAN..
totally four systems connected. and all systems having MS SQl server installed in it.
now i need to retreive that - which all server's i can connect to..?
Subj.There is no knowledge that is not power.
View 3 RepliesI am real new in vb. I need to connect to ms server and retrieve information for database. Just simple ''select * from update, delete and so on.If I add new data source using data source configuration wizard - everything is fine, but I want to use just simple selects.I use
Dim connectionString As String = _
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BBD-2;Initial Catalog=wilopumpen1;Persist Security Info=True;User ID=*****;Password=****;"
Dim queryString As String = _
"SELECT * from dbo.tableName "
[Code]...
When I to connect to remote host to retrieve sql record...
it execute to few minute will get his error message... but there is already work perfectly and get connected... it loop it a few record only will occur this error...
"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."
I have mail server configuration data (server - user name - password - port) and i want to access it using vb.net and retrieve its mails in collection.i need to parse the email body to make some operations on it.
i tried to search for it but i found a complex samples.
I would like to ask a question with SchDocVW Internet explorer control.I added the reference "Microsoft Internet Controls" forum. [code]Could anyone give a known-good working example of how SHDocVW can be used to retrieve HTML contents reliably using VB?
View 4 RepliesIn VB.NET 2005, what is the best way to retrieve and parse HTML data from a URL, a bit like a search engine crawler?I am building an app, where I need to parse a website, and collate data from it (the website uses some tags that I could pull out to get the appropriate bits of data). I want to be able to do this in a thread, and just update a DB with the data, and give the client app a status update of the progress.
View 6 RepliesHow would I generate a list of html element names from a website/document that is being displayed in WebBrowser1?
View 1 RepliesHow can I retrieve info from a HTML table like this :
[Code]...
I'm using the following code to retrieve a URL and then parse the HTML from the page:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnStart.Click
Dim Temp As String, searchstr As String
[Code]....
I think my problem is that I don't exactly understand how I am supposed to start and end the parsing. I know that in my above code, the "meta" tag is the start and the chr(34), double quotes, is the ending.
When I modify my code, I have price line, which in th html ends with another character, the ">" sign. In the first code, the "content" tag doesn't end with another character, it just continues the line, which is easy and it works.
I've a HTML page and i need to pass some value to my aspx page.
Since the url got a maximum length 256, i need to use <param /> tag to help me pass values and also get values from aspx.
(the numbers of param is not fix)
I've been searching days for the example how to get this done.
Here is my problem: I need to store HTML in a MySQL database. Afterwards, I need to be able to retrieve the HTML and have it be valid HTML that a browser can render.
How can I store HTML in a MySQL database using .Net? How do I retrieve it afterwards? As this is the design phase, I can create the database any way that is needed.
I need to create a VB.net app that automatically reads a html table. It should connect to a web address (eg "[URL]") and read it. I'll be happy if I could just get the full HTML. I was able to use this code to get the HTML of a regular website:
Dim strReply As String = "NULL"
Dim objHttpRequest As HttpWebRequest
Dim objHttpResponse As HttpWebResponse
objHttpRequest = HttpWebRequest.Create("[URL]")
objHttpResponse = objHttpRequest.GetResponse
Dim objStrmReader As New StreamReader(objHttpResponse.GetResponseStream)
strReply = objStrmReader.ReadToEnd()
This code sample will give me the HTML for the website [URL]. However it will not work with the website I want (eg "[URL]"), because when you access it via regular browser it will popup a browser dialog asking for credentials (user / pass). So when I run the code above for it, I'll get the exception:
The remote server returned an error: (407) Proxy Authentication Required.
How do I set this up to use the credentials, before retrieving the HTML? This is actually my first web-related app.
How to retrieve the absolute coordinates of an HTML or CSS element from the webbrowser control using Visual Basic? I am using VB 2008 Express Edition. I would like to be able to display the control in my application and then using the HTML Document Object Model (I guess?!) get the X and Y coordinates (top, left, bottom, right) of a DIV or other HTML tag.
View 2 Replieswhy the code below fails to retrieve the html
Dim WebReqeust As WebClient = New WebClient
Dim URL as string = "http://www.professionalorganizervannuys.com"
Dim WebPage As String = WebReqeust.DownloadString(URL)
It fails on this particular URL.
I need to connect my VB app to html site and login in it...after that I need to view informations in labels may be it will be with ID or anything alse I do not know...[URL]I only need to log in from VB application form with out any webbrowsers and something alses...
P.s. I have my username and password on this site but I want do log in with my VB app...
What I would like to do is to find a way to get the results from a HTML/Javascript script in a string, using VB 2010.To make it clean on a practical case, I would like to get, in my VB application, the results provided by the run of the following external script:The resulting string should be something like this :
"document.write('<'+'style type='text/css'>#TCGPHiLoContainer {width: 300px;font-family: Arial;}#TCGPHiLoTable {width: 300px;margin-bottom: 3px;}.TCGPHiLoHeader {font-size: 8pt;text-align: center;}.TCGPHiLoHigh {background-color: #D9FCD1;color: Black;font-weight:
[code].....
I have used .NET and ShDocVw for years to grab data off webpages without any issues I couldn't overcome. This website has me beat though. It seems like such as easy task to grab the titles and other information off a library search page, but I can't see the data to be able to grab it. Usually, I just look in the DOM, but the data wasn't there. I did a view source, but the data wasn't there.
View 1 RepliesWhat i'm trying to do is retrieve 2-3 pieces of information from a parsed html file, then add the data into a listview in the corresponding columns i was initially going to do a function for each piece of information to retrieve but thought maybe i could do it all with 1 function instead.
[Code]...
I'm coding an ASP.NET page, with VB code behind. When the user clicks a button on the page, I send them an email with information and instructions. Rather than sending a plain text email, I send a nice, pretty, HTML-formatted one. Right now, I'm doing this in a way that I KNOW will be difficult to maintain. That is, I'm straight up writing out all of the html. [code]...
View 4 RepliesI was offered this interesting scenario by a visitor of my site and have been trying a few approaches, but not seeming to get it quite right. I have a Form with a WebBrowser control (or an AxWebBrowser if that works too) and on the page loaded in the browser, is a link that uses javascript to open a new popup window.This popup window I am unable to take "ownership" of and it launches in a new instance of the user's default browser (IE for this scenario). I need to then interact with that javascript popup window which now is not part of my application. If I needed to set a value of an input box on that form, how would I accomplish that if I can't "interact" with the form?
View 1 RepliesWhat I would like to do is to find a way to get the results from a HTML/Javascript script in a string, using VB 2010.To make it clean on a practical case, I would like to get, in my VB application, the results provided by the run of the following external script:
<script src="http://partner.tcgplayer.com/syn/synhighlow.ashx?pk=MAGCINFO&pi=fnmp-124"></script>
The resulting string should be something like this :
[code].....
This may sound really stupid but I have to ask cause I'm not finding this answer anywhere.I have an application where the user will need to sign up for a new user account on the website [URL]..However when I am using Firefox's plug-in Firebug to view html I am getting something totally different than when I just right click on the site and view the page source.
What I am trying to do is to get the captcha from the website and display it in a picturebox on the application so the user can view the captcha, solve the captcha and then the app post is back to the service for a response.
Here is the source that I am getting using Firefox's Firebug to inspect the element:
<td>
<input type="hidden" value="Oo3Jo1I8bgzK68agMqo3s79ZZib2OkbK" name="iden">
<img class="capimage" src="/captcha/Oo3Jo1I8bgzK68agMqo3s79ZZib2OkbK.png" alt="i wonder if these things even work">
</td>
[Code]...
Why would the two be showing me two different versions of the HTML?
And how would you be able to grab that source to view in a picturebox using webclient?
Usage: Users create pretty HTML news letters in another app. They post the newsletter to the web, but they also want to set the contents of the HTML news letter file as the body of an email and send it using Application In Question. The users understand to use absolute link and image references when sending an E Newsletter. Environment:
AIQ is a VB.Net app deployed via ClickOnce. It is an intranet app; one can be sure MS Office 2003 and the interop 11 dlls are on the target machines.
Restrictions: MAPI is out. It mangles the HTML. Since it is a ClickOnce deployment, we can't register dlls (I think, correct me if I am wrong). Therefore CDO and COM is out (again, I may be wrong.... I would be happy to be proven so).
I have a code that retrieves all the "place names" and all the "addresses" separately in this link:[URL]
I need to modify my code so that it will only retrieve the "placename" and "address"
CODE:
Some screenshots, view them for better understanding:
[URL]
[URL]
We have a VB.Net application which works fine in our tests in different Windows XP SP3 machines. However there is one machine in which is displaying this error:
Unable to connect to any of the specified MySQL hosts
Using the mysql command, we can successfully connect to the database. We already checked for any other application or firewall that could be blocking the connection but it seems fine. We also reinstalled the system (no errors during the installation) but the MySQL error message doesn't change.
The system settings are exactly the same as in the other computers. We are using "localhost" as server in the connection string. The "hosts" file has its default values (nothing strange in there).
I'm working on an application where I'm using an webcam image. I have code that works when using the built in iSight (It's an Apple running boot camp windows 7) camera. However after installing a second USB powered Microsoft Life Cam I am unable to connect to this second camera. When runnign this code I only ever get one input device:
Private Sub LoadDeviceList()
Dim strName As String = Space(100)
Dim strVer As String = Space(100)
[Code].....
I am trying to connect to my remote MySql Database within Visual Studio using the compact framework.
I can successfully add a data source and preview the data within the IDE so assume that the connection is ok regarding Connection strings and remote access.
However, when I attempt to access the data using any run time control I get the following error when the table is loaded using the .fill method.
MySql.Data.MySqlClient.MySqlException was unhandled
ErrorCode=-2147467259
Message="Unable to connect to any of the specified MySQL hosts."
[Code]....
