Collect Two Sets Of Data From Two Different Databases
Feb 5, 2009
I collect two sets of data from two different databases, This data is now in two collections. I then join/append the one collection to the other and then put it in to a list view.I really would like to order this list view by the first column without the click event.To make this even harder the First column contains Data that is DateTime and i have found that it orders the items by the day number and not the months or years or time.I have found one way but it then cause's me further agony when doing some checks upon the data within the listview later in my code. This answer is to rearrange the format to "yyyy-MM-dd HH:mm:SS" then using the listview.sorting = sortorder.
View 7 Replies
ADVERTISEMENT
Aug 2, 2009
I have a program that simply checks if the account number and pass word match. And if not it allows you to create it. But i have no idea on how to create something that will hold the data and will allow the user to add and remove sets of data.
View 1 Replies
Nov 18, 2009
I have a SQL server table that has a list of Usernames and a list of points ranging from 1 to 10,000.I want to display the number of points in my VB.NET program from the username given. For example, if I type in "john" in the first box the program will give me a message box saying whatever amount of points "john" has. I'm not really sure about
This is the Table Structure:
Usernames Points
-----------------------------
[code].....
View 1 Replies
May 27, 2009
I have a data entry screen to collect data. At the bottom of the form I have buttons to add a new record, save current and add, save current and end, and an end without saving. The buttons all function properly. After clicking the save current and add new record button, a new blank record comes up with the cursor on the save current and add button. I haven't been able to figure out how reset the tab order so the first field in the entry screen is ready for data. I'm coming up empy on my research.
View 2 Replies
Jun 12, 2010
I have 4 textboxs in my new form. and each of them, i want the data from the db show in the txtbox.[code]...
View 1 Replies
Mar 11, 2010
i want to create an application that collect data from the rs-232.Someone have a code example with multi rs-232 in thread .I have one pc that have mapping virtual com.
View 1 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
Mar 26, 2012
I need to link different arrays of data that I am gathering from different Select Cases.For Example:Araray A, B and C from Case 1Array C, D and F from Case 2 Note: Array C is common between two cases.I know in C++ I could have used Pointers and use SQL in Java.
View 1 Replies
May 10, 2012
I get a problem with my program. My program should do :
-Explore folders from a main folder (LOGS)
-See if there are csv files
-Copy the data from CSV (all informations are on the first column)
-Paste it in one xls file (with a sheet for every csv)[code]...
View 2 Replies
Jan 4, 2010
I have an access database with 3 tables, want to collect data from 2 and insert them into a new row in the third (although this seems redundant there are reasons for wanting it that way). I created a form and call the data from the two tables fine, once the form is filled I try to add a new row to the third but it will not add the row even though it is telling me that is has. When I open my access table the record is not there. I am new at this and just can't figure out why it won't work, I have tried several approaches the latest is
Code:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Activate()
Dim IDNUM As String = InputBox("Enter Student ID Number")
'storing the text entered in a string
[Code] .....
View 2 Replies
Nov 12, 2009
I have only 2 sets of "fixed" numbers used, that I need to be able to toggle between. Particularly, for array sizes/for loops. Is it best to use "Collections" in VB.NET to accomplish this?
View 5 Replies
Jun 3, 2011
I have a regular expression that I use to grab data between two sets of id's for example:
<CLASSCOD>70</CLASSCOD>
The regular expression I use is:
(?<=<CLASSCOD>)(?:[^<]|<(?!/CLASSCOD))*
Which works in most case but when I have a single value like this
<CLASSCOD>N</CLASSCOD>
It says there are no matches.
The whole data string looks like this :
<STATUS>PRESOL</STATUS>
<DATE>0601</DATE>
<YEAR>11</YEAR>
<AGENCY>Department of the Interior</AGENCY>
<OFFICE>Bureau of Indian Affairs</OFFICE>
[Code] .....
View 2 Replies
Nov 5, 2011
We use a database to create Data Collection forms with dynamic items
I used this code to generate labels and textboxes from a table in database (when the user hits the button "load CRF")
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click[code]...
View 4 Replies
May 4, 2011
I have just written an app in VB 2010 with .NET 4.0 that contacts our field loggers to collect data via modem or IP. Originally it was written without threading, but now the requirements have changed and I need to collect data simultaneously from 4-6 sites at a time. I have never used threading, TPL, etc. Can anybody tell me where to begin so that I can concurrently run multiple collections?
View 6 Replies
Oct 17, 2011
I have a USB device which creates a Virtual Serial Port on Windows. I am using VB.Net to write and read from the port. My device responds with specific sized set of bytes, but I am finding that SerialPort.Read(byte-array,offset,number-bytes) does not return the full number-bytes but it also does not timeout or generate an exception. Repeated calls return additional fragments (up to 3 calls required). Python code using pySerial does not have the same problem.So, what am I doing wrong here? Am I expecting too much?
Some scenarios are:I write a command to the port and expect to get 4 bytes in response. I get 1 byte first and then 3 bytes on the subsequent call.I write a command and expect 21120 bytes in response. I get 1, 12671 and then 8448 bytes in 3 calls to read from the port.
Here are some excerpts from my code:
Private Sub SetupVirtualSerialPort()
Dim portName As String = "COM" + (m_DeviceContext * -1).ToString
Const baud As Int32 = 9600 '7680000
Const parity As Parity = parity.None
[code]....
View 2 Replies
Feb 16, 2012
I am a newbie at VB.net and would like for you to review my code in order to improve its performance.My objective is to append a bunch of ".csv" files into daily data sets. Within a directory I have about 2500 individual text file (.csv). Each file represents minute intraday stock market data for an individual stock covering 5 days or one week of data. This means that each symbol has 1950 string lines..Here is an example of what a string line looks like: "2011-06-27,10:07,48.15,48.15,48.02,48.02,25421". Not that is relevant but these represent Date, time,Open, High, Low, Close & Volume. Since I have 2500 files within a directory; doing some math, I am processing 2500*1950 = 4,875,000 lines. This process takes me about 16 hrs to run.[code]
View 7 Replies
Mar 15, 2012
I have a customer and booking data sets on my form. customer id is a foreign key in booking table .but when i click delete button. it gives me an error: The DELETE statement conflicted with the REFERENCE constraint "FK_Booking_Customer". The conflict occurred in database "photoshoot", table "dbo.Booking", column 'Cust_id'. The statement has been terminated. Its a one to many relation between customer and booking. one customer can make many bookings each booking will belong to only 1 customer.
View 1 Replies
Mar 27, 2012
We are creating a VB program for school to collect data on student attendance and populate it to a table. I have all of the 'GET' statements but am having trouble creating the 'Insert' procedure. This is what I have so far. The form being used to fill the table has 4 items being recorded. 'Present' radio button marked as present, tardy or absent; StudentId, PeriodId and date. Not sure if we are on the right track. The target table is tmAttendance. There are approximately 25 rows of data on the input form.
View 3 Replies
Apr 30, 2011
Currently I have a list of items that are based off of a structure of information. I have been putting off the saving function of my program until near the end to make sure that I have all the elements before I start worry about what needed to be saved. I am not asking for code, more for direction. Is it possible that I can load and save data directly to a database rather than have to hold it all in memory as a list? I have never worked with databases in vb.net, and wonder if there are places that would help with this under the requirements I need.
My program saves recipes into a structured list. All the listboxes and forms use the list to populate the correct data on them. I know I could just save all the data each time the program ends into an XML file, and load it each time the program opens.... but is that the best way? Can it be done with a database without having to constantly save or load a file?
View 8 Replies
Jun 6, 2011
I'm developing a project for gathering customer feedback using a Samsung Q1 Ultra, a cheap touchscreen PC. The project consists of two parts: a PC based application that builds the survey and stores the info on an SQL Server, and a survey viewer on the Samsung device which downloads survey data from the SQL Server and stores it on a SQL Server Compact 3.5 database.
My question is, how best can I transfer survey data from the SQL Server to the handheld device's database? Writing a tonne of code to copy data from one database to another seems overcomplicated - is there a handy function or somesuch that I can use to copy data from identical tables on these two separate databases?
View 2 Replies
May 22, 2009
Does anyone know how to, or if it is even possible, to add data from two different databases into one datagridview? For instance, the following is my code for one source of data, pulling from Access.
[Code]...
PartNumber from the first dataset and ItemNumber from the second are supposed to be alike. What I need in my datagridview is all the info from the first dataset and then for each row I need the description from the second dataset, based on the PartNumber that is listed for that row.
View 26 Replies
Apr 20, 2009
I need to get data from 2 databases namely cable and History. The results obtained from it will be display in a datagridview. MyCommand is a sql statement i wrote. However,i have errors in it. The codes are as followed.
Dim dbset As New DataSet
Dim data As New OleDbDataAdapter
data = New OleDbDataAdapter(MyCommand)
[code]....
View 5 Replies
Sep 21, 2011
I'm doing a little project on the side and was wondering if it was possible to enter data from text boxes on a vb form into two different tables in the same database? [code]
View 3 Replies
Oct 27, 2011
I have used two database (1) party (2)partydup.[code]In both tables i have common field ("code"). I tried to retrieve the value of "description" field from partydup table when the "code" field in both the tables are same. I run the below coding but it is showing the error as "No data exists for the row/column". But i have a record which contains the code field value as 123 in both the tables. Still it is showing the error. Please let me know what is the mistake i have done.[code]
View 8 Replies
Jan 24, 2012
I am rewriting a program I originally did in MS Access. In this program I pull a table from the company's AS400 iSystems, it is filtered by data that I have in an Access Table. In Access, I first link both tables to the source and then just create a Query as if both tables were local. Now that I am using .Net, the second table is in SQL Server 2008.
SELECT LPROD
FROM ITEMS
WHERE EXISTS(
[code].....
View 1 Replies
Nov 12, 2009
I am in the process in developing a new version of my software. I have changed my design of my database slightly (added a few new tables and new fields to existing tables). The issue is that my users have user data in the old Db that I would like to transfer to the new Db. Both Db's are access 2003. Because my software is distributed over a wide geographical are it would not be possible to do this manually
I have appended data between two different tables in a single Db, but not between two separate Db's.
View 4 Replies
Oct 25, 2010
I have an interesting project.I've been tasked to create utility in VB.Net. So far from what I can see, I will need two tables produced from data in other databases. The mockup was done in Access which has a unique way of treating all tables as local tables that can interact with one another without any serious side effects. Simply put, I can add three tables from three databases and create a relationship and query against them without any problems.I'm not allowed to write or create items on the Server, so I need to do everything within VB.NET. I've created a local MDF file that will be included in the project installation, but as I'm new to .Net. I'm not sure if this is the best practice.I was excited at the prospect that I might be able to avoid having an attached data source when I realized I could create a DataTable and call data from it. When the application shuts down, the table would disappear and the footprint would be virtually 0. But now rather than just selecting data from that table I need to now delete and insert data to the Datatable object based on AdHoc selections on the form.
View 8 Replies
Sep 22, 2010
I want to store Usernames/Passwords in a Database/Data Connection...eg. A login.
View 4 Replies
Aug 4, 2006
I would like to import the excel in to the sql server using vb.net. how can i do it? Another question is how can i execute the DTS using vb.net
View 6 Replies
Jun 9, 2011
I have started making applications that retrieve data from sql databases.
I write the database with Sql management studio then apply that database to my applicaton.
My question is, how can I make my applications more secure against hackers. Some applications store user names and passwords and personal information / finantial information and so on.
View 1 Replies
