there are different kind of joins available by sql like
inner join,left join,etc.by the following example i will show
how to do left join which i used in my application to
get data from two tables -

.Net framework 3.5 sp1 contains more features than
previous .net framework versions like 2.0,3.0,3.5

It's a very common requirment that you may want to
insert ad codes or some other texts in a joomla article
or elsewhere.I am going to show how it can be done so
that if you want some text like "{replace it}" will be
replaced by your code -

Gravatar.com is used to store one's avatar image according to email.
then if you comment in any application using your that email address
where gravatar image has been programmed then your avatar image will
be displayed in the application.

we can use DataSet to populate DataList or
GridView efficiently.DataSet is the best
option for accessing rows of tables.

it is easier to print part of page.the part of the page
may be under a div or panel.you can achieve this from code
behind file too as per requirement.here i showing only
in page lavel -

following are guidelines to develop modules
for dotnetnuke 5/6 with visual studio 2008/2010 -