Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
need C# code
April 20, 2011
In sql database the procedure displays output as
name a1 a2 a3 c1 c2 c3
ram 0 0 0 0 0 0
xy 34 56 44 sy sz sx
ty 0 0 0 0 0 0
Now i want to use this procedure and write a code in c#. I want out put as follows in dataset
Posted Date: April 25, 2011 Points: 20
first of all collect the result in one datatable by executing stored procedure and the use datatable.select method and iterate through each column so that you get new datatable as per u r req...
hope this helps...
Posted Date: July 24, 2011 Points: 20
try this .
Create view Table
SELECT (a1 + c1 ) AS Column1
SELECT (a2 + c2 ) AS Column1
SELECT (a3 + c3 ) AS Column1
Regards, Lakshmi Naraayanan.S
To post reply
Related Questions Related Questions
What is Code Access Security in .NET
protection in C#.NET source code
please check the code
need code in C#
Best ASP.NET Websites for Sample Code / Code Projects
Code to create setup file .net
Random Number code
how to convert code from vb to vb.net
Latest Forum Questions From The Same Category
To Achieve draw wave form from speaker outputs.
How to display the text in the second ck editor with strikes while extracting from database
Mail is working but I want send two excel file to each different person
how to display child nodes with headers and keeping the child nodes in a table
In DataGrid I have Two Dropdownlist, One in Header template and Item Template
Display data directly from database table to PDF using stored procedures in asp.net C#
How to install and use Dev Express ?
Dialogbox Custom Control
Custom Control in Winforms
I just started learning c#.net console application
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend