Jack is Here, asp.net findings

Welcome, in this tutorial we are going to create a new data source in Visual Studio.Net using the built in wizards and drag-n-drop. To begin go to “File”, “New”, “Project” and name the project something like “MyPubsDataSource” or whatever makes sense to you. This will be a windows application although it’s not really important because we just need any type of project because creating a new data source is commom to all project types. Ok after you enter a name for your project and press the “Ok” button VS.Net will have created your first form for you named “Form1.cs”. At this point the form1 view should be already in design view(If you see a rectangular window that reads “Form1.cs[Design]* then you are in design view.
Ok next click once anywhere on the form and then select the “ToolBox” tab on the left of the design window. If it’s not viewable then select “View”, “ToolBox” from the main menu.(See image below)

[Click to see full-size]

Which will show you the window below.

[Click to see full-size]

Ok, next select the “SQLDataAdapter” from the ToolBox and drop it anywhere onto your form. Once you release it, it does not actually sit on top your form but instead it positions itself just below your form inside the design area. At this point you will have another window in front of you for you to choose your data source like this(See image below).

[Click to see full-size]

In the next window, select Microsoft SQL Server or Microsoft SQL Server 2005 Express or whatever data your server can be. The next thing to do is enter the server name if you know what this is, if not click the drop arrow and select from the list of providers. (See picture below).

[Click to see full-size]

Next, if your server is setup for it then you can choose “Windows Authentication” if not and you know what your SQL Server login settings are then enter the user name and password. Now you want to test your settings and make sure you can connect to your server so click on the “Test Connection” button now. Next you will get a message box showing the connection status of the test. If it’s ok press the “OK” button and the form will close and you will be back at the Data Adapter Configuration Wizard. Select either “Yes or No” to save the password for your connection in the App.config file. (Please note if you select “No” you will be promted for it each time you run any of your applications that need to connect to SQL server for data). I normally select “Yes” as I setup a login on SQl Server with only enough rights to handle the data I’m working with.
Ok, now click “Next” to advance to the next screen of the wizard. Here you can use sql statements, use existing stored procedures, or create new stored procedures. For now select “Use SQL Statements” and press the “Next” button.(See image below)

[Click to see full-size]

The next window you will see will be this one.

[Click to see full-size]

Select the “Sales” table and press the “Add” button and then the “Close” button.

The following window will appear below.

[Click to see full-size]

Select the (All Columns) square to place a tic mark and then press the “OK” button to save and close the window. You are once again back at the wizard and now you will see this code in the center.

SELECT sales.*
FROM sales
Ok, great, now press the “Next” and then the “Finish” button. In design view of Form1 just below the bottom of the form right click on the “sqlDataAdapter” and select generate dataset. Just go with the default settings and press the “OK” button. Ok now right click on the “sqlDataAdapter” again but this time choose “Preview Data”. On the form that pops up(See image below) press the “Preview” button

[Click to see full-size]

You will now see your data in the resulting form.(See image below)

[Click to see full-size]

Now look at the ball only because once data is
Thank you for taking the time to go through this tutorial, I really hope you have gained some knowledge. I fully intend to make these tutorials as complete and as easy as possible. Until next time take care, continuous learning.
JR

>> View the entire article here

In fact, a right hustings Web Hosting comfort for your website is not a slight mishap, especially when there are thousands of experienced top hosting providers all remembrance almost specific web hosting packages. Therefore, it is important to know some important considerations before starting your web hosting search. Below are three important criteria for web host seeker:

Web hosting traits demand

This is unvaried the mightily necessary account to build adjustment a innkeeper for your site. You solicitude to resolve the technical requirements for your website, this including:

a) Server suggestion and hardware requirements
If the site is a programming environment in this case Active Server Pages (ASP) is, Visual Basic scripts, Cold Fusion, or similar to Microsoft Access or Microsoft SQL database is going to agree to use flowering to support the hosting of one of the jewels of the grid you entrust such as Windows NT or Windows 2000 Server Windows proposition.

Likewise, if you dash to gravy train programming languages comparable as Perl, CGI, SSI, PHP or mySQL database, hence gob interlacing hosting plans that help Unix/Linux strategy should be operative to hang out your hosting requirements. Once you have these server platform and hardware requirements in mind, you can decide the best web hosting plans for your need. For more information, you can read “How to select a web server and server platform?”

b) Disk turn & Bandwidth desideratum
There are plenty of technology necessary, rest assured that you are greedy selection before interlacing hosting plan, that is, the scope and bandwidth of the disk. If you want to teach the content of the site is not exclusive (ie, web page), then the disk space requirements may not be a big concern you. In general, a 200MB hard disk space of 500 megabytes should be sufficient to meet the requirements of your host. Conversely, if you plan to hold a the same, graphics and video a large number of MP3 or video files, then you should consider a virtual hosting plan, such as providing a huge disk space, web site, 500 megabytes to 1,000 bytes.

Similarly, the bandwidth exigency bequeath depend on your suburb traffic estimation. Obviously, a website that gather to haul upset traffic leave smash the daily bandwidth premium very fast. If so, you will need to find one web hosting service that offer huge bandwidth with 40 GB to 100 GB per month. Depending upon your website requirement, choosing a web hosting service that provide sufficient amount of disk space and bandwidth is crucial consideration to prevent paying extra costs in the future should you overuse the monthly disk space and bandwidth allowance.

c) Other hosting traits
While the larger requirements are uttermost
important, practiced are poles apart hosting like that you have to presume true too. Can interlacing hosting provider aid video clips on your website, if you have? Is the lattice hosting assistance compatible with Dreamweaver or FrontPage web authoring tool? Do you plan to set up a virtual store online? Can the host support the e-commerce features without adding extra cost to your monthly payments? On top of that, you may also want to find out the number of email accounts provided, number of FTP accounts, web statistic software (analyze your web traffic), type of control panel supported (manage your web hosting account), database and scripting languages supported and etc.

Reliability and scalability

A culminating netting
hosting provider offers undisguised server uptime and flashing Internet connection. You should diagnostic pour in a lacework hosting aid that guarantee at inaugural 99% server uptime with high-speed Internet backbones using at number one OC3 (Optical Carrier) lines (155 Megabits per second) or above instead of T1 or T3 lines. A reliable web hosting provider usually invests heavily on their data center infrastructure with high performance servers, high speed multiple backbones providers with fail-over redundancy, backup power generators and firewall software protection in place to ensure they meet the uptime guarantee specified in the terms of service.

Similarly, you should aggregate a net hosting helping hand with hardware facilities that designed for scalability, thereupon that they can thrive
with your business. For example, if you need to elaborating further disk space, bandwidth or accommodate of mySQL databases, you should be telling to upgrade as needed without any problems.

Customer cooperation and sustain

The never cease basic basis in poll a netting
hosting furtherance is to catch a mesh hosting providers that offers admirable customer backing and support. You should always search for a web hosting provider that offers 24 hours a day, 7 days a week technical support that fielded with highly experience technicians, so that any web hosting problems will be resolved within a reasonable amount of time. You may also want to consider to test how responsive is their customer support by sending few inquiry emails to the web hosting provider. In general, any response in less than 24 hours is considered acceptable. It is a sign of poor customer support if they take more than one day to response.

In addition, a lacework hosting provider with elegant sustain
should and guard confused support channels, such as toll-free phone support, 24/7 email support, convincing chat, online knowledgebase, Interactive form tutorials and FAQ.

1. Introduction
Open Source Software (OSS) is an in-ternational phenomenon in terms of user adoption and development processes. Enterprise Information Integration (EII) significant gains credibility in the market as the most efficient approach to the combination of back-office data with line-of-business content. Enterprise integration with open source middleware, offers an automated tool for Data Integration, interoperability of data in a distributed environment. This integration tool using open source middleware to reduce costs through shorter, Sca-lability to realize.
2. Open Source Application Servers & Mid-dleware
There is a wide variety of open source applications and middleware on the market, many of which support the Java Enterprise Edition framework. These include Apache Geronimo, Apache Struts, Apache Tomcat, Apache Web server, Easy Beans, JBoss, JFox, JOnAS, IBM WebSphere Community Edition (formerly Gluecode), Mono Project (supports .NET), OpenEJB, Resin, and Sun’s Glassfish.

2.1 JOnAS – a Java Application Server
JOnAS (Java Open Application Server) is an open source Java EE applica-tion server which has been released free of cost under the terms of the open source GNU General Public License. JOnAS is the most widely used open source J2EE 1.4 ap-plication server. Applications deployed on Java EE application servers are assemblies of components dealing with user presentation or business logic. Those two layers (presentation and logic) are composed of JSPs and Servlets for the first one and of different kinds of components (i.e., EJB for Enterprise Java Beans) for the second one. An EJB can be a Session Bean implementing application logic which converts and parse the XML data , an Entity Bean to simplify access to persistent data contained in databases, A Message Driven Bean that reifies a message queue polling (like JMS queues or topics) to be performed during the server runtime. These services are required in most enterprise applications. To access services, application component implementations are placed into containers. Those containers are used as the glue between components and technical services.

Fig 2.1 JOnAS Architecture

3. Enterprise Integration using JOnAS
The key feature of enterprise integration is data integration that automates the inter organizational business transactions without requiring replacement or major changes to companies existing source systems, thus avoiding an expensive and time-consuming activity. This paper aims at developing an automated tool for integrating the data from different sources thereby providing integration among the data and interoperability of data in a distributed envi-ronment. The Enterprise integration provides the following advantages
? Integration of data
? Unified view of relevant information
? Cost Effective because of open source
? Distributed access because of middle-ware
? Reduced time consuming since integrated and unified view
? Transparency
? Scalability

Fig 3.1 JOnAS with Client and DBServer
The above figure 3.1 shows how a client can communicate with a database server through JOnAS via EJB (Enterprise Java Bean).
4. Framework
The paper Enterprise integration using open source middleware can have client side and server side. In client side, it can have number clients. Client can access with the information stored in Excel or Access. A client can insert or delete or update any information stored in the data source. Clients can be provided with Excel or Access database where they can do updations. After updating the information, client has to save the updations. Then the defined macro in that Excel or Access data sheet can call the batch file automatically which in turn calls the server program. The client program gets the input file (Excel or Access) and passes the file name as an argument to the server program. Client machine can have either Excel or Access or both.
The server program to retrieve the file path from the client, to activate the code, XML data or access to XML data to Excel for the input file depends on the conversion. Server-side program is then stored in an XML file to the server after you convert the XML data. The server then these XML files to extract and analyze data in a table to store information, SQL Server is stored in.

Fig. 4.1 Frame work of Enterprise integration using JOnAS

The Fig 4.1 clearly depicts the workflow of information integration and various components involved in this project. The steps involved in Enterprise information integration is as follows:
1. The latest access data is converted to xml whenever a new record is inserted /updated on a real time basis.
2. The latest excel data is converted to xml whenever a new record is inserted /updated on a real time basis.
3. Implement these two modules in Enterprise java bean with JOnAS as application server.
4. Extract the information from all XML files by parsing and store the data into tables residing in SQL Server.
5. Generate Reports by getting information from the tables using frames and JTable.

5. Setting up the Environment
The first and foremost step in implementing the system is setting up the environment. The overall tasks involved in setting up the system are as follows:
? Installing JOnAS
The steps involved in installing JOnAS require J2SE SDK 1.4, ANT 1.6 and JOnAS. Install everything and start the JOnAS.
? Connecting JOnAS with NetBeans
The next step after installing the JOnAS application server is to connect the installed JOnAS with the working environment. NetBeans is the working environment. Requirements for connecting JOnAS with NetBeans are NetBeans 5.5, JOnAS/Tomcat 4.7.x or 4.8.x and JOnbAS
? Connect SQL Server with JOnAS
To allow access to one or more relational databases, JOnAS will create and use DataSource objects. Such a DataSource object must be configured for each file that is used for the persistence of a bean. By default, JOnAS provides HSQL default data server. SQL Server can to Jonas by using a plug-in called jTDS connected. Before you install the SQL Server, we are three jar files in JO NAS_4_8_4libcommonsjonas upload directory, which gives access to SQL Server for JOnAS. Login JonasAdmin console. Select the new data source as a database. Enter the required information such as driver's name, URL, etc. are Done.

6. Implementation
This paper uses session bean for im-plementing the first two modules and entity bean for implementing the third module. The session bean converts Excel or Access data file to XML data file and fetches the data from the XML file by parsing it and after parsing, the session bean automatically calls entity bean which stores the extracted data in to SQL Server.
? ExcelToXML (File Excelfile, String file-name) – converts any Excel file to XML data file by getting Excel file as inputs. The procedure involved in converting Excel to XML data file is as follows:
? AccessToXML (String table, String connec-tion) – converts any Access DB to XML data file by getting table name and connection for JDBC connection as inputs.
The procedure for converting Acsess_to_XML and Excel_To_XML is shown below.

Fig 6.1 Procedure for XML conversion
The next step after converting the Microsoft Access or Excel file data to XML data is parsing the obtained XML files. By parsing the XML files, we can extract the data from the XML file and store it in an array which can then be used for storing it to an SQL Server. To manipulate a XML document, we need an XML parser. The parser loads the document into memory and once the document is loaded, its data can be manipulated using the DOM
? xml_parse_For_Excel (String xmlFile) – Parse the XML file obtained from Excel that suits for storing the latest XML data to SQL Server.
? xml_parse_For_Access (String xmlFile) -Parse the XML file obtained from Access that
The procedure for parsing XML files is same for both XML files obtained from Access or Excel. The steps involved in parsing the XML files are as follows.

Fig 6.1 Procedure for XML Parsing
Building and Deploying the Application
Now, enterprise application ready to deploy to the application server. There is no need for additional deployment descriptor configuration. IDE will have to configure the deployment descriptors, and the preparation of a new connection pool and data for enterprise applications source code. Right-click on the left of the window, and construction project applications. Output window displays the error, if any. Correct the error, the project deployment. Right-click, formation_Integration project, and then select Run Project. IDE will execute all of the following:
? Builds the enterprise application project and all of its subprojects (the Web module project and EJB module project).
? Starts the server if it is not already running.
? Undeploys the enterprise application if it is already deployed to the application server.
? Deploys the enterprise application to the application server.

fig 5.1 Information Integration deployed in JOnAS

Conclusion
Integration problem has been with information technology, information systems because the invention of the world. Today, the integration need to directly support the organization's goals and needs. Enterprise Integration using the open-source information integration middleware provides an automated tool, but also interoperability of data in a distributed environment. Therefore, this combination of enterprises use open source

Middleware provides an automated tool for information integration and thereby effects reduced cost and time, interoperability, scalability, persistency through open source middleware named JOnAS.
Future work can focus on developing an automated tool for integrating any number of input files from any sources and make it suitable for distributed environment.

References:
[1] Mabanza, N.; Chadwick, J.; Rao, G.S.V.R.K., “Performance evaluation of Open Source Native XML databases – A Case Study” Advanced Communication Technology, 2006. ICACT 2006. The 8th International Conference Volume 3, Issue , 20-22 Feb. 2006 Page(s): 1861 – 1865
[2] Ian Gorton2, Justin Almquist, Kevin Dorow1, Peng Gong3, Dave Thurman1, “An Architecture for Dynamic Data Source Integration”, Proceedings of the 38th Ha-waii International Conference on System Sciences, IEEE Transaction, June 2005.

[3] Alain Boulze, Francois Letellier, Pascal Moussier,” The ObjectWeb initiative, An Ex-ample of an open development process to promote a set of open source middleware technologies and bring them to main stream” , ObjectWeb Consortium, 2006.
[4] ObjectWeb Consortium , “Red Hat Application Server: JOnAS Tutorial “, 1999-2004

[5] Giovanni Guardalben, Shaku Atre, “Integrating XML and Relational Database Technol-ogies: A Position Paper” .
[6] Richard Monson-Hoeffel, “The Ultimate Guide J2EE web Services “, Pearson Educa-tion, 2002
[7] Heather Williamson,” XML: The Complete Reference”, Osborne/McGraw-Hill, 2001
James Edward Keogh, James Keogh, “J2EE: The Complete Reference”, McGraw-Hill/Osborne, 2002
[8] JOnAS: Java (TM) Open Application Server, http://jonas.objectweb.org/
[9] JOnAS Platform Documentation, http://jonas.objectweb.org/doc/jonas-doc-en-jonas4.2.3.pdf
[10] http://www.w3schools.com/xml/xml_syntax.asp
[12] http://JOnAS.objectweb.org/current/doc/howto/install_JOnAS.html
[13] http://www.theserverside.com/news/thread.tss?thread_id=42251
[14] http://objectweb.org/JOnAS/2006-12/msg00027.html
[15] http://java.sun.com/developer/onlineTraining/Beans/EJBTutorial/

AJAX is known as Asynchronous JavaScript and XML. Ajax is a type of web development method popularized by Google. Developed with the sole aim of making web development easy and simple, Ajax is a new means to create user friendly web applications. The main advantage of using Ajax technology is to generate quick responses and increase interactivity with the end users. Ajax is mainly based on JavaScript and HTTP requests. With this new technology, your JavaScript can communicate directly with the server, using JavaScript XML Http Request object. This technology uses asynchronous data transfer between the browser and the web server, which allows the web pages only to request little information from the server instead of retrieving whole pages.

Ajax technology is mainly based on Web standards, including JavaScript, XML to HTML and CSS. Ajax's main feature is that all of the web standards using this technology, clearly defined, and the same by all the major browsers support. With the help of Ajax, Internet applications, can be richer, more user-friendly. Ajax has several advantages. It can help programmers separate ways and the information provided through the website means to different aspects of the format used. Ajax-based Web site has become a big advantage as Digg, MySpace and other sites of many Web sites. Ajax also has some negative impact, mainly including the integration of the browser, search engine optimization, as well as the reliance on JavaScript.

Ajax is also called as a free framework for fast creation of interactive cross-platform web experiences. Based on server side architecture, Ajax supports interaction model. Intermediate application layer is an Ajax engine, which is added in between the user and server and which allows asynchronous user’s interaction with application. This approach has many benefits. The main features of Ajax include real-time form validation with server-side validation of codes. Ajax is quite complicated and hence it is not easy to learn Ajax. There are millions of tutorials on the web on Ajax. Some tutorials are very informative and resourceful. Most of them are written by people who have little experience and are just looking for some more traffic to their sites. Hence, you have to be very careful in choosing your tutorials.

If you want to use an Ajax application in your website, it is very important to take into consideration network latency. Network latency is the interval between the user’s request and the server’s response. If the user is unaware of Ajax properties, then it may result in assuming there is something wrong with that page. With the help of Ajax, you need not wait for your server to reload the page according to your requests. Ajax allows the page to process your request and make all the small changes accordingly without reloading an entire page. Professional Ajax Programmers use this language for several reasons. The main reason for using Ajax is to enhance the user experience, and to make web pages to behave like stand-alone applications. Ajax enabled pages load faster because they generate HTML within the browser.

ASP.NET (Active Server Pages.NET) is a standard programming language for website application development and more significantly for developing database-driven websites. ASP.NET was developed by Microsoft in the year 2002 with version 1.0 of the .NET Framework and is a fundamental part of Microsoft’s .NET framework vision. It is mainly used to create web pages and web technologies.

It is a full featured programming language and a valuable tool for programmers and developers which allow them to develop dynamic websites globally. With the help of ASP.NET, developers are able to build variety of applications such as custom software applications, mobile games, web applications, product development, ecommerce shopping carts, etc. Languages that support ASP.NET are C#, Visual Basic, and JavaScript.

ASP.NET is the most preferred language for developers is that very little code to write applications for the development of small and large. This development work, in addition to the long list of features provides a server-side programming model is to help some of the most favorable. Before you send to the browser, the server code with the code, instead of backup is to eventually provide additional security against theft of the code will run unwanted ASP.NET HTML code is sent.

ASP.NET pages can be written in easy, because the following reasons:

• It provides source code and HTML together.
• Source code is executed on server which provides power & flexibility.
• Source code is compiled fast in the first request of page because server saves the compiled version for the next time.
• Better security of application source code as it is not sent back to browser.
• Security through continuous monitoring of pages, components and applications running on it by web server which automatically removes the illegal software, memory leaks, infinite loops, etc.

Since 2002, ASP.NET and Web upgrade version of the advanced features provided with the world of development is the introduction of five. Its latest version 3.5 Service Pack 2008 features, Visual Studio 2008 Service Pack 1 in the ASP.NET Dynamic Data, ASP.NET is, AJAX applications, to control the browser's history and a new name space system Launched in support of incorporation and release