So Helpful. Thanks again. sepel

Thank Manas. I find Some Code sample? sepel

Sorry.I found there are some article in this site after I had wrote my post. sepel

Thanks for your replay. I found the solution: http://professionalaspnet.com/rss.aspx[^] sepel

The first question is that is your indexing correctly (on all ID columns and ParentID columns). The other question is that do you really want to retrieve all rows. You propably have somekind of where clause when you query the data. You should also build indexes to support that query. Just a sidenote, you don't have to have 3 table. If the columns in all tables are (almost) the same, yuo can combine the data into 1 table. However, I think that's not where you should start from. The need to optimize rises from a bad design.My articles[^]

It rises error yet: Server Error in '/MySite' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /MySite/Sale/find.aspx I think i must change /MySite/Sale/find.aspx to /MySite/find.aspx. It means i must rewrite Relative Path of httpCuntex.But I don't know how? sepel modified on Tuesday, January 13, 2009 4:54 AM

Yes, I set it in the web.config. My local IIS version is 5.1. thanks ok

tnx. i try it. sepel

you have to connect to the database!!! dont you know how? Download Microsoft tutorial videos Absolute Beginners Lessons (from BOB TUBOR) on Visual Studio 2008. :doh: nelsonpaixao@yahoo.com.br trying to help & get help

sepel wrote: how about bind to a view? READ THE FREAKING DOCUMENTATION AND STOP TYPING INTO INTERNET FORUMS!!!!!!!! :mad: Oh, and have a nice day. led mike

Use inheritance in your database, so you can add different subclasses of Advert later. From our docs: In this example, a ServiceProduct and a StockProduct table are defined. Both primary key columns are also declared as foreign keys referencing the Product.Id column. These relationships guarantee that for every ServiceProduct or StockProduct record there will be a corresponding Product record with the same Id. Effectively these two tables inherit from the product table... Mark Churchill Director, Dunn & Churchill Pty Ltd Free Download: Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio. Alpha release: Entanglar: Transparant multiplayer framework for .Net games.

Yes, sorry my bad for not be more clear. :-O

Hahahah.(MySexCell) it is a cell that for male or female that saved in bit format in db, show corespond string such as "man or woman or Mr or Mrs,...". i think i should use Attribute . tnx sepel

but i think to use AddRang function. sepel

sepel wrote: yes i want to save a font for each control (for example: textbox). i think there should be a solution for it .as same as we save image or file in database. You can neither save images nor files in a database. An images is converted into a byte array before it's saved in the database. The contents of the file is read as a byte array before it's saved in the database. It's the same with a Font object. You can't save the object in the database, you have to take the information from the object and package as data that can be saved in the database. Despite everything, the person most likely to be fooling you next is yourself.

You could use a rich text box and save in the RTF format. Of course, you could also create your own (simplified) format, but this would be much work. regards

tnx.you are right. using server.Mappath return local path(e:\...). sepel