LK-TECH Academy

Are you a graphic designer, web designer or digital artists who is paying back most of your income for software tools that you are using for your creations? What will be your net income if you could save money that you are paying for those software tools? Yes, there are tons of free tools that you can use as alternative graphic software tool. Some of the free tools having rich set of functions than commercial tools, but most of the people are having lack of knowledge about them and their features. So, I decided to introduce few of them that I am using for my creations without paying any dollar for any company. That means cost for my creations are negligible and income is really high.

Are you tired in writing complex code for your database design? Want to be little relax? This article will help you to enjoy your job. In early days we had to write coding from the scratch to implement our database designs. Later people moved to database designing graphical tools. The latest trend of designing databases is use database navigation maps where you can visually feel your database design. This method is very useful if your database is little complex and you have lot of key constraints, referential integrity constraints, indexes and triggers etc. Using database navigation maps you can see either the entire database or part of it, how the tables are integrate each other, what are the keys you have defined for tables and references etc. Most importantly you don't need to write any single code or no need to remember complex SQL syntax.

In my previous article, we discussed on how to generate XML document or XML stream from your dataset. There I mentioned that one of the major advantage of converting a dataset into XML is we can easily validate our XML data against the XML schema. The XML schema is used to define the format, data types and key constraints that you want to validate. The XML document or XML stream can be validate against the predefined XML schema and exactly you can get the validation error and on which tag that error is occurred. First you need to have a XML document to validate. There are several ways to convert your data into XML documents. In previous article I showed you one such method. In this article I will show you how to do a validation with XML schema for existing XML document.

XML data definition format is heavily used in nowadays applications since it is very rich data definition method. Working with XML data is very customizable, easy and reliable. Important features of XML language are; well defined schema purely character based data definition method customizable tags easy validation of XML documents In ASP.NET it provides lot of shortcut methods to work with XML data. Actually .NET Frameworks most of the components fully based on XML languages. Few examples are Data Grid, Data Set and Class Designer etc. Due to this reason you can easily convert data in dataset to XML document and read data from XML document to feed into dataset. Why it is important to convert dataset into XML documents is a good question to analyze. There are few reasons to explain here, first thing is dataset is a kind of a special data format and not exchangeable with different applications. Transfer through web protocols is not straight forward with dataset, but XML data is ba...

Using iSeries Navigator you can very easily specify Unique Key and Primary Key for database table in DB2 database. Most of the people are not well aware that DB2 is relational database and it support all the relational database concepts. I have experience that most of the developers are not using key constraints, referential integrity, triggers etc. But most importantly DB2 is support for all these features. Let's look at one by one how these concepts can be implemented using iSeries Navigator on DB2 database. To create Unique Key or Primary Key for a given table you need to go the table definition. Right click on the table that you want to modify and add new key and select "Definition" option. Fig 1: Table Definition Option

With Microsoft Visual Studio 2005 you can develop applications with Crystal Reports without using separate Crystal Report application installed in the development machine. They have provided Crystal Reports tool in standard toolbox in Visual Studio 2005 environment. Simply you need to drag and drop these controllers and develop your reports same as previously with Crystal Report. Advantage is you don't need to buy separate Crystal Report application and install them in development and deployment environments. Fig 1: Crystal Reports Tools in Microsoft Visual Studio 2005

In conventional method it is not very straight forward to write stored procedures with DB2 in AS400 environment. You might need to remember lot of syntax or might need to refer books to find syntax to code the procedures. This is very inefficient method for today's database programming context. iSeries Navigator has been provided very cool feature to develop your stored procedures from the iSeries Navigator graphical UI . You don't need to remember all the syntax to write database coding and the tool itself given you all the syntax which are required to write your coding. Only you have to do is insert them into your coding and make necessary modifications. Login to your iSeries Navigator and browse your database that you want to create new stored procedure and select "Procedures" section. Fig 1: Select you database and Procedures in iSeries Navigator pane Right click on Procedures and select "New" to create new stored procedure. There are two...

Sending an E-mail from your web site is really simple with ASP.NET. First of all will look at what actually happened when an E-mail is sending from a web site. First step is preparing your complete E-mail programmatically. For that you need to set source e-mail address, destination e-mail address, e-mail subject, e-mail body, SMTP (Simple Mail Transfer Protocol) mail server and SMTP port of your server. Once you prepare your E-mail in correct format, there is only one step to send the E-mail to your destination addresses. For that you need to pass the E-mail request to message queue of the SMTP server through SMTP port. By default port 25 is used as mailing port. That is only what you have to do and rest of the relaying of E-mail part will handle by the SMTP server itself. SMTP server is responsible to pass your E-mail to respective destinations. System.Net.Mail namespace should import using following code. using System.Net.Mail; Code for prepare your E-mail format is as follows. // Sy...

Session timeout period can be set as you required simply changing web.config file of your web site. In ASP.NET web site once you add web.config file you can find tag. Inside this tag you can specify session timeout value. Add following code to your web.config file. <system.web> <sessionstate timeout="60"/> </system.web> In this example you have set sessionState timeout value to 60 minutes. You can change this value as you wish, but need to make sure that it is really required. For example if you set a very large value for timeout, your session will hang on forever in the server. This will lead some security issues, memory overflow issues and sometime unexpected behaviour of your web site. And also this value should not be very small values. For example if you have functions like uploading files in the web site, then you should give enough time to upload a file based on the size of the file, network traffic and bandwidth limitation of the client machine.

I lanched a new blog site for discuss about power electronics and robotics related topics. This site is intended to publish deep theoritical articles and practically implementations of power electronics and robot world. http://www.elecsl.blogspot.com/

Does DB2 support for identity columns? Yes, it is. All numeric data types in DB2 database support for identify columns. Identity columns means, a field or column in a database table which automatically set its values for a new row insert. You don't need to provide value for the identity field when you insert new row into your table. For example if you want to set your customer identification number grow like 1000,1001,1002,1003... , you can set customer identification number column as identity column and starting number 1000 and increment value is 1. Then when you insert next customer it will increase the maximum customer identification number by 1 and automatically insert into the table. You can find iSeries Navigator from "Start -> IBM iSeries Access for Windows -> iSeries Navigator". Open iSeries Navigator and select your database and table that you need insert identity column. Keep in mind that you can only set identity only for numeric fields. You can eithe...

IBM iSeries Navigator is a rich client tool to work with DB2 database in AS400 machines. From your Microsoft Windows client machines through iSeries Navigator you can connect to remotely located DB2 database and work with it as simple as work in Microsoft Access database. You don't need work with console or do lot of coding which always lead to errors. Using iSeries Navigator you can very quickly develop you database and manage it very effectively. Login First step is to login to AS400 machine through iSeries Navigator. You need to provide server name, user id and password. Fig 1: Login iSeries Navigator Once you successfully login to the system in "Environment" pane it will list down all the entities that you can manage through iSeries Navigator UI. This list will vary based on the access permission to the connected AS400 server. In this article will discuss on how to work with SQL tables through the Navigator. At the end of the article you will realize how ...

DB2 is one of the most popular Database Management System developed by IBM. DB2 is heavily used in various high end applications around the world on mainly AS400 platform. High security, higher performance, easy maintenance and backup/recovery procedure of DB2 are key factors to lead the industry. Even though DB2 is very powerful database management system, it was not very user friendly at early stages. Basically console based programming was required. Most of the users came from Microsoft Windows operating system background don't like to work on console and write everything manually. They always expect some graphical tool to make easy their work. IBM iSeries Navigator full fill this gap effectively and nowadays iSeries Navigator is heavily used desing and program database. Work with iSeries navigator is realy simple as work with Microsoft SQL server UI. iSeries Navigator is client tool that is allowed to work with your DB2 database remotely from your PC. Installing iSeries Navigat...

We discussed how to enable SSL in a web site and create your own self-signed security certificate. Also you can use exsisting security certificates for a same server and same domain. You can use "Import" and "Export" facilities in Actions pane of Server Certificates window. Open IIS Manager browsing Start -> Control Panel -> Administrative Tools -> Internet Information Services (IIS) Manager or run "inetmgr" command. Click on "Server Certificates" icon in middle pane of IIS manager. Click on "Server Certificates" icon. Fig 1: Server Certificates Icon Select your existing certificate from Server Certificates window. Once you select your certificate it will show few new links in Actions pane to Export the certificate. Fig 2: View, Export or Remove links View link is for view details of the selected certificate, Export link for export the selected certificate and if you no more required selected certificate you can c...

While you have freedom to use security certificate from third part organization, for simple applications you can use self-signed certificates in IIS. With self-signed security certificates there is no third party is involved for certification or validation process. You can generate self-signed certificate in IIS (Internet Information Services) Manager and use the same for your HTTPS enabled or secure site. Open IIS Manager browsing Start -> Control Panel -> Administrative Tools -> Internet Information Services (IIS) Manager or run "inetmgr" command. Click on "Server Certificates" icon in middle pane of IIS manager. Fig 1: Server Certificates Icon Click on "Self-Signed Certificate" link in Actions pane. Fig 2: Server Certificate Pane Specify the friendly name for your certificate in "Create Self-Signed Certificate" window and click Ok. Fig 3: Create Self-Signed Certificate Finally you can bind the generated self-signed cer...