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
Generating CSV from DataSet via XML - too much many Columns
5) { innerNode.Value = ...Unanswered | 5 Replies | 1173 Views | Created by Michael_laanti - Wednesday, August 14, 2019 12:34 PM | Last reply by Michael_laanti - Friday, August 16, 2019 5:46 AM -
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 | 1747 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 | 17480 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 | 1216 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 | 6319 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 | 1236 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 | 52510 Views | Created by sh 2020 - 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 | 1037 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 | 34511 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 | 1167 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 | 3190 Views | Created by beckss - Wednesday, February 13, 2019 12:52 PM | Last reply by beckss - Friday, February 15, 2019 9:11 AM -
0 Votes
ado.net compatibility matrix with sql server
May I know where I can find the support matrix between sql server and ado.net ?Proposed | 9 Replies | 1067 Views | Created by sakurai_db - Friday, January 11, 2019 1:41 AM | Last reply by Zhanglong Wu - Tuesday, January 22, 2019 8:57 AM -
0 Votes
object reference not set to an instance of an object vb.net
Dear Sir, I am suffering above mentioned error so please help me in regards. Best Regards, Muhammad ShahidProposed | 2 Replies | 856 Views | Created by Supershahid - Friday, January 18, 2019 10:48 PM | Last reply by Zhanglong Wu - Monday, January 21, 2019 5:12 AM -
0 Votes
Gridview footer dropdownlist will not reload after insert
I have the following: 1 - Gridview with a footer used to insert data. 2 - The footer has a dropdownlist that is loaded via a stored procedure. ...Answered | 1 Replies | 807 Views | Created by PCTony - Thursday, January 3, 2019 3:21 AM | Last reply by Zhanglong Wu - Thursday, January 3, 2019 5:58 AM -
0 Votes
WPF Save Dataset to Database
I have been pulling my hair out over this one, please help. I have a simple database called ContactsDB that is bound to a DataGrid and I can't get any changes to save back to the ...Answered | 12 Replies | 1482 Views | Created by KeatsP - Friday, December 28, 2018 9:22 PM | Last reply by BonnieB - Tuesday, January 1, 2019 3:07 PM -
0 Votes
Unable to Convert Excel to PDF through OLEDB connection
The Microsoft Office Access database engine could not find the object 'Sample'. Make sure the object exists and that you spell its name and the path name correctly. The above error ...Proposed | 2 Replies | 902 Views | Created by Surakshith Reddy - Friday, December 21, 2018 10:17 AM | Last reply by Jamesbn - Monday, December 24, 2018 8:28 AM -
0 Votes
Error occurred while working with max pool size
In connectivity of SQL database using ADO.Net C#, I am getting exceptions randomly while working with thousands of data simultaneously which is being executed ...Proposed | 1 Replies | 1999 Views | Created by PinkiPatra - Wednesday, December 19, 2018 12:43 PM | Last reply by Zhanglong Wu - Thursday, December 20, 2018 6:38 AM -
1 Votes
¿how do a join between datatable and Linq?
How are you? I have a Data and I want to make an internal link with a Linq query. Attached code that I am using but that returns to an error ...Answered | 1 Replies | 746 Views | Created by CrissandoCO - Tuesday, December 11, 2018 2:38 PM | Last reply by Zhanglong Wu - Wednesday, December 12, 2018 1:51 AM -
0 Votes
Mouse drag opertion failed
i have a project with database classes which are generated from database objects. That is I add a dataset to the project and drag and drop a database object onto it. The problem Message Could not ...Unanswered | 1 Replies | 730 Views | Created by Osama M - Sunday, December 2, 2018 8:23 AM | Last reply by Zhanglong Wu - Monday, December 3, 2018 1:26 AM -
0 Votes
Comboboxes with same DataSource on multiple Tabpages
Hi there, I have a very strange problem. I'm using a TabControl with 3 TabPages on an UserControl. On the 2nd and 3rd tab I've added a GrouBox, within those GroupBoxes are ...Answered | 9 Replies | 970 Views | Created by [Raiken] - Wednesday, September 5, 2018 9:30 AM | Last reply by BonnieB - Friday, September 14, 2018 1:52 PM
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