how to do ? :)

thanks man but u didn't tell me how to acess data of recepts and factures ! where the number is a auto increment number

thanks man !! i'll check it

thanks man but OoOoOps the site don't open

You're welcome.;) WhiteSky

It's those little (read: HUGE) tidbits that make all the difference in the world when you ask a question in a forum environment. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

so man can u give me an example of error handeling where there is more than one exception thanks

Lord Hasan wrote: so here i should make 4 procedure 4 these instructions Well, it depends. Do you access them all together all the time. Or do you need to access them individually. When you display a customer order you will likely need to get a row from the orders table and several rows for each line item in the order. Rather than write two stored procedures, you can combine both SELECTs in to one stored procedure because you are always getting both bits of information at the same time. Lord Hasan wrote: so more than hundred procedure Like I said, 100 stored procedures isn't that much. The system I'm currently working on has well over 300 stored procedures. I've worked on systems with less, and I've worked on systems with much more. When you write, say, C#, do you worry that you are writing thousands of methods? on dozens of classes? Probably, because there is no object orientation in the database and all stored procedures appear together does it seem more daunting. The key, I've found, is to have a good naming convention. That way you can find things easily and you will be able to work out what that stored procedure was you created last year but haven't needed to use since. Upcoming events: * Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

Use the WindowsControllibrary project or right click on your existing project select add then add new item then select usercontrol.

What you describe is a tree. Depending on the direction you want to go in the tree you should choose 2 or 3: 2 if you go from the root to leafs (you have the house and you want the rooms) or both ways (previous + you know the room and want to find the house it belongs). Choise 3 is more complete and memory used to keep the pointer to house is small 4B. Usualy I do like this: a row in a table contains all the members of a class - each row = object; procedures that insert/update/delete in the database are methods of the class, each method calling corresponding stored procedure. Columns (members of classes) are accessed (read/write) through properties or functions offering a good consistency check even from the input of data.

Maybe you should post a bigger junk of code or help explain the situation in further detail . I tested your code also and it works perfectly. Something else has to be going on.

hello again man we have now a new problem with this structure i'm doing that but the application became so slow !! espacilly by filling listviews and combos WHY we don't use ADO.NET things, like data sets and bind them in a listview !!! i'm comfused !!! " I love deadlines. I like the whooshing sound they make as they fly by. "

Lord Hasan wrote: how to put sql server instances running on the local area network in a combo A little Searching goes a long way. Here is an article that showed up Searching "SQL Server Network" here at Code Project. Finding SQL Servers on the Network[^] If your having specific issues then post those instead of a very general question, which is why no one responded to you. I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

men help

try this one. it is much simplier Private Sub LV_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader) With LV .SortKey = ColumnHeader.Index - 1 .SortOrder = lvwAscending .Sorted = True End With End Sub geboy

thanks man i solved the problem thanks alot ;)

that's what i need. thanks a lot , you made it. so 'll search the web now to know about the BLL and DAL.

please, i'm using th VS.net can u tell me how or give me the code. thanks

hello thanks it was a good idea and it works thanks