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]....
I'm using visual basic 2008 and really need help in this question ...
-I'm creating a web browser : how to stop adding pages to Internet Explorer History...
-And auto save/open Listbox (so i could use my own browsing history)
I'm trying to produce a history viewer similar to the Log File Viewer in SSMS. To group history I'm using Marks TreeGridView [URL] I can filter the results down to just the job in question, but how do I: Group the results similar to the Log File Viewer (Grouped by job run) I cannot see any columns to differentiate job runs. Add them to the TreeGrid in such a way they display as pictured. I'm using SMO to retrive the job history and filtering to show only the required job:
Dim server As New Server(SQLServer)
Dim jobServer As JobServer = server.JobServer
Dim jhf As New JobHistoryFilter()
jhf.JobID = j.JobID
Dim jobHistory As DataTable = j.EnumHistory(jhf)
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?
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?
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 RepliesDoes 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.
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 RepliesI 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 RepliesI 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].....
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.
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 RepliesI want to store Usernames/Passwords in a Database/Data Connection...eg. A login.
View 4 RepliesI 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 RepliesI 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.
I developed a program using Vb.Net that is data based enabled, it has a field for serial number etc. its working fine but the serial number failed to update when a record is deleted, its always keeps tracks of its formal numbering, even when the program is restarted, unless reinstalled.How do i also backup the data stored in such program.
View 6 RepliesI have two MS Access database; Mydb1 and Mydb2. I would like to do the following:
1. Copy all records in table (MyTable1) from Mydb1 to Mydb2. MyTable1 also exists in Mydb2
2. Move all records in table (MyTable2) from Mydb1 to Mydb2. MyTable2 also exists in Mydb2 which needs to be flushed.
I have a device that communicates with the pc via a serial to usb cable. So I have made windows form with a serial communication to speak with it. The communication is every 125ms so every time it checks if the com port is open and sends the new message. The problem is that if the usb is not connected the program tries every 125 ms to connect to the serial port and the busy cursor appears always and the form is not responding to any action (for example enter into the menu or refresh a listbox). I have tried multiple times to connect and disconnect the usb while the program is running. That's mean that the serial connection stopped and started all over again several time. The problem is that occasionally it shows an error "unable to open com port".
View 10 RepliesI am having trouble getting the total due for businesses to calculate correctly. Especially when I run the program and alter the amount of connections or the number of premium channels.
[Code]...
Ok, most of my Visual Basic experience I admit was with VB 3 and VB 5. I'm just starting with VB 2005 Express, and get this error when trying to connect to a new database.
I'm using Windows Vista and have the latest Microsoft JET version, so I have no idea why I'm getting that error.
I would like to detect the insertion, and completion of installation of a USB cable in VB2008 as two separate events. The driver gets installed prior to insertion of the cable.
View 5 Repliesi would like to ask is there a method which i can read a specific file from another computer??i would like to use IP address to specify the address.
View 21 Repliesi want to make a little program that virtually REplugs my internet cable.
View 1 RepliesSo I am trying to get info from a scale using an RS232 cable into a VB2010 program. But before we even start talking about that, I don't know ANYTHING about serial ports. I need to learn how to get the data from the scale without programming first... I am using Win7. I do have a sample program (w/ source) I downloaded [URL]) It runs without any errors, then I have a big USER error, what do I push? How do I tinker to figure out the right settings on this interface? or any interface. These are the sittings for the scale: [URL] I am considering returning my scale and getting something with maybe USB on it, I need to be able to weight things up 100lbs, I am shipping car parts.
View 8 RepliesIs it possible to toggle the D+/D- signals of the USB port to activate a relay
View 9 RepliesI have a VB.net app running on one computer, displaying text into 2 texboxes or labels.I need to see the two values in two sperate textboxes or labels from the two labels on another computer via a null modem serial adapter.
1st computer.
Code:
serialport1.writeline(label1.txt)
straight forward right?
2nd computer to read the data
Code:
Private Sub SerialPort1_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
dim s as new string = serialport1.readline()
label1.text = s
This is what I was thinking;
Code:
serialport.writeline(label1.text & label2.text
This would send the two values over the serial port. How would I seperate the two values and display them in two different texboxes?cannot use them together)Am I on the right path at all? Or using the serialport.writeline method won't work at all....
I am doing wrong? I am using VB2008/VB.NET to send a command (set to 4 volts) to a Tenma DC Power Supply over an RS232 cable. I don't have documentation from Tenma that lists the commands that the instrument understands, I got "VOLT040" from a program in an older version of VB that someone else wrote for this instrument. The code is below:
[Code]...
I have a desktop computer with a cable connection on the back that allows me to watch TV on the computer using Windows Media Center. I had the idea of writing a program that would access this feed and send it to another computer (laptop) via my network. That way I would be able to watch TV from anywhere that my network spans. I have no idea if this is possible or how I would even do it,
So I have three questions.
1: Is it possible?
2: How would I go about access the feed?
3: How would I send it over the network?
My original thought was doing it in Flash, but I'm not very good at Flash so I wanted to do it in VB.Net.
How would I go about clearing IE's history from with VB? I've looked on the internet and couldn't find anything, and I honestly don't have a clue about how to do it.
View 1 RepliesI am a still a beginner at this so bare with me. I have made a web browser which is my starting point in VB. Now its fully functional and has history and all that. And i am using tab control as the browser part. History works when the go button or enter key is pressed but I can't get this to work when a user clicks a link.
Public Class Form1
Dim int As Integer = 0
Dim tabs
[code].....