This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
:CreateViewProfileText: Sign in
Subscriber portal
Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 1

ADO.NET DataSet announcement

  • Link
    Guidelines for entering Dataset forum posts
    Chris Robinson- MSFT Wednesday, January 28, 2009 4:40 PM

    For people who are posting questions on this forum, here are a couple of questions to ask to understand if this forum is the best place to ask your question

    1) If you have a question about how to connect to a database using Ado.Net, the Ado.Net Data Providers forum is the correct place make a Post

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads/

    2) If you are having Databinding issues and not using a Dataset, DataTable or DataView, here is an appropriate forum to make a Post

    http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads/

    3) For issues that occur when using Visual Studio and dragging and dropping within VS, here is an appropriate forum to make a Post

    http://social.msdn.microsoft.com/Forums/en-US/winformsdesigner/threads/

    4) If you have a question related to VB6 Data Access please proceed to the following Discussion group

    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.vb.general.discussion&lang=en&cr=US

     

    Thanks

    Chris Robinson

    Dataset - PM

     

RRS feed

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
ADO.NET DataSet
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    0 Votes

    Removing ONLY one item from EF table

    Data Platform Development
     > 
    ADO.NET DataSet
    I've got a SaleItems table with three snickers bars in it.  I want to remove only one item and no more.  In SQL I can use  Select TOP(1) * FROM ...
    Unanswered | 3 Replies | 255 Views | Created by Mimosa Arts - Monday, December 2, 2019 3:16 PM | Last reply by William Xifaras - Wednesday, December 4, 2019 11:56 AM
  • large check mark
    0 Votes

    Microsoft Access Database Engine 2016

    Data Platform Development
     > 
    ADO.NET DataSet
    I am working with Access (office 365) and Visual Basic. I need to install Microsoft Access Database Engine. I downloaded the 64 bit version and started the install. Got a message saying there are 32 ...
    Proposed | 4 Replies | 4470 Views | Created by Claell44 - Tuesday, February 13, 2018 11:51 PM | Last reply by MD351 - Tuesday, December 3, 2019 2:49 AM
  • large check mark
    0 Votes

    SQLCE error while trying to insert a record

    Data Platform Development
     > 
    ADO.NET DataSet
    tried to use the following sql INSERT INTO ...
    Answered | 1 Replies | 243 Views | Created by Mimosa Arts - Tuesday, November 26, 2019 7:07 PM | Last reply by Daniel_Zhang-MSFT - Wednesday, November 27, 2019 6:08 AM
  • large check mark
    0 Votes

    Updating records with primary keys that can change.

    Data Platform Development
     > 
    ADO.NET DataSet
    I have an interesting scenario that probably isn't very rare but, probably worth a quick question on here to get some feedback. I have a table with a Product ID varchar(30) primary ...
    Unanswered | 3 Replies | 315 Views | Created by Phill D - Thursday, October 24, 2019 3:01 PM | Last reply by Kyle Wang - MSFT - Monday, October 28, 2019 6:47 AM
  • large check mark
    0 Votes

    How to unit test ado.net code

    Data Platform Development
     > 
    ADO.NET DataSet
    i used sql helper to perform db operation. i use this one https://gist.github.com/imranbaloch/10895917 please tell me how could i unit test the sql helper wrapper call. i am ...
    Unanswered | 1 Replies | 304 Views | Created by Sudip_inn - Friday, October 25, 2019 12:44 PM | Last reply by William Xifaras - Sunday, October 27, 2019 3:19 PM
  • large check mark
    3 Votes

    TableAdapterManager.UpdateAll() not working.

    Data Platform Development
     > 
    ADO.NET DataSet
    Firstly, I thought you could embed image URLS ? so you can see screen shots etc. I can't see the image tags??   This seems to be a common problem, i have ...
    Unanswered | 17 Replies | 30311 Views | Created by Hullster - Monday, February 28, 2011 12:41 PM | Last reply by Vadim Rapp - Monday, October 21, 2019 1:35 PM
  • large check mark
    0 Votes

    SDF table ID not resetting to one

    Data Platform Development
     > 
    ADO.NET DataSet
    I've got a Sales table which has a Primary Key  which is also Identity(1,1) called SaleID.  Whenever I copy the blank "fresh" database over to the device to replace an existing ...
    Answered | 2 Replies | 320 Views | Created by Mimosa Arts - Thursday, September 26, 2019 6:53 PM | Last reply by Mimosa Arts - Monday, September 30, 2019 4:28 PM
  • large check mark
    0 Votes

    SQLCE Table Indexes

    Data Platform Development
     > 
    ADO.NET DataSet
    I've got a very simple database  with sales and sale items tables and three simple product tables which is basically just a an id and a description column.  I'm using EF to access ...
    Answered | 2 Replies | 387 Views | Created by Mimosa Arts - Friday, August 30, 2019 12:22 PM | Last reply by Mimosa Arts - Tuesday, September 10, 2019 7:54 PM
  • large check mark
    0 Votes

    SqlCeConnection Exception Stumped me

    Data Platform Development
     > 
    ADO.NET DataSet
    private void BtnClear_Click(object sender, EventArgs e) { SqlCeConnection conn = null; try { string path = ...
    Answered | 3 Replies | 427 Views | Created by Mimosa Arts - Thursday, August 22, 2019 2:48 PM | Last reply by Mimosa Arts - Friday, August 23, 2019 4:51 PM
  • large check mark
    0 Votes

    Generating CSV from DataSet via XML - too much many Columns

    Data Platform Development
     > 
    ADO.NET DataSet
    5) {                         innerNode.Value = ...
    Unanswered | 6 Replies | 490 Views | Created by Michael_laanti - Wednesday, August 14, 2019 12:34 PM | Last reply by BonnieB - Sunday, August 18, 2019 1:52 PM
  • large check mark
    0 Votes

    DB2 Timestamp returns DateTime in C#

    Data Platform Development
     > 
    ADO.NET DataSet
    Hi. My UI app is using C# and calling DB2 with DB2Connect to displays result of query SELECT * FROM myTable. ...
    Unanswered | 4 Replies | 681 Views | Created by Sam Sam L - Monday, June 24, 2019 3:12 PM | Last reply by Sam Sam L - Monday, July 22, 2019 8:36 PM
  • large check mark
    2 Votes

    Concurrency violation: the DeleteCommand affected 0 of the expected 1 records [yet again]

    Data Platform Development
     > 
    ADO.NET DataSet
    I'm recieving that -very annoying- message on a very simple task consisting on a) Loading a datatable with a dataadaptor that contains a selectcommand with certain parameters (eg: ...
    Answered | 5 Replies | 16416 Views | Created by IB_DavidT - Thursday, December 17, 2009 3:05 PM | Last reply by neverleave0916 - Saturday, June 1, 2019 10:20 AM
  • large check mark
    0 Votes

    SQL server not working on certain machines

    Data Platform Development
     > 
    ADO.NET DataSet
    I need help figuring out why my app only works on some machines. It works fine on my computer and my laptop (Windows 10 pro x64), but not on the machines of other people who used Windows 10 in S-mode. ...
    Unanswered | 3 Replies | 686 Views | Created by Lime the fruit - Monday, April 22, 2019 7:31 PM | Last reply by William Xifaras - Friday, May 10, 2019 3:19 PM
  • large check mark
    26 Votes

    PLEASE READ: Problem with ADO & VACHAR in windows 10 Update 1809 and Server 2019

    Data Platform Development
     > 
    ADO.NET DataSet
    I am having problems when I use Ole DB Provider: MSDataShape, when the SHAPE APPED command has a column declared as NEW adVarchar (50) ColumnName. When opening the dataset, you get an error saying ...
    Unanswered | 31 Replies | 5004 Views | Created by Giorgio H. Bazzo - Friday, October 5, 2018 12:37 PM | Last reply by KyleJP - Tuesday, May 7, 2019 12:24 PM
  • large check mark
    1 Votes

    How to access current data row while populating DataGridView?

    Data Platform Development
     > 
    ADO.NET DataSet
    I have the following table adapters. I'm populating a DataGridView from the ReqSecretarial table adapter. Instead of showing the foreign key StaffID, I'd like to show the StaffName. It's a read-only ...
    Answered | 2 Replies | 691 Views | Created by Robert in SF - Wednesday, April 17, 2019 8:34 PM | Last reply by Robert in SF - Saturday, April 20, 2019 2:58 AM
  • large check mark
    0 Votes

    How to Gruop By in DataTable {VB.Net}

    Data Platform Development
     > 
    ADO.NET DataSet
    Hi All I Have a DataTable In My DataSet SELECT * FROM DataTable: Result Is: Id        ...
    Answered | 6 Replies | 47107 Views | Created by sh 2019 - Friday, May 11, 2012 4:31 PM | Last reply by Mary OB - Friday, April 12, 2019 6:12 PM
  • large check mark
    0 Votes

    Taking values from one data table column, and adding to another data table's column

    Data Platform Development
     > 
    ADO.NET DataSet
    I have a table called CheckedFiles with a column called filesChecked, and a table called startDate, which depending on any advice I can get, has a column called FilesChecked. What I want to do, is to ...
    Unanswered | 3 Replies | 738 Views | Created by voot1989 - Tuesday, March 12, 2019 12:00 PM | Last reply by BonnieB - Wednesday, March 13, 2019 1:53 PM
  • large check mark
    0 Votes

    Left Outer Join on two Datatables in C#.net

    Data Platform Development
     > 
    ADO.NET DataSet
    Working on C# I have two DataTables with one common column. I want to perform a Left outer join on these two and store the result in a third ...
    Unanswered | 6 Replies | 32807 Views | Created by jo_28 - Friday, June 20, 2008 6:39 AM | Last reply by bramDat - Tuesday, March 12, 2019 11:04 AM
  • large check mark
    0 Votes

    SqlBulkcopy sortorder

    Data Platform Development
     > 
    ADO.NET DataSet
    Hi All, Is there an option to specify that the data is sorted in the dataset when using SqlBulkCopy. I am observing in SQL execution plans that there is an sort ...
    Answered | 2 Replies | 760 Views | Created by GKS001 - Sunday, February 3, 2019 2:10 AM | Last reply by William Xifaras - Friday, March 1, 2019 8:18 PM
  • large check mark
    1 Votes

    Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error

    Data Platform Development
     > 
    ADO.NET DataSet
    I am trying to connect a Microsoft Access Database with my application but this error appears when the connection is tested in VS2017. I have installed Microsoft Access Database 64 bit (Office 365). I ...
    Answered | 2 Replies | 1722 Views | Created by beckss - Wednesday, February 13, 2019 12:52 PM | Last reply by beckss - Friday, February 15, 2019 9:11 AM
  • Items 1 to 20 of 3016 Next ›
Announcement: 1

ADO.NET DataSet announcement

  • Link
    Guidelines for entering Dataset forum posts
    Chris Robinson- MSFT Wednesday, January 28, 2009 4:40 PM

    For people who are posting questions on this forum, here are a couple of questions to ask to understand if this forum is the best place to ask your question

    1) If you have a question about how to connect to a database using Ado.Net, the Ado.Net Data Providers forum is the correct place make a Post

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads/

    2) If you are having Databinding issues and not using a Dataset, DataTable or DataView, here is an appropriate forum to make a Post

    http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads/

    3) For issues that occur when using Visual Studio and dragging and dropping within VS, here is an appropriate forum to make a Post

    http://social.msdn.microsoft.com/Forums/en-US/winformsdesigner/threads/

    4) If you have a question related to VB6 Data Access please proceed to the following Discussion group

    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.vb.general.discussion&lang=en&cr=US

     

    Thanks

    Chris Robinson

    Dataset - PM

     

Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Make a suggestion

Dev centers

  • Windows
  • Office
  • Visual Studio
  • Microsoft Azure
  • More...

Learning resources

  • Microsoft Virtual Academy
  • Channel 9
  • MSDN Magazine

Community

  • Forums
  • Blogs
  • Codeplex

Support

  • Self support

Programs

  • BizSpark (for startups)
  • Microsoft Imagine (for students)
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
logo © 2019 Microsoft