Below is my code in the Data access layer to get a list of data from the database.
public DataSet GetSHTemplateListByUserDA(string strUserID)
SqlCommand objSqlCommand = Execute.GetCommandObject();
objSqlCommand.CommandText = "SHR_Select_TemplateListByUser";
objSqlCommand.CommandType = CommandType.StoredProcedure;
Now the Stored Procedure "SHR_Select_TemplateListByUser" contains table with 8 columns.but, i want to display only 3 columns out of 8 in the radgrid.I think i need to convert Dataset to Datatable for this.So can anyone please tell me what code i need to add above.