i am trying to transfer a textbox entry in my program, and place it into another textbox field on my WebBrowser. I am also going to need to press a button on the website as a part of the routine once the code has completed (the submit button). It will also have to select a specific item on dropdown box a a part of the routine.
View 4 RepliesI want to make it so I have a form and a button and a web browser. The web browser will automatically load to a website that has boxes to fill in. In google chrome when i right click on the text box i can find the element or whatever its called. I am just wondering how I can make it so when I press the button it will change the text of the textbox on the website to whatever I want. Also how to make it press a button on a web browser as well.
View 11 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI need to get the url of the web browser (check what website it is on) and then convert it to string so it can go in a textbox or wherever.
View 11 RepliesDim Page16 As String
Page16 = Application.StartupPath & "ResourcesHTMLPage16.htm"
WebBrowser16.Navigate(Page16)
[code].....
I need to fill some field on webpage in my webbrowser . This field has not got ID and I can not use
[Code]....
I have some data in my clipboard (or textbox) that I would like to put into a field on a webpage in the webbrowser control.
View 1 RepliesBasically I just want to set up exceptions for my program to prevent errors. The problem I am having is that sometimes the field name does not exist. For example, I am setting focus to the username text field named simply "username". However, if the entry does not exist (name=username) then I get an error. So what I need is a simple if statement to determine if it exist beforehand.
If Webbrowser1.Document.All("username").Exist Then
WebBrowser1.Document.All("username").Focus()
else
Messagebox.show("Field was not found!")
End If
In the past, I used the code below to fill out a form field using the webbrowser control in VB.Net. The page I am working with doesn't have name field for the inputbox, so my code doesn't work. How would I fill out the input box defined at the bottom of this post in bold?[code]...
View 1 Replieswebbrowser1.document.All.Item(f_id).InnerText = f_data
f_id (input field id) , f_data (set data)
it can work
but
f_data=webbrowser1.document.All.Item(f_id).InnerText
f_data cannot get anything?
I am writing a program which allows me to log in to my favorite forum, and displays me my fav. threads, and automatically refreshes current thread every 30 seconds or so.For this, I first need to login to the forum page. Fortunately, the forum allows to login during posting a new message, and it's a public forum so browsing threads is possible without login. Therefore I can directly jump to the "edit article" page without login, fill in login information and write the post, and then send it altogether. Here is an example link for that:
[URL]
Here comes my problem. I have searched for autofilling values and my code is like this:
Dim mydoc As HtmlDocument = sender.Document
Dim mynickname As HtmlElementCollection = mydoc.Forms("f").GetElementsByTagName("input").GetElementsByName("nickname")
Dim mypass As HtmlElementCollection = mydoc.Forms("f").GetElementsByTagName("input").GetElementsByName("pass")
If mypass.Count > 0 Then
[code]....
I guess it doesn't set the value attribute, at least during debugging the 'outerHTML' property stays like this:
"<INPUT class=form_input type=password value="" name=pass>"
The database field has text inside the field and I want to match it with another string...How do I convert a field to a string?
View 7 Replieshow can i make my webbrowser open up a new link in my same webbrowser or in another form? basically what im saying is i dont want it opening links in internet explorer.
View 3 Repliesi had the code belowing workin fine before but all of a suden i have a error init
[Code]...
I'm trying to get the list of field names for a given table, to turn them into a string which I can to post back as a variable to another function.I've Googled loads of stuff regarding GetSchemaTable but all I seem to be able to output are field parameters, but not the actual value of these parameters (ie ColumnName, which is the one I actually want!)
Found this page; What is the SQL command to return the field names of a table?But all the queries on there give me an error "You do not have access to Table 'Columns'"I feel sure this is pretty simple, can someone give me a little function that will simply give me fieldNames = "fieldName1, fieldName2, etc"I am using a MySQL server and ODBC connections ASP.NET using VB.
I had been using this way for while, and it seems it work fine with char and numbers.
Dim MyVar1 as String = "Hello"
Dim MyVar2 as Integer = 1
Dim MySQL = "Select * from table where field1 = '<field1>' and Field2 = <field2>"
MySQL = MySQL.Replace("<field1>",MyVar1).Replace("<field2>",MyVar2)
msgbox(MySQL)
But, when I have to deal with blob field, where I store "wav file" for example, I had to read it as array of bytes, and the only way I find to insert the array of bytes in my query string is by using the command.AddParameter
Dim myfile As System.IO.FileStream = System.IO.File.OpenRead("full_wav_file_path")
Dim myArray(myfile.Length) As Byte
myfile.Read(myArray, 0, (myfile.Length))
[Code] .....
Is there another way to insert it without addParameter?
In my VB project I am returning an SQL datetime field to a date variable mdtCreated = CType(oReader("dtCreated"), Date) In an example it returns mdtCreated as #5/13/2011 2:59:43 PM# which is correct. Later on I want to show this as a string to dd/mm/yyyy format. I have tried mdtCreated.ToString("dd/mm/yyyy hh:mm:ss") But that returns "13/59/2011 02:59:43". I want it to return "13/05/2011 14:59:43" How can I achieve this?
View 2 RepliesI am trying to format a string of arbitrary length into a fixed width field for display.
Let's use a width of 20 as an example, and call the string to be formatted s. I'm adding the formatted string to a StringBuilder named b.
Dim b As New System.Text.StringBuilder()
Dim s as New String
If the string I want to display is shorter than 20 characters, I can do this:
b.Append(s.PadRight(20))
or
b.AppendFormat("{0,-20}", s)
So far, so good. But, if the string is longer than 20 characters, I want the string to be truncated to 20 characters as it is appended. The code above appends the entire string.
I tried this:
b.Append(s.Substring(0,20).PadRight(20))
But, this fires an exception if the string was shorter than 20 characters.
So, I ended up with:
b.Append(s.PadRight(20).Substring(0,20))
This seems to do the job. The PadRight prevents the exception by making sure thet string has 20 characters before the Substring is performed.
I was wondering if there is an alternate method that would look more elegant and avoid padding the string just so prevent the substring from causing an exception. Have I missed a feature of String.Format that can accomplish this in one step?
Edited to add solution:
I ended up with the following code:
Module Extensions
<Extension()> _
Function AppendFixed(ByVal b As StringBuilder, ByVal s As String, ByVal width As Integer) As StringBuilder
[Code]....
This uses an extension method to clean up the syntax, as suggested by Joel and Merlyn, and uses the StringBulider Append overloads to avoid creating new strings that will have to be garbage collected, as suggested by supercat.
I'm a beginner developer using VB 2008 Express Edition and SQL Server 2008 Express. I have tried my simple problem using many different ways and also have searched the web, LINQ to SQL, SQL commands, MSDN library, MSDN Forums, 'How do I' help document, and ... but come up empty. In my simple Table.mdf (see below), I have created some tables (T1, T2, T3, ...) which none is joined together. What I try to do upon request is to get a value string of specific row and column of table?
[Code].....
VB.NET 2010/ASP.NET 4. I am using a web service which returns a string like this:
US,"UNITED STATES",MN,MINNESOTA,"MAPLE GROVE",45.1234,-93.4947,613,763,AMERICA/CHICAGO,NA,55311,"COMCAST CABLE","COMCAST CABLE",COMCAST.NET,"AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC",CABLE/DSL,RESIDENTIAL,3,99,35,96,,
If I split by comma it's usually fine except in the above string I have the following:
"AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC"
Which contains a comma and splits into two. This I don't want.
How to see if this field (array(15)) contains a comma & if it does to leave it intact into one array field? It's always constant in the same place in the array
Example:
(14) = COMCAST.NET
(15) = "AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS"
(16) = "INC"
(17) = CABLE/DSL
But I wish to keep it so it's:
(14) = COMCAST.NET
(15) = "AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC"
(16) = CABLE/DSL
is there way to update having quote string eg. drug's name ('s) in vb text field ' this corrector REFUSING TO UPDATE TO DATABASE. this kinds of error always comes up Incorect Syntax Near 'S'.Unclosed Quotation Mark After character string '))'.
View 3 RepliesI want to convert a database field that is text into a VBasic String...
View 3 RepliesI have a couple of textfields in a Windows form. One of these textfields is allowed to be NULL. When I enter a value for every field, it is all inserted, no problem. When I leave the field (txtGewicht) blank, I can't seem to be able to insert NULL in Access Database.
If Double.TryParse(txtGewicht.Text, 0) Then
klant.Gewicht = Double.Parse(txtGewicht.Text)
Else
[Code]....
This is what I get:
"Cannot set column 'Gewicht' to NULL, please use DBNull instead"
So I changed 'Nothing' to DBNull.value, but it then tells me that System.DBNull cannot be converted to type Double.
A string can contain from 0 to approximately 2 billion (2 ^ 31) Unicode characters. Does this mean the length field for the string is a 4 byte unsigned binary field, or is it a 4 byte signed binary ?
View 4 RepliesI have a multiline textbox from which I create a single string[code]...
What I'd like to do is write this to a DB as-is by adding wholeThing as a parameter using to SqlCommand.Parameters.AddWithValue, but all of my painstakingly-inserted newlines go away (or appear to).
I saw this and was hoping I didn't need to concern myself with CHAR(nnn) SQL stuff.
I'm pulling records from a db table (sybase) where I have run into a problem with a long varchar field. Using the OLEdb class I convert the field into a string variable which works fine in most cases, but there are problem with a few records. Examining the field in the database it shows that the value is not null, but the length of the field is 0.(SELECT field, length(field) FROM table). When I try to convert this into a string the result is rubbish.strContent = objReader.Item(i). I can't figure out what's the problem here, so I have avoided the issue by doing a table update before I start the process of getting data (I set the field value to null if field.length = 0
View 3 RepliesI have already connected my database and have completed multiple forms and reports.Just discovered that I missed adding ONE field in an Access table.Since it is attached how can I add a field to the database without disconnecting it? If I do disconnect it and reconnect will I have to redesign all my forms and reports?
View 1 RepliesI created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
How to check if string entered in a text box matches a field in a data table
I have a form with two text boxes for users to enter their Username and Password. When they enter their details and click the 'Login' button I want their details to be
checked against data in a data table to see if they match or not. I am using an 'if...else' statement but can't work out the syntax to use. My code is as follows[code]...Check when string entered in a text box matches field in data table?
How to check if string entered in a text box matches a field in a data table.I have a form with two text boxes for users to enter their Username and Password. When they enter their details and click the 'Login' button I want their details to be checked against data in a data table to see if they match or not. I am using an 'if...else' statement but can't work out the syntax to use. My code is as follows:[code]The fields I want to match the textbox strings against in my database table are called 'Username' and 'Password'.
View 2 Replies