Skip to main content

Posts

Showing posts from August, 2015

IIS Installment Steps

Install IIS Guide This guide is a walkthrough of necessary steps for installing IIS on windows. 1.     IIS Installment Steps   1.        Go to start   -> Control panel        2.        Go to Programs  3.        Click   Turn Windows Feature on or off       4.        Click   on the following   Feature on                 5.        Scroll down the windows feature window and also select the following feature             6.        Press ok a progress bar will appear. 7.       Once the installation is over, to confirm it, simply type the following URL into your browser: http://localhost .             If installation is successful, then you will see the following screen:    NB : if you cannot see this screen on the browser, restart your PC and try it again.  2.     IIS Open Steps              1.        Type IIS on search program and files              2.      

T-SQL single parameter will perform like search on multiple table column

ALTER PROCEDURE [dbo].[USP_GetPickerNameList] @SearchStr varchar(50) AS BEGIN SET @SearchStr = RTRIM(@SearchStr) + '%' SELECT DISTINCT TOP(10) p.cpickerid ,p.cpickername ,p.cpickeridtype ,p.cid ,p.cidissuingstate ,p.pickerid_PK ,p.pickeridtype_FK ,p.idissuingstate_FK ,c.ccusname ,c.cusid_PK ,c.dbirthday ,f.caddress1 FROM pickers p INNER JOIN pickergroups ON p.pickerid_PK = pickergroups.pickerid_FK INNER JOIN customer c ON c.pickergroupid_FK = pickergroups.pickergroupid_PK LEFT OUTER JOIN family f on c.familyID_FK = f.familyID_PK LEFT OUTER JOIN rx r on c.cusId_PK = r.cusId_FK WHERE RTRIM(LTRIM(p.cpickername)) LIKE @SearchStr OR RTRIM(LTRIM(c.ccusname)) LIKE @SearchStr OR RTRIM(LTRIM(c.ccusfirstname)) LIKE @SearchStr OR RTRIM(LTRIM(c.ccuslastname)) LIKE @SearchStr

Bank Management Project in C Language

hi i am helping my sister to create a simple bank management project. i like to share with you #include <stdio.h> #include <conio.h> #include <string.h> #include <stdlib.h> // Structure declaration struct acc_type { char bank_name[20]; char bank_branch[20]; char acc_holder_name[30]; int acc_number; char acc_holder_address[100]; float available_balance; }; struct acc_type account[20]; int num_acc; // Global variable void Create_new_account(); // Create_new_account function declaration [ This function will create a new customer account ] void Cash_Deposit(); // Cash_Deposit function declaration [ this function will Cash_Deposit money for specific account ] void Cash_withdrawl(); // Cash_withdrawl function declaration [ this function will withdaw money from specific account ] void Account_information(); // Account_information function declaration [ this function will show