ADO.NET DataSet announcement
-
Link
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
Thanks
Chris Robinson
Dataset - PM
-
0 Votes
Removing ONLY one item from EF table
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 -
0 Votes
Microsoft Access Database Engine 2016
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 -
0 Votes
SQLCE error while trying to insert a record
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 -
0 Votes
Updating records with primary keys that can change.
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 -
0 Votes
How to unit test ado.net code
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 -
3 Votes
TableAdapterManager.UpdateAll() not working.
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 -
0 Votes
SDF table ID not resetting to one
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 -
0 Votes
SQLCE Table Indexes
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 -
0 Votes
SqlCeConnection Exception Stumped me
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 -
0 Votes
Generating CSV from DataSet via XML - too much many Columns
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 -
0 Votes
DB2 Timestamp returns DateTime in C#
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 -
2 Votes
Concurrency violation: the DeleteCommand affected 0 of the expected 1 records [yet again]
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 -
0 Votes
SQL server not working on certain machines
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 -
26 Votes
PLEASE READ: Problem with ADO & VACHAR in windows 10 Update 1809 and Server 2019
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 -
1 Votes
How to access current data row while populating DataGridView?
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 -
0 Votes
How to Gruop By in DataTable {VB.Net}
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 -
0 Votes
Taking values from one data table column, and adding to another data table's column
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 -
0 Votes
Left Outer Join on two Datatables in C#.net
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 -
0 Votes
SqlBulkcopy sortorder
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 -
1 Votes
Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error
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 ›
ADO.NET DataSet announcement
-
Link
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
Thanks
Chris Robinson
Dataset - PM