Access SAP R/3 Data Directly From .NET?
Sep 21, 2010
We have an assignment to create some XML outputs from data in SAP R/3. We are using SAP .NET Connector, for doing this. The problem we are facing is that there are some fields which are not exposed by any standard BAPI. Unfortunately we cannot create customized BAPI on this particular system.
We are therefore restricted to whatever standard BAPI are available. I have seen on internet that tools like ERPConnect can provide access to tables directly using RFC. How can this be performed in VB, without purchasing any such tool, using or without using .NET Connector.
View 1 Replies
ADVERTISEMENT
Jul 26, 2010
I recall being told by a professor the following is bad practice. But it makes stepping through code a lot less tedious. I'm just solicting comments on pros and cons:
Friend Class MyClass
Private isEmpty As Boolean
Public Property IsEmpty() As Boolean
[code]....
View 3 Replies
Apr 13, 2012
how to build it and how to manipulate it?can i use the data of an access file table as a matrix directly?
View 8 Replies
Jan 29, 2011
How do I access a file located directly in my bin folder via a relative file path?
View 2 Replies
Mar 6, 2012
If I have an application that load some assembly at runtime. Is it possible to access the events and the methods of these assemblies direcly, without always using Reflection
View 15 Replies
Jun 10, 2012
Using OpenFiledialog I can access a file. Is there a way that I can include a specific file in the code? This would allow me to access the file directly without the selection process and the application would always use that same file.
View 14 Replies
Jun 15, 2011
I am converting old VB6 code to VB.NET with ADO.NET (OleDB). This is my query that will create a blank table when ran in VB.NET, but then works when ran directly in Access. This code presumably also works in VB6, as I am using the same SQL:
SELECT qryAsOf.name, qryAsOf.type, 0 as opt, 0 as swap
INTO qryCon
FROM qryAsOf
LEFT JOIN qryLinked on qryAsOf.c = qryLinked.lc
I feel like this has something to do with the left join and select into being together, but like I said it is only VB that has an issue with it, Access handles it perfectly.Without the INTO line, this query returns all 600+ rows.
This DOES NOT WORK:
cm.CommandText = "CREATE TABLE qryCon (etc...)"
cm.ExecuteNonQuery()
cm.CommandText = "INSERT INTO qryCon SELECT ..." '(rest of query above without INTO line)
cm.ExecuteNonQuery
This DOES WORK:
cm.CommandText = "CREATE PROC qryCon AS SELECT ..." '(same select as above without INTO, again)
cm.ExecuteNonQuery
The CREATE PROC that does work is fine, except I need to insert data into it later, so I get errors about how I need an updatable table. I really want the end qryCon to be a table, but I can't seem to get that to work :(
*However, when I do something like this (using the stored proc (renamed) above which, if viewed in Access, is full of data)
cm.CommandText = "SELECT * FROM storedProc"
dr = cm.ExecuteReader
[code]....
This DOES NOT WORK! By the way, I removed the concatenation in the query for readability. It is correct in the actual project.
View 3 Replies
May 6, 2010
I would like to be able to read a column of numbers from an Access database into a VB.NET program and then manipulate that data.For example I have a column of numbers and want to add them up and then take the averageThe maths is not a problem but how do I read the column of data into the program. I know how to do this if I first export the Access data into a CSV file, but
View 11 Replies
Nov 24, 2011
I am trying to 1) write code in VB2010 that will get a JPG image from a Access Database field and write the image to a PictureBox 2) write code which will write a JPG file to an Access Database field. I have already sucessfully coded this in VB6, without fully understanding what I was doing.
Browsing the various forum's I have come across a few discussions on this subject, but due to my complete amerture status I don't seem to be able to follow the logic.
Below is the VB6 code
Writing JPG file to DataBase:
Dim bytBlob() As Byte
Dim intNum As Integer
[Code]....
View 1 Replies
Feb 28, 2011
I have the following pages structure in my asp.net 3.5 website ...i want if anybody directly access any page of my site as [URL] then it will automatically redirected to [URL] How to do this using vb.net, asp.net
View 2 Replies
May 9, 2010
Is there any possibility to access directly from a Windows form created in VB.net a protected Excel file? I mean, that the password for opening xls file to be stored in VB.net Windows form. I also have the same problem for a Microsoft Access protected file.
View 2 Replies
Feb 6, 2011
Office 2010; Windows7; Visual Studio Basic 2008 (VB.Net)
[Code]...
The following strSQL string is not working as expected when run in VB.Net Interop to Access: (NOTE: The line-feeds " _" are used below are for reading only - are not in actual code line)
[Code]...
View 14 Replies
Apr 10, 2010
I want to collect all stocks information within 2009 & 2010. I stored the required parameters (YMD & stock code) in DB. Is it possible to write a VB.Net windows application to pass all required parameters (post method) to web server and retrieve the web response automatically? (1 - 5 are valid stock code) It is
View 2 Replies
Jul 17, 2010
I was wondering, if there is a way to use httpwebrequest post method to send data to a PHP function directly (no forms, or whatever)
so for example, i have this PHP function, which writes to a file:
<?php
$File = "textfile.txt";
$Handle = fopen($File, 'a');
[Code]....
Now, i have a form which would usually post the text which should be writen, so, can this be done directly, without that form, using httpwebrequest in VB?
View 2 Replies
Jun 21, 2010
I have a process that does a lot of data manipulation and then prints a simple report directly to a printer. The overall priority is speed. Tens of thousands of records need to be scanned & processed individually so moving thru them quickly as possible is the goal.
Pseudo code
01)Scan Barcode
02)Fill DataSet from Sql Server
03)Manipulate data in dataset
04)Update data back to Sql Server
05)Print crystal report directly to printer; the dataset is the reports source
06)Clear dataset and start next record back at step one
The process if pretty complicated with a ton data manipulation and data coming from multiple sources but that part works super and in short all I am doing is scanning barcode, filling a dataset, passing it to a report and starting over. Steps 1 to 4 are averaging one tenth of a second (0.01) to complete; great. Passing it to the report to print takes several seconds which is the problem. I thought I would resolve this by passing the dataset to the report print sub - allowing the print sub to run on a background thread - and moving on to processing the next record.
Dim m_ds As MyTypedDataSet
Sub ScanBarCode
Fill DataSet
Validate & Manipulate Data
Call PrintReport
Clear Dataset
End Sub
I have been attempting to add the PrintReport sub to process on a background thread. The problem though is the main thread blows right by to the next step and clears the dataset; causing an error in the report sub. I've tried unsuccessfully just about everything I can think of; including using DataSet.Copy to local datasets (which I really don't want to keep recreating the same object over & over tens of thousands of times), as soon as the main dataset clears, all clear.
View 1 Replies
Oct 24, 2011
How can I configure my connection that directly my data save into server. I am using databinding approach, like this me.tblnameTableAdapter.Fill (me. DbnameDataSet.tblname). It is possible to stored data into server just like ADO.Net?
View 3 Replies
Sep 7, 2011
I'm trying to "convert" an Access DB to a stand alone application. I have under estimated the differences between VBA and VB. Although I have many questions, I'll focus on this topic first.
The Access DB collects and maintains SNMP traps from a radio station. I import CSV files from a remote Unix server via FTP, parse the text line-by-line, and add to a table as a new record. So far, I can parse the text and add to a dataset but I want to write directly to the data source. I also need error handling that will trap errors for duplicate records. There is a Reconcile function that ensures that all lines in the CSV files are added to the table before the files are permanently deleted. Here's what I have so far:
Public Class clsRnm
Private msTrapTable As String
Private moTrap As clsRnmTrap
[Code].....
View 1 Replies
Dec 12, 2009
I'm trying to update some data fields in an existing data table, and want to access the data directly. I know it's possible, and I used to do it years ago in VBA, where you could do things like
[Code]...
View 6 Replies
Mar 3, 2009
I would like to develop a program (in VB2008) that can send files directly from one computer to another through the internet.
I figure there would be one program on the sending end and a separate on the receiving end. A server and client perhaps?
Anyway, I need to know how to send a file on the host machine in a simple method that is least likely to be blocked by anti-viruses and such. The fewer issues that result in a failed transfer, the better.
Also, note that my goal is to molulize this code (later) so it can be reused for multiple applications such as file sharing, gaming, etc.
View 1 Replies
Jul 8, 2010
Is there an easy way to consume xml to access any of the nodes directly without reading line by line?Here is a sample set of the xml working with. It contains two records of data. I am trying to find a way to load it so if I wanted to get say PostalCode and say Site SID value quickly.
HTML
<?xml version="1.0" encoding="utf-8"?><MainSite><MainSites Found="201" Returned="20" Status="0"><Site SID="123456"><Relevance>0.985</Relevance><Title>JDoe</Title><DateModified Date="2010-01-29T01:05:00">1/29/2010</DateModified><DateCreated Date="2010-01-29T01:05:00">1/29/2010</DateCreated><PersonalData><Confidential>0</Confidential><Name><First>John</First><Middle>
[code]....
View 12 Replies
Oct 18, 2011
I have a small problem that I am sure is due mostly to my inexperience with threading. I have used simple entirely self-contained threads before, but not to a great extent. I understand the basic laws that surround them, such as how a thread cannot access another thread's member directly, and must use delegates.
[Code]...
View 1 Replies
Jun 9, 2009
I'm trying to insert data from an Access unbounds form to an Access Table using the follwoing code:
View 2 Replies
Sep 18, 2009
I need a good book for beginning to use VB 2008. I have some (limited) experience in using VBA. I want to access a database (SQL) and have access to the data set as variables?
View 6 Replies
Apr 19, 2011
I have a basic application that allows pre-defined users to use the application.The Username & passwords along with some other basic user info is stored in a simple access dbIn my application I want a user to login, Username & PasswordI create a connection string, a data adapter and a dataset, I then need to validate the password the user has entered.Would it be best to query the access db directly, or the dataset?
View 5 Replies
May 7, 2009
how to connect to a database and retrive data in a table using oledb data provider in Microsoft access?
View 2 Replies
Jul 7, 2011
I'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
View 5 Replies
Nov 11, 2010
The control comes up blank??Imports System.Data Imports System.Data.OleDb Public Class Form1
[Code]...
View 6 Replies
May 18, 2010
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 Replies
Sep 30, 2010
I've tried exporting data from an Access 2003 database to Excel in VB.NET using the following [code]...
View 4 Replies
Feb 9, 2011
I am trying to read and save data into a access Database but using the rows and colunms valeu can
View 1 Replies
