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
[Announcement] "ADO.NET DataSet" Forum will be migrating to a new home on Microsoft Q&A!
This "ADO.NET DataSet" Forum will be migrated to a new home on Microsoft Q&A! We've listened to your feedback on how we can enhance the forum ... -
0 Votes
SqlConnection.GetSchema("DataTypes") returns wrong data (BUG)
using ADO.NET to determine datatype info but MSSQL returns tinyint as "System.SByte" when it should be "System.Byte" as this datatype is UNsigned (i.e. valid range 0-255) ...Unanswered | 1 Replies | 1700 Views | Created by Dick Baker - Sunday, November 15, 2020 12:10 PM | Last reply by Daniel_Zhang-MSFT - Monday, November 16, 2020 3:20 AM -
1 Votes
ReadXml, Xml DataSet, Empty String to null
I am using ReadXml() with Schema. ds.ReadXmlSchema(Path.Combine( AppDomain.CurrentDomain.BaseDirectory, ...Answered | 9 Replies | 3988 Views | Created by Q John Chen - Friday, March 4, 2016 8:08 PM | Last reply by BonnieB - Saturday, September 5, 2020 4:54 AM -
0 Votes
Convert comma separate records into individual records in sql server
HI Team, I am using Sql server 2014 to load data from excel to Sql server, in excel file data looks like below from above specified data ...Unanswered | 1 Replies | 1850 Views | Created by praveenci - Monday, August 31, 2020 3:47 PM | Last reply by Daniel_Zhang-MSFT - Tuesday, September 1, 2020 3:16 AM -
0 Votes
Type mismatch error inserting rows in DBF File
I'm trying to process some SQLite Databases and insert some data into DBF Files, DBase III (old databases, cannot exchange them for the moment) and I keep getting type mismatch error when trying to ...Proposed | 1 Replies | 2142 Views | Created by Alexandru Bodea - Thursday, July 30, 2020 11:00 PM | Last reply by Daniel_Zhang-MSFT - Friday, July 31, 2020 7:25 AM -
0 Votes
Loading Json Data(ADLS ) To Azure SQL Database
Hi All, I am not able to load Json data which is in ADLS Gen2 to Azure SQL Database through Azure Data Factory (Copy Data) ...Unanswered | 1 Replies | 2100 Views | Created by Vijayakumar Panabaka - Friday, July 24, 2020 10:29 AM | Last reply by Daniel_Zhang-MSFT - Monday, July 27, 2020 6:27 AM -
0 Votes
error in data set connection
in visual studio when i try to add new data source using Microsoft OLEDB data base but in the IDE i cant select Provider=Microsoft.ACE.OLEDB.16.0 their is default value ...Discussion | 1 Replies | 2048 Views | Created by kuldeep9909 - Saturday, March 28, 2020 7:29 PM | Last reply by Kareninstructor - Thursday, April 9, 2020 2:02 PM -
0 Votes
Timeout Exception or slow execution time when using strongly typed tableadapter but not when using SqlDataAdapter
instead of "Dim ta AS new myDataSetTableAdapters.myTableAdapter" Dim dt AS new myDataSet.myDataTable ta.Fill(dt) -------> now it took about 2 ...Answered | 10 Replies | 11356 Views | Created by jon09 - Thursday, July 16, 2009 8:19 PM | Last reply by bpatin - Monday, February 3, 2020 5:52 PM -
0 Votes
why not ????
int Credits = Convert.ToInt32(datatbl5.Rows[0][0].ToString()); when i pass it nothings it gives error "input string was not in correct format" ...Proposed | 3 Replies | 2414 Views | Created by oseedeqi - Monday, December 23, 2019 8:14 AM | Last reply by Daniel_Zhang-MSFT - Friday, January 10, 2020 5:23 AM -
0 Votes
Must Declare a scalar value
if (txt_kata_amount_check_search.Text != null) { int id = ...Unanswered | 1 Replies | 2278 Views | Created by oseedeqi - Monday, December 23, 2019 5:20 AM | Last reply by Daniel_Zhang-MSFT - Monday, December 23, 2019 10:01 AM -
2 Votes
How to avoid open/close connections between tableadapter fills?
I have a form with several combo boxes that show items from their respective lookup tables. To load the tables in the first place, I do this. private void ...Answered | 5 Replies | 2685 Views | Created by Robert in SF - Thursday, December 19, 2019 3:43 AM | Last reply by Robert in SF - Friday, December 20, 2019 4:39 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 | 2728 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 | 10000 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 | 2578 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 | 2460 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 | 2731 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 | 36386 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 | 2535 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 | 2648 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 | 2725 Views | Created by Mimosa Arts - Thursday, August 22, 2019 2:48 PM | Last reply by Mimosa Arts - Friday, August 23, 2019 4:51 PM - Items 1 to 20 of 3021 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