Use Databases / Data Connections In Express?
Sep 22, 2010I want to store Usernames/Passwords in a Database/Data Connection...eg. A login.
View 4 Replies
ADVERTISEMENT
IDE :: VS Server Explorer Close Databases Connections While Debugging?
Jul 27, 2009Every time I execute my application and the app try to access the database I received an error message telling me that the user cannot login into the database. This is because the VS Server Explorer have the connection opened. What I need is that every time I debug (F5) my app the Server Explorer close the connection with the database so I do not have to stop the execution and manually close the connection. Is this is possible? Is there any way I can setup the debug or the Server Explorer to do this?
[Code]...
Databases : Find An Angle In VB 2010 Express?
Apr 23, 2010i want to create a windows form where i can add names, Employee ids and the projekt they are working on. Clicking a button should add the data to a database. Later id need to retrieve this data.First i was thinking that setting up a sql database and finding functions to access it would be fairly easy however.. Theres obviously more than one way of doing this and im having trouble finding the right angle...
View 13 RepliesSync 2 Sql Server 2005 Express Databases
Feb 23, 2010I have a client that has the basic database on a server(sql server 2005 express database) and wants to work on his laptop from his home, so i guess that i can install the software on his laptop but how will the 2 databases be synchronized, having same data. the synchronization will be made once a day in the morning when he returns to his office. How can this be accomplished?
View 2 Replies.Net SQLClient Connections And SQL Server - Active Connections Reflect Even Though All Closed?
Jul 19, 2011Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
[Code]...
VS 2008 Windows 7 And Data Connections
Jun 4, 2009I need help getting a connection to a database from within the windows 7 environment. The code currently works for windows XP flawlessly.However in Windows 7 i get an error about a resource not being registered on the local computer.
View 12 RepliesVS 2005 Accessing Data Connections On Form2 And Other Sub's
Oct 11, 2009I have a small databse program. Form1 uses the Private Sub OpenToolstripmenu to Openfiledialog box and creates a connection and adapters. I need a second form that will access the same connections and adpaters what is the best /correct way to do this? Also other sub functions on form1
View 8 RepliesUsing Databases To Store Data?
Apr 30, 2011Currently 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?
Best Method For Transferring Data Between Two SQL Databases
Jun 6, 2011I'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?
Collect Two Sets Of Data From Two Different Databases
Feb 5, 2009I 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 RepliesCombine Data Into Datagridview From Two Databases?
May 22, 2009Does 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.
Get Data From 2 Databases Namely Cable And History?
Apr 20, 2009I 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]....
Insert Data Into 2 Different Access Databases At Once?
Sep 21, 2011I'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 RepliesQuery To Access Data From Two Databases
Oct 27, 2011I 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 RepliesQUery To Combine Data From Two Different Databases?
Jan 24, 2012I 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].....
Transfer Data Between Two Access Databases?
Nov 12, 2009I 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.
Two Tables Produced From Data In Other Databases
Oct 25, 2010I 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 RepliesInsert The Excel Data Into Sql Server Databases
Aug 4, 2006I 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 RepliesMaking Applications That Retrieve Data From Sql Databases
Jun 9, 2011I 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.
VB Databases - Backup The Data Stored In A Program?
Sep 29, 2010I 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 RepliesVS 2010 Copy And Move Data Between Two Access Databases?
Feb 27, 2012I 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.
Supported For External Data Sources Or For Databases Created With A Previous Version Of Microsoft?
Aug 11, 2007Ok, 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.
Saving Data From A Data Grid To An Access Database (2008 Express)?
May 18, 2010I'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 Replies2010 Express Data-set / Data-view With XML
May 11, 2011I am a co-op student learning vb.net and I have a project which retrieves data from an xml file within the program (based on selections made from combo boxes) and calculates and displays prices.[code]I have one combobox that loads data from the Processes section just fine, but then another uses the same method and gets an "IndexOutOfRange" error or "Column AB12345Bed_Size Not Found" even though I am using the same method for both. For "Processes" I am using DataView.Sort on "<12345Material_Process>" which reflects the selecteditem in the combobox. The program retrieves that row without a problem. [code]
View 1 Replies.net Express And Data Sources?
Aug 17, 2010The company I work for has gone to great expence in getting me Express to code in.Tring to use the datagridview and attaching it to a source has me stumped.I can start the wizard, but it only shows Access and SQL express file locations.I need the connection to get to the actual SQL 2008 database.
View 8 RepliesGet Data Out SQL Express With Usersadapter?
Apr 13, 2011i have a little program (kind of log in) and i want to get data like security level in a text box. the table: [colums: UserName, Password, SecurityLevel]
my query:
Select SecurityLevel as [@SecurityLevel]
from users
Where UserName = @UserName]
[Code].....
VB Express USB Data Acquisition?
Nov 26, 2007I had a copy of Visual Studio Professional on my old computer years ago, but decided against getting it on my new PC. Instead, I downloaded Microsoft's free offerings in the Express editions (C++, VB being the ones I am somewhat familiar with and interested in continuing).
I recently thought of an application that I would like to create, but am concerned that Visual Basic Express won't be able to handle it. I don't quite know what it means when 'they' say that Express can't work with remote data, so I will describe my application and let you tell me if I need to go ahead and get a pay-for version of VB.
a) USB temperature probe (like the one you used in high school chemistry, if you're young enough...) in fish tank, plugged into PC.
b) VB Express app intercepts the data stream and reads the temperature. (I can figure out numerical conversions if necessary using the Logger software which comes with the probe, and excel, if my VB application is showing numbers that follow a pattern with the temperature)
c) Application compares the temperature to the user-defined hi/low settings.
d) Application communicates wirelessly with an X10 Lamp Module, turning on or off the outlet, which is the same as turning on or off the 7.5 watt 'dumb' heater (no on/off switch; you plug it in to turn it on).I've seen ActiveX controls and code examples online that tell you how to code for X10 in visual basic)
.Net 2008 Express / Sql 3.5 Adding Data?
Oct 30, 2009I built the sample project "How Do I" Data Access and ran into a problem adding, updating or deleting records. The project works like a champ until this step... It will let me delete, change or add records just fine, but when I save and close project and go back to my "show table data" in the database explorer nothing has changed?
[Code]...
App Data Folder With 2010 Express
Jan 19, 2012I wish to know what location does the "|Data Directory|" in "|Data Directory|XYZ.sdf" that shows in the connection string when I create a dataConnection using the wizard in VB 2010 Express. Is it the Application's directory in Program Files or is it the AppData folder of the client computer.If it is the Application Directory in Program Files then the client user wont be able to write to the database without Admin rights. If so how do I make a dataConnection to a file in the AppData folder using the new data connection wizard.
View 2 RepliesExtracting Data From A Table In VB Express 08
Apr 25, 2009I have a Access database table that I have extracted data from. The Age column has 12, 13 and 14 year old entries. I am trying to figure out how to calculate and extract the total of 12, 13 and 14 years old from this Age column. [Code]
View 2 Replies