dataset

  1. D

    Question Stored Procedure/TableAdapter and Failed to enable contraints

    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...
  2. S

    Question How to use SQL commands with DataSets

    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...
  3. U

    Question Queries in the IDE

    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...
  4. S

    DataTable already belongs to this DataSet.

    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...
  5. E

    how to update the dataset of the parent form from child form

    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...
  6. E

    Question how to set a new bindingsource to a datagridview?

    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...
  7. C

    Question Exporting SQL data to Word

    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...
  8. J

    Getting certain item from two related tables in a dataset

    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"...
  9. D

    Question Global Dataset versus local dataset

    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...
  10. D

    Question combox on datgridview not matching column

    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...
  11. W

    Question detail view : comboBox value is not getting into the dataset before update

    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...
  12. D

    DataSet/Binding Help

    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||'.'...
  13. S

    Question How to prepopulate a listbox populated by dataset

    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...
  14. N

    Question Creating a wishlist for use with ASP.NET Membership

    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...
  15. I

    Question TableAdapter, Add works, Update works, Delete has no effect

    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...
  16. Grayda

    Stopping "automatic" updating of controls with datasource

    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...
  17. R

    Question How to set DataSet Primary Key programmatically

    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...
  18. G

    Question Help merging four tables into a datatable

    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...
  19. N

    Question DataSet/DataView with XML problem

    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 >...
  20. emaduddeen

    Question Database book sample code not saving changes to the database

    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...
Top Bottom