Fistly, on the good note, I just wanted to say that netTiers is really great and does save lots of work. However, there is one thing I can't handle and hope that the community can help figure this. I have done some searching and (my bad, possibly) can't find an easy solution for my problem.
I am writing a little application, part of its functionality allows users search by user name and full name from profile. The user base is asp.net membership based and user's Full Name is part of user's profile. Asp.Net membership does not provide built-in tools for searching within user's profiles so I had to toss a dll for ms SQL assembly, wrap it with a couple of functions and a view.
To cut this short, I ended up with a stored procedure that takes a string as an argument and returns list of users with this string entry in their user names and full names.
What I do next, is I envoke this SP with:
(DataSet)result =
DataRepository.Provider.ExecuteDataSet("_cust_QueryProfiles_ByName", tb_searchString.Text);and then bind it to a GridView
GridView1.DataSource = result;
GridView1.DataBind();
the GridView columns are as follows:
<
Columns>
<asp:HyperLinkField HeaderText="NickName" DataTextField="UserName" SortExpression="UserName" />
<asp:BoundField HeaderText="FullName" DataField="FullName" />
<asp:BoundField HeaderText="DrinkerType" DataField="DrinkerTypeName" />
</Columns>
The questions I have are:
how do I get the paging and sorting to work and how do I sort the HyperLinkField to point to a specific URI? (something like http://host.com/userview.aspx?UserName)
Are there any methods/classes or generally, a better approach to get this?
Many thanks for all your replies!