Click here to Skip to main content
15,893,722 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
using Linq, i need to retrieve value to dataset..

for normal query,

i have tried like this for normal select statement,


DataClassesDataContext obj = new DataClassesDataContext();


public DataSet display()
   {
       var temp = from value in obj.employees
                  select value;
       SqlCommand cmd = (SqlCommand)obj.GetCommand(temp);
       SqlDataAdapter da = new SqlDataAdapter(cmd);
       DataSet ds = new DataSet();
       da.Fill(ds);
       return ds;
   }



But for stored procedure..
SQL
create procedure spdisplay
as
begin
select * from employee
end


public DataSet sp_display()
   {
       var temp = obj.spdisplay();

   }


how to retrive the values to dataset.
Posted

1 solution

 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900