Save data into gridview

You cannot save the data into gridview. Rather you will display the data using gridview. For that
first Write a stored Procedure that returns dataset of the all the columns in the table emp.

Create Procedure getdetails
as
begin
select * from emp
end

Then Take a Class file and write a method that use the the above stored procedure.like

public dataset getdetails()
{
return sqlhelper.executedataset(strcon,commandtype.storedprocedure,"getdetails");
}

where strcon is your connection string

Then in the code behind file call this method by creating the object for the class and bind the returned data to tour gridview. like
cls obj=new cls;
dataset ds=obj.getdetails();
gridview1.datasource=ds;
gridview1.databind();

Hope this will help you. and sqlhelper above in class file needs microsoft.applicationblocks.data dll