database

Hi I am trying to check where an item in my array list exists in the database. The list would have already been created at an earlier stage. Now that some items may have been removed from the database, I wish to check the list against that database before removing the items, from the list...

Is it possible to get information about whether a child table has reference to a parent table through a certain record? For example, tblParent has a record whose primary key value is 5. I want to know whether tblChild_A, tblChild_B and tblChild_C have one or more records in them where the...

I'm about ready to drop VS and go back to VBA I'm so frustrated! Is there a way to get Visual Studio to return Null values from database tables?? 99.999% of the time I have a table of user data, there's always fields that have the option of leaving them blank. But, in VS, it always throws an...

I am a VERY advanced VBA programmer making my way into VB.net. So far, I have set up a MyDatabase.mdf database file in visual studio, and followed tutorials to make pretty forms that allow the user to view and update the data. Now what I want to do is manipulate the data with VB code - go...

Hello All :) I have been looking in to this on and off for about two weekes now and I have come to a head!! I have designed a small local windows application that will store old emails and their attachments to a database. You can put in a number to only look at thing over say 60 days old? so...

Help on how to create queries, I mean how to retrieve data from access database. I wanted to fill my dataset with my query. I wanted to query the database using the data in the inputbox in the tables listed in combobox. See attached source (VB2010) Please help.

Hello everyone. I have a database let's say db1.mdb that is opened by app1.exe db1 has a table named Users Table Users has 3 fields ID,User,Status i am creating app2.exe that will have 2 buttons. Button 1 will set the value of field Status to false, and button 2 will set the value to true. What...

I have read many articles on multithreading over the past few days and so far I'm fairly comfortable with how it works. I am now working on my actual application, and have come across a few design issues that I'm hoping somebody has experience with. The basic premise of the application is...

hi im new to this and wondering if ay1 can help me. i have created a web page in visual studio 2008. The website is based on databases e.g entity relationship . it shows booking of a hotel with customer id etc. i manage to get a add, delete and edit button to work on my website fo them databases...

Hello, I am aware about the COPY ALWAYS or DO NOT COPY features for files and database files. But my problem is the following: This is the code: Imports System.Data.SqlClient Imports System Imports System.Data Imports System.Windows.Forms Public Class Toybla ' Dim ConnectionString As...

Hello! I hope somebody can help me. I have a MS SQL database with multiple tables, where one of the tables is really important. I have several clients simultaniously working with this table and the data should be consistent between the clients. How can I make sure all my clients no that data...

I want to add a find next button to find the next record in a query made with a find button. I am in the data list view. I have an Access database and I want the result displayed in my text boxes. Can anyone help with the code for the button?

Good Afternoon All, I'm fairly new at VB.Net and Visual Studio so please bear with me if what I'm asking seems ridiculous. I would like to query a MS SQL Server database (not on the local machine) and store the results in a so-called "in-memory" DataTable. I've done this... not too...

i want to use the data adapter for standard login and registration procedures. my first form is a login window contaning 2 textboxes,one for username and one for password.. i used a table adapter to connect to database.. using sql statement.in the adapter "SELECT COUNT(*) AS Result...

Hi, [Scroll down for the real question] I've been challenged by my college tutor to create a program that allows employees to "clock in" and "clock out" when they arrive and leave work. My general idea is that I could create a VB.Net application for staff to "log in" with. This would then...

Hi there, was hoping someone could shine a light on my problem; Im a 3rd year student studying computer forensics in Wales, UK and for my project I plan to create a small program to track or confirm online payments. The scerario will be totally fictional. The project will be connected to a...

Hi, I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about...

I am making a bookworm game as my project in school and I wanted my words database to be in notepad, but how can I connect and query using vb.net2008?:confused: I got this idea from an online game that the game database for restricted words are in notepad, I also wanted to do that....:cool...

We use JOIN in the SELECT statement often to retrieve data from multiple related tables. But, some times we can get into a situation where we may need to use UPDATE statement by joining multiple tables. Consider a situation: A table named as USER_DATA is there which contains user details. This...

How do I create an external file that would act as a database but without using sql or MS Access database files...