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 VotesGetSchema doesn't retrieve schema on table type parameters
So I have a table type parameter on a stored procedure, named like "MySchema.MyUDTT". Calling GetSchema with ProcedureParameters, Data_Type returns just the type name ...Unanswered | 1 Replies | 76 Views | Created by Marbry - Wednesday, September 27, 2017 2:23 PM | Last reply by Bob Ding - Friday, September 29, 2017 8:25 AM
-
22 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 | 22 Replies | 22516 Views | Created by Svend Tofte - Tuesday, June 27, 2006 9:40 AM | Last reply by J A Baker - Wednesday, September 27, 2017 6:28 PM -
0 Votes
No column in TableAdapter
Hi all, I have having this SQL query. When I put the code into TableAdapter Configuration Wizard, the wizard did not detect any column nor @startdate and @enddate parameter. To ...Answered | 1 Replies | 108 Views | Created by CF.Choong - Monday, September 18, 2017 9:24 AM | Last reply by Bob Ding - Thursday, September 21, 2017 6:32 AM -
0 Votes
DATASET - Mouse drag operation failed. could not retrieve schema information for table or view dbo.DATABASE.
Hello Everyone. I have a question and problema but maybe is very simple to you. I did a "DATASET" in my proyect of VISUAL STUDIO 2013 but whe i will try ...Proposed | 1 Replies | 132 Views | Created by Oswaldo Cortes - Thursday, September 07, 2017 2:17 PM | Last reply by Bob Ding - Friday, September 08, 2017 2:07 AM -
0 Votes
Using LINQ with duplicate and distinct ID numbers in DataTable
My project is to read an Excel file into memory and process each row. I am reading the Excel file into a Data.DataTable and it has over 100 columns and over 250 ...Unanswered | 2 Replies | 115 Views | Created by RandyHJ57 - Tuesday, September 05, 2017 3:18 PM | Last reply by Bob Ding - Wednesday, September 06, 2017 12:15 PM -
0 Votes
Group rows into Column sql Server or C#
hi i am using c#4.5 & sql Server 2014. i am importing excel file and saving database . please find the screen ...Answered | 4 Replies | 209 Views | Created by naweez - Tuesday, August 22, 2017 4:54 AM | Last reply by naweez - Tuesday, August 29, 2017 4:59 AM -
0 Votes
PARSE ERROR WITH MYSQL QUERY IN DATASET
= 0 AND `leads_cstm`.`property_sale_price_c` <= 100000 THEN '0-100,000' ELSE 'Over 100,0000' END 'Price Range' ...Unanswered | 1 Replies | 132 Views | Created by ARTDECIEL - Saturday, August 19, 2017 9:04 AM | Last reply by cole wu - Monday, August 21, 2017 3:28 AM -
0 Votes
question about System.Data.OracleClient
If I'm using System.Data.OracleClient in WPF, do I need to have Oracle Client installed on the client pc? ThanksUnanswered | 1 Replies | 115 Views | Created by Barbi Rio - Friday, August 18, 2017 11:25 AM | Last reply by cole wu - Monday, August 21, 2017 2:36 AM -
0 Votes
Why is the unique constraint missing when filling the datatable?
c.ColumnName).ToList(); AutoIncrementColumns = dt.PrimaryKey.Where(c => c.AutoIncrement).Select(c => c.ColumnName).ToList(); UniqueColumns = ...Proposed | 4 Replies | 254 Views | Created by markussd - Wednesday, August 16, 2017 5:25 AM | Last reply by bfuerchau - Thursday, August 17, 2017 12:38 PM -
0 Votes
data are not being saved permanently in data source
When I click on save button on a form my data are not being saved on data source - they just stay on the data set memory.They used to work fine until I changed the data base location and ...Answered | 5 Replies | 4260 Views | Created by mortaza.mkr - Saturday, June 16, 2012 4:59 PM | Last reply by gwboolean - Sunday, August 13, 2017 7:58 PM -
1 Votes
Unable to Add New Query in TableAdapter Query Configuration Wizard
Add > Query Use SQL Statements SELECT which returns rows. I then enter the new query with the parameter e.g. WHERE (jobid = ...Answered | 9 Replies | 4963 Views | Created by Blueboy1894 - Friday, July 27, 2012 4:08 PM | Last reply by Redsoxyear2005 - Wednesday, August 09, 2017 7:58 PM -
0 Votes
Configuring Oracle with ConfigurationSourceBuilder in Microsoft enterprise library
How to configure oracle database using ConfigurationSourceBuilder in Microsoft enterprise library? what should be the provider name for the oracle??Answered | 2 Replies | 105 Views | Created by Trunal Deshmukh - Wednesday, July 26, 2017 12:20 PM | Last reply by Trunal Deshmukh - Thursday, July 27, 2017 6:05 AM -
0 Votes
Entity Framework SaveChangesAsync() throws DbUpdateConcurrencyException
I have the following model class: public partial class RoutePartner { ...Unanswered | 11 Replies | 208 Views | Created by dann055 - Friday, July 14, 2017 2:19 PM | Last reply by BonnieB - Wednesday, July 19, 2017 3:50 PM -
1 Votes
Why do I get an erroneous "DataSet11.Designer.cs" under my Dataset1.cs?
After fiddling with the DataSet Designer with multiple Tables (they involve Foreign Keys from SQLite if it matters), I occasionally get a "DataSet11.Designer.cs" under ...Proposed | 1 Replies | 147 Views | Created by j riv - Tuesday, July 18, 2017 10:42 AM | Last reply by BonnieB - Wednesday, July 19, 2017 1:02 AM -
0 Votes
MSDataSetGenerator Has Gone Wacko
In the past, I've not had any problems generating a Typed DataSet from my .xsd. (I'm using VS 2010). The project is set to .NET 4, but the MSDataSetGenerator refuses to generate ...Unanswered | 15 Replies | 5623 Views | Created by BonnieB - Wednesday, June 13, 2012 6:21 PM | Last reply by BonnieB - Tuesday, June 27, 2017 3:57 PM -
0 Votes
Best way to import typed dataset (xsd)
Hi I had asked this on the VB forum, and it was advised to ask here as well. I'm working on merging several reports and forms from other projects. Some of these ...Answered | 5 Replies | 278 Views | Created by SimeonD - Wednesday, June 21, 2017 3:55 PM | Last reply by BonnieB - Tuesday, June 27, 2017 3:36 PM -
0 Votes
Visual Studio insists on making unnecessary changes to DataSet
I work on a project that uses DataSets heavily. If I add a new table to an existing DataSet, Visual Studio rewrites the xsd and changes the attribute order for every single column element in the ...Unanswered | 8 Replies | 4630 Views | Created by Brenda.Bell - Thursday, August 13, 2009 8:19 PM | Last reply by BonnieB - Monday, June 19, 2017 3:13 PM -
4 Votes
Reading SQL Rows
How do i get this to display the information contained within a Row and not a column? as of now if i enter information like my name into the search box it does nothing but if i enter the column name ...Answered | 19 Replies | 467 Views | Created by RattlerrFx - Friday, May 19, 2017 9:40 PM | Last reply by BonnieB - Friday, June 02, 2017 6:13 PM -
19 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 | 59 Replies | 132274 Views | Created by Karamasov - Monday, October 17, 2005 11:08 AM | Last reply by ToolTimeTabor - Wednesday, May 31, 2017 2:45 PM -
0 Votes
OleDbType.VarChar ==> Access Memo?
I'm adding content from a DataSet into an Access DataTable: cmd.Parameters.Add("@" + everySingleDbColumn[col + 1], OleDbType.VarChar, 40).Value = ...Unanswered | 3 Replies | 308 Views | Created by Jonas Andersson - Monday, May 08, 2017 9:42 PM | Last reply by BonnieB - Wednesday, May 10, 2017 3:49 PM - Items 1 to 20 of 2949 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
