TALLEY OURO BLOG

Data Audit With SSIS(VS 2005/2008)

2009-10-26T13:15:00.000-07:00

Hi,

Here are the steps required to perform sql data tables audit using SSIS
SSIS=SQL Server Integration Services.

Requirements:

1-SQL 2005/2008 Developer or Standard or Enterprise Edition
2-Visual Studio 2005/2008 Pro or Team edition.
3-Microsoft Office Word

Visual Studio Express editions do not work with SSIS.

Here is the link :Download It

Thank you for passing by!

Talley
.NET Developer,Raleigh,NC

New I am learning ROR(Ruby On Rails).Very special Language

Let see how to use Dictionary/SortedDictionary classes from System.Collections.Generic(C#)

2009-09-30T20:41:00.000-07:00

Hi Readers,

Thank you again for your emails.I`ve been busy lately doing some code for my open source software i will be publishing next month.Again thank you for sending emails.I received 52 yesterday.

Today i will explain to you how to use these 2 classes Dictionary/SortedDictionary.

Dictonary

Step1:we have to import System.Collections.Generic:

using System.Collections.Generic;

Step2: we have to declare Dictionary object with new keyword

Dictionary dic = new Dictionary();

You have to remember that we are dealing with key/pair schema.

Step3:Now let`s add some items with Add(key,value) method

dic.Add(2000, "Talley");
dic.Add(10, "John");
dic.Add(200, "Sam");

Step4:Let`s use ContainsKey method to find values

if (dic.ContainsKey(2000))
{
string st = dic[10];
Console.WriteLine(st);
}
else
{
Console.WriteLine("No Match!");
}

You can also use ContainsValue method to query the Dictionay object.There are methods and
properties of Dictionay object you may have to take a look.
SortedDictionay and Dictonary classes have almost the same methods and properties except
SortedDictionay accepts ICompareras parameter like this:

SortedDictionary<string,int> sd=new SortedDictionary<string,int>(IComparer<string>();

SortedDictionary

In a SortedDictionary elements must be sorted when they are added, making insertion times slower.

Remember you could also link table columns to these Dictionay objects.

Thank you for stopping by.See you next time.
If you have any question concerning this post please feel free to send me email at
johnstalley@live.com

Talley
Software Developer,ISV
Raleigh,NC

How to insert the result set of a store proc or dynamic batch into a new table using SELECT INTO?

2009-09-27T10:42:00.000-07:00

Hi Readers,

Thank you for sending emails.I appreciate it.Now let do some coding.

Suppose you want to insert the result set of a store procedure or a dynamic batch into
a new table,but you do not know what the schema is that you need to create.
You can use SELECT INTO statement and OPENQUERY.Here is how it works:

1-SELECT INTO format

SELECT
INTO
FROM

ex:
SELECT CustomerID,CompanyName,Country
INTO US_Customers
FROM Northwind.dbo.Customers

NB Do not create US_Customers in Northwind database before executing the query.This table
US_Customers is created automatically for you after query execution.

2-The main query of concern(see title)

EXEC sp_serveroption,'data access',true;
SELECT *INTO FROM OPENQUERY(,'EXEC {(

That`s all i want to share with you today.
See you!

Talley Ouro
.Net Developer(Web&Smart Client Development)
Email: johnstalley@live.com

Adding NUnit Tool to any version of Visual Studio

2009-09-10T13:22:00.000-07:00

Hi Readers,

Thank you for sending me emails.I appreciated it.
Here is easy way to integrate Unit framework to Visual Studio.

1-First download NUnit at http://www.nunit.org/index.php?p=home

2-Copy nunit.framework.dll to the bin section of your project.

3-Add this reference to you project by right clicking on the project and click add reference

Now the dll is referenced to your project you can start using NUnit framework.

4-Go to Tools/External Tools(this task add NUnit tool to your visual studio-design time)

Thank you for visiting my blog.

Talley Ouro
Application Developer
Raleigh,NC

How to load a document with JavaScript?

2009-09-07T10:58:00.000-07:00

Hi Readers,

Thank you for sending me emails.I appreciate it.
Happy holiday to you and your families.

Here is a single function you can use to load a page:

function ViewDocument(strDocument)
{
strDocument = escape(strDocument);
if (strDocument != null) //or strDocument!=undefined
{
//window.open(strDocument,"resizable:yes;scroll:yes;status:no;");
window.open(strDocument);
}
else
{
alert("Document Unavailable");
}
}

Thank you for visiting my blog.

Talley
Web & Windows Developer
Raleigh,NC

How to animate images with JavaScript?

2009-09-01T09:20:00.000-07:00

Hi Readers,

Here are steps required to animate images using javascript:

Step1:Download AnimateByTalley.js from downlad page of my blog

Step2: create a new web form,add 2 htlm buttons and one image.
Everything should look like this:

Step3: reference AnimateByTalley.js in the head section of your page or
you can just copy the scripts and add it your page

That`s all you need to animate image with JS.

Thank you for visiting.
If you have any question or concern please feel free to email me
at johnstalley@live.com

Talley Ouro
Web & Windows Application Developer
Raleigh,NC

CRUD operations with LINQ To SQL(ASP.NET 3.5)

2009-08-31T21:34:00.000-07:00

Hi Readers,

Thank you for you emails.I appreciate it.
Here are some tips if you want to use LINK To SQL to select, insert,
delete and update known by CRUD.
I used ASP.NET AJAX web Template for this demo and VS 2008
Here are steps:

1-Add a new table called Users to Northwind database :

CREATE TABLE [dbo].[Users](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) NOT NULL,
[Password] [nvarchar](50) NOT NULL,
[Email] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

2-Create ASP.NET AJAX web app and make sure ScriptMaster is in place(without it
ajax functionality=null).Make also sure that Ajax ToolKit controls are in place.
Drop Tab Container on the design surface with 4 tabs:
-Query Task tab: to query and show result on GridView control
-Insert Task tab : to insert new records .
-Update Task tab: to update records
-Delete Task tab: to delete record.

Copy the source code Demo.Zip

Here is how it works:

A-For Query Task:

The goal of this task is to load data into GridView control via a button control:

' This code will query all users where UserName is not null

Dim users=From usr In db.Users _

Where usr.UserName IsNot Nothing _

Select usr

'This code bind users data to GridView control

Me.GridView1.DataSource=users

Me.GridView1.DataBind()

B-For Insert Task:

'I defined a new User class and i used the column names

'you need With which allows you select column names

'after you type .(dot) inside {} column names will appear automatically

Dim u as New User With {.UserName=me.txtUserName,.PassWord=me.txtPassWord,.Email=me.txtEmail}

'Now submit result on Insert and Update table

db.Users.InsertOnSubmit(u)

db.SubmitChanges()

C-For Update Task:

'This section is little loosy

'I select users where UserID=upUserID.txt

'You need these parentheses to make it work

'You need to specifiy single meaning you are

'updating only a single row

'match columns again fields

'finally update user table

Dim u=(From usr In db.Users _

Where usr.UserID=me.upUserID.txt _

Select usr).Single

u.UserName=me.upUserName.text

u.PassWord=me.upPassWord.text

u.Email=me.upEmail.text

db.SubmitOnChanges()

D-Delete Task:

'Tricky too

Dim p1=db.Users.First(Function(p) p.UserID=me.delUserID.text

db.Users.DeleteOnSubmit(p1)

db.SubmitChanges()

Run app and if everything is ok you should see something like this:

Do you know the Best developers IDE?

2009-08-28T17:27:00.000-07:00

Hi readers,
Thank you for your emails.I received 80 emails yesterday.
I appreciate it.

Here is the top 4 IDE for both .Net and Java Developers:

No1 Visual Studio 2008(Pro and Team Editions) from Microsoft.com
Why No1? Because all is visual (windows& web apps) and it has robust
framework behind it.

No2 Netbeans IDE from Netbeans.org(Java,C++,Ruby,PHP,Python..)
It has all except the visual part is missing except Swing(Java)

No3 Eclipse IDE(Java) from eclipse.org

No4 Aptana Studio (Java,PHP,Ruby,Perl) from aptana.com

There are still good IDE out there but these are the top one.

Thank you for reading.

Talley Ouro
johnstalley@live.com

Do you know which version of AJAX Toolkit to use for VS2005?

2009-08-28T17:21:00.000-07:00

Hi readers,
Thank you for your emails.I appreciate it.

If you have Visual Studio 2005 and wonder which version of Ajax ToolKit
to use then i have the answer.
The version to use is 20229

You can download it directly on my downlaod page HERE
If you are having problem clik HERE

That`s all i want to share with you today.

Thank you for visiting my blog!

Talley Ouro
johnstalley@live.com
Raleigh,NC.

2009-08-23T20:21:00.000-07:00

XScheduler will be release end September 2009 easten time.

XScheduler is an Advanced Document Management System,

Business Process System,Employee Task Management,Active

Directory Manager,Government Ressource Planning(GRP)

and more to come.

I published some screenshots from the program but these

screenshots are 1/200 of the screeshots and will be update

every friday.Thank you for reading and see you soon!

Talley Ouro,

Project Manager and Administrator

Cary,NC USA

johnstalley@live.com

How to get the current Primary Key from GridView(ASP.NET 2.0/3.5)?

2009-08-23T19:01:00.000-07:00

Hi Readers,

Thank you for your emails .I am very grateful to your emails.They help me
post more blogs even i am very busy debug codes.

Take a good look at this grid:

What if i want to update Documents table with this statement:

Update Documents SET Status='Active' WHERE DocumentID=Current selected row on gridview!!!!(Remember Document is a SQL Keyword)

Here are the easy way to do it(VB.NET):

Step1: fire RowCommand event from Gridview( ex GridView1_RowCommand ...Handles GridView1.RowCommand)

Step2: Use CommandName and CommandArgument properties

Ex commandname are :Edit,Update,Delete,Insert....
commandargument is used to find the primary key of currently select item on gridview

Here is the code within GridView1_RowCommand :

Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand

Dim itm As Integer
If e.CommandName.Equals("Edit") Then

itm = Convert.ToInt32(e.CommandArgument) REM get primary key of selected row on gridview
UpdateStatus(itm)
REM your code goes here.Update() is a function with parameter named itm.
It goals is to update Documents table based on selected row on the grid.

End If

End Sub

That`s all i want to share with you today.
Any question or if you want private training a lower cost please send
me email at johnstalley@live.com

Thanks
Talley Ouro
.Net Developer(VB.NET,C#,PHP,ASP.NET 2.0/3.5)

New To LINQ To SQL?Watch this video

2009-08-22T20:11:00.000-07:00

Introduction to Windows Live Cloud Services

2009-08-22T18:18:00.000-07:00

Hi readers,

All IT compagnies are moving from traditional computer systems into cloud computing.

The good news is Microsoft invested a lot into it.

As a programmer and a member of MSDN network i invested myself into this too.

I am working on a Business Process/Workflow program which will be published soon on sourceforge.net and i need a chat control for the chart section of my project.I created a C# class library project which has all the functionality i needed for chat purposes.But i need something quick and fast.I have 1000 lines of code to review .So i checked Windows Live Services and i found a control that fit my need.

Here is a link to live service: link

To get started with Windows Live Controls(work both with VS 2005/2005) i precompile required bin on my download page .Copy Live Chat Bin here

Here are the steps:

Step1: Unzip Live Chat Bin and copy them into the bin section of your web project.

Step2: Open toolbox window from VS ,add a new tab and select choose items.Locate the ddl from step1 and click ok .You should see something like this:

Step 3:Drag any control from the list( i picked MessengerChat in my case).

NB :Remember to set PrivacyStatementUrl in order for MessengerChat to work properly.

The output shoud look like this after you run the browser:

Again thank you for you emails.

Talley Ouro
johnstalley@live.com

.Net Web & Windows Developer

How to bind XML Data to GridView or DataGrid?

2009-08-20T20:26:00.000-07:00

Hi Readers,

Thank you for reading my blog.I received 40 emails yesterday.

Here is how to bind xml data to GridView or DataGrid:

Download aspnetbooks.xml source code here

Step 1:

-Add reference to System.Data and System.XML
In VB.NET :
imports System.Data
imports System.Xml

In C# :
using System.Data;
using System.Xml;

Step2:
-Drop a GridView or DataGrid on designer surface
-Double click on designer for Page_Load event

Step3:Add this code inside Page_Load

In VB.NET :

Dim ds As New DataSet
Dim XMLMode As New System.Data.XmlReadMode
ds.ReadXml(GetXMLPath("Demos/aspnetbooks.xml"))
Me.GridView1.DataSource = ds
Me.GridView1.DataBind()

I programmed GetXMLPath function which is:

Protected Function GetXMLPath(ByVal xmlpath As String) As String
Return Request.PhysicalApplicationPath & xmlpath
End Function

In C#:

DataSet ds=new DataSet();
System.Data.XmlReadMode XMLMode=new System.Data.XmlReadMode();
ds.ReadXml(GetXMLPath("Demos/aspnetbooks.xml"))
this.GridView1.DataSource = ds
this.GridView1.DataBind()

for the function:

protected string GetXMLPath(string xmlpath)
{
return Request.PhysicalApplicationPath + xmlpath
}

Note + sign instead of & inside GetXMLPath method(C# uses + while VB.NET uses &)

The code inside VS should look like this:

The output should look like this:

Thank you for reading.

Any question or if you need private online training please email me at
johnstalley@live.com

Talley Ouro
Raleigh,NC

Free HTML control for your VS 2005/2008 Projects

2009-08-20T12:19:00.000-07:00

Hi all,

Do you want this control in your VS(Visual Studio)2005/2008 projects?
If so please download the DLL and sample project i precompile for you.
Here is the link http://sites.google.com/site/developercodesclub/downloads

Steps:

1-Copy the DLL to the bin section of your project and refresh the project
2-Go to ToolBox and Rick Click on it and choose Add Tab ang give it a name.
3-Right Click on the newly name you gave on 2 and click on Choose Items.Locate
the HTML Editor dll on project bin(Winthusiasm.HtmlEditor.dll) and clickOK.
It should look like this :

4-Now drag it on designer surface and that is all.You can disable OK and Cancel Buttons on designer surface or from property window.

Pleas leave your comments on my blog.

Thanks you for visiting my blog.Keep coming for more blogs.

Talley Ouro
C#,VB.NET,ASP.NET,PHP,Java(use java for fun) Developer
Raleigh,NC

How to configure Visual Studio 2005/2008 to use Enterprise Library for Data Access?

2009-08-17T20:53:00.000-07:00

Here is the quickest way to configure visual studio to use Enterprise Library.

System Requirements:

-Microsoft Visual Studio 2005/ 2008 development system (any of the following editions):
Standard Edition
Professional Edition
Team Edition for Software Developers
Team Edition for Software Testers
Team Edition for Software Architects
Team Suite

-For the Data Access Application Block, the following is also required:

A database server running a database that is supported by a .NET Framework 2.0/3.5 data provider. This includes SQL Server 2000 or later

-To run the Unit Tests, the following is also required:

Visual Studio 2008 Professional or Visual Studio 2008 Team Edition. Enterprise Library includes both unit test binaries and source code.

-For the Logging Application Block, the following is also required:
Stores to maintain log messages. If you are using the MsmqTraceListener trace listener to store log messages, you need a message queue. If you are using the DatabaseTraceListener trace listener to store log messages, you need a database server. If you are using the EmailTraceListener trace listener to store log messages, you need an SMTP server.

After these requirements you need to download Enterprise Library 4.0 - May 2008
(It working fine for both VS2005/2008).
Download it here

After you download it open both Visual Studio 2005/2008 and Enterprise Configuration Libary tool(C:\Program Files\Microsoft Enterprise Library May 2008\bin bleu icon)

-After you open the config tool you need add Data Access Block from it.You will see this image

-Right Click(RC) on Enterprise Library Configuration and choose New Application

-After that RC on Application Configuration and choose New then Data Access Application Block

-Change the connection Name and string that will match the connection string of your applicatio.
Database=Database;//name of your database

Server=(local)\SQLEXPRESS;Integrated Security=SSPI //name of your server

-Save it on the location of your application aroung web.config or app.config

-Open VS 2005/2008 ,RC on web.config and add these 3 configurations between configuration tags(You can get this by openning the saved configuration from the tool)

That`s all you need to get started with Enterprise Library Configuration .
You are ready to start Data Access Block.

Talley Ouro,
Developer Cary,NC,USA
johnstalley@live.com

How to Enable Administrator Account on Vista

2009-08-16T21:43:00.000-07:00

Here are the steps to enable Administrator Account on VISTA:

1-Right Click on CMD prompt and choose Run As Administrator

2-When command windows pops up type the following command and press ENTER

net user administrator /active:yes

That`s all you need.

NB To disable the account use net user administrator /active:no

You need to restart LogOut your pc in order to take effect.

Talley Ouro
johnstalley@live.com

Best VB.NET 2005/2008 Books

2009-08-16T15:20:00.001-07:00

Hi,
If you want to become vb.net expert buy these books depending on what version of
.Net Plateform you are using.
You can buy them on bn.com.

SQL Server 2005 Authentication

2009-08-16T10:31:00.000-07:00

How a add SQL Login to SQL Server

FIRST STEP

1-Login to SSMS with Windows Authentication

2-Click on Security/Login

3-RC Login/Add New Login

4-Enter name/Choose SQL Authentication/Enter strong password(8 characters min with
special key @#...) and click OK.

SECOND STEP: Assign grants

1-Login in again with Windows Auth

2-Click on Databases then choose the db on which you want to assign User

3-Go to security(inside the db) then Users

4-RC Users/Add New User

5-Click on Eclipse after Login name and select login will popup

6-Enter first 2 letters of the user you want to add and click on Check Name Button

7-Choose the name of the user you added on first step and click OK twice.

8-Copy the same name on step 7 and paste on the textbox after Username

9-Under Schemas owned by this user choose appropriate schemas especially db_datareader,
db_datawriter,db_datacessadmin,db_owner).You can add more later.

10-Database role membership choose roles for this user(Usually the same as 9) and click OK.

You done with SQL Authentication.
Start SSMS and login with the user and password you just created. Make sure you choose SQL Server Authentication.

Solution to this error:Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

2009-08-13T11:11:00.000-07:00

Just turn off recursives triggers,views ,functions and store pro wich
cause the problem.
For trigger for example Go to SSMS,open the table in question,open trigger folder
and right click the trigger that cause the problem and choose disable.
You should be good to go.

Talley Ouro
Developer

Useful JavaScripts for DataGrid control

2009-08-08T11:39:00.000-07:00

This codes will help you with your datagrid activities.
You have to add a CheckBox to datagrid.

HTML Code

this html tag adds a checkbox to header 1-add asp:TemplateColumn tag
2-add HeaderTemplate tab
3-add input tag with id=checkAll,type=checbox,onclick=DGSelectOrUnselectAll('DataGrid1',this,'chkDel')

this html tag adds checkbox to datagrid 1-add ItemTemplate tag
2-add asp checkbox control within ItemTemplate tag with id=chkDel,RunAt=server

JavaScript codes:Add these js code in

section of HTML

this is to select or unselect the datagrid check boxes

function DGSelectOrUnselectAll(grdid,obj,objlist){
//this function decides whether to check or uncheck all
if(obj.checked)
DGSelectAll(grdid,objlist)
else
DGUnselectAll(grdid,objlist)
}
//----------

function DGSelectAll(grdid,objid){
//.this function is to check all the items
var chkbox;
var i=2;

chkbox=document.getElementById(grdid +
'__ctl' + i + '_' + objid);

while(chkbox!=null){
chkbox.checked=true;
i=i+1;
chkbox=document.getElementById(grdid +
'__ctl' + i + '_' + objid);
}

}//--------------

function DGUnselectAll(grdid,objid){
//.this function is to uncheckcheck all the items
var chkbox;
var i=2;

chkbox=document.getElementById(grdid +
'__ctl' + i + '_' + objid);

while(chkbox!=null){
chkbox.checked=false;
i=i+1;
chkbox=document.getElementById(grdid +
'__ctl' + i + '_' + objid);
}
}

If you have question please email me at johnstalley@live.com
My name is Talley Ouro,Developer in Raleigh,NC

How to hack "Failed to query a list of database names from the SQL Server"

2009-08-06T09:24:00.001-07:00

Sometimes ASP.NET Configuration Tool(ASP.NET) is a pain in the ass when trying to add aspnet.db for role management.

By default on Vista the current user on the machine is not a member of SysAdmin on SQL Server 2005/2008.

So here is the trick.

1-Open Sql Server Surface Area Configuration tool from C:\Program Files\Microsoft SQL Server 2005/2008.

2-When the screen pops up click on Add New Administrator.

-on top right make sure that User to provision=Username of the pc
-on your left (Available Privileges) select Member of SQL Server SysAdmin and click on the right arrow (>)
-click ok and you should be ready to go.

My name is Talley Ouro,Developer in Raleigh,NC
Blog: http://talleyblogs.blogspot.com/
Email:johnstalley@live.com

Code to add JavaScript confirmation dialog to a button in a datagrid

2009-08-02T23:07:00.000-07:00

Here is the code.It is free like "free beer".If you have question send me email at johnstalley@live.com.Remember datagrid index it 0 based.
NB You could add another parameter to the function that will execute when click=ok

public static void AddConfirm(DataGrid theGrid, int columnNumber, string question)
{
//for each row in the DataGrid
foreach(DataGridItem item in theGrid.Items)
{
//for each webcontrol in the column
foreach(WebControl control in item.Cells[columnNumber].Controls)
//if it is a LinkButton or Button
{
if(control is LinkButton || control is Button)
//add the attribute
control.Attributes.Add("OnClick", " javascript:return confirm('" + question + "');");
}
}
}

How to color a row of DataGrid in ASP.NET 2.0/3.5

2009-08-02T13:27:00.000-07:00

1-Here is the code in VB.NET 2005/2008
The name i gave empGrid to the datagrid.To do this go the property of datagrid and
click on the events section and double click on ItemDataBound event and add the code.

Protected Sub empGrid_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles empGrid.ItemDataBound

If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then

Dim drv As DataRowView = CType(e.Item.DataItem, DataRowView)
Dim Status As String = Convert.ToString(drv.Row.Item("Status"))

If Status = "Active" Then
e.Item.Cells(4).BackColor = Drawing.Color.Green

ElseIf Status = "Inactive" Then
e.Item.Cells(4).BackColor = Drawing.Color.Red

End If
End If
End Sub
1-Here is the code in C# 2005/2008
The name i gave empGrid to the datagrid.To do this go the property of datagrid and
click on the events section and double click on ItemDataBound event and add the code.

private void empGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView Drv = (DataRowView)e.Item.DataItem;
// Get fourth column value.The coloumn needed
String Status = Convert.ToString(rv.Row.ItemArray[4]);
if (Status =="Active")
{
e.Item.Cells[4].BackColor = Color.Green;
}
//Just add the remaining steps
}
}

This code is free like "Free Coffee"

Talley Ouro

Try free Live HTML and Javascript

2009-07-16T18:57:00.000-07:00

There is a new great tool on Mozilla.org website.
It name is Bespin.
With Bespin you can test your HTML and js codes online.

Here is the link to Bespin:
https://bespin.mozilla.com

You need to open an account with Mozilla project in order
to use Bespin

Enjoy it!

Talley

free PHP training in 1 month(Part III)

2009-02-01T16:55:00.000-08:00

Hi all,

Sorry i was busy.Now let start our first hello world program from PHP.

Steps:

1- Open your NetBeans IDE from Start Menu.

2-Go to File/New Project/Select PHP from Category/PHP application/Next/Give HelloWorld to application name/Click Finish.

After you finish you will see a page with a bloc of code for index.php.I will will explain to you more about this file later.

// put your code here
?>

Note1:
Every php application starts with .
The php code goes within

Note2:

You declare php variable with a dollar sign $ follow by the name of the variable.
For more info about definition go to php.net/documentation.

Let declare a variable named i and assign it 12;

$i='Hello World';

Note 3:
Single quote is best way to handle string.Do not use "" for strings.Any variable
within "" will be Executed.

Note 4:
Php comment is c# style // or /* */
Let print it to the browser.The best browser for php is FireFox.
Right click on the projoect HelloWorld/Properties/Debug/Deselect Debug Server with php/Seelect Debug client with Javascript/Choose FireFox and click OK.

Now let print $i to the browser.
add code like this:

$i='Hello World;
//to print hello world we use echo keyword or print

echo $i;

?>

Note 5:Every variable declaration end with ; like c#

Run the project :Right click on index.php/Run.

You will see Firefox showing Hello World.

Note6:
PHP is a loosy type.It mean you don`t have to define a variable type to use it.
Let me be clair.In C# if i want to declare an integer variable named i this is how i
will do it:

int i=12;
In php $i=12;so php is less trouble than c#,vb......

See you Next time.Remember to go to documentation section of php.net and copy
php keyword to a file named keyphp.txt on your desktop.

Talley John
Software Developer

free PHP training in 1 month(Part II)

2009-01-18T19:35:00.000-08:00

PHP IDE download

Download the Netbean IDE for free.
Click here to download it.

Make the IDE that contain PHP only for
now.
Familiarize yourself with that IDE and make
sure you explore it templates and toolbox items.

See you soon!
Talley John Ouro

free PHP training in 1 month(Part I)

2009-01-05T11:17:00.000-08:00

Welcome to php world.

PHP is a powerful server-side scripting language for creating dynamic and interactive websites.

PHP is the widely-used, free, and efficient alternative to competitors such as Microsoft's ASP. PHP is perfectly suited for Web development and can be embedded directly into the HTML code.

The PHP syntax is very similar to Perl and C. PHP is often used together with Apache (web server) on various operating systems. It also supports ISAPI and can be used with Microsoft's IIS on Windows

If your server supports PHP you don't need to do anything. Just create some .php files in your web directory, and the server will parse them for you. Because it is free, most web hosts offer PHP support.

However, if your server does not support PHP, you must install PHP.

Download PHP for free here: http://www.php.net/downloads.php

Download MySQL for free here: http://www.mysql.com/downloads/index.html

Download Apache Server

Download Apache for free here: http://httpd.apache.org/download.cgi

REMEMBER YOU NEED TO INSTALL APACHE AND MYSQL BEFORE INSTALLING PHP
See you next time for Part II

Talley J Ouro
Developer

Try the most advanced HTML Editor

2008-12-25T09:17:00.000-08:00

Hi my reader,

I want to share this HTML Editor and you won`t regret.It is free
Come back for more.

HTML EDITOR

TALLEY . OURO

Download your free copy of VS 2008

2008-12-19T17:19:00.000-08:00

For new programmers in need of development platform there are free tools on
Microsoft website.

FREE Visual Studio 2008 Express.

Have a question?
Need help with your code?
Need to be trained with VB.BET(2003/2005/2008),C#(2003/2005/200),SQL(2005/2008),ASP.NET,SQLAnywhere?

Email me at talleyabibou@hotmail.com

TALLEY J.OURO
Software Developer & IT Consultant

Speed your .net development with SQL Anywhere 11 Developer Edition

2008-12-19T17:06:00.000-08:00

Programming with VB.NET,C#,J#,C++,Java and more required the knowledge of database such as SQL, DB2,PostgreSql,Oracle, Java DB.
The most popular is SQL follow by Oracle.That does not mean to limit yourself to these two.
Knowledge of SQL Anywhere is also useful.
To download your free version of SQL Anywhere Developer Edition please click on the link below.

Download free SQL Anywhere 11 Developer Edition

Good luck!

TALLEY J OURO
Developer

SQL 2008 Training

2008-12-17T17:45:00.000-08:00

I am providing SQL 2008 training online at very low
cost.
Also see below for other programming training such as
VB.NET 2008,C#,ADO.NET 3.0 and more.
For more information see contact info.
Good Luck!

TALLEY JOHN OURO.
Software Developer.
Discussions: http://groups.google.com/group/talleygroup/

Securing your Website with ASP.NET 3.0

2008-12-17T16:51:00.000-08:00

Enjoy this video . You need Visual Web Developer 2005/2008 Express edition. If you need help please send me an email. TALLEY JOHN OURO. Software Developer(.Net and Java).
Talley J Ouro

Build Excel with Java

2008-11-11T20:45:00.000-08:00

This program i wrote in Java is all you need to create an Excel program.
You need Java 2 and Netbeans IDE .
Good Luck!
If you need the code You know where to find me.
Talley

----------------------------

VB.NET/C# (2003/2005/2008)training

2008-11-07T21:04:00.001-08:00

I am prodiving training with VB.NET(2005/2008),C#(2005/2008) for a period of 3 months
in the U.S.A ,France et Britain.
If you want to enroll please request registration form at :
training.africtek@live.com
See you there .
5 students per class.

Course title: Extreme programming with C#(2005/2008) or VB.NET(2005/2008)

Chapter1: Introduction to .Net Framework
Chapter2: User interface.
Chapter 3: Types and members.
Chapter 4: OOP(Object Oriented Programming)
Chapter 5: Testing and debugging your application.
Chapter 6: Data Access programming
Chapter 7: Controls and .Net
Chapter 8: Configuration and security
Chapter 9: Printing with .Net
Chapter 10: Samples applications.
Chapter 11: Deploying your applications with Windows Installer,ClickOnce or Updater block V2

TALEY JOHN OURO

Windows 7 Preview

2008-11-07T05:53:00.000-08:00

Copy and paste on your browser.I was having problem with my HTLM Editor

http://news.bbc.co.uk/1/hi/technology/7696648.stm

Custom Backgroundworker with VB

2008-11-05T17:21:00.000-08:00

Hi All,

Here is a sample code of how to create a class that implement a custom backgroundworker with VB.NET 2005/2008;
Prerequisite: you have to be familiar with Delegates and Events.

1-Create a new project.
2-Right click on the project name and choose Add New Class
3-Name the class tBackgroundWorker.
4-Imports System.ComponentModel
5-Serialize this ToolboxBitmap with follow by the class tBackgroundWorker.Usen _ if necessary.

Namespace AFRICTEK

_
Public Class BackgroundWorker : Inherits System.ComponentModel.Component
Private _CancelPending As Boolean = False
Private _ReportsProgress As Boolean = False
Private _SupportsCancellation As Boolean = False

Public Event DoWork As DoWorkEventHandler

Public Event ProgressChanged As ProgressChangedEventHandler

Public Event RunWorkerCompleted As RunWorkerCompletedEventHandler

Private Sub ProcessDelegate(ByVal delegateToProcess As System.Delegate, ByVal ParamArray args As Object())
If delegateToProcess Is Nothing Then
Exit Sub
End If

Dim delegates As System.Delegate() = delegateToProcess.GetInvocationList
For Each handler As System.Delegate In delegates
InvokeDelegate(handler, args)
Next
End Sub

Private Sub InvokeDelegate(ByVal delegateToInvoke As System.Delegate, ByVal args As Object())

Dim synchronizer As System.ComponentModel.ISynchronizeInvoke = Nothing
If GetType(System.ComponentModel.ISynchronizeInvoke).IsInstanceOfType(delegateToInvoke.Target) Then
synchronizer = DirectCast(delegateToInvoke.Target, System.ComponentModel.ISynchronizeInvoke)
End If

If Not (synchronizer Is Nothing) Then ' A windows Form object
If synchronizer.InvokeRequired = False Then
delegateToInvoke.DynamicInvoke(args)
Return
End If
Try
synchronizer.Invoke(delegateToInvoke, args)
Catch ex As Exception
End Try
Else ' Not a windows form object
delegateToInvoke.DynamicInvoke(args)
End If

End Sub

Private Sub AsyncOperationCompleted(ByVal asyncResult As IAsyncResult)

Dim doWorkEventDelegate As DoWorkEventHandler = CType(CType(asyncResult, System.Runtime.Remoting.Messaging.AsyncResult).AsyncDelegate, DoWorkEventHandler)
Dim doWorkArgs As DoWorkEventArgs = CType(asyncResult.AsyncState, DoWorkEventArgs)
Dim result As Object = Nothing
Dim doWorkEventError As Exception = Nothing

Try
doWorkEventDelegate.EndInvoke(asyncResult)
result = doWorkArgs.Result
Catch ex As Exception
doWorkEventError = ex
End Try

Dim completedArgs As RunWorkerCompletedEventArgs
completedArgs = New RunWorkerCompletedEventArgs(result, doWorkEventError, doWorkArgs.Cancel)
OnRunWorkerCompleted(completedArgs)
End Sub

Protected Overridable Sub OnRunWorkerCompleted(ByVal completedArgs As RunWorkerCompletedEventArgs)
ProcessDelegate(RunWorkerCompletedEvent, Me, completedArgs)
End Sub

Public Overloads Sub RunWorkerAsync()
RunWorkerAsync(Nothing)
End Sub

Public Overloads Sub RunWorkerAsync(ByVal argument As Object)
Me._CancelPending = False
If Not (DoWorkEvent Is Nothing) Then
Dim args As DoWorkEventArgs
If argument Is Nothing Then
argument = New Object
End If
args = New DoWorkEventArgs(argument)
Dim callback As AsyncCallback
callback = AddressOf Me.AsyncOperationCompleted
DoWorkEvent.BeginInvoke(Me, args, callback, args)
End If
End Sub

Public Overloads Sub ReportProgress(ByVal percent As Integer)
Me.ReportProgress(percent, Nothing)
End Sub

Public Overloads Sub ReportProgress(ByVal percent As Integer, ByVal userState As Object)
If WorkerReportsProgress Then
Dim progressArgs As ProgressChangedEventArgs = New ProgressChangedEventArgs(percent, userState)
OnProgressChanged(progressArgs)
End If
End Sub

Protected Overridable Sub OnProgressChanged(ByVal progressArgs As ProgressChangedEventArgs)
ProcessDelegate(ProgressChangedEvent, Me, progressArgs)
End Sub

Public Sub CancelAsync()
If Me._SupportsCancellation = True Then
SyncLock Me
Me._CancelPending = True
End SyncLock
Else
Throw New System.InvalidOperationException("This BackgroundWorker states that it doesn't support cancellation. Modify WorkerSupportsCancellation to state that it does support cancellation.")
End If
End Sub

Public ReadOnly Property CancellationPending() As Boolean
Get
SyncLock Me
Return Me._CancelPending
End SyncLock
End Get
End Property

Public Property WorkerSupportsCancellation() As Boolean
Get
SyncLock Me
Return Me._SupportsCancellation
End SyncLock
End Get
Set(ByVal Value As Boolean)
SyncLock Me
Me._SupportsCancellation = Value
End SyncLock
End Set
End Property

Public Property WorkerReportsProgress() As Boolean
Get
SyncLock Me
Return Me._ReportsProgress
End SyncLock
End Get
Set(ByVal Value As Boolean)
SyncLock Me
Me._ReportsProgress = Value
End SyncLock
End Set
End Property

End Class

Public Class DoWorkEventArgs : Inherits System.ComponentModel.CancelEventArgs

Private _Result As Object

Public Property Result() As Object
Get
Return Me._Result
End Get
Set(ByVal Value As Object)
Me._Result = Value
End Set
End Property

Public ReadOnly Argument As Object

Public Sub New(ByVal argument As Object)
Me.Argument = argument
End Sub

End Class

Public Class ProgressChangedEventArgs : Inherits EventArgs

Public ReadOnly ProgressPercentage As Integer
Public ReadOnly userState As Object

Public Sub New(ByVal percentage As Integer, ByVal userState As Object)
Me.ProgressPercentage = percentage
Me.userState = userState
End Sub

End Class

Public Class AsyncCompletedEventArgs : Inherits EventArgs

Public ReadOnly [Error] As Exception = Nothing
Public ReadOnly Cancelled As Boolean
Public ReadOnly UserState As Object

Public Sub New(ByVal runException As Exception, ByVal cancel As Boolean, ByVal userState As Object)
Me.Error = runException
Me.Cancelled = cancel
Me.UserState = userState
End Sub

Protected Sub RaiseExceptionIfNecessary()
If Me.Cancelled = True Then
Throw New System.InvalidOperationException("Operation has been cancelled.")
End If
If Not Me.Error Is Nothing Then
Throw New InvalidCastException
End If
End Sub

End Class

Public Class RunWorkerCompletedEventArgs : Inherits AsyncCompletedEventArgs

Public ReadOnly Property Result() As Object
Get
Me.RaiseExceptionIfNecessary()
Return Me.UserState
End Get
End Property

Public Sub New(ByVal result As Object, ByVal runException As Exception, ByVal cancel As Boolean)
MyBase.New(runException, cancel, result)
End Sub

End Class

Public Delegate Sub DoWorkEventHandler(ByVal sender As Object, ByVal e As DoWorkEventArgs)

Public Delegate Sub ProgressChangedEventHandler(ByVal sender As Object, ByVal e As ProgressChangedEventArgs)

Public Delegate Sub RunWorkerCompletedEventHandler(ByVal sender As Object, ByVal e As RunWorkerCompletedEventArgs)

End Namespace

VB.NET /C# Bootcamp

2008-11-02T21:27:00.000-08:00

Essential Class coding(C#)

2008-11-02T20:31:00.000-08:00

Let`s declare a class named Cars.Remember each class contain fields,methods,sub-classes and more.
standard definition:access return type class
Access modifier is how the class will be accessed could be publicly,privately,protected....
public class Cars
{
//let`s declare some fields ,you can add more depending on your requirement.
public int ntires;
public bool sunroof=true;

//let declare a method

public void Start()
{
Console.WriteLine("Vooommm......");
}

Public void Stop()
{
Console.WriteLine("Stoppinnnnnnng.....");
}

//You could add Property,structs and more

} //end class Cars

//Now let create a class that will use all fields and methods of Cars class=INHERITANCE
//u use : in front of sub class like JapaneseCar

Public class JapaneseCar:Cars
{
//JapaneseCar class will inherit all fields,methods.... of Cars Class and can implement it own
//methods,fields....

}

//Let say i dont a sub class inherits a given class .The anwer is you need to seal the class you dont to be inherited with the keyword sealed
//Let create 2 classes:

public sealed class AllCars
{
//field,properties,methods...
}
public class ChineseCars :AllCars
{
/Putting a colon in front of ChineseCars will not work and generated error because
//AllCas class is sealed
}

If you have question or concerned see me here.
For training go to www.africtek.com

TALLEY JOHN OURO
Software Architect

Developing Applications with Embedded Databases

2008-11-01T22:37:00.000-07:00

Check this video! For more information about it click this Link

In order to test this you need visual studio 2005 Pro or download the expess one at here.

TALLEY JOHN OURO ,Sotware Developer

Need serious programming training?

2008-11-01T22:30:00.000-07:00

CLICK THIS LIK

IT TRAINING

Introduction to Progressbar control(VB)

2008-10-29T22:14:00.000-07:00

Add Timer and progressbar on you form.
Name the progressbar myProg
'Within the form load

myProg.Mininmum=0
myProg.Maximum=100

'Double click Timer control on the form and add this code

MyProg.Value=MyProg.Value+myProg.Step
if(MyProg.Value>100)
(
'Reset the value of
myProg.Value=0
)

Add additional code to Timer control and you shoul be ok.

TALEY A OURO

Introduction to ClickOnce API

2008-10-29T21:28:00.000-07:00

Prerequisites: Visual Studio 2005/2008;VB.NET ;C#
1-Imports System.Deployment.Application
2-Got to Properties of your application/Publish tab/Unchek Application should check for Update
3-Make sur you set Update location (very important)

VB.NET

Private Sub InstallUpdateSyncWithInfo()

Dim info As UpdateCheckInfo = Nothing
If (ApplicationDeployment.IsNetworkDeployed) Then
Dim AD As ApplicationDeployment = ApplicationDeployment.CurrentDeployment
Try
info = AD.CheckForDetailedUpdate()
Catch dde As DeploymentDownloadException
MessageBox.Show("The new version of the application cannot be downloaded at this time. " + ControlChars.Lf + ControlChars.Lf + "Please check your network connection, or try again later. Error: " + dde.Message)
Return
Catch ioe As InvalidOperationException
MessageBox.Show("This application cannot be updated. It is likely not a ClickOnce application. Error: " + ioe.Message)
Return
End Try
If (info.UpdateAvailable) Then
Dim doUpdate As Boolean = True
If (Not info.IsUpdateRequired) Then
Dim dr As DialogResult = MessageBox.Show("An update is available. Would you like to update the application now?", "Update Available", MessageBoxButtons.OKCancel)
If (Not System.Windows.Forms.DialogResult.OK = dr) Then
doUpdate = False
End If
End If
If (doUpdate) Then
Try
AD.Update()
MessageBox.Show("The application has been upgraded, and will now restart.")
Application.Restart()
Catch dde As DeploymentDownloadException
MessageBox.Show("Cannot install the latest version of the application. " + ControlChars.Lf + ControlChars.Lf + "Please check your network connection, or try again later.")
Return
End Try
End If
End If
End If
End Sub

private void InstallUpdateSyncWithInfo()
{
UpdateCheckInfo info = null;
if (ApplicationDeployment.IsNetworkDeployed)
{
ApplicationDeployment ad = ApplicationDeployment.CurrentDeployment;
try
{
info = ad.CheckForDetailedUpdate();
}
catch (DeploymentDownloadException dde)
{
MessageBox.Show("The new version of the application cannot be downloaded at this time. \n\nPlease check your network connection, or try again later. Error: " + dde.Message);
return;
}
catch (InvalidDeploymentException ide)
{
MessageBox.Show("Cannot check for a new version of the application. The ClickOnce deployment is corrupt. Please redeploy the application and try again. Error: " + ide.Message);
return;
}
catch (InvalidOperationException ioe)
{
MessageBox.Show("This application cannot be updated. It is likely not a ClickOnce application. Error: " + ioe.Message);
return;
}
if (info.UpdateAvailable)
{
Boolean doUpdate = true;
if (!info.IsUpdateRequired)
{
DialogResult dr = MessageBox.Show("An update is available. Would you like to update the application now?", "Update Available", MessageBoxButtons.OKCancel);
if (!(DialogResult.OK == dr))
{
doUpdate = false;
}
}
if (doUpdate)
{
try
{
ad.Update();
MessageBox.Show("The application has been upgraded, and will now restart.");
Application.Restart();
}
catch (DeploymentDownloadException dde)
{
MessageBox.Show("Cannot install the latest version of the application. \n\nPlease check your network connection, or try again later. Error: " + dde);
return;
}
}
}
}
}

If you have any question or concern send me email

TALLEY A.OURO

Software Archictect

Introduction to ClickOnce Deployment

2008-10-29T21:13:00.000-07:00