Thursday, July 30, 2009

HOW TO REMOVE PRINTER DRIVER

You can remove printer driver by following steps that are defined below:

1. Go to Printers & Faxes

2. Delete the printer configuration in question. (For safety's sake, you may want to consider deleting all printer configurations to ensure that you aren't still using some element of the driver in another configuration somewhere. Remember that a driver is often times more than just a single file. It may involve shared libraries in use by multiple printer configurations.)

3. Go to File --> Server Properties

4. Go to the Drivers tab. You will be presented with a list of drivers.

5. Select a Driver and press the "Remove" button.

Tuesday, July 28, 2009

\\server is not accessible. You might not have permission to use this network resource. Contact the administarator of this server to find out if you

Problem:

Often time I receive a problem while my computer is connected with networks.It work properly on server 5 minutes ago but after 5 minutes it display me the error.

"\\server is not accessible. You might not have permission to use this network resource. Contact the administarator of this server to find out if you have access Permissions. Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed. Disconnect all previous connections to the server or shared resource and try again."

I digged alot about the solution of the problem. Some post suggest block your firewall which I was not using and many other solution. But nothing work.

After a long hours of digging on web for the above problem and implementing all the solutions that they suggest in their post, I have found a valuable command which solve my problem and now I am not facing this problem and if some time I face then use the solution.


Oh........ I forget the share solution with you. The solution is based on commands and they are (Open your command prompt first)

1) net use * /d

The above command will remove all the map drives from your computer. After writing this command and press enter, it will ask you that to press 'y' for Yes and 'n' for No. Press y. After then write the next command

2) net use h:\\server_name\foldername

Now wait for a few seconds / minutes (might be). It will ask the user name and password. Enter the user name and password and get rid from the problem.

Hope this will work for you as well.

Best of Luck.

OUTLOOK CANNOT CONNECT TO YOUR OUTGOING SMTP EMAIL SERVER.

Dear Friends,

I am using MS OUTLOOK for my Email. It was working fine but since last day it is giving me an error.

"Outlook can not connect to your outgoing SMTP E-mail server. If you continue to recieve this message contact your Administrator or ISP Provider."


After digging long hours I get some solutions.

1) Change smtp port from 25 to 587.

OR

2) create the account again.

OR

3) Check Firewalls either they are not creating the problem.

OR

4) If any of the above options is not working then contact to your ISP Provider. Either they have block the SMTP address from their side. Ask them to allow your SMTP to send E-mails.

In my case the fourth option works.

I hope that this will help you in solving the problem.

Wish you all the best............

CONNECTION STRING IN WEB.CONFIG IN C#

Dear Fellows,

You can create declare connection string in web.config file. You can do so by

<add name="Connection_Name" connectionString="server=(local);database=database_name;uid=sa;pwd=sa" providerName="System.Data.SqlClient"/>

Now you can call this connection in any .aspx page by this command.

NOTE: I am getting connection string in a string variable named "Path"

string path = System.Configuration.ConfigurationManager.ConnectionStrings["Connection_Name"].ConnectionString;

See how simple is this. In the same way you can use this connection string in all your .aspx pages.

Take Care and Enjoy...............

Thursday, July 16, 2009

The TargetControlID of '_AccordionExtender' is not valid. The value cannot be null or empty.

Once I was working with a Ajax Based Project in .NET. I was using Accordian Pane. My code was like this (Please note this is just a sample code only for readers):

<ajaxToolkit:Accordion runat="server" TransitionDuration="240" FadeTransitions="true" FramesPerSecond="40" SelectedIndex="0" >
<Panes>
<ajaxToolkit:AccordionPane ID="hd1" runat="server">
<Header>
<a href="" onclick="return false" >HEADER 1</a>
</Header>
<Content>
CONTENT OF HEADER 1
</Content>
</ajaxToolkit:AccordionPane>


<ajaxToolkit:AccordionPane ID="hd2" runat="server">
<Header>
<a href="" onclick="return false" >HEADER 2</a>
</Header>
<Content>
CONTENT OF HEADER 2
</Content>
</ajaxToolkit:AccordionPane>
</Panes>
</ajaxToolkit:Accordion>

And I was facing an Error saying

"The TargetControlID of '_AccordionExtender' is not valid. The value cannot be null or empty."

After digging a little bit I found that I have not provided ID to Accordian

<ajaxToolkit:Accordion id="accordian1" runat="server" TransitionDuration="240" FadeTransitions="true" FramesPerSecond="40" SelectedIndex="0" >
<Panes>
<ajaxToolkit:AccordionPane ID="hd1" runat="server">
<Header>
<a href="" onclick="return false" >HEADER 1</a>
</Header>
<Content>
CONTENT OF HEADER 1
</Content>
</ajaxToolkit:AccordionPane>


<ajaxToolkit:AccordionPane ID="hd2" runat="server">
<Header>
<a href="" onclick="return false" >HEADER 2</a>
</Header>
<Content>
CONTENT OF HEADER 2
</Content>
</ajaxToolkit:AccordionPane>
</Panes>
</ajaxToolkit:Accordion>

After providing ID to Accordian its works fine..................

I hope that this post will also help you.

Wednesday, July 15, 2009

HOW TO CONVERT A STRING INTO DATE IN VB.NET OR C#

To Convert a String into Date Format we need date.parseexact() Function.

date.parseExact(date as string, format as string, third attribute)

example

date.parseExact(stDate, "MM-dd-yyyy", nothing)

That's all......... Enjoy.............

WEBCONFIG FILE FOR AJAX IN ASP.NET 2.0 , ASP.NET 3.0 AND ASP.NET 3.5

Dear Friends,


When I have installed VSTS 2008 in my PC, I faced problem in using Ajax Files. I follow all the instructions that was told in vidoes on www.asp.net\learn but no result.


After investing a number of days and hours, I come to the conclusion that I must have to see my old Ajax Projects WebConfig files. When I compare my existing projects webconfig files and old webconfig files I found that they have no Commands to work with Ajax Based Controls.


The reason to publish this webconfig file is to save others time as they might face some time the same problem which I faced and wasted my time.


Below is the entire webconfig file. Simply copy it in your webconfig file or change it as per your need.



<?xml version="1.0"?>

<configuration>

<configSections>

<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>

<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/></sectionGroup>

</sectionGroup>

</sectionGroup>

</configSections>

<system.web>

<pages>

<controls>

<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add namespace="AjaxControlToolkit" assembly="AjaxControlToolkit" tagPrefix="ajaxToolkit"/>

<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></controls>

</pages>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

-->

<compilation debug="true">

<assemblies>

<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Web.Extensions.Design, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></assemblies>

</compilation>

<httpHandlers>

<remove verb="*" path="*.asmx"/>

<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>

</httpHandlers>

<httpModules>

<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</httpModules>

</system.web>

<system.web.extensions>

<scripting>

<webServices>

<!-- Uncomment this line to customize maxJsonLength and add a custom converter -->

<!--

<jsonSerialization maxJsonLength="500">

<converters>

<add name="ConvertMe" type="Acme.SubAcme.ConvertMeTypeConverter"/>

</converters>

</jsonSerialization>

-->

<!-- Uncomment this line to enable the authentication service. Include requireSSL="true" if appropriate. -->

<!--

<authenticationService enabled="true" requireSSL = "true|false"/>

-->

<!-- Uncomment these lines to enable the profile service. To allow profile properties to be retrieved

and modified in ASP.NET AJAX applications, you need to add each property name to the readAccessProperties and

writeAccessProperties attributes. -->

<!--

<profileService enabled="true"

readAccessProperties="propertyname1,propertyname2"

writeAccessProperties="propertyname1,propertyname2" />

-->

</webServices>

<!--

<scriptResourceHandler enableCompression="true" enableCaching="true" />

-->

</scripting>

</system.web.extensions>

<system.webServer>

<validation validateIntegratedModeConfiguration="false"/>

<modules>

<remove name="ScriptModule"/><add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</modules>

<handlers>

<remove name="ScriptHandlerFactory"/>

<remove name="ScriptHandlerFactoryAppServices"/>

<remove name="ScriptResource"/><remove name="WebServiceHandlerFactory-Integrated"/>

<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</handlers>

</system.webServer>

<system.codedom>

<compilers>

<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">

<providerOption name="CompilerVersion" value="v3.5"/>

<providerOption name="WarnAsError" value="false"/></compiler>

<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">

<providerOption name="CompilerVersion" value="v3.5"/>

<providerOption name="OptionInfer" value="true"/>

<providerOption name="WarnAsError" value="false"/></compiler></compilers></system.codedom>

<runtime>

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

<dependentAssembly>

<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>

<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/></dependentAssembly>

<dependentAssembly>

<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>

<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/></dependentAssembly></assemblyBinding></runtime></configuration>

Wednesday, July 1, 2009

How to Insert a new Node in XML File in C#

This is 4th post regarding XML. In this, I will teach you how to insert a new node in XML file.

The sample XML file is shown below which is before Inserting new Node.

<?xml version="1.0"?>
<Library>
<Subjects name="Computer Science">
<Publishers name="Wrox">
<Begginers>Beginning C#</Begginers>
</Publishers>
</Subjects>
</Library>


Now write the below code to insert a new node in XML.

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(filename);
//Create New Element
XmlElement element = xmldoc.CreateElement("Begginers");
element.InnerText = "BEGINNER C# (INDIAN WRITER)";
//Insert Node after Publishers
xmldoc.DocumentElement["Subjects"].ChildNodes[0].InsertAfter(element, xmldoc.DocumentElement["Subjects"].ChildNodes[0].LastChild);
FileStream fsxml = new FileStream(filename, FileMode.Truncate, FileAccess.Write, FileShare.ReadWrite);
xmldoc.Save(fsxml);
Console.WriteLine("XML Updated Successfully");


After executing this code you will get the following output.

<?xml version="1.0"?>
<Library>
<Subjects name="Computer Science">
<Publishers name="Wrox">
<Begginers>Beginning C#</Begginers>
<Begginers>BEGINNER C# (INDIAN WRITER)</Begginers>
</Publishers>
</Subjects>
</Library>

How to Insert an New Element in XML File in C#

This is my third post in which I tell you how to Insert an Element in XML file.

The sample XML file is shown below

<?xml version="1.0"?>
<Library>
<Subjects name="Computer Science">
<Publishers name="Wrox">
<Begginers>Beginning C#</Begginers>
</Publishers>
</Subjects>
</Library>


Now you write the code to insert a new Element.

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(filename);
//New XML ELEMENT Created
XmlElement xElement = xmldoc.CreateElement("Publishers");

//NEW XML ATTRIBUTE Created
XmlAttribute xAttribute = xmldoc.CreateAttribute("name");
xAttribute.Value = "Indian Book";
xElement.SetAttributeNode(xAttribute);

//Create Inner Element
XmlElement element = xmldoc.CreateElement("Begginers");
element.InnerText = "BEGINNER C# (INDIAN WRITER)";
xElement.AppendChild(element);
xmldoc.DocumentElement.InsertAfter(xElement, xmldoc.DocumentElement.LastChild);

FileStream fsxml = new FileStream(filename, FileMode.Truncate, FileAccess.Write, FileShare.ReadWrite);
xmldoc.Save(fsxml);
Console.WriteLine("XML Updated Successfully");



After executing this code. you will get the following output xml.

<?xml version="1.0"?>
<Library>
<Subjects name="Computer Science">
<Publishers name="Wrox">
<Begginers>Beginning C#</Begginers>
</Publishers>
</Subjects>
<Publishers name="Indian Book">
<Begginers>BEGINNER C# (INDIAN WRITER)</Begginers>
</Publishers>
</Library>

How TO READ XML IN C#

This is my Second post regarding XML. In first post i told you that how to create a xml file in C#. Now we will learn that how can we read a xml file in c#.

To read an XML file in c# you need to add a namespace.

using System.XML;

Now write the below code to read xml file.

XmlTextReader reader = new XmlTextReader(filename);
reader.Read();
while (reader.Read())
{
if(reader.Value.Trim()!="")
Console.WriteLine("Attribute Count={0}, Attribute={1}, Value={2}", reader.AttributeCount, reader.GetAttribute("name"),reader.Value);
}



I used this code to get my result which I want. You can modify the code to get yours one.

Enjoy..........

HOW TO WRITE XML IN C#

Below is the code in C# which you can use to create an XML file.



Note: You must include System.XML namespace. You can do so by writing the below command.

using System.XML;

The sample of XML is shown below:

<?xml version="1.0"?>
<Library>
<Subjects name="Computer Science">
<Publishers name="Wrox">
<Begginers>Beginning C#</Begginers>
</Publishers>
</Subjects>
</Library>

Now write the below code to get the above result.

XmlTextWriter writer = new XmlTextWriter(filename, null);
//SELECT THE FORMATTING STYLE (INDENTED, NONE)
writer.Formatting = Formatting.Indented;
//STARTING TAG
writer.WriteStartDocument();
//STARTING "Root"
writer.WriteStartElement("Library");
//STARTING ELEMENT NAMED "COMPUTER SCIENCE"
writer.WriteStartElement("Subjects");
writer.WriteAttributeString("name", "Computer Science");
//FURTHER ELEMENT NAMED "COMPUTER SCIENCE"
writer.WriteStartElement("Publishers");
writer.WriteAttributeString("name", "Wrox");
writer.WriteStartElement("Begginers");
writer.WriteString("Beginning C#");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Close();
Console.WriteLine("XML Written Successfully");

Thursday, June 18, 2009

DataRowStates of DataSet

Programmers always look for shortcuts and ease while he perform his job. Microsoft provides a number of Services in this Regard. VisualStudio.NET is one of the remarkable development of Microsoft. (Enough to talk about Microsoft)


Here, I want to tell you that how can we get only that data from DataSet which we manipulate while we were performing our job.

DataSet has a number of DataRowState Properties:

1) DataRowState.Added
2) DataRowState.Deleted
3) DataRowState.Modified
4) DataRowState.Detached
5) DataRowState.Unchanged


DataRowState help us in getting the manipulated data which we either Change, Delete or Add.

Now, How can we use these state. I am telling you below but first we have to fill a dataset by any values. For Example, I create my own database. Insert values in it and after then I call them through query into dataset.

Here, I assume that you must have fill your dataset already. Now change a value of any row from your dataset. To get confirmation that something is changed you can use the below command:

MessageBox.Show(dataSetName.HasChanges)

If it return you "True" then we get confirmed that something is modified in dataset. Now you can get all the changes either modified rows, added rows, deleted rows, etc. by single command

ds.GetChanges()

or you can get only those deleted/Modified/Added rows by following the below code:

ds.GetChanges(DataRowState.Modified)

The above command will return you only updated rows.

Below I am writing entire Code for the easiness of your sake:


/////////////Form Loaded Method//////////////////////
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles

MyBase.Load
Try
con.Open()
da = New SqlDataAdapter("select * from tblstudent_Main", con)
da.SelectCommand.ExecuteNonQuery()
da.Fill(ds, "table1")
con.Close()
ds.Tables(0).Rows(1).Item(1) = "Zeeshan"
ds.Tables(0).Rows(5).Item(1) = "Ahmed"
Dim dr As DataRow
dr = ds.Tables(0).NewRow
dr.Item(0) = 7
dr.Item(1) = "Memon"
ds.Tables(0).Rows.Add(dr)
Catch ex As Exception

End Try
End Sub



//////////Button Click Method/////////////////
MessageBox.Show(ds.HasChanges)
Dim ds2 As New DataSet
ds2 = ds.GetChanges()
For Each dr As DataRow In ds2.Tables(0).Rows
///Return True if the rows are added else False

''MessageBox.Show(ds2.HasChanges(DataRowState.Added))

//Return you DataRowState. Remember if you do not write toString() then
it will return you numeric value.

MessageBox.Show(dr.RowState.ToString)

Next
DataGridView1.DataSource = ds2.Tables(0)

MessageBox.Show("transfereed successfully")


I hope that this will help you alot in understanding the DataRowState Concept.

Wednesday, June 10, 2009

PARAMETERS REQUIRED IN CRYSTAL REPORT

Dear Friends, When I was new to Crystal Report in Visual Studio. The very first problem that I was encoutered was how to pass parameters to Crystal Report from vb.net. And I was amazed when I found the solution quite easy.

Solution:

You must first make an instance of the report object

dim rpt as new reportname

now you can pass the parameter to report

rpt.setparametervalues("ParameterName",value)

For Example

rpt.setParameterValues("Name",value)

I hope this will help you alot.

Invalid Report File Path

Dear Friends, Last days I was very upset due to a minute problem which make my life hell, and when I discover its solutions I was amazed that how much easy it was to resolve.

Problem:
I create a report in Visual Studio 2003 in vb.net. The report display its results but when I give it command to print the document or to export the document then it shows me an error which says

"Invalid Report File Path"

I google on web alot and found a huge number of solutions too but neither work for me.

Solution:
The solution was quite simple. I have written all the queries and codes in FormName_Activated() Method. I just cut the code from there and paste it to FormName_Load() Method.

And get the result which I want.

It now not only export the report but also print the report too.

Ohh..... GOD some times a minor problem becomes a huge one and have a very minute solution but only the problem is to discover it..............

I hope this will help you as well.

Wish you all the best......................

Wednesday, June 3, 2009

INSTANCE OF REFERENCE IS DISPOSED

Some times we have a situation where we dispose the reference instance and then later on we try to use it and it gives us an exception

"Cannot access a disposed object".

The simple solution of the above problem is that you first check that either the instance of the reference is not disposed. If it is disposed then create a new instance of the reference and to check that either the instance of the reference is alive or not, we simple write the following code

if frm.IsDisposed()=true then
frm=new form1
end if

That's all....

Enjoy the world of Programming.

Wednesday, May 27, 2009

DATAGRID INSIDE COMBOBOX

Dear All,

Once my client demand me to provide combo box inside datagridview. I have searched a number of articles but was unsucessfull to know that how to get the value from combo box. On the below link you will find the program in winrar format. Extract it and enjoy.

After Opening this link, search for windowsApplication1.rar.

http://tech.groups.yahoo.com/group/universal_programmersgroup/files/

Saturday, May 2, 2009

CRYSTAL REPORT INSTR() FUNCTION

Many Novice/Professional users face a common error "A boolean is required here" while using Instr() Function in Crystal Report. They try to give true /false or 0/1 value. But still failed in getting the desired result.

Instr() Function take the Index if it find the given text in the defined string. So the simple solution of the problem is

if Instr(string from where to search , string that is searched) > 0 then
"Type the message if the search is successfull"
else
"Type the message if the search is Unsucessfull"

I hope that you will understand it this time and after then in entire your life you will not forget it.

Monday, April 27, 2009

CLOUD TECHNOLOGY

Cloud Computing [ known as Softwares as a Service (SaaS), and also as on-demand software ] is a new technique in which you can access the services and software application on your system without the need of installing software applications and services on your end. The reason behind this is that all these services/applications are provided to you from any system that is enrolled or part of the cloud.

Cloud computing is a computing paradigm in which tasks are assigned to a combination of connections, software and services accessed over a network. This network of servers and connections is collectively known as "the cloud." Computing at the scale of the cloud allows users to access supercomputer-level power. Using a thin client or other access point, like an iPhone,
BlackBerry or laptop, users can reach into the cloud for resources as they need them. For this reason, cloud computing has also been described as "on-demand computing."

An example of Cloud Computing is Google Apps, which provides common business applications online that are accessed from a web browser, while the software and data are stored on Google servers.

Cloud Technology is a style of computing in which typically real-time scalable resources are provided “as a service” over the Internet to users who need not have knowledge of, expertise in, or control over the technology infrastructure ("in the cloud") that supports them.