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 VotesAuto generated Primary Key.. recordset.Update?
guess I just don't understand..... following samples and what I could find. i have a SQL database with an auto increment pKey ...Unanswered | 3 Replies | 86 Views | Created by jb 1010 - Monday, September 26, 2016 5:55 PM | Last reply by jb 1010 - 15 hours 27 minutes ago
-
0 Votes
How to use Dataset to import xml file to sqlite table ? (C#)
Is this possible ? I'm trying to transfer a large (1,000,000+ records) Access database to an SQLite database. It's so easy to quickly fill a dataset and export it as an .xml ...Proposed | 7 Replies | 291 Views | Created by CaravelleMike - Friday, September 02, 2016 8:50 PM | Last reply by cole wu - Wednesday, September 28, 2016 1:49 AM -
0 Votes
syntax error when using tableadapter.update method after adding field to access database
I have just added a column to an access database. I have updated the dataset query and the Password field now comes up when I update the row. However when I use the update method I now get a syntax ...Proposed | 3 Replies | 337 Views | Created by Paul Andrews 1969 - Friday, September 09, 2016 12:43 PM | Last reply by BonnieB - Sunday, September 18, 2016 1:30 AM -
0 Votes
how to save parent and child list using Ado.net (no EF)
I have parent/child list class, public class PointDataClone { public int DataId { get; set; } public string UniqueKey { get; set; } ...Proposed | 3 Replies | 263 Views | Created by Yazdani ISTS - Sunday, September 11, 2016 6:16 PM | Last reply by Nico Boey - Friday, September 16, 2016 10:12 AM -
1 Votes
out of memory
Hello, C# is using the datareader to get 100 million rows and do some validation for every row. It fails with out of memory error. I ...Answered | 6 Replies | 538 Views | Created by arkiboys - Sunday, September 11, 2016 3:54 PM | Last reply by Nico Boey - Friday, September 16, 2016 9:56 AM -
0 Votes
GridView RowDataBound Issue
Hi Forum, I am getting one issue in my GridView. In my GridView i am using two events one is OnRowCommand and OnRowDataBound ...Unanswered | 1 Replies | 78 Views | Created by Long URLs are not shown totally on the search resu - Wednesday, September 14, 2016 10:08 AM | Last reply by cole wu - Thursday, September 15, 2016 2:01 AM -
0 Votes
DataColumn Default Value
I create a DataColumn using this command: Alter Table [TablesColumnWidths] Add [Column2] REAL DEFAULT -2 When a row is added using DataTable.NewRow(), the ...Proposed | 10 Replies | 315 Views | Created by W-c-v - Monday, September 05, 2016 9:48 PM | Last reply by cole wu - Monday, September 12, 2016 6:10 AM -
0 Votes
In accessing data from a table in ASP.net C# webpage, which method is technically recommend?
I would like to create a ASP.Net C# webpage to show required data from SQL database table with where clause. Which of the following methods is technically best and correct? And gives zero data ...Answered | 4 Replies | 246 Views | Created by K.R.V.Prasad - Saturday, August 20, 2016 6:32 PM | Last reply by K.R.V.Prasad - Friday, September 02, 2016 4:09 PM -
0 Votes
How to get Column Group Name
I need to get column group name from the Data Table, currently I only see columnname property in Data Table. How can we get it? ThanksProposed | 4 Replies | 197 Views | Created by wpf_xam1 - Thursday, September 01, 2016 1:44 PM | Last reply by cole wu - Friday, September 02, 2016 1:21 AM -
0 Votes
Cannot add a DataRelation or Constraint that has different Locale or Case Sensitive settings between its parent and child tables.
Below is the code. Same is working fine in windows2008r2 but when i run the same code in windows 2012 r2 it giving me the error..(Cannot add a DataRelation or ...Answered | 5 Replies | 329 Views | Created by Harish Waghmare - Wednesday, August 17, 2016 8:48 AM | Last reply by cole wu - Monday, August 22, 2016 6:35 AM -
0 Votes
My code "da.Fill(dataSet)" Needs to Complete Faster
I wrote this code about 5 years ago at a time the client application and SQL server were in the same building. The time to complete the line "da.Fill(dataSet)" was about 3 seconds - ...Answered | 10 Replies | 798 Views | Created by LHendren - Wednesday, May 13, 2015 12:47 PM | Last reply by BonnieB - Wednesday, August 17, 2016 4:48 PM -
0 Votes
Visual studio 2012 and Mysql
I'm using visual studio 2012 as front end of an application (Windows form) and back end My sql (local host) too save data. My requirement is to import Microsoft access (.accdb) data table ...Answered | 2 Replies | 173 Views | Created by Nashbaw - Wednesday, August 10, 2016 4:55 AM | Last reply by lake Xiao - Thursday, August 11, 2016 1:56 AM -
0 Votes
Visual studio 2012 and Mysql
I want to add new row , edit , delete and save Data grid view data in visual basic 2012 from text box and also data grid view itself . my data table is residing in My Sql work bench ...Answered | 2 Replies | 165 Views | Created by Nashbaw - Wednesday, August 10, 2016 5:04 AM | Last reply by lake Xiao - Thursday, August 11, 2016 1:56 AM -
0 Votes
Visual studio 2012 and Mysql
I am a beginner in Visual studio 2012 and making a data management programme with visual studio 2012 as front end and MySql as back end. I want to filter data grid view table with combo box , ...Answered | 2 Replies | 155 Views | Created by Nashbaw - Wednesday, August 10, 2016 5:01 AM | Last reply by lake Xiao - Thursday, August 11, 2016 1:52 AM -
2 Votes
VS 2013 Express error / Reference component ADODB could not be found
Hi, I have Windows 10 home edition/ Visual studio 2013 express - Visual Basic project is using ADODB connections. It has been working fine for long ...Answered | 2 Replies | 205 Views | Created by Hareshb - Monday, August 08, 2016 3:39 PM | Last reply by Hareshb - Wednesday, August 10, 2016 10:54 PM -
0 Votes
Updating a dataset using the Data Source system?
so likely I've started down the wrong path, seemed so simple. trying to update a row in a table after changing it in code. no form. i have the table built ...Answered | 5 Replies | 220 Views | Created by jb 1010 - Tuesday, August 09, 2016 3:30 PM | Last reply by BonnieB - Wednesday, August 10, 2016 3:35 PM -
0 Votes
Query regarding performance when updating data in a repeater to sql server - loop or batch update?
We have a repeater control in which we are binding some data from a table. Here the user has option to edit data in each and every row. (Update can happen for all rows or some rows as the user ...Answered | 3 Replies | 192 Views | Created by Simi J - Friday, August 05, 2016 12:04 PM | Last reply by cole wu - Tuesday, August 09, 2016 1:53 AM -
0 Votes
SqlDataReader Index Out Of Range Exception when correct column count is returned
Exception Type: System.IndexOutOfRangeException > Message: Index was outside the bounds of the array. > Data: ...Answered | 9 Replies | 386 Views | Created by Pingpong689 - Tuesday, August 02, 2016 11:45 PM | Last reply by cole wu - Monday, August 08, 2016 9:11 AM -
0 Votes
The DbObjectName for the database in Report DataSet is wrong but still works - help me understand!
I have an xds file automatically created from developing the report (rdlc) file. My web.config uses an external file for the connection string, and inside that it's called ...Answered | 1 Replies | 132 Views | Created by FLDaveM - Friday, August 05, 2016 3:00 PM | Last reply by cole wu - Monday, August 08, 2016 3:08 AM -
0 Votes
ServerVersion_'objcon.ServerVersion' threw an exception of type 'System.InvalidOperationException'_string {System.InvalidOperationException} Soon after I execute the line OleDbConnection objcon = new OleDbConnection("Provider=SQLOLEDB.1;Integrated Secur
Soon after I execute the line OleDbConnection objcon = new OleDbConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Context ...Proposed | 3 Replies | 259 Views | Created by Shaheryar Arshad - Wednesday, July 27, 2016 2:52 PM | Last reply by BonnieB - Saturday, July 30, 2016 3:59 PM - Items 1 to 20 of 2899 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
