dataset

I have been struggling for several days now trying to figure out why I am getting the failed to enable constraints, one or more rows contain values violating non-null, unique, or foreign-key constraints when running my code. I have a stored procedure in sql server, part of it below...

What I want to do is load two tables from MS Access into VB.NET and modify the data they contain with SQL statements I have managed to copy the two tables into a dataset, but now I am stuck on how to run SQL commands on them Someone did say that if your data is in a dataset you cannot use SQL...

I may not be in the right place. I added an mdb file using the add new datasource. this isn't terribly complicated. there are only 3 linked tables and some SQL queries. In the IDE when I display the dataset I can see all the tables but I cannot see any of the queries. Do they get imported when...

what solution of this erorr Imports System.Data Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Frmallreports Dim cn As New SqlConnection Dim cmd As New SqlCommand Dim cmd1 As New SqlCommand Dim da As New...

good day friends :D., i have a parent form with datagridview filled with datas from my dataset., and a child form namely add_data... now whenever i want to add a new data to my parent form(datagridview) i use the child form(add data form), i entered datas accordingly and it saves perfectly...

OK, I have 2 bounded datagridviews in my form naming beneficiarydatagridview and beneficiarydatagridview1 which is bound to the same bindingsource... now heres the thing in my beneficiarydatagridview i have a search engine using textbox and a button, using the .FILTER feature of...

Hello, My aim is to export data from my SQL database into a word document. I have managed to export data into the word document from my database however if I was to go back onto the word form and type another service ID from the database and click export to word document it would export the...

Hi I am a newbie for vb.net. I am trying to related two tables in a DataSet. I have looked through a lot of threads but could not find the answer I want. Say, I have two tables: table1 : "ID", "ID in table 2" 1 3 2 4 table2 : "ID"...

Hi, I have a good understanding of dataset, datatables and dataadpaters and have used them for a few test programs in vb.net 2010 express and they seem to work OK. What I would like to ask is where to declare the dataset such that all the Forms in my Windows application can access the same...

Hi I have a Combobox on a dataviewgrid on a form. The DataGridView is tied to my customers table and shows the records alright and has a County column. The Combox is tied to my County Table and consists of an ID column and County column and is working well. But I can't get the combox to...

The dataset is missing the JobSiteID(required field) but it exists in the Winforms combobox. The following code fails to get thecombobox.SelectedValue into the dataset. Private Sub EstimatingSheetBindingNavigatorSaveItem_Click(sender As System.Object, e As System.EventArgs) Handles...

I am trying to convert a vb6 program to vb.net. I don't think I fully understand the whole dataset/binding. So my sql code is this: SELECT CASE WHEN e.empl_middle_init != ' ' THEN e.empl_last_name||', '||e.empl_first_name||' '||e.empl_middle_init||'.'...

I have a datagrid which has one custom column(List Box) which should be populated from the resultset of a SQL Stored Procedure. I used dataset to handle and assign the values to custom column(List Box). List box is populating from the dataset but i'm unable to show the default(actual) value in...

I am working on a web application that uses ASP.NET Membership. My SQL Server Database therefore includes (along with all the others created when setting up ASP.NET Membership) a table named aspnet_Users which has the fields ApplicationId, UserId, UserName, LoweredUserName, MobileAlias...

Don't know what's happened to my post?... Hi All, I've been banging my head against this for days now if anyone can help it would be greatly appreciated I've got a couple of forms that share a datatable (declared in a module as public), it's basically a list of documents, one form has a...

I'm writing an app that pulls information from a DataSet as a one-way thing (e.g. the datasource populates a listbox, but for selection purposes only -- the user cannot change the list values). My problem is, when I select something from the listbox, all of the other listboxes change too, as if...

I need some help here. I have a form that populates two tables (countries and states). Country Primary key is Identity. State PK is Country PK + state PK (not identity and entered by the user) I want one form to allow the user to add or modify countries and states. My form has a textbox, a...

I currently have a SQL database with four tables. I need to find a way to imalgamate these tables into one. The one table contains a postcode with around 15 or 16 employee numbers attached to it the people covering this area. I then have a staff table which all the employee numbers listed...

I 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. My XML looks like this: <.Root> ....<.Processes> ........<.Process>12345<./Process >...

Hi Everyone, I'm using the book titled "Database Programming with Visual Basic® .NET and ADO.NET: Tips, Tutorials, and Code". I'm going through the chapter that has me do data binding by setting the properties of a DataGrid and TextBoxes. It had me drag a DataAdapter onto the form using the...