Tuesday, December 30, 2008

Make Money From Free E-books!

Have you ever wandered how those marketers that give away ebooks and reports actually benefit from doing so? It might seem a little strange that someone would put their time and effort into creating a quality product and then just give it away for nothing but there is an excellent reason for marketing this way, you see, those free ebooks will generate sales and leads for years to come, all on the backend.

What is the purpose of a free ebook?
The purpose of a free ebook is to drive traffic to a website that will result in sales, subscribers, adsense clicks or any other goal you may want to achieve. The main purpose for a free ebook is presell/generate leads for a paid product, For more details visit to www.create-own-ebook.com .You would presell by explaining advantages and benefits subtly in the ebook and generate leads by providing links within it.

How do I create one?
let's say you have a product about gardening that you sell for $47, you could then write a short report that would compliment that product such as a review, a short extract of it, a short report about gardening that would not go into as much detail as your paid product, the point is that it is very relevant to your paid product but does not have as much value, I mean you don't want to give away a free ebook that reveals all the methods contained in your paid one, you just want to generate interest for it.

How do I distribute it?
You can distribute a free ebook in a number of ways such as in your signature file at forums, to your email subscribers, free ebook directories, your website, arranging joint ventures with other marketers, there are many different ways to distribute your free ebook, To know more logon to www.create-free-pdf.com .You just have to find where your target audience is and offer them your ebook, most people love to get stuff for free so you shouldn't have to much trouble trying to get them to take it.

How do I get my ebook to go viral?
This is one of the most powerful ways to market online, viral marketing; you want your ebook to spread as far as possible and to reach as many prospects as you can so you should give people a reason to pass your ebook on to others for you. This can be done by allowing people to "rebrand" your ebook, basically you allow them to replace the links to your products with their affiliate links, and therefore the people who pass on your ebook can actually make money doing so. If people have a good reason to pass your ebook on, then they more than likely will.

Free ebooks can be an extremely effective way to advertise your website and products and if you can put the effort in and make a great product, then it is possible it will generate you sales and leads for years to come.
read more......

Sql Server Integrated Services Package Deployment

SQL 2005: SQL Server Integration Services
Package Deployment

Introduction

A decent amount of material has been covered in this introductory series on SQL Server 2005 Integration Services. Many of the basic data flow tasks have been covered along with some database maintenance tasks. It is now time to put these techniques into use.

Scenario

The package development is now complete and it is time to move the package into a working environment whether it is a testing environment or a production environment. Using some file configurations settings and SQL Management Studio, the developed packages will be deployed to a SQL server.

Implementation

If you have worked all the way through the series, you will have several packages to import. All though they each build on top of one another, this will give a good example on how to deploy several packages that are under the same SSIS project. So the first issue is how SQL server finds dtsx files. There are numerous ways but one that I prefer is to add some settings to the integration services configuration file to tell SQL server where to look for dtsx packages. Go ahead and open up Windows Explorer and navigate to C:Program FilesMicrosoft SQL Server90DTSBin.

1
[Click to see full-size]

Then open up MsDtsSrvr.ini in your favorite text editor add a meaningful name denoting the types of packages are contained in the folder and also add the physical folder path to where the dtsx files are located. For this example, Dev is the name and C:SSIS is the folder path of where the files are stored. The completed changes should look like the highlighted area in the following screen shot.

Please Visit Programminghelp.com For the full article and pictorial tutorial.

http://www.programminghelp.com/database/sqlserver/sql-server-integrated-services-package-deployment/

read more......

Linq Projection in Vb

This tutorial was created with Microsoft Visual Stuio.NET 2008. 2005 can be used, but you must install Microsoft's LINQ Community Technology Preview release.

In this tutorial we will look at LINQ Projection, which is when we can select specific data from a source without retrieving all fields. We will be creating a class to define a list in which we will create a number of people with IDs, names and cities. Then we will use buttons to select only parts of this data.

First, we will start off by creating a new Windows Form application in VS.NET 2008. Next, we will create a class - call it aList - and define our list object:


Public Class aList
Private _personID As Integer
Private _name As String
Private _city As String

Public Property PersonID() As Integer
Get
Return _personID
End Get
Set(ByVal value As Integer)
_personID = value
End Set
End Property

Public Property Name() As String
Get
Return _name
End Get
Set(ByVal value As String)
_name = value
End Set
End Property

Public Property City() As String
Get
Return _city
End Get
Set(ByVal value As String)
_city = value
End Set
End Property
End Class

This class defines a Property for each field we want, and its data type.
Next, we can add our Controls to the Form. We will add three buttons, and a Rich TextBox. The buttons will retrieve all of the IDs, Names and Cities, individually. This will demonstrates how we can retrieve the specific data that we want. Once we have our controls, we can move onto the code-behind of the form and define our data. We will add a few sample entries:

Please visit Linqhelp.com to complete this article. Happy Coding!

read more......

Linq Projection in C#

In this tutorial we will look at LINQ Projection, which is when we can select specific data from a source without retrieving all fields. We will be creating a class to define a list in which we will create a number of people with IDs, names and cities. Then we will use buttons to select only parts of this data.

First, we will start off by creating a new Windows Form application in VS.NET 2008. Next, we will create a class - call it aList - and define our list object:


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace LINQProjection_cs
{
class aList
{
private int _personID;
private string _name;
private string _city;

public int PersonID
{
get
{
return _personID;
}
set
{
_personID = value;
}
}

public string Name
{
get
{
return _name;
}
set
{
_name = value;
}
}

public string City
{
get
{
return _city;
}
set
{
_city = value;
}
}
}
}

This class defines a Property for each field we want, and its data type.
Next, we can add our Controls to the Form. We will add three buttons, and a Rich TextBox. The buttons will retrieve all of the IDs, Names and Cities, individually. This will demonstrates how we can retrieve the specific data that we want. Once we have our controls, we can move onto the code-behind of the form and define our data. We will add a few sample entries:

Please vist LinqHelp.com to complete this article. Happy coding!

read more......

Querying Table Data Using Visual Basic Code in Ms Access

In order to fully utilize the capabilities of MS Access, one must learn not only learn the Visual Basic (VB) programming language, but should also learn Standard Query Language (SQL). Once a grasp of these two languages have been obtained, MS Access users can begin to build faster and more efficient databases.

One tool that has proved itself very useful to me over the years is querying data from tables or queries using VB and SQL code. A brief introduction to this process is presented in this article. To best understand this process, an example is provided below along with an explanation of its parts.

‘*********CODE***********

Dim rstTemp As Recordset

Dim strSQL As String

Dim routeNum As Integer

strSQL = "SELECT [Route], [Main Route PM], [Intersecting Route], [IntBeginPM], [IntEndPM] “

strSQL = strSQL + “FROM Intersections_list WHERE (((CStr([Route])) = """ + cmbRouteQuery + """));"

Set rstTemp = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)

If (Not (rstTemp.EOF)) Then

rstTemp.MoveFirst

routeNum = rstTemp(0)

‘************************

After the initial variable declarations, the code assigns an SQL statement to the string variable strSQL. This statement directs Access to gather all the data in the Route, Main Route PM, Intersecting Route, IntBeginPM, and IntEndPM fields of the table named Intersections_list. Furthermore, it directs Access to only gather information from these fields where the Route field is equal to a value held in the combo box cmbRouteQuery.

Once the SQL statement has been set, it is passed to the next line of code which executes it. It should be noted that the dbOpenDynaset variable is built into Access and holds an integer value that changes the type of recordset to open. For most general purposes, using dbOpenDynaset will work just fine.

The “if statement” in the code example verifies that the recordset just created contains information. If information is present, the code directs Access to move to the first record in the recordset. The code then stores the route in the first record (routeNum = rstTemp(0)) in the variable routeNum to be used for later use.

read more......