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 -

if you want to read get/read data from a file according to
querystring using StreamReader then following codes will
help you.It is very useful in some case.here i get data from
a ashx file according to query string i pass to the file -

by the following way you can resize a image to a predefined
dimension and resolution.you can also use it to make a image
thumbnails.

connecting Asp.net local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -

if you want to resize your asp.net textbox height according
to content then these codes will help you perfectly.

access database file is easy to use than sql server
or MySql server databases.for accessing access db
System.Data.OleDb namespace used.following are
steps are needed to use access db in .net
application.

the base keyword is used to access base class
members inside derived class.