Search results for query: *

I am trying to add a data table to my dataset in Visual Studio. I run through the wizard and add the new Oracle ODBC connection and then when I get to the screen to select either "Use SQL Statements" or "Use existing stored procedure", if I select to use SQl statements I can add one and it...

I have a login form in a vb.net windows app and I run a stored procudure that returns the count for username and password sent in to see if someone is a valid user. how do i get this count that is returned for an if else statement in my windows form so I can tell it whether to error or...

I am creating a website that has two different types of login, customers and admin. There are two tables in an SQL 2000 database that holds the login details for each, and I am using webservices to check and return the details if they are valid to let them login. Okay I have set up all of...

I have a webservice that when it runs is supposed to return all of the customers in a particular state. I have run the stored procedure that it calls in SQL 2000 query analyser and it returns 3 customers, but when I run the webservice nothing is returned, and there is no error either. The...

I have a datagrid view that is bound to a stored procdure. I have a save button at the bottom, when it is clicked I want it to save selected columns to a database table. I have added the query to the table adapter for the table I want to save to which updates the entry in the table, but How...

I need to insert some records into a table for each record in another table. I have a table called Courses (tbl_Course), these course have Catogories (tbl_CourseCategories) and each category can have multiple Competencies (tbl_Competencies). Now I want a stored procedure which runs and...

I am getting the following error when I try and delete a record from a table called Course from a windows form; "DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_tbl_CourseCategory_tbl_Courses'. The conflict occurred in database 'cams', table 'tbl_CourseCategory', column...

I have a windows form in the VB.Net Windows application that shows a persons details and their Next of Kin details. You can scroll through the people using a binding navigator. You can also scroll through the next of kin details using a binding navigator. What I want is to have the results...

VB.Net Windows Application, what is the difference and which is better to use; 1. Attach MSSQL database 2. SQL Server Connection

I need to set up a form that shows the course competencies that a person has completed. I want a drop down list at the top of the form that is a lsit of all the Courses, when a course is selected I then want the following to be displayed (in datagrid views or whatever anyone thinks will best...

I am having an issue with a combo box on a vb page. I have created a form in VS 2005 (vb) and have on it fields from a table called Cadets. One of the fields is state, which is an int and has a relationship with the state id in the states table. The field on the page is a combo box which is...

I have a visual Basic .net 1.1 windows application connected to an access database. One one of the pages there is a drop down box, and depending on the selection of a project ID (the combo box is populated from a table in the access database) I want a datagrid to populated with all of the rows...