hi,
I am using data sets and object data source that allows the user to enter a value to text box and search
the database.
Table PlayMePlaylist
TrackId - int
Name - nvarchar
UserId - unique identifier
first In the button click event, I redirect to another page passing query string as below
Response.Redirect("xxxxxxxxxxx.aspx?Name=" + TextBox1.Text.ToString());
In the new aspx page, I get the query string and bind the results to a gridview.
Select Method in Data set
SELECT UserId, FirstName, LastName, StageName, Address, CountryId, Brief, Date, Email, (SELECT CommonName FROM Country WHERE (CountryId = PlayMeArtist.CountryId)) AS CountryName, (SELECT TOP (1) FilePath FROM PlayMeImages WHERE (ArtistId = PLayMeArtist.ArtistId))
...
Go to the complete details ...