In Database:
Create Procedure ProcedureName
as
Begin
Select * From TableName
End
In Front End
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("ProcedureName", con);
DataSet ds = new DataSet();
da.Fill(ds, "result_name");
DataTable table = ds.Tables["result_name"];
return table
HOPE ITS CLEAR