DB/Reporting :: VB 2008 Log Data From PLC
Aug 21, 2008
I have vb 2008 and I have RSLinx classic, and a Allen Bradley PLC. I knwo there is a way to have vb call through linx to the PLC, I just don't know how. There are about 90 different tags in the PLC I would like to have logged into a csv/excel file. My thought on doing this was to have a very simple vb program to just collect that data and every day at midnight have it save it to a excel file. My problem comes when I try to talk to linx, I have no idea how to get them to communicate. I am just looking for some ideas on how to get that to work. I have tried link...whatever, and it seems that was for vb 6.
View 1 Replies
ADVERTISEMENT
Jun 3, 2012
i am using webbrowser control as reporting tool ( instead of exporting the data to excel or other COM interface )i have built some HTML table structure and rows headings etc.
View 3 Replies
Sep 28, 2009
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
View 1 Replies
Sep 27, 2009
I recently switched to V.Studio 2008 and using VB. I can not find in the data toolbox the connection and data adapters. Should I do something else to make this appear so I can drag them in my form.
View 2 Replies
Feb 8, 2009
I am currently using vb 2008 and access 2003 as back end database. I am trying to import excel data to a data table. my excel and access table header & columns are same. I was trying to do this.........
[Code]...
View 1 Replies
Sep 29, 2008
I tried this code to check if the data in textbox1 not equal to any data in column name, so insert the data that in the textboxes to the table1. Esle.. do another thing. But it didn't success with me.
Code:
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "DataBaseName.mdb "
[Code].....
View 2 Replies
Nov 14, 2011
I'm developing a VB.Net and SQL Server 2005 Express application.Q: How to encrypt string values in the database to secure them from the one using my software and from DBAs (people who have access to the DB Server)? Here is what I tried:First, I used a Symmetric Encryption provided by the .Net Framework. But I noticed that I could not make partial searches (LIKE keyword). So, this is not working.
Then, I used a logic similar to the ROT13 to hide text. Although this logic works fine from VB.Net, once data has been stored in the database, the logic fails to decrypt data correctly. After some tries, I thought that the reason the logic failed was the Collation of the database (I do not know much about Collation topic).So, the first way doesn't allow partial searches, and the second way is not secure and also does not work because of the Collation or maybe another reason.I want to encrypt data. I've successfully hidden the schema by giving meaningless names to tables and columns.
View 5 Replies
Nov 26, 2009
I'm trying to bind data to a combo box but it does not appear to be working. I've setup the DataSet and the DataSetBindingSource and all this appears to be working, within the form design I can expand the little arrow in the ComboBox control and preview the data. This appears to be working but when the application is run, nothing appears in the drop down box.
I have the following code in place:
Code:
cmbSelectCompany.DataSource = ContactsDBDataSet.Company()
cmbSelectCompany.DisplayMember = "CompanyName"
cmbSelectCompany.ValueMember = "CompanyName"
[Code]....
View 1 Replies
Dec 6, 2008
How to get the total sum of my fields that are not duplicated? The highlighted are examples of my duplicated fields (both lec and lab) but they don't have the same time.
View 1 Replies
Jul 10, 2009
I built a database from an .sql script file in Microsoft SQL Server 2008 Express Management Studio.Now, I need to connect an application I'm developing to this database. So in Visual Basic 2008 Express (that's what I use) I go to:
Data-->Add New Data Source-->Database-->New Connection
In the dialog which pops up (name: Add Connection) I set:
Data Source = Microsoft SQL Server Database File
[code]....
View 2 Replies
Oct 30, 2008
This error has me completely baffled. There is no indication (that I ca FinD as to what field won't handle the information. Heres the situation:I am using an Accees query to insert a new record in a table with 49 fields. Of these fields, 1 is an integer, 7 are booleans and the other 41 are text fields. The text fields represent either Time of Day or a Timespan.
My field sizes are:
For time of day 8 digits(example 08:00 AM)
For a time span 5 digits(example 03:30) I will never exceed 2 digits for
hours
I have checked every field in the dtatbase and they are all as noted. I am at a loss as to how to proceed.
View 4 Replies
Nov 6, 2009
I will try and explain my problem as simply as I can
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
CODE:
What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.
I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.
Below is the code for doing this in the same datasource:
Code:
I am using VB.Net 2005, just for info
View 2 Replies
Feb 18, 2011
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID
1 5
2 8
3 5
[code]....
View 2 Replies
Oct 11, 2010
need to get the data from Cell(2) on my gridview but cant figure it out. id like to put it in a varible im using VB 2010 express ed. what im aiming for is to show a popup box showing of my note and to show the date. by compairing in a loop of all entries if the date is falls on the date that was picked on the entry.
View 1 Replies
Aug 17, 2009
I am trying to build a boggle solver, and this is the way I want to do it.I have a list of 52000 words.I want to Put them into a list as follows.A b c d e f g h i j k l m n o ..... z..Then for each letter, If possible, put each letter.Eg. under m a e i o u y or for q [code]i will look at "a" and then "av" and "ae" and "at" and check if further down the line there is a possibility. If not then I will abandon that line.How will I be able to build this tree database?
View 14 Replies
Dec 29, 2008
How to direct put (without someone key in) the data into the database with VB? The data will automatically generated by the program..
View 5 Replies
Jul 30, 2009
How to i insert Variable @ClassID(If Identity Propeties) @LecturerID , @StudentID and a Date from Calendar Control into the Date Collumn , into a Database Called Fingerprint, TableName= Attendance.
The Collumn Are ClassID, LecturerID, StudentID, Date.
View 5 Replies
Feb 17, 2008
I am working on what appears to be a very simple application but have a problem that I can't seem to get around. Using Visual Basic 2008 and an Access database. My application starts with only 3 text boxes and using the Data Wizard it works fine. I want to expand it to give the user a way to select an individual record to review so I dragged a ListBox on to the form onto the form, filled the DataSource and DataMember properties and When I run the program I click on one of the items in the List Box and the proper record fills the Text Boxes.
[Code]...
View 2 Replies
Dec 24, 2008
I have an Access database with a table called Events.I created a new VB.net 2008 project and created a MicrosoftReportViewer control. I also added a "Report" component (which created a .rdlc file).I am easily able to drag things from my Access database I added to the data sources onto the report. However, one part of the report I would like to add data to a Matrix that I calculated with VB (ie it is not in the database). The database has a list of names and a bunch of times associated with each name. and then I calculate some fancy stuff based on those times. I would like the matrix to be a list of names (from the database) on the rows, a list of dates (which I specify in the code) on the columns, and the data of the matrix I also calculate.
View 3 Replies
Apr 4, 2011
I have created a database in VB2008.NET using SQL 2008.
My problem is that while I am in the form where I see the the data, I want to retrieve backwards the related data from Owner and Car eg. the owners name and the car model.
Is there any way to do this in a single row?
View 1 Replies
Mar 4, 2010
I would like to return the data in a database query as an array, but the problem is, Im having trouble working out how to do it, here is how I would like the data to be returned:
array (
---> 1
---> ---> 1
---> ---> ---> fieldname
[code]....
I could create a multi dimentional array, but the results could range from 2 rows, to 2000 rows, I looked into redim, but you can only redim the last dimention, I would need to the first and second, but not the last.
View 2 Replies
May 11, 2008
I want to take a drop down menu. It will contain LastName, FirstName. I want that to select a record from a table. First Name and LastName are two different columns
View 5 Replies
Feb 25, 2008
Ive got a web page so that the users select a day from the calendar and the date is input to a text box, the format is dd/mm/yyyy, it is the same format in the database table.
I want to select the data from the database when it is = the date in the text box but it is retrieving data in mm/dd/yyyy format. My sql is:
SELECT Booking.Date, Booking.RoomNo, Booking.Lesson, [NoComps] - " & students & " AS diff FROM Rooms INNER JOIN Booking ON Rooms.RoomNo = Booking.RoomNo WHERE booking.Date= #" & txtdate.Text & "# AND booking.Lesson = '" & lessonlist.SelectedValue & "' AND booking.Type IS NULL
how can i make sure it retrieves the data using the correct date format?
View 1 Replies
Mar 12, 2009
I'm writing an application to mimic a cash machine, I have a Form1 on which the user enters their PIN and chooses their card no. from a drop down box.The accountID is passed to Form2 and I know this is successfully seen by displaying it in a simple message box.A data adapter and dataset are used for this to the cards table.However, what I then require is within Form2 to retrieve the balance from that accountID in table Accounts, another data adapter and dataset have been created for this under Form2.I'm trying to get the balance into another variable, and I have written this as follows: [code]I would expect the result of this to be e.g. 100.00 but instead I am getting a response of "There is no row at position 0".
View 1 Replies
May 27, 2009
I have been having trouble finding a good way to do this. Basically what I need to do is take a query from a SQL Server Database and place it into a DataTable (or an array) for manipulation. I've got the connection and everything working, but none of the methods I've tried so far seem to work very well.I need it to compare data with an uploaded CSV file and post on a website.
View 1 Replies
Jan 22, 2011
What SQL Server data type should be used to store RichTextBox text? The reason I ask is because the BOL indicates not to use text or ntext anymore because these data types will be excluded from future versions of SQL Server.
View 4 Replies
Sep 3, 2008
When trying to create a new data source to a sql database (database up and running with no problems) I get the following error message when testing the database connection
Quote:
Unable to open the physical file "". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
View 1 Replies
Jun 2, 2009
I'm working on a program in which users will fill out a form, and the information from the form will
be stored in a database. My problem is that I have been unable to insert the data from the form into
my table.
The variables are declared as follows:[code...]
View 1 Replies
Aug 18, 2009
I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:
Code:
Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OpenFileDialog1.FileName = ""
OpenFileDialog1.Title = "C# Corner Open File Dialog"
[code]....
View 4 Replies
Jun 10, 2009
say you have a database that you want to store 100 different recipes in. Out of that 100 recipes 20 have 5 ingredients, 30 have 7 ingredients, 30 have 4 ingredients and 20 have 6 ingredients. So what's the best practice for storing an unknown number of items in a database?
Currently what I am doing in these situations is storing them in a single field in a database separated by a comma. Then when I have to retrieve them I split them by the comma into an array. This doesn't seem right to me but I haven't noticed an impact on speed or efficiency, so what would be the best practice to handle this situation?
View 2 Replies
