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
Found 3022 threads
-
0 VotesAzure SQL DB Connection fails intermittently from SSMS
Hello Team, We are connecting to Azure SQL DB using SSMS. Our IP address has been added in the FIrewall listing of Azure Portal. But, we keep ...Unanswered | 1 Replies | 54 Views | Created by skelkar4 - 17 hours 9 minutes ago | Last reply by Daniel_Zhang-MSFT - 2 hours 43 minutes ago
-
0 Votes
Splitting Characters in to different part every 30000 characters
Hi All, I have Image stored in sql Table and I want to split the image column to multiple rows for every 30000 characters to load in the power BI ...Unanswered | 1 Replies | 302 Views | Created by Bihon noro - Monday, October 26, 2020 2:32 PM | Last reply by Daniel_Zhang-MSFT - Tuesday, October 27, 2020 2:44 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 | 1900 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 | 407 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 | 432 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 | 500 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 | 578 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 | 9638 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 | 788 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 | 634 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 | 922 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 | 1076 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 | 6649 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 | 933 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 | 1006 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 | 965 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 | 32097 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 | 1052 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 | 1124 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 | 1135 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 3022 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
