Software Applications Programming Errors and solutions.

Net banking If you are tried to stand in stand in a ling queue waiting for a passbook to be updates or wait for the next day for a demand draft to the prepared. Internet technology has evaded the portals of our banking institutions and everything is click away innovations like tale banking and automated teller machines (ATM) have considerably put customers at ease in the recent past but with net banking the customer will be able to transact with the help of mouse and visit to the neighborhood bank will become a thing of the past. Tough a modest start has been given in India; net banking has still a long way to go, ICICI Bank, HDFC Bank. Citibank have endeavored to make real time banking a reality before this century closes. An average customer will be interested to know whatever firstly, net banking offers him/her a wide range of services, secondly show a history of transactions made, thirdly transfer funds between accounts and most importantly whether the services offered are well

DATA FLOW DIAGRAM D.F.D. (Data Flow Diagram) is a set of technique and graphical tools that allow the programmer to develop a kind of software specification that is easily understood by the user. It shows a sequence of functional transformations that convert system input to required output. It represents how a data flows through a system and how output is derived from the input through a sequence of function formation. They describe the end-to-end processing in the form of a flow chart from top to bottom. The Data Flow Diagram shows the use of data in the system pictorially structured analysis making use of some standard conventions. A full description of a system actually consists of a set of DFDs. Different levels of the system can be expressed using different DFD’s. The notations that are used by out DFD are described in brief below: 1. Rounded Rectangle : It represents functions, which transform input to output. The name inside the rectangle indicates its functio

3BHK ,starting  just Rs. 18 Lakhs near Chandigarh 3BHK starting @ just Rs. 18 Lakhs near Chandigarh.3 Bedrooms, Drawing Dining Room, Modular Kitchen, 2 Bathrooms, 2 Balconies, Car Parking, Lush Green Park, Kids Playing Area, Secured entrance of complex etc. Call: 9216-333-666 The key attractions of our project are: - Punjab Govt. Approved Project - Situated on NH-21, Chandigarh-Ropar Road, Kharar - Modern Design with Superior Architecture - Options available in 1BHK / 2BHK / 3BHK - The project offers Budget Class Housing - Good Quality Construction & Low Price - Surrounded with a lot of Educational Institutions - Loan Facility available from Leading Banks Call: 9216-333-666, 9216-44-22-33 Email: agbperfecthomes@gmail.com

1. Indira Gandhi National Open University - DELHI 2. Dr. B.R. Ambedkar Open University - Hyderabad 3. Kota Open University - Rajasthan 4. Nalanda Open University - Patna 5. Madhya Pradesh Bhoj University - Bhopal, Madhya Pradesh 6.Dr.Babasaheb Ambedkar Open University - Ahmedabad, Gujarat 7. Yashwantrao Chavan Maharashtra Open University - Nashik ,Maharashtra 8.Netaji Subhas Open University - Kolkata ,West Bengal 9. U.P.Rajarshi Tandon Open University - Allahabad 10. Karnataka State Open University - Karnataka

% Function for initializing the matrices 'tt' and 'w' for Gaussian % Integration; with n = 5, 10, 20, 24, 32, 40 or 48 % SAMPLE CODE FOR IMPLEMENTING DOUBLE INTEGRATION % gaussian_points = 10 ; % Define the number of points to be used % % a = 1; % Lower integration limit for y % b = 2; % Upper integration limit for y % % c = 3; % Lower integration limit for x % d = 4; % Upper integration limit for x % % sum = 0; % % for ii = 1:gaussian_points % % yy = ((d - c)*tt(ii) + d + c)/2; % % inner_sum = 0; % % for jj = 1:gaussian_points % xx = ((b - a)*tt(jj) + b + a)/2; % Fm1 = xx + yy*yy; % I N T E G R A N D % inner_sum = inner_sum + 0.5*(b - a)*Fm1*w(jj); % end % % sum = sum + 0.5*(d - c)*inner_sum*w(ii); % % end % ------------------------------------------------------------------------- function [tt w] = func_gaussian_integration_weights (gaussian_points) switch (gaussian_points)

ASP.NET 2.0 What improvements are provided in ASP.NET 2.0? How does ASP.NET 2.0 eliminate tedious coding? How do we encrypt web.config files in ASP.NET 2.0 ? With the above technique can you encrypt everything in the web.config file? In .NET 1.X how was the encryption implemented for config files? Can you explain membership and role providers in ASP.Net 2.0? What kind of security web controls are introduced in ASP.NET 2.0? Can you explain master pages concept in ASP.NET? what is the concept of Web parts? What are the different components of the web part framework? What are partial classes in ASP.NET ? Can you explain generics in .NET ? Can you explain the concept of generic collection? How do you send a email using ASP.NET ? How did you deployment and setup in ASP.NET ? .NET 3.5 Define LINQ ? We already have common data access model what is special about LINQ? How can you make entity classes from the table itself ? How can we transform LINQ to objects ? How to tr

JNI What is Native Interface in JAVA? Can you say in brief steps required to implement Native interfaces in Java? Can JNI be used for VB6, C# or VB.NET directly? What are JNI functions and pointers? How does the garbage collector know JNI objects are no more used? Twist: - What are the different types of references JNI supports? Twist: - How to do you delete global objects? how does the native language C or C++ understand data types in JAVA? Can you explain exception handling in JNI? What are limitations for “JNIEnv” pointer in multi-threading scenarios? What are the advantages and disadvantages of using “JNI”? Architecture What are design patterns ? What is the difference between Factory and Abstract Factory Patterns? What is MVC pattern? Twist: - How can you implement MVC pattern in Servlets and JSP? How can we implement singleton pattern in JAVA? How do you implement prototype pattern in JAVA? Twist: - How to implement cloning in JAVA? What is shallow copy and

Compute charge distribution for 2D electrostatic problem by Method of moment function [charge,sigma] = MoM2D(xs,ys,xe,ye,phi) %Arguments: % xs = x-coordinate for starting points % ys = y-coordinate for starting points % xe = x-coordinate for ending points % ye = y-coordinate for ending points % Returns % sigma = charge density for each element % charge = total charge on each element xobs = 0.5*(xs+xe); % Observation Points yobs = 0.5*(ys+ye); h = sqrt((xe-xs).^2+(ye-ys).^2); % Length of elements % Loop over elements for k = 1:length(xs) s = (((xobs-xs(k))*(xe(k)-xs(k)))+((yobs-ys(k))*(ye(k)-ys(k))))/(h(k))^2; d = sqrt((xobs-xs(k)).^2+(yobs-ys(k)).^2-(s.^2*h(K)^2)+1e-24); xis = -s*h(k); xie = (1-s)*h(k); temp = 0.5*xie.*log(xie.^2+d.^2) ... - xie + d.*atan(xie./d) ... -0.5*xis.*log(xis.^2+d.^2) ... - xis + d.*atan(xis./d) ... A(:,k) = temp(:)/(2*pi*8.854187))); end sigma = (A\phi')'; % Charge density

Concept of Mutual Funds A mutual fund is a trust that pools the savings of number of investors who share a common financial goal. The money thus collected is than invested in capital market instruments such as shares, debentures and other securities. The income earned through these investments and capital appreciations realized are shade by its unit holders in proportion to the number of units owned by them. Thus a mutual fund is the most suitable investment for the common man as it offers an opportunity to invest in a diversified, professionally managed basket of securities at a relatively low cost. Definition Mutual funds are associations or trusts of public members who wish to make investment in the financial instruments or assets of the business sector or corporate sector for the mutual benefit of its members. The funds collects the money of these members from their saving and invests them in a diversified portfolio of financial assets with a view to reduce risks and to maxi

What are the Key differences between IPv4 and IPv6. IPv4 Source and destination addresses are 32 bits (4 ytes) in length. IPsec header support is optional. No identification of packet flow for prioritized delivery handling by routers is present within the IPv4 header. Fragmentation is performed by the sending host and at routers, slowing router performance. Has no link-layer packet-size requirements and must be able to reassemble a 576-byte packet. Header includes a checksum. Header includes options. ARP uses broadcast ARP Request frames to resolve an IPv4 address to a link-layer address. Internet Group Management Protocol (IGMP) is used to manage local subnet group membership. ICMP Router Discovery is used to determine the IPv4 address of the best default gateway and is optional. Broadcast addresses are used to send traffic to all nodes on a subnet. Must be configured either manually or through DHCP for IPv4. Uses host address (A) resource records in the Domain Name S

How to open Excel file from Microsoft Access 2007 strFileName = CopyMyFile("abc.xlsm") Set appExcel = CreateObject("Excel.Application") appExcel.Workbooks.Open strFileName ' Put the data in the file appExcel.Visible = True Set appExcel = Nothing

India Is Famous due to following reason. Lucknow is  famous for its monuments like bhool bhulaiya Mumbai is  famous for  port. Agra is famouse for Tajmahal. Cochin is famous for its busy harbour complex which has found a safe haven in the Vembanad Lake waters. Shahjahanpur is famouse for Carton and Tilhar place of Shahanpur district is famous for Laung sweats. Sitapur is famous for Basen laddu. Ratlam is famous for Ratlami save namkeen. Andhra pradesh is famous for hyderabad biryani and haleem ,spicy foods,  ladies wear in hyderabad, redchilly from guntur Assam state is famous for Tea. Goa is famous for beaches and church. Kerala  is famous for cocunuts and cocunut oil,backwaters, lagoons, hill station. Maharastra  is famous for industrys, shipping. Karnataka  is famous for Bangalore IT professionals and engineering, coffee. Kashmir  is famous for apples. Utter pradesh  is famous for sugar, varanasi temple,taj mahal, handicrafts, aundh cuisine, etc.

Converting Resultset Into User Defined Name using select query in sql example SELECT date_format( doj, '%d/%m/%Y' ) AS week ,COUNT(user_id) FROm user_tb  WHERE doj between '2012-01-01' AND '2012-01-31' group BY WEEK(doj) Outlput will be like this Result week    COUNT(user_id) 06/01/2012  3 17/01/2012  2 25/01/2012  3 29/01/2012  1  

Total number of following things Total number of websites in this world - 232000000 Total number of blog in the world - 70 million blogs Number of email accounts worldwide -3.146 billion Internet users worldwide-2.1 billion . Total number of countries in world-243 Total number of cities in the world-36,722 Total number of companies in world-100000000 Total number of banks in the world -1,000,006 The total number of railway stations in India -7000-8000 Total number of airports in the World are approximately 14000 airports. Total number of villages in world-3,900,000.(Approx.) Total Population of the World by Decade, 1950–2050 Read more: Total Population of the World by Decade, 2020 7,584,821,144 Total number of religion in the world-more than 730 established Religions Total languages in the world-6912 This is prediction which taken from different websites. Number may change in future. This post will show you only approximate result.

Splitting a String to a Certain Position  substring('abc/123',charindex('abc/123','/')+1,3) Pulling a Row Prior to Maximum Row in sql SELECT    es.emp_employee_id    ,MAX(es.emp_stat_eff_dte) FROM emp_status es WHERE es.emp_stat_eff_dte <    (    SELECT       max(es2.emp_stat_eff_dte)    FROM emp_status es2    WHERE es2.emp_employee_id=es.emp_employee_id    ) order by es.emp_employee_id Update Table from Select Statement in sql To Update Table from Select Statement in sql you can see below example. E.g. update customers CUST set CUST.likes_us = 'Y' where CUST.link_id in  (select distinct REST.link_id   from restaurant REST   where REST.rest_type = 'Diner') and CUST.likes_us is null

MY table name  product1 ID    Amount      Date ---- 1    300     02-02-2010 00:00  2    400     02-02-2009 00:00  3    200     02-02-2011 00:00  4    300     22-02-2010 00:00  5    400     12-02-2009 00:00  6    500     22-02-2009 00:00  7    600     02-02-2006 00:00  8    700     02-07-2012 00:00  9    500     08-02-2012 00:00 10    800     09-02-2011 00:00 11    500     06-02-2010 00:00 12    600     01-02-2011 00:00 13    300     02-02-2019 00:00 Desired output:    Y1          Y2            Y3 ...........  sum(amount)   sum(amount)   sum(amount) What is an approach, where Y1 is the year part of the date, such that the result column would be the following? YEAR       2006   2009    2010   2011   2012 -   --------- Total         600   1300     800   1900   1200 Create procedure [dbo].[pivot] as begin DECLARE @Years nvarchar(max) SELECT @Years = STUFF( ( select distinct ',[' + cast(Year([Dates]) as nvarchar(4)) + ']' fro

How to split string in sql server queryQuestion : If I have strings like 'abc/123' then  split string function to obtain only 123 from the string. Answer: RTRIM(RIGHT(Field1, LEN(Field1) - CHARINDEX('/',  Field1)))

Following is example that how to join table in sql using select query to retrieve rows from both tables. select * from  First_table as T1 ,Second_table as T2  where T1.wono=T2.wono and T1.id = (select top(1) id from   First_table as T1) In above query T1 is alias name of first table and T2 is alias name for second table. Wono is primary column which used to join both table. It also example of sub query.

This is stored procedure which show you rows return as per mention in stored procedure. CREATE PROCEDURE get_categories( IN p_action_flag VARCHAR(50), IN p_firstrow int, IN p_lastrow int) BEGIN IF p_action_flag = 'all' THEN SELECT top 50 u.*, d.name, d.image FROM user u, member gu, detail d WHERE u.user_id = gu.user_id AND u.user_id = d.user_id AND u.status = '1' AND gu.group_id IN (1, 7) GROUP BY u.user_id ORDER BY d.name LIMIT p_firstrow,p_lastrow; ELSEIF p_action_flag = 'Most Viewed' THEN SELECT top 50 u.*, d.name, d.image FROM user u, member gu, detail d WHERE u.user_id = gu.user_id AND u.user_id = d.user_id AND u.status = '1' AND gu.group_id IN (1, 7) GROUP BY u.user_id ORDER BY u.views DESC, d.name ASC LIMIT p_firstrow,p_lastrow ; END IF END

 run the following simple macro that display assigned macros for each Button:  Sub ButtonOnAction() Dim shp As Shape Dim i As Integer For Each shp In ActiveSheet.Shapes ' Type 8=Button, 13=Picture, 4=Comment, ... '-- i = 1 If shp.Type = 8 Then ' 8 = Button Application.Goto Reference:=shp.TopLeftCell, Scroll:=True shp.Select MsgBox i & ". Button '" & shp.Name & "' - Macro: '" & shp.OnAction & "'" i = i End If Next shp End Sub

select data from an excel sheet and display it in a datagridview public void ImportExcel2007(string path) { FileInfo filePath = new FileInfo(path); DataTable workSheetsTable = new DataTable(); DataTable columnsTable = new DataTable(); string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;IMEX=1; HDR=YES'"; OleDbConnection excelConnection = new OleDbConnection(connString); excelConnection.Open(); //This bit assumes the first worksheet is the one to import, //change this as required. workSheetsTable = excelConnection.GetOleDbSchemaTable(OleDbSchemaGui d.Tables, null); string tableName = workSheetsTable.Rows[0]["TABLE_NAME"].To String(); //This section uses the tableName declared above to get a //list of columns for that worksheet only. columnsTable = excelConnection.GetOleDbSchemaTable(OleDbSchemaGu

Convert to proper case using dotnet code string sentence= "santro is my favorite car"; Response.Write(ConverTopropercase(sentence)); private static string (ConverTopropercase(string senstr) { return Regex.Replace(s, @"\b[a-z]\w+", delegate(Match yourMatch) { string Tempstr = yourMatch.ToString(); return char.ToUpper(Temp[0]) + Tempstr.Substring(1); }); } output: Santro Is My Favorite Car.

Dotnet Code to get size of Folder including subfolders Public Shared Function GetSize(ByVal folderFullPath As String, Optional ByVal includesubFolderss As Boolean = True) As Long Dim sizeoffile As Long = 0 Dim directory As directoryInfo = New directoryInfo(folderFullPath) For Each fileInfo As System.IO.FileInfo In directory.GetFiles() sizeoffile += fileInfo.Length Next If includesubFolderss Then For Each subFolders As System.IO.directoryInfo In directory.Getdirectoryctories() sizeoffile += GetSize(subFolders.FullName) Next End If

To Clear temporary files from temp folder of internet explorer by .net code you can try below code in any event to check the effect. "using System.IO;" void clearTempfolder(DirectoryInfo MyDirPath) { foreach (FileInfo yourFile in MyDirPath.GetFiles()) { yourFile.Delete(); } foreach (DirectoryInfo youSubFolder in MyDirPath.GetDirectories()) { clearTempfolder(youSubFolder ); } } public static void Main() { clearTempfolder(new DirectoryInfo(Environment.GetFolderPath(Environment.SpecialFolder.InternetCache))); }

How to execute executable file from dot net application Just write following code on your control event like button click event. System.Diagnostics.Process.Start("C:\WINDOWS\system32\calc.exe")

select the non empty cell and clear the content to allow another selection. Sub ReferenceNonEmptyCells() Dim rngAll As Range Dim rngConstants As Range Dim rngFormulas As Range ' 1. reference complete range Set rngAll = Worksheets("Data").Range("A1:K30&qu ot;) ' or use named range... Set rngAll = Worksheets("Data").Range("MyRange&q uot;) ' Reference Constants (23=Numbers+Text+Logical+Errors) On Error Resume Next Set rngConstants = rngAll.SpecialCells(xlCellTypeConstants, 23) ' Reference Formulas Set rngFormulas = rngAll.SpecialCells(xlCellTypeFormulas, 23) '-- ' Clear (or ClearContents) Non Empty Cells If Not rngConstants Is Nothing Then rngConstants.ClearContents End If If Not rngFormulas Is Nothing Then rngFormulas.ClearContents End If End Sub

Sql query to get second top record from table select top 1 *from customers where id NOT IN ( select top 1 id from customers order by id ) order by id

Private Function XmlToExcelfile(ByVal XMLSourcefileAs String, ByVal ExcelfileAs String)         Dim Exapp As New Excel.Application Dim fileInf As New System.IO.FileInfo(XLSFile) If fileInf.Exists Then SetAttr(XLSXFile, vbNormal) fileInf.Delete() End If Dim fxml As New System.IO.FileInfo(XMLFile) If fxml.Exists Then exapp.Workbooks.Open(XMLFile) exapp.Workbooks.Item(1).CheckCompatibility = True exapp.DisplayAlerts = False exapp.Workbooks.Item(1).SaveAs(XLSXFile,exappcel.XlFileFormat.xlWorkbookDefault) exapp.DisplayAlerts = False exapp.Workbooks.Close() SetAttr(XMLFile, vbNormal) fxml.Delete() Else MessageBox.Show("XML File does not exists") End If Dim file2 As New System.IO.FileInfo(XLSXFile) If file2.Exists Then SetAttr(XLSFile, FileAttribute.Normal) End If exapp.Quit() Exapp= Nothin

Sub SaveAs(Filename As String, Format As String) 'XLS Format If UCase(Format) = "XLS" Then ActiveWorkbook.SaveAs Filename:= _ Filename, FileFormat:= _ xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False Else 'default 'XLSX Format ActiveWorkbook.SaveAs Filename:= _ Filename, FileFormat:= _ xlOpenXMLWorkbook, CreateBackup:=False End If End Sub Sub Test() SaveAs "C:\tmp\Filename.xls", "xlsx" SaveAs "C:\tmp\Filename.xlsx", "xls" End Sub

--First step is create Table empmaster with column empid,eno,ename etc create table empmaster ( empid int primary key identity, eno int, ename varchar ) -- Now create Table empdetails with column empid,sal,dept, hiredate etc create table empdetails ( empid int , sal money, dept varchar, hiredate datetime ) -- Now create Stored Procedure empvalues to insert records in tables create proc empvalues @eno int, @ename varchar(20), @sal money, @dept varchar(20), @hiredate datetime as begin insert into empmaster . INSERT INTO empdetails. end

Using a Variable As Datatype In A Package in Oracle CREATE OR REPLACE PACKAGE pkg_xx IS v1 number(10); end; sho err CREATE OR REPLACE PACKAGE pkg_yy IS v2 pkg_xx.v1%type; end;

Code to export crystal report to pdf directly //Declare Reportdocument Object ReportDocument rpt=new ReportDocument(); //set a ReportPath and assign the dataset to reportdocument object rpt.Load(Server.MapPath("Report1.rpt")); rpt.SetDataSource(ds); //assign the values to crystal report viewer CrystalReportViewer1.ReportSource = rpt; CrystalReportViewer1.DataBind(); //Exporting PDF MemoryStream oStream; // using System.IO oStream = (MemoryStream) rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End();

Exam : Microsoft 70-512 Title : TS: Visual Studio Team Foundation Server 2010,Administration Version : DEM0 1. You plan to install a dual-tier Visual Studio Team Foundation Server 2010 environment using two servers named Server1 and Server2. You install and configure Microsoft SQL Server 2008 and SQL Server 2008 Analysis Services on Server1. You install and configure IIS 7.5, SQL Server Reporting Services, and Windows SharePoint Services 3.0 on Server2. You need to install and configure Team Foundation Server using the two servers. What should you do? A. Install Team Foundation Server on Server2 and run the configuration wizard on Server2 using the Basic option. B. Install Team Foundation Server on Server2 and run the configuration wizard on Server2 using the Advanced option. C. Install Team Foundation Server on Server1 and Server2. Run the configuration wizard on Server1 using the Basic option. Run the configuration wizard on Server2 using the Application-Tier Only

Training centers lists of India Arsh spoken english institute IIFCA Institute of Finance & Computer Accounting K11 Sangli Fitness Academy K11 Bangalore Fitness Academy K11 Indore Fitness Academy K11 Nashik Fitness Academy K11 Pune Fitness Academy Computer Application Centre(CAC),Cuttack Dcube Tech Campus Debest computer systems Chandigarh computer centre Technosys - Technically Ahead Mob com international Glance Tutorial Dynamic bharati Tutorials Aryan Academy ARS Tutorial Institute of Nephro Urology Triumphent Institute of Management Education - TIME Automation & Control System, Pune Ias study point ConceptZ Training Institute, Bangalore Prolific Systems & Technologies Pvt. Ltd. IIHT, Surat Broadline Technologies - SAP Authorised Training Centre A.K.Jindal Accountancy Centre Balaji Institute of Information Technology, Malleswaram, Bangalore Balaji Institute of Information Technology, Indiranagar, Bangalore Balaji Institute of Information Tech

Top NGOs in India Abhiyan Patna - Bihar Action for Development of Demos(ADD) Patna - Bihar Adarsh Charitable Trust Ernakulam District - Kerala Ahmedabad Women's Action Group Ahmedabad - Gujarat Akhanda Seva for International Shanti (Operation Shanti) Mysore - Karnataka Akshara Foundation Bengaluru - Karnataka Alternative For Rural Movement(ARM) Balasore District - Orissa Amar Seva Sangam Ayikudy - Tamil Nadu Ananya Trust Bangalore - Karnataka Andhjan Kalyan Trust Rajkot - Gujarat Anga Karunya Kendra Bangalore - Karnataka Apnalaya Mumbai - Maharashtra Arokiya Charity Pudukottai - Tamil Nadu Asha Deepa School for the Blind Bidar - Karnataka Ashadeep Guwahati - Assam Ashish Foundation for the Differently Abled (AFDA) Charitable Trust New Delhi - Delhi Ashray Akruti Hyderabad - Andhra Pradesh ASHWINI Gudalur - Tamil Nadu ASSIST Guntur - Andhra Pradesh Association for Rural Development and Action Research (ARDAR) Visakhapatnam - Andhra Pradesh Association for Sust