Hi..

I am a beginner C# programmer and I did some simple program with database(mssql 2005) but i think my coding system is poor because I found some of codes that are redundant, one of the example is the execution of the query.
what i want to happen here is to normalize my code and to find better techniques on coding.

what are the things I need to learn and to study? to make my learning faster....
what will I do so that my code are not redundant?

somebody here please...i need your opinion....

thanks....




http://www.johnalsopinsurance.com/

How about posting some code to look at and discuss? We'd be happy to help!

Especially the code for execution of a query because as far as I know, with the exception of LINQ, it hasn't changed much since 1.1?

As for learning and studying, I would say you definatly need a firm grasp on Data Access, logical blocks (if, while, switch etc). Like any other trade, a lot of the rest comes from experience, blood, sweat, maybe some tears and lots more work ;)

Rob
http://robzyc.spaces.live.com

Some basic guidelines to reducing redundancy:

- When you find yourself copying and pasting the same chunk of code to use elsewhere, think about putting it into a reusable method.
- When you need to reuse code in different files (i.e. other classes) you'll need to explore creating utility classes (helpers). For this you'll need to learn how to construct your own classes, and where you can put them in order to reuse them.
- When you need to reuse code in different assemblies (i.e. other applications) you'll need to explore creating shared class library assemblies. For this you'll need to learn how to work with binary/project references and namespaces.

Unfortunately, there is a lot to learning how to write code efficiently. It is very much a crawl/walk/run metaphor. As Rob said, only years of experience will make you very efficient. In spite of that, you'll always find a better and faster way to do something. No one can become an expert overnight.

-Peter
compiledthoughts.com