Want to become a Vibe Coder? Join Vibe Coding Training here
x
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 Aspire
.NET Core
.NET MAUI
.NET Standard
Active Directory
ADO.NET
Agile Development
AI
AJAX
AlbertAGPT
Alchemy
Alexa Skills
Algorand
Algorithms in C#
Android
Angular
Apple
Arbitrum
ArcObject
ASP.NET
ASP.NET Core
Augmented Reality
Avalanche
AWS
Azure
Backbonejs
Base Blockchain
Big Data
Bitcoin
BizTalk Server
Blazor
Blockchain
Bootstrap
Bot Framework
Business
Business Intelligence(BI)
C#
C# Corner
C# Strings
C, C++, MFC
Career Advice
Careers and Jobs
Chapters
ChatGPT
Cloud
Coding Best Practices
Cognitive Services
COM Interop
Compact Framework
Copilot
Cortana Development
Cosmos DB
Cryptocurrency
Cryptography
Crystal Reports
CSS
Current Affairs
Custom Controls
Cyber Security
Data Mining
Data Science
Databases & DBA
Databricks
Design Patterns & Practices
DevExpress
DevOps
DirectX
Docker
Dynamics CRM
Enterprise Development
Entity Framework
Error Zone
Exception Handling
F#
Files, Directory, IO
Flutter
Games Programming
GDI+
General
Generative AI
GO
Google Cloud
Google Development
Graphics Design
Graphite Studio
Hardware
Hiring and Recruitment
HoloLens
How do I
HTML 5
Infragistics
Internet & Web
Internet of Things
Ionic
Java
Java and .NET
JavaScript
JQuery
JSON
JSP
Knockout
Kotlin
Kubernetes
Langchain
Leadership
Learn .NET
Learn iOS Programming
LINQ
Machine Learning
Metaverse
Microsoft 365
Microsoft Fabric
Microsoft Office
Microsoft Phone
Microsoft Teams
Mobile Development
MongoDB
MuleSoft
MySQL
NEAR
NetBeans
Networking
NFT
NoCode LowCode
Node.js
Office Development
OOP/OOD
Open Source
Operating Systems
Oracle
Outsourcing
Philosophy
PHP
Polygon
PostgreSQL
Power Apps
Power Automate
Power BI
Power Pages
Printing in C#
Products
Progress
Progressive Web Apps
Project Management
Prompt Engineering
Public Speaking
Python
Q#
QlikView
Quantum Computing
R
React
React Native
Reports using C#
RevealBi
Robotics & Hardware
RPA
Ruby on Rails
RUST
Salesforce
Security
Servers
ServiceNow
SharePoint
Sharp Economy
SignalR
Smart Devices
Snowflake
Software Architecture/Engineering
Software Testing
Solana
Solidity
Sports
SQL
SQL Server
Startups
Stratis Blockchain
Swift
SyncFusion
Threading
Tools
TypeScript
Unity
UWP
Vibe Coding
Visual Basic .NET
Visual Studio
Vue.js
WCF
Wearables
Web API
Web Design
Web Development
Web3
Windows
Windows Controls
Windows Forms
Windows PowerShell
Windows Services
Workflow Foundation
WPF
Xamarin
XAML
XML
XNA
XSharp
Register
Login
1
Answer
regarding TableData Adapters?
petre ricardo
15y
2.7k
0
1
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?
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
DB-Direct and batch update patterns in designing DAL?
How do i write code to handle exceptions in the DAL if i use the designer to create DAL?