==================================================================== function myModule_personal_detail_form($form, &$form_state) { $form = array(); $form = array( '#type' => 'textfield', ); $form = array( '#type' => 'textfield', ); $form = array( '#type' => 'textfield', '#maxlength' =>…

— Create Employee Table Create Table EMPLOYEE( ID int,EmpID int,EmpName varchar(50)) — Insert Sample data to the Employee table INSERT INTO EMPLOYEE VALUES ( 1, 1, ‘Aasish’) INSERT INTO EMPLOYEE…

How do we Insert,Delete,Update from Kentico webproject by using a webpart? In Kentico CMS we have a database with number of tables to support the CMS system, still some times…

C# does not support pointer arithmetic by default to have type safety and security. If we want to use pointers in C# we need to use the keyword unsafe. We…

Steps: 1- Register the webservice in CF admin using any method (whether by manual creation in cf admin or by creating an object) 2- After the wsdl is registered, it…

Caching has been used for years to improve performance of applications. So it is very much important to control caching properly to get highest possible benefit out of it. Please…

Using Zend_Db Adapter method we use the following approach to connect database and execute SQL statement. //Connect to database $db = Zend_Db::factory(‘DB_ADAPTER_TYPE’, array( ‘host’ => ‘127.0.0.1’, ‘username’ => ‘webuser’, ‘password’…

By Default, a nonclustered index gets created if keyword ‘clustered’ is not specified. Here in the above example, we have created a nonclustered index ‘IX_Employee_EmpID’ on EmpID column of  Employee…

Here I am assuming 1- Many relationship between Department and Employee table(i.e. A department has many employee and a single employee can work only in a single department). Part –…