CRUD operation in GridView using StoreProcedure

Question

0.00/5 (No votes)

See more:

Hi All,

1.I need a query to join 2 databases
eg: 1st database contain dbo. employee table and second database contains dbo.attendance table
i would like to join these to tables and store it in a storeprocedure in 1 of the database
2.I would like to perform crud operation with the same storeprocedure

Posted 12-Jun-13 18:28pm

Kaushik.Subramanian

Updated 12-Jun-13 18:43pm

v2

Add a Solution

Comments

Ron Beyer 13-Jun-13 0:32am

CRUD is 4 operations, all separate and distinct. Also, you can't store a database join in a stored procedure, you have to create a new database or table to store the merged data. Its difficult to answer this without more information on what you are really wanting to do.

_Amy 13-Jun-13 1:47am

What have you tried for it? Simply "i need" doesn't explains much about your question. Click on Improve question and provide the code block which you've tried.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MaulikDusara · Answer 1 · 2013-06-12T19:25:00

Hi,

Please review below links

How to perform Edit, Update, and Delete operation in GridView?[^]
Complete CRUD Operations using GridView[^]
CRUD Operation in GridView in ASP.NET (Add/Update/Delete) Programmetrically[^]
Create Read Update Delete (CRUD) data with a GridView and ObjectDataSource[^]
Basic Gridview CRUD operations[^]

CRUD operation in GridView using StoreProcedure

1 solution

Solution 1

Add your solution here

Preview 0

CRUD operation in GridView using StoreProcedure

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us