using Dataset and DataTable to display selected columns

Joined
Jul 5, 2011
Messages
2
Reaction score
0
Hi,

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.Parameters.AddWithValue("@USER_ID",strUserID);
objSqlCommand.CommandType = CommandType.StoredProcedure;
return Execute.ExecuteDataset(objSqlCommand);

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.

many Thanks,
Arun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,733
Messages
2,569,440
Members
44,832
Latest member
GlennSmall

Latest Threads

Top