Hello, We are working on an asp.net application. The application let's people search for items to purchase. The returned items will be displayed in an asp.net web page with about 50 items per page. We figure we will need to dispaly anywhere from 1 to 400 items
returned from the query of the database. Each item will have 1 to 3 images associated with it? What would be the best way to store this data. Should we use a collection of objects, or one of the C# collections such as SortedList Collection? I am new to C#,
having previously worked in C++ and Java. Your help is appreciated. Note that currently we are using the current code which uses a data list obtained from the ExecuteReader(...) Method. Here is the list of the code we are currently using. // create a connection
to the data base SqlConnection TheConn = new SqlConnection(connectionString); // create the command to call a stored procedure SqlCommand myCmd = new SqlCommand ("ET_GetTheProducts", TheConn); TheConn.Open(); // Execute the call to the sproc and set the returned
data as the //DataList's datasource DataList1.DataSource = myCmd.ExecuteReader(CommandBehavior.CloseConnection); // Bind the datalist with the data that was returned DataList1.DataBind();
rogerdotnet
Member
25 Points
5 Posts
Need C# and ASP.net advice for a list of data
Mar 24, 2004 04:55 PM|LINK