C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
.NET
.NET Assemblies
.NET Core
.NET Standard
Active Directory
ADO.NET
Agile Development
AJAX
Alexa Skills
Algorithms in C#
Android
Angular
Architecture
ArcObject
Artificial Intelligence
ASP.NET
ASP.NET Core
Augmented Reality
Aurelia
AWS
Azure
Backbonejs
Big Data
BizTalk Server
Blockchain
Bootstrap
Bot Framework
Business
C#
C# Corner
C, C++, MFC
Career Advice
Chapters
CIO
Cloud
COBOL.NET
Coding Best Practices
Cognitive Services
COM Interop
Compact Framework
Cortana Development
Cryptocurrency
Cryptography
Crystal Reports
Current Affairs
Custom Controls
Cyber Security
Data Mining
Databases & DBA
Design Patterns & Practices
DevOps
DirectX
Dynamics CRM
Enterprise Development
Entity Framework
Error Zone
Exception Handling
Expression Studio
F#
Files, Directory, IO
Games Programming
GDI+
General
Generative Engine Optimization (GEO)
Google Cloud
Google Development
Graphics Design
Hardware
Hiring and Recruitment
HoloLens
How do I
HTML 5
Internet & Web
Internet of Things
Ionic
iOS
Java
Java and .NET
JavaScript
JQuery
JSON
JSP
Knockout
kotlin
Leadership
Learn .NET
LightSwitch
LINQ
Machine Learning
Microsoft 365
Microsoft Office
Microsoft Phone
Mobile Development
Multithreading
Nano Banana
NetBeans
Networking
Node.js
Office Development
OOP/OOD
Open Source
Operating Systems
Oracle
Outsourcing
Philosophy
PHP
Power BI
Printing in C#
Products
Progressive Web Apps
Project Management
Python
Q#
QlikView
R
React
Reports using C#
Robotics & Hardware
Ruby on Rails
Salesforce
Security
Servers
SharePoint
SignalR
Silverlight
Smart Devices
Software Testing
SQL Language
SQL Server
Startups
String in C#
Swift
TypeScript
Unity
UWP
Visual Basic .NET
Visual Studio
WCF
Wearables
Web Development
Web Services
Web3
Windows 10
Windows Controls
Windows Forms
Windows PowerShell
Windows Services
Workflow Foundation
WPF
Xamarin
XAML Standard
XML
XNA
XSharp
Register
Login
1
Answer
regarding TableData Adapters?
petre ricardo
15y
2.4k
0
1
Active Directory
Reply
Hi,
As recommended by MS, i use the Designer to create Optimistic concurrency enabled DAL.
In it we have to create a Table Adapter, i can understand up to "Choose methods to Generate" where i give name for method that fills the Data table and Name the method that returns the DataTable. by default thsi is set to Fill() and GetData().
I use stored "use existing stored procedures" in the "chose command type" dialog. After click to finish it added the
following line in the designer table "Fill" and "GetData( )".
I have few question regarding the table that is created:
When i use the stored procedure the table name of the designed table (the table like Icon that displays on the .XSD), the table name is assigned with the name of the stored procedure. the method i create in the designer GetData() assigned values to select, update, Insert and delete commands. THis GetData() will return all the rows of the table.
Assume i need to create a search method that will search an item by index and i want to name it as GetItemsByIndex(Index), i have to right click on the
TableDataAdapter --> add Query --> select from existing Stored Procedure
à
Select the new stored procedure that search from index
à
select tabular data
à
named the fill and Getdata methods
à
finish
When I click Finish it throws this error : "The new command text returns data with schema different from schema of the main query, check your queries command text is this is not desired ",
ERROR:
When I do preview of the data of the data returned by GetItemsByIndex() by right click
à
preview data it doesn't display the data properly.
But when I create a new DataTable in the .XSD with a new
TableDataAdapter
then I create a new method to fetch data then only it works.
I don't understand why I can only add one method (a GetData method) with Optimistic concurrency and if I need to add another (assume GetItemByIndex(index))
I need to create a another table with a new TableDataAdapter,
How do I add more than one method that will return table data with optimistic concurrency under on TableDataAdapter?
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Post
Reset
Cancel
Answers (
1
)
Related Discussion