I am trying to make a program to auto login to a website and answer a question.
<form class="dailiesAnswer-input dailiesForm" action="">
<textarea style="height: 44px;" class="dailiesAnswer-text-area">ANSWER HERE
[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 am trying to populate a listbox from access (and later SQL 2008) that will display all item names that are marked yes in another column. It is a validation for verifying whether or not it needs to be displayed. I am using the databinding method in the properties window and I am not sure how to do this without coding.
View 3 RepliesI am trying to populate a listbox from access (and later SQL 2008) that will display all item names that are marked yes in another column. It is a validation for verifying whether or not it needs to be displayed. I am using the databinding method in the
View 3 RepliesWould it be possible to make my program visit a website and basicly filling out a text field and using the submit button in a form?For example; I have a text field named "Field" in my webpage, and I want my Visual Basic 2008 application to visit that page, and automaticly fill out that field named "Field" with a string I gave my application, and next to click on the submit button.The purpose for this is because I want that the users of my application can post feedback on my webpage. I was looking for something like a MySql client but it's best if I would encrypt/hide the protected information such as table names or MySql passwords.And I believe that these users need to have specific MySql drivers installed to use it. So this idea sounds better. So, is there a way to navigate trough a website like this?
View 4 RepliesI'm using the following code to fill a DataGridView:
Dim conz As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:BdadosCV_PARTS.accdb;Persist Security Info=False")
Dim cmd As New OleDbCommand("SELECT * FROM PECAS_IN WHERE Data >= ?", conz)
Dim da As New OleDb.OleDbDataAdapter(cmd)
[code]....
The field 'Data' has the format "dd-Mmm-yy" on the Access database. The code allways fails with a type mismatch in the criteria expression.I already tried
cmd.Parameters.AddWithValue("P2", Me.DateTimePicker1.Text)
but the problem is the same.
I it's my first post on this forum. I need help with filling textbox in WebBrowser.
I wanted to fill textbox in webbrowser. I used for one teztbox and it worked.
WebBrowser1.Document.GetElementById("message").SetAttribute("value", TextBox1.Text)
WEB SOURCE: <input type="text" value="" size="50" tabindex="2" name="subject">In the case above everything was good but how to put the text from textbox3 between '>' and '<'?
<textarea id="message" rows="16" cols="70" tabindex="3" name="text">TEXT HERE
I am trying to submit a feed back form, but I am struggling to actually fill it!!!
Here's the
<form target="ajaxframe" method="post" action="misc_js.php">
<div class="class_postfeedback">
<textarea id="feedback_body" class="feedback_area" cols="25" name="feedback_body" style="overflow: hidden; height: 70px; color: rgb(136, 136, 136);">Write Something...
I am having difficulty trying to fill two different comboboxes (cbo) with data from a database. More accurately, the 1st cbo gets filled correctly, but when I attempt to do something similar with the second, I'm getting an error about not being able to use the & Operator in my SQL string (Operator is not defined for string and DataRowView types). So evidently the SelectValue from my combobox isn't acting the way I expect.
The overall goal of what I am attempting to do is to fill two cbo's, one with a list of contracts and a second as a list of parts given the selected contract from the first cbo. There are 3 tables in the database that I am drawing the data from: the "contract" table, the "parts" table, and a bridge table called "partList" that has foreign keys pointing to the two other tables. The first cbo is a basic query to the "contract" table using "ContractName" as the display member and "idContract" as the value member. The 2nd cbo I would like to display the name of the part from the "parts" table but use the id of the part from the "partsList" table, and to further filter this list based on what contract was selected.
I am writing the code in VB.Net from VS 2010, storing the data in a MySQL DB, and using a DBFactory to create all the components from ".GetFactory(MySql.Data.MySqlClient)"Below is the code that has the two places I am attempting to fill the two cbo's. Also if there is a better way to handle this, please let me know.
[Code]...
I finally got this code to work:
vb
Dim path As String = OpenFileDialog1.FileName
Dim myDataset As New DataSet()
Dim strConn = New OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0;Data Source=" & path & ";Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""")
Dim myData As New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myData.Fill(myDataset)
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
Now that I figured that out I was going to try and place the data in a specific location. On my application I have a datagridview set up with 4 columns. What I would like to do is put column A of the excel file under the 1st column of the datagridview and column C of the Excel File in the second column of the datagridview.
So replace:
vb
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
With:
vb
DataGridView1.columns(0) = myDataset.Tables(0).columns(0)
DataGridView1.columns(1) = myDataset.Tables(0).columns(2)
Obviously this doesnt work, and something tells me I might need a for loop to import the data, but I have never imported information from an Excel file before and to make it worse I have never worked with datagridviews before so I have no idea how to go about this.
I would like to do something like this if I could:
vb
For x = 1 To xldoc.rows.length - 1
DataGridView1.Item(0, x).Value = CType(xlDoc.Cells(0, x + 1), Excel.Range).Text
Next
I'm trying to fill a ComboBox with values from a column in a database...I'm trying to use code I found in jmcilhinney's CodeBank post at url. credits to him since it's basically 100% his code in my image below.I've tried 4 methods before this, and I've been receiving the same error, so it must be my fault... the image below shows the code and the problem.
View 1 RepliesI am making my first windows forms application in VS2010 and I am having trouble with arrays. I have code that dim's an array 'TabSiteInfo(2,20)' as a string. Then, I have a Loop that adds records to the array. The problem is that my array is not filling values from the loop. I know VS2010 handles arrays differently, but I have this same code working fine for me in VS2008 ASP.NET application. Below is a sample of the code.
[Code]...
Public Sub db_UpdateWorkHistory(ByVal WorkHistory_tablename As String, ByVal WorkHistory As DataSet)
Dim Conn As OleDbConnection
[code].....
Im trying to execute on the click of the submit button adding the text in textbox 1 to the field status within the mysql table. My code is:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
End Sub
Private Sub Submit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit.Click
[code]....
And the error I get is NotImplementedException was unhandled.
I have a field that I want to check to see if it has a value or not. But my code is not working. I am using:[code]
View 9 RepliesI have a class library that is referenced by several other class libraries along with the main program. About two weeks back, I made a change to one of the classes in that base library, which is used as an argument for some events. Since that time, I have been testing code. Today, after a couple more tests, I started getting this exception. It is indicating a field is missing, which was renamed in that change about two weeks ago. The exact code that is raising the exception is code that I have run a couple dozen times in the intervening time, and it has always worked.I have tried everything I can think of, including deleting the bin and obj folders of every module that could be in any way related to this issue, such that the whole thing was rebuilt. I have removed the references and re-added them. Nothing worked. Code that has run fine for weeks has decided that it wants a version of an object that has not existed for weeks.
This problem arose immediately after a different problem, so the two might well be related. The other problem was that, while stepping through code, the IDE decided that one of the code pages was different from when it was last loaded. I get that a fair amount, and solving it is fairly routine. It generally means that I am stepping through code in a dll, and inadvertently tried to fix a bug in that code, rather than in the dll itself. Now it no longer matters. I can't get to that code page, nor can I get to anything else in that dll. It is acting like it has sponaneously decided to revert two weeks back in time, and use that source code for debugging, despite any attempt I make to bring it up to modern times.
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 RepliesI'm quite a newbie when it comes to coding. I am creating a bot to automatically fill in a form for me.I've got everything but the birthday down. When I go to debug, I select my month, date, year, and click the start button. It'll load the webpage but it won't fill in the year section of the birthday. I looked over the code and it looks fine to me.
[Code]...
want to inset a field on vb form with texboxe besides it such that when i inset values a polygon is drawn.
View 2 Replieshow to make database field as datagridviewheader For example,I have table called subject, and have one column named subjectName. This column will hold all the subjectName, there are more than 100 subject names. E.G
subjectName: math,physics,chemistry,history
Let say a student take those subject, then how to display in datagridview something like this. (field in the subjectName appear to be datagridview header in datagridview)
I want the output something like this
studentName |math |physics | chemistry
| history| etc... |<-datagridview header
student a |
[code]....
i want to convert the user input field to MD5 Algorithm
View 2 RepliesOk so I have a 3 fields in a webBrowser that my bot will need to fill. 1st field is the City: 2nd is the Place Name: 3rd is the Street Address: Here is an example of my addresses:
~1Cafe~2 ~322 Queen st.~4 ~5Toronto~6 So for the city I will need to fill it with all the text in between ~5 and ~6. Right now this is what I have
[Code]...
I have a script that will enter values into a field, click submit and then it takes you to a page that shows a field containing text. How do I grab that text from that field?
View 8 RepliesWhat I want to do is to get information which has been stored on a webpage in a hidden field.
I have been able to put information on to a web page using the following
WebBrowser1.Document.GetElementById("email").InnerText = email
WebBrowser1.Document.GetElementById("college").InnerText = coll
WebBrowser1.Document.GetElementById("status").InnerText = status
[Code]....
I have tried various lines of code but non of them seem appropriate for what I want to do. The current line I have got is:
'hidfld is the hidden field on the webpage which I want the info from
findword = WebBrowser1.Document.GetElementById("hidfld").OuterText
Trying to get a textbox to write the contents to a field within mysql.
View 3 RepliesI have a simple query that fills a datatable from an Access DB. There are about 1.7 million records returned, so I would expect it to take a little time. At first, the query was a very simple one, and it took a couple seconds to fill the datatable. However, I really wanted the ability to restrict the rows by a certain date field, which meant a single INNER JOIN to a different table. Having written this, I verified that it was correct by copying the SQL string into the query builder in Access. The query, in Access, took a couple seconds to complete. That was comparable to the time I was seeing before I added in the join.
However, in VB, the query isn't completing at all. After 60 seconds, I get a message about a ContextSwitchDeadlock stating that it hadn't been able to transition or pump messages in a long time. Frankly, since the exact code works fine when I remove the JOIN, this seems like it is either a deadlock internal to the Jet engine, or the error message is an artifact of a very long running query. My question is why a query (albeit a large one) is hanging in the VB program when the exact SQL runs in a couple seconds in the Access query designer, and when I remove the JOIN, the query runs in a couple seconds in VB?
I have a question about event handling. Is it possible to detect field level data change in vb.net? i don't want my codes to be dependent on the the bound control's event to detect the change on the field value. I'm thinking there must be a better way (coming from a Delphi background). For example: a change on the Qty field will automatically trigger the event to compute the invoice detail Amount - (pseudo-case sample: Amount = Qty * UnitPrice).
In Delphi, every field is treated as an object with its own properties and events. So it's very easy to associate an event with it.
Example:
procedure TfrmInvoice.qryInvDetQtyChange(Sender: TField);
begin
inherited;
qryInvDetAmount.value := qryInvDetQty.AsInteger * qryInvDetUnitPrice.AsCurrency;
end;
How can I achieve the same using vb.net?
I have a field in my table called RentPaid, its set to bit data type. On my form I have a button called Pay Rent, when the user clicks that button I want my checkbox set to true.
I've tried both of these:
Me.chkRentPaid.Text = True
Me.chkRentPaid.Checked = True
Neither seem to be written to my SQLExpress database, however EVERY other field on my form does. The field shows up in my datasource for that form, I just dragged it over to my form with the rest of my fields.
I'm opening this discussion up primarily because I felt that it was inappropriate that Samir Ibrahim and I had hijacked another thread by turning it into a collaborative development thread. This thread will also hopefully serve as a searchable reference for those few who actually make an attempt to search the forum for information before posting a question. For reference the original thread I mentioned is [URL]
This thread is meant to be a repository for our continued collaboration on trying to find a way to update the attachment field using the OLEDB class. Samir believes that he is close to cracking the secret code.:)
Attachment retrieval and updating is a fairly trivial task using the Microsoft Access Database Engine. It is also fairly trival to retrieve the attached files using OLEDb as well. The difficulty comes when trying to add or delete an attachment with OLEDB.
The attachment field is actually a record set where each record consists of six fields. One of these fields is the data field that contains the binary file data. According to the documentation, Access will compress certain file. It appears that compression/decompression is handled behind the scenes so to say and what you are present with is sequence of bytes. The data field consists of sequence of header bytes followed by the actual data. The first four bytes define an offset to the start of the data. One thing that we are trying to determine is the meaning of other bytes in the header.
I have uploaded a sample project at: [URL]
This project is by no means a finished product. It is hard code to retrieve the first record from the included Access database.
I just started using VS 2010. This product is supposed to be so much better than VS 2008 yet I'm noticing a couple of glaring things that are failures if you ask me.
1. When designing a Gridview, after having clicked on Edit Columns, in VS 2008 I could select the first field listed on the left side of the window, set a property--say headStyle-- and set the Horizontal Align to Left. Then if I clicked on the next field, that same property would still be selected on the right side of the window. In VS 2010, I have to go through finding the property and then expanding it and selecting it for each individual field. While it seems like a small thing, it's time consuming and kind of a pain. Is there some reason they couldn't have made it behave the same as in VS 2008?
[Code]...