Back again... getting into the next issue. My question is regarding a simple way to pull the table in without headaches. Right now I open the website, navigate to the page and am ready to pull in the needed info. It's Paypal, I'm trying to automate getting new sales customer addresses/orders downloaded into a spreadsheet.
[Code]...
Anyway, i have a list of products in a product table. Primary key 'id', and 'Price' is a float(all variables defined at the top - cut main code out)
objConnect = New OleDbConnection
objConnect.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=|DataDirectory|Ecommerce.accdb;"
[code].....
I'll try to explain as best I can. I have a Datasource linked to an SQL table (called Products) containing the following fields
[Code]...
I have one table here with a list of UserIDs, Users, and ClientCodes. Each user can be assigned a client code to view that client's data elsewhere. Right now I have to change it for everyone via SQL Server and actually going into the table manually, but I'm trying to make a simple little program that will let the user change it themselves. All I need is a textbox that pulls the user based on a certain UserID from the table, and a drop down list that will not only show the current ClientCode they're set to, but allow me to change it and save that change to the table in the database.
What's the best way to go about this? I tried using the wizards but I guess that's not the best way to go about it. I have it displaying the correct user and their current ClientCode but that's about it.
I am trying to work with an access database. If this line pulls data from a dataset and puts it into a textbox: TextBox1.Text = Me.A_DataSet.a_Table.Rows(0).Item(0).ToString How would I pull the field name? For Example, in this database I have 3 fields:
[Code]...
I am trying to learn the new methods in .net, but, I cant see a way to step through the data like you can in an ado recordset. I want to pull data from a table once, then split the data with a filter, then step through the rows gathering the dtata till eof. Clear the filter and reset it for the next batch.
View 1 RepliesI need to be able to pull the data from a row to either store in variables or to place into a class to store the variables there. I've tried to do so with the following code but get an error about the row not existing
[Code]...
how can I pull data to DomainUpDown box from some data table
View 2 RepliesI am trying to call up different forms based on a basic login screen (thats fine) the part that is not working is that when I put in any information it should pull up one of 2 screens but neither will come up. Any help below is my code so far. (using professional 2010)[code]....
View 10 RepliesI have two comboboxes and a listBox to display data from several databases. The whole process should be that after an option is selected in the first comboBox, the second comboBox and the listBox are populated. So for example, I could select a Company from the first comboBox, and the second conboBox will be populated with all it's locations while the listBox will first display the location of the headquarters(default location). But the user can then select a different location from the second comboBox if they want to and the listBox will then display the location of that newly selected office location.how do I dynamically pull these data from various databases cause all the companies will have their information in separate DB's. My challenge is how to dynamically pull these data from the various DB's to populate these 3 controls.
View 3 RepliesI have a form that needs to pull a CSV file into a datagridview, which I have working OK with the code below.
VB
Private Sub FillDataGridviewWithCSV()
Dim strDirectory = Path.GetDirectoryName(ofdCSV.FileName)
Dim conString As String = String.Format(ProviderString, strDirectory)
' I extracted the provider string to a separate
' sub to make this post a little easier to read
[Code] .....
I have tried many different variations on converting what is in the DataGrid (or what is feeding it) into somthing I can push into the BulkCopy but have not got it to work right.
I need to be able to pull the current machine OU. I found some VB code that could do this,but I would like to just be able to do in the script with out having to call VB.[code]...
View 2 RepliesMy program pulls a weeks worth of records at a time and filters it into daily columns on a form, the problem is that there are ~80 fields to be filled in this manner and as far as i know each one has to be check for null before it can be filled. Could someone tell me if there is a faster way to do this? Below is my current code for one set of fields.
Private Sub cboDigit_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboDigit.SelectedIndexChanged, cboOffice.SelectedIndexChanged, dtEndDate.ValueChanged, dtStartDate.ValueChanged
[Code].....
I am developing a background wallpaper changer for Windows. I am looking into pulling images from RSS feeds. As how they are displayed from feed to feed changes, I am currently pulling the page as text and searching for text such as "<img src="... and others. Obviously this is not a viable option, how else could I complete this?
View 1 RepliesI'm trying to get my hands on my ThinkPad T500 tilt sensor data.So the (unfinished, but works (i'll get three values, state,x and y)) code is:
Public Class Form1
Private Structure AccelData
Dim stat As Integer
Dim x As Short
[code]....
With debug.print I'll get the correct information, but as soon as I try to insert the outcomes to label.text I'll get error:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
So, how can I pull the information from dll to label text?how to use the sensor.dll to extract information?
I'm trying to pull information from an XML webpage but for some reason it just isn't working. The XML webpage looks a little like
<?xml version="1.0" encoding="UTF-8"?>
<item>
<reqdat>Date and time</reqdate>
<result>Completed</result>
</item>
I want to get the node, but everything I've tried hasn't worked :( I think what I need to do might have something to do with SelectSingleNode but I'm not sure.
I need a method so that I can check for a certain selection of keywords(i.e. "The great cake") out of any website? Is there a method.
View 2 RepliesI have code which has been working awesomely but for some reason wil not take dates from this year. the date starts in a date picker datepick is a variable string log is the table, dater is the coloum
datepick = format(datetimepicker1.value, "dd/MM/yyyy")
dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbsource = "Data Source = C:datadatafile.mdb"
[Code]....
now the code has worked fine (and still does) for dates pre 2012. now and dates like 02/01/2012 it hates. the dates in the database are set to custom format of "dd/mm/yyyy" and i CAN NOT figure out why this is not pulling the data ..
I am a beginner at both vb.net and JAVA. I have self taught myself just about everything I know so far.I have a project where my boss wants me to create a macro using VB.Net to pull data from a webpage. The only problem that I have have is that this webpage is written in JAVA and is a owned by a third party. Does anyone have any advice, solutions, or references on how I can do this?
View 3 RepliesI have a database with two tables in it: People and Logs.I have created a Details page that displays Person information and additionally includes the associated logs records. All of this has just been done by adding a standard details page - not custom coding, etc.When a user clicks on the green + to add a row to the Logs for that person I want to autopopulate a few of the columns. To do this I've opened the Log class and added the following:
Private Sub Log_Created()
Me.Create_Date = Date.Now
End Sub
This works great. But I also want to pull in the card number associated with the person. In the end my code should look something like (pseudo):
Private Sub Log_Created()
Me.Create_Date = Date.Now
Me.CardNumber = SelectedPerson.CardNumber
End Sub
However, I'm not sure exactly how to accomplish this in code?
I'm trying to pull the username of every user available through active directory. Here is the code my colleague first tried to use, but this method is burning all of the memory out and throwing out of memory exceptions. Is there a quick alternative?
Dim userList As ArrayList = New ArrayList
Dim sPath As String = "LDAP://test.ca/OU=foo,OU=bar,OU=foobar,DC=test,DC=ca"
Dim myDirectory As New DirectoryEntry(sPath, Nothing, Nothing, AuthenticationTypes.Secure)
Dim mySearcher As New DirectorySearcher(myDirectory)
mySearcher.Filter = ("(objectClass=user)")
[code]....
I'm trying to figure how to pull the computers workgroup name using VB.NET.
View 6 RepliesI'm having a problem to pull data from MS Access to my combobox. I know how to search one data using another data (e.g: using IC num to search name) but this time I just want to pull the data (e.g: name) that has several rows to my combobox. I think the method is the same but don't know where to change it.
Then when I added new names to the combobox, want to save it to my database, can each name be saved in different rows? I added the names to the combobox 1st, after that then I saved it. [code]...
I was wondering if there was a way of pulling text from a website and the displaying it in a label, text box, etc.My idea isn't malicious in nature, I just want to be able to pull text from a specific page and then compare it with another page.
View 4 RepliesBasically, I have a quiz program for which It would be much simpler for me If i could pull the strings for the correct questions to display and answer to test if i could pull them from excel. For example,
vb If qststrng = (excel document cell A1) and answrstrng = (excel document cell B1) Then
'Correct End if
Or maybe there's something much simpler already integrated into Visual Studios 2010 in which i can copy and paste my excel data and then pull the data in a similar way all within Visual Studios?
I open a form from the datagridview on a selected record in the database. When saving I have my code saving to (0) I need to somehow pull the text form the account textbox in order to save to that row in the database. here is a copy of my save button...
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
'save updates to database
[Code]......
I've written a bunch of queries that bring back a set of results that look like the following. I have a user level column in an employees table which I'm trying to pull the value from. Only one result (number) will ever be returned. For instance the query will be like: Select username, userlevel from employees where username = "joe" So i'd be bringing back just the level, say 7.
[Code]...
I'm making a trail and i need to pull the time of a server.
View 6 Replies[Code]...
How do I just pull out the text i.e. (Wholesale) or Retail ? I am using this at present and it seems to work if there is brackets around but not if there is "-"
[Code]...
Visual Studio 2008. .NET 3.5 VB 2008 or VB9 as it is also called. I have an XML file that I need to parse efficiently. I had completed the project by means of pulling the document into an array and pulling the variables I needed via looping through the array. This turned out to be very inefficient as the file is quite large.
I am now looking into using XmlDocument or Linq to XML so that I can pull the variables that I need without looping. I read that Linq is the fastest so I was trying to go that route.
I have searched all over the place for examples of parsing xml documents and I can't find exactly what I need.
My XML file is formatted somewhat like this:
Code:
<Folder>
<set>
[CODE]............
The idea is that I need to get those <fp> values for certain f_types only. Not only that, but it also needs to <set> specific. You will notice that the second "<set>" has a <num> Value of 2 within the <data> tags.
So... I need to find a way to search for say all the <fp>'s in set one that are of f_type 5 only, exlcuding all of set 2's f_type 5. This XML is not ideal but re-formatting the XML is not an option for me. I have to work with what I got.
After hours of googling all I was able to do was pull all the Element values for each <F> child nodes if they included a f_type value of 5. But... It does it for the whole doc, not just the 1st set like I need.
I will post what I have so far: It is not much but I can't find great info on using Linq to xml that does what I am trying to do.
[Code]:.....................
This doesn't even need to be enclosed in an XML block but for some reason it wouldn't work unless I put it into XML block.