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; }
create procedure spdisplay as begin select * from employee end
public DataSet sp_display() { var temp = obj.spdisplay(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)