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 Voteswhy 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 | 2 Replies | 76 Views | Created by oseedeqi - Monday, December 23, 2019 8:14 AM | Last reply by BonnieB - Wednesday, December 25, 2019 12:44 AM
-
0 Votes
Must Declare a scalar value
if (txt_kata_amount_check_search.Text != null) { int id = ...Unanswered | 1 Replies | 54 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 | 182 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 | 384 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 | 5459 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 | 346 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 | 406 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 | 398 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 | 30608 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 | 410 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 | 480 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 | 515 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 | 567 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 | 784 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 | 16530 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 | 765 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 | 5132 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 | 776 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 | 47352 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 | 838 Views | Created by voot1989 - Tuesday, March 12, 2019 12:00 PM | Last reply by BonnieB - Wednesday, March 13, 2019 1:53 PM - Items 1 to 20 of 3019 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
