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 VotesHow to rollback a DataSet to a given point?
Hello, My application has a DataSet. When I reach a certain point in my program (call it a "savepoint") I need ...Proposed | 8 Replies | 83 Views | Created by Danny QuickBrownFox - Thursday, June 07, 2018 4:23 PM | Last reply by BonnieB - Thursday, June 14, 2018 8:48 PM
-
0 Votes
How to cascade update of primary key when DataRow is self-referencing ?
Hello. I have a DataSet with just 1 table called T. The table has 2 columns : column "ID" (primary key) and column "refID". I have a foreign key constraint ...Proposed | 7 Replies | 74 Views | Created by Danny QuickBrownFox - Tuesday, June 05, 2018 12:01 PM | Last reply by Danny QuickBrownFox - Thursday, June 14, 2018 7:27 AM -
0 Votes
How to rollback a DataSet?
Hello, My DataSet is read from/saved into Oracle via OracleDataAdapter. When I call Update on the DataSet so as to ...Proposed | 3 Replies | 55 Views | Created by Danny QuickBrownFox - Thursday, June 07, 2018 4:30 PM | Last reply by Zhanglong Wu - Monday, June 11, 2018 1:00 AM -
1 Votes
Header multiple detail XML File
Hi can someone please help me, I have this Code, string connetionString = null; SqlConnection connection; SqlDataAdapter ...Answered | 2 Replies | 60 Views | Created by Alucard023 - Friday, May 25, 2018 11:37 AM | Last reply by Alucard023 - Saturday, May 26, 2018 5:35 AM -
0 Votes
DataRelation problem with more than 32 columns - Comparing two different datatables
Hi Team, Task to compare two different source of database with same set of tables.So select queries are made dynamic and getting the DataSet, which will hold maximum of 5 ...Unanswered | 1 Replies | 44 Views | Created by Anilsurendar - Wednesday, May 16, 2018 9:46 AM | Last reply by Zhanglong Wu - Thursday, May 17, 2018 2:28 AM -
0 Votes
Will TLS 1.2 break our system?
We have a distributed system that has been in production for a few years now. One of the interactions that are made between the distributed components is between the SQL Server Database and ...Discussion | 1 Replies | 77 Views | Created by Eddie_88 - Monday, May 14, 2018 5:18 PM | Last reply by Sheng Jiang 蒋晟 - Monday, May 14, 2018 8:50 PM -
0 Votes
How to make the store procedure call routine generalize
see my code and below approach. guide me How to make the store procedure call routine generalize which will work in any scenario. store procedure may ...Answered | 1 Replies | 40 Views | Created by Sudip_inn - Tuesday, May 08, 2018 9:36 AM | Last reply by Zhanglong Wu - Wednesday, May 09, 2018 2:48 AM -
0 Votes
-
0 Votes
I have a data table with 4 coloums where I want distinct of 1 and last column and sum of remaining to columns using linq or Select statement please help me to achieve this
I have a data table with 4 colunms where I want distinct of 1 and last column and sum of remaining to columns using linq or Select statement please help me to achieve thisProposed | 1 Replies | 36 Views | Created by Tasnim Iram - Tuesday, May 08, 2018 4:33 AM | Last reply by Zhanglong Wu - Tuesday, May 08, 2018 8:05 AM -
0 Votes
DataTable.Select with a clause on a binary column
Is there any way to use DataTable.Select with a clause on a binary column? No matter what I do I always end up with an exception. Sample code: Guid guid ...Answered | 6 Replies | 11214 Views | Created by etitcombe - Thursday, September 11, 2008 3:04 PM | Last reply by Evgeniy Gavrylov - Friday, May 04, 2018 12:31 PM -
1 Votes
procedure property of SqlException class returns empty
Hi I have a typed dataset,I created dataset with dataset designer and simply placed a storedprocedure into designer and it created a datatable for me then I have a fill command and ...Proposed | 10 Replies | 116 Views | Created by arash ghasemi - Monday, April 16, 2018 9:48 AM | Last reply by BonnieB - Sunday, April 22, 2018 1:39 PM -
0 Votes
Issues fetching data
I am developing for a multilanguage software with support for arabic, chinese, english, spanish, etc, recently we at the office are adding support for vietnamese. And I found a bug. When I set my ...Proposed | 1 Replies | 49 Views | Created by GenaroArteagaSalinas - Friday, April 06, 2018 2:47 PM | Last reply by Zhanglong Wu - Monday, April 09, 2018 4:54 AM -
21 Votes
How to dynamically change connection string in generated dataset class?
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 with this is that I ...Proposed | 62 Replies | 140789 Views | Created by Karamasov - Monday, October 17, 2005 11:08 AM | Last reply by Sergio Gia - Friday, April 06, 2018 3:17 PM -
0 Votes
Using OleDbDataAdapter to update DataTable with data field that is not required but with AllowZeroLength = false
Hi, I am working on an issue on using the OleDbDataAdapter.Update() method to update an MS Access database table with data stored in the DataTable variable, in ...Unanswered | 2 Replies | 72 Views | Created by pchoskw - Friday, March 30, 2018 11:06 PM | Last reply by Zhanglong Wu - Tuesday, April 03, 2018 2:43 AM -
0 Votes
JUST TRYING TO CONNECT!
I'm in Visual Studio building a webform in asp.net with C#. I've built my database in the server explorer and all looks well BUT when I try to connect to it from the code within my page_load method or ...Unanswered | 1 Replies | 65 Views | Created by KazBridson - Friday, March 23, 2018 7:44 PM | Last reply by Zhanglong Wu - Monday, March 26, 2018 1:14 AM -
24 Votes
Typed DataSet fails with sproc containing #tables
Column", I get the same "Invalid object name '#temptable'". The server is SQL2000, and I'm wondering if that may be why it fails? The sproc is ...Answered | 24 Replies | 23874 Views | Created by Svend Tofte - Tuesday, June 27, 2006 9:40 AM | Last reply by Mr Zaw - Tuesday, March 20, 2018 7:37 AM -
1 Votes
fill a data table from a huge IEnumerable takes a long time
Hi I use a data table to pass it as a parameter of a stored procedure. To fill the data table, I read a huge list saved in IEnumerable (items, Contains millions of ...Proposed | 6 Replies | 1212 Views | Created by persian developer - Sunday, February 18, 2018 8:37 AM | Last reply by BonnieB - Sunday, March 18, 2018 4:58 PM -
0 Votes
What is this?
Greetings! I'm learning VB and SQL and DataBases all alone, can someone tell me: In ...Proposed | 1 Replies | 74 Views | Created by Fmdsma - Friday, March 16, 2018 3:53 PM | Last reply by BonnieB - Sunday, March 18, 2018 4:53 AM -
0 Votes
Fieldname Case Sensitive In Hungarian Windows
I am accessing an ADO recordset with the following fields. My SELECT statement is SELECT ...Unanswered | 1 Replies | 60 Views | Created by rpotash - Wednesday, March 14, 2018 10:24 AM | Last reply by Zhanglong Wu - Thursday, March 15, 2018 1:13 AM -
0 Votes
TableAdapter not accepting dbnull values
Hello there, I have a simple forms-based application using a DataSet (xsd file). In there I have a few DataTable instances with its TableAdapter and Select,Insert, Update ...Answered | 3 Replies | 1079 Views | Created by Francisco Lopez ICSC - Wednesday, July 29, 2015 1:25 PM | Last reply by fawzymokhtar - Wednesday, February 28, 2018 1:53 AM - Items 1 to 20 of 2987 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
