Advanced Dot Net Technologies

2011-07-10T07:50:00.000-07:00

Error :

In VS 2005 some time it will not go to the Debug mode , the reason may the IE update , To resolve this issue do the below task

Solution :

1. Open RegEdit

2. Browse to HKEY_LOCALMACHINE -> SOFTWARE -> Microsoft -> Internet Explorer -> Main

3. Add a dword under this key called TabProcGrowth

4. Set TabProcGrowth to 0

2011-01-15T23:08:00.000-08:00

Error Message

Error 1 Method 'get_EnableCdn' in type 'System.Web.UI.ScriptManager' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' does not have an implementation.

Solution :

Check the version of the 'System.Web.Extensions.dll , in the reference , web config file and the place where use the script manager , if you are using ver 3.5 you should refer the same in pages also

2011-01-13T10:45:00.000-08:00

I came across a good website for JQuery based Image gallery .

http://www.flash-gallery-maker.com/jquery-photo-gallery.html

2011-01-13T10:43:00.000-08:00

Error Message
Microsoft JScript runtime error:

This error will occur in the Jquery the error will be displayed based on the User Defined ..

Solution :
Check the Jquery Source file

2011-01-13T08:00:00.000-08:00

ERROR :

CS1703: An assembly with the same identity 'System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' has already been imported. Try removing one of the duplicate references

SOLUTION

Check the version of the .net Framework . in the project ,

2010-01-21T03:00:00.000-08:00

Hosting ASP.NET 1.1 Application in IIS7 with Windows Server 2008 Environment

Migrating your ASP.NET 1.1 application from IIS 5.1 to IIS 7 is easy task , until you had installed all the patches and Service pack , while installing the IIS 7 install the IIS 6 Comparable tools also

Check List:

Mostly in Windows Server 2008 there won’t be ASP.NET 1.1 , so we need to install the .Net Framework 1.1 , then the service pack for .Net framework 1.1 then the security updates for asp.net 1.1 , After you installed all the patches you can find the ASP.NET 1.1 in the application pool (fig -1)

fig-1

Yes now your IIS 7 is ready for ASP.NET Application , then Create a Virtual Directory and assign the Specific folder of the application , then assign the asp.net 1.1 application pool to the application

Click on the application in the right hand side you can find the action window [fig-2]Click on the Basic Settings edit window will open [fig-3 ] in that select the ASP.NET 1.1 application Pool and press Ok

fig-2

fig-3

Tips & Tricks:

Tips 1 : Custom Error Click on the projects in the property area under IIS  Error Pages  open this right Click on the window and open the Edit window [fig-4] here you can set the customer error based on your needs [fig-5]

fig-4

fig-5

Tips 2: SMTP –Just fill the Necessary details

Tips 3: Authentication - Purpose is same as the previous version this time must user friendly then before

Common Errors:

IIS Worker process stopped. – If you had not installed Service pack for 1.1 this error will come

An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Ambiguous match found – if you had not assigned the correct application pool

Folks all the above said procedures, tips and error messages are what I had faced in my production environment. Kindly bear for my poor English

2010-01-19T23:07:00.000-08:00

Error Message :

unable to start debugging on the web server. the type initializer for system.net.digestclient threw an exception

Cause : if your environment is VS2005 with .Net Framework 2.0 ,and if u have an assembly with security.dll this error will come ,

Solution : rename the assembly name

2010-01-19T00:00:00.000-08:00

Error Message

Error 811 F:\MySampleProject\RptCrystalViewer.aspx: ASP.NET runtime error: '/LM/W3SVC/1/ROOT/MySampleProject/is not a valid IIS application. F:\MySampleProject\RptCrystalViewer.aspx 1 1 Finance

Cause : Due to Invalid path

Solution :

Right Click on the Project go to the web Tab and Change the path

2010-01-02T22:15:00.000-08:00

Error Message

IIS Worker process stopped , When your Deploy your ASP.Net 1.1 Version of application in II7 , we need to set the application pool for Framework 1.1 , if you install Framework 1.1 it will automatically create , once the application pool is created and you had assigned to the the asp.net 1.1 application grt, it should work fine.. rit , but it wont , what it will do means it will stop the work process ,,.. you might ask why the hell it stops my work process ? good Question

y beacause ..... u r using microsoft products u have not installed the service pack that the reason ,,

So u need to the install the service pack for .net framework 1.1 , with asp.net 1.1 security update for framework 1.1 once your had installed it will work fine ..

2009-12-25T02:02:00.000-08:00

Error Message :

ASP.NET Ajax client-side Framework failed to load

Solution :

add the tag in web config file

2009-12-25T00:28:00.000-08:00

While using the Ajaxtoolkit and if you have different version of Framework you might receive this message

Error Message :

Error 2 Assembly 'AjaxControlToolkit, Version=3.0.30512.17815, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e' uses 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' which has a higher version than referenced assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'

Solution :

in the web config file inside the configuration section add this tag

2009-02-13T00:11:00.000-08:00

Error: The Web Server Could Not Find the Requested Resource while debugging the web application you might receive this type of error after you update the web application tools

Reason :
If you have installed the URLScan Filter this error will come , basically URLScan is for IIS 7 if you install for IIS 6 it will create this problem .

Solution:
Un install the URLScan Tool , Because IIS 6 has all the resources of URLScan

2009-01-28T02:01:00.001-08:00

Nowadays i am mostly working in VS 2005 , i have a problem in master page . the problem is when i am creating the pages its not showing the option to select the master page, I am receiving this problem in my laptop but in my desktop I had installed the same version its showing the option .As a temporary solution I am adding the master page in code behind . any guess what could the problem . I had also installed the service pack 1 for VS 2005 in

both the PC

2008-12-03T21:26:00.000-08:00

Development Environment :
Windows XP, IIS 6, VS 2005 , Framework 2.0 ASP.NET 2.0

Deployment Environment :
Windows Server 2008, IIS 7 , ASP.NET 2.0 and Framework 2.0

Error Message :
Request is not available in this context Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Request is not available in this contextSource Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[HttpException (0x80004005): Request is not available in this context]
System.Web.HttpContext.get_Request() +3465893
IIMSMain.Global.Application_Start(Object sender, EventArgs e) in C:\Prabakar\IIMS\Global.asax.cs:27
[HttpException (0x80004005): Request is not available in this context]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +3385130
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +125
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +182
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +259
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +245
[HttpException (0x80004005): Request is not available in this context]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3465475
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +675
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434

Solution

Change in Global.asax file in the

protected void Application_Start(Object sender, EventArgs e)
{
ApplicationConfiguration.OnApplicationStart(HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath));
Masters.SystemFramework.ApplicationConfiguration.OnApplicationStart(HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath));
}

Then change the application pool to classic .net , this is how i solved my problem

2008-11-23T23:47:00.000-08:00

Error Message :
This error will occur when u try to send mail from your web application
"the smtp server requires a secure connection or the client was not authenticated"

Cause : due to the Network Credential we will receive this error when we use any third pary smtp servers

SOLUTION :

string sMailServer = "smtp.gmail.com";
MailMessage mailmsg = new MailMessage("sampl@gmail.com", "sampl2@gmail.com", "HAI", "Success ! ");
SmtpClient smtpclt = new SmtpClient();
System.Net.NetworkCredential basicauth = new System.Net.NetworkCredential("sampl@gmail.com", "007");
smtpclt.Host = sMailServer;
smtpclt.UseDefaultCredentials=false;
smtpclt.Credentials=basicauth;
smtpclt.EnableSsl = true;
smtpclt.Send(mailmsg);

2008-11-23T03:56:00.000-08:00

Error Message :

Failed to update database "D:\HOHRMIS\APP_DATA\ASPNETDB.MDF" because the database is read-only.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Failed to update database "D:\HOHRMIS\APP_DATA\ASPNETDB.MDF" because the database is read-only.

Cause of the problem :

when we move the project from the inetpub default folder to some other location we will get this error , this is due to the read / write rights .

Solution :

Detach the database
Give read / write access to the APP_DATA folder
Attach the database then run it

2008-10-08T08:38:00.000-07:00

Error:
some time while saving the project we may receive this type of error

Error occured saving the project file '' access is denied

Cause:

read only rights is given the project folder

Solutiuon :

Remove the Read only rights for the project and give write rights also

2008-10-08T08:30:00.000-07:00

Error:

Auto-attach to process '[4572] aspnet_wp.exe' on machine 'PRABAKAR' failed. Error code 0x8013134b.
OR
Error While Trying to Run Project : Unable to start debugging on the server.

Cause:
there are many reason for this error.the one possiable reason is when u r migrating form one version to another versionwe will get this type of error.

Solution :

select the project in the IIS and go to the properties and select the ASP.NET Tab and change the version,possiable to the previous version.

2008-08-25T23:05:00.000-07:00

Error

Error in File C:\Inetpub\wwwroot\IIMS\RptTrialBalance.rpt: Error detected by export DLL:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.ExportException: Error in File C:\Inetpub\wwwroot\IIMS\RptTrialBalance.rpt: Error detected by export DLL:

Cause: Mostly we will face this problem while exporting the report to excel, or to doc , for PDF there wont be problem , the solution is to update the Crystal report

Solution:

ftp://ftp1.businessobjects.com/outgoing/CHF/crnet11win_en.zip

update the hot fix so there that the problem will be solved

2008-07-28T06:53:00.001-07:00

Error Message

Parser error

Cannot load type admin.web.login

Cause and Solution

This error will occur when the assembly for the project is not created. Check whether the assembly is created or not, some time the assembly will be created in the project folder not in the solution folder, for that change the project output location

2008-07-27T23:44:00.000-07:00

Error Message

Configuration Error

Access is denied ‘Web’

Cause and Solution

Start --> Administrative Tools --> Computer Management --> Services and Application --> Indexing Services -->

Stop the Indexing services and restart it ,

This Error is caused due to the access denial for the temp location if we restart the services this location will set if the problem still exists go the system link and create new directory and add the specific location

2008-07-23T02:32:00.001-07:00

Error Message

Parameter count does not match parameter value count

Cause and Solution

This error will occur when you make any changes in the stored procedure i.e. like adding new parameter to the procedure .The reason is in the SQL catalog the old sp will be there , even if you drop the Sp it will show the same error , the solution is

1. First drop the sp
2. Then if its is web application reset the application
3. Then open the application now it will show the sp not found error now you run the Sp this problem will be solved

2008-07-23T02:31:00.000-07:00

Error Message

Arithmetic overflow error converting numeric to data type numeric

Cause and Solution

Arithmetic overflow will occur when you try to set the larger value in the lesser length variable , Just increase the length the field. This problem will be solved

2008-07-23T02:30:00.000-07:00

Error Message

String or binary data would be truncated. The statement has been terminated.

Cause and Solution

Some time we will receive this kind of error from procedure while retreving data this is due to the overflow of any filed value , so just Turn of the Warnings using the System Variable as give below

SET ANSI_WARNINGS OFF

2008-07-23T02:25:00.000-07:00

Error Message

Tables or functions 'bspl_detail' and ‘bspl_detail' ' have the same exposed names. Use correlation names to distinguish them. ...

Cause and Solution

This type of error will occur when you use the same table more then once in the join with out alias name,

Give the Alias name to the table so that it will be solved

2008-07-01T23:26:00.000-07:00

Eric Traut talks Windows 7 and MinWin from Long Zheng on Vimeo.

2008-06-27T02:12:00.000-07:00

Bill Gates' last day
At CES 2008, Microsoft Chairman and CEO Bill Gates and some of his closest friends debuted a comical look at what life would be like as Bill's last day approaches. Many of entertainment's biggest heavyweights, such as Bono from U2, actor George Clooney, and director Steven Spielberg, got some laughs..

Copied from : builderau

Find Colum present in the table or not

2008-04-29T01:23:00.001-07:00

Hi,

if((select @count=count(*) from sysobjects tab,syscolumns col where col.id=tab.id and tab.Name=<tablename> and col.name=<columnname>)>0)
begin
print 'Column present'
end
else
begin
print 'Column not present'
end

Regards,

Sasikumar D

Direct - +91 80 41041751

Mobile - +91 9986080299

iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and Ranked No.6
by Business Today-Mercer Human Resource Consulting-TNS in a cross industry survey of Best Companies to work for in India
----------------------------------------------------------------DISCLAIMER---------------------------------------------------------
Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com
and delete this EMAIL including any attachments

2008-04-21T23:24:00.000-07:00

System restarts after i install Windows XP Service Pack 3

Good news is that Microsoft had released a service pack 3 for windows xp. as usual it comes with some problem . a week before i installed the service pack 3 after that it ask me restart then the problem starts it will boot and come till the welcome screen and then it will restarts .... even when i try thought the safe mode and all other modes which they had given nothing works .. then as usual gooooogleeee.. and found the solution , that’s is due to versioning problem to solve this

Put your windows cd and boot in repair mode and then copy the file gdi32.dll from c:\windows\servicepackfiles\i386\ to c: \ windows \ system32\ before coping this file make a backup of this file in c: \ windows \ system32\ this location and reboot it It works

2008-03-25T23:39:00.001-07:00

Last week I got a chance to go to the VS 2008 Launch event in Abu Dhabi, It’s a nice time to be there. the event starts with all the basic formulates and the launch is for VS 2008, SQL Server 2008 , Server 2008 , there were 2 sessions one is for developer and another is for Professional , so I went for developer session . first they start with the features in framework and then they explained about the other features in asp.net and they are more concentrated on team server , that’s the very important feature, there is lot new in SQL server 2008 also with more features for reporting and charting . they had included chat and reports in SQL 2008 , I remember in my previous company we bought that , and its very powerful with gadgets with dashboard and they also launched a new product called expression suit , it has expression blend, expression media, expression web media and another one I forget it ..

We had a good breakfast in the morning and very good lunch … at last they gave a trial pack for VS 2008, SQL Server 2008, Server 2008 and expression suit , in the next once I will write deeply about the technologies

2008-02-18T00:56:00.000-08:00

Writing the Error or any log message to Event log of the OS

string sSource, sLog, sEvent;
sSource = "Error Occur While Inserting Employee Record";
sLog = "Application";
sEvent = "Insert";

if (!EventLog.SourceExists(sSource))
EventLog.CreateEventSource(sSource,sLog);
EventLog.WriteEntry(sSource,sEvent);

2008-02-05T00:56:00.000-08:00

Error Message

The Current time on this computer adn the current time on the network are different for moreinformation about Date/Time Propertoes, see Help and Support . To log on , Contact your system administrator

Cause : This error will occuer when you convert you client PC to the Domain sever . There is the date / time difference between the server and the client .

Solution : ASk your administrator to check the correct time in the server and the client or if your are the administrator log in to the client and set the time as if in the server

2008-01-20T05:56:00.000-08:00

Specified argument was out of the range of valid values. Parameter name: 9

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: 9

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: 9]
System.Web.UI.WebControls.ListControl.set_SelectedValue(String value) +152
Masters.Web.LedgerMasterAddEdit.Display() +32
Masters.Web.LedgerMasterAddEdit.Page_Load(Object sender, EventArgs e) +1710
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

________________________________________
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Reason: Inadequate master record. This type of error will usual occur in the dropdown list / list boxes, for example if we have 3 records which need to be bind to the dropdown list
1 – India
2 – UAE
3 – USA

Now we had bind to the control and we had select (UAE) and saved in the transaction file after that we had removed UAE from that list and now when we try to edit the record from the transaction file , it will look the record UAE . if it is not there in the list we will get this error

Solution: Add the record UAE to the list

2008-01-19T01:21:00.000-08:00

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30560: 'Global' is ambiguous in the namespace 'IIMS'.

Source Error:

Line 31: _
Line 32: Public Class Global_asax
Line 33: Inherits IIMS.Global
Line 34:
Line 35: Private Shared __initialized As Boolean = false

Source File: C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\iims\6d858d13\228f9de0\y2eps_v4.0.vb Line: 33

Reason: There is an assembly in the project with the same class name; we can find the assembly in the bin folder

Solution : Just delete the assembly from the bin folder and rebuild the solution .This kind for error occur some time when we may change the assembly name for some reason and forget the delete the assembly from the bin folder

2008-01-16T23:03:00.001-08:00

It’s a Great News from Microsoft that they had given provision to see the source code of the .Net Framework libraries. It had been announced on October and now it has been released , and its only for VS2008 . for detailed view you can see that in Scott’s Blog

2008-01-16T22:35:00.000-08:00

What are the stages in Software release, what does it actually mean?

Alpha: Alpha refers to the very early release, which is typically very buggy and only released to few people internal to the organization. It is helpful, in development,

Beta: Its is the first version released out side the Organization with bugs.

Gamma or Release Candidate:
At this phase the product is also most completed and up to release with very minimum bugs. When the product reached this stage it means that, there won’t be any further change or update in the code

Gold or Release: It’s the final finished product, with only few fixes. After this stage the product will be stable for release in the market

2007-12-11T06:46:00.001-08:00

To display the content in the web browser status bar

<’''body id="samplepage" onload ="window.status='First Page'">
<''form id="Form1" method="post" runat="server">

<''/form>
<’''/body>

2007-12-11T06:32:00.000-08:00

Disabling the right click in the webpage
" <" body id="”samplepage”" oncontextmenu="return false;">

<"/body>"

2007-12-11T06:30:00.000-08:00

Getting the client browser / system details through ASP.NET

HttpBrowserCapabilities bc=new HttpBrowserCapabilities();
bc=Request.Browser;
Response.Write(bc.Cookies.ToString());
Response.Write(bc.ActiveXControls.ToString());
Response.Write(bc.Platform.ToString());

Here HttpBrowserCapabilities is an class which is available in the system.web namespace ,first create an object and assign the client browser to it then we can get the details of the client browser with this the different property available

Response.Write( HttpContext.Current.Server.MachineName ) ;

This is used to get the client system name

2007-12-05T00:00:00.000-08:00

Using shared variables in Crystal report

1. Create a formula in mainreport as @iammainformula with shared variable declared as Shared stringVar amtword := {?amntInWords};

2. Create a formula in subreport as @iamsubformaula with the shared variable with same name as we declared in the main report
Shared stringVar amtword ;
amtword;

now we can access the value from the main report in the sub report

2007-10-14T22:17:00.000-07:00

How do i learn from my Job ?

Many of well-wishers and friends had advised me to learn from the present job and try to go for a better job. At the beginning I am very confused about “Learning the Job “, because I thought learning the technology is enough to grow up in the carrier but that’s not a true apart from learning that, there are lot of other things are there to learned. When I grew up in my carrier I started understanding the real meaning for “Learning the Job”. So I thought of sharing my view with you all. Basically, learning means what we grasped from the work which we do or what we grasped from the environment which we are. Just a very small list that I used to follow

1. Learn professionalism both in the work the and culture
2. Learn the best use of Technologies
3. Learn to Update yourself with latest technology and news
4. Learn how to Speak
5. Learn how to write and maintain documents
6. Learn how to handle the situations
7. Learn the real Business
8. Learn how to present yourself
9. Learn how to motivate other and to get self-motivated
10. Learn how to deal with peoples
11. Learn the way to analyze the situations
12. Learn how to build a team
13. Learn your Duties
14. Learn to take responsibility
15. Learn to plan and Execute
16. Learn to Manage Time
17. Learn to make good relation with your co-workers
18. Learn how to earn
19. Learn how to set a target and focus on that
20. Learn all the bad things in your profession which will help you to do the good things
21. Learn to be loyal
22. and finally learn to LOVE your work

These are all a very small list which I had given. There are lot to learn .Learning the work and the work culture will vary from the company to company and the locality to locality and that to depend on the team which you work .don’t scold me if there is any grammatical mistake .sorry .hahaha

2007-10-14T22:00:00.000-07:00

Generating KeyPair using SN.EXE

The Strong Name tool helps to sign assemblies with strong names. SN Stands for Strong Name
The Strong Name Consists of the Assembly Identification like Assembly Name ,Version ,Culture ,Public Key, and digital signature

The Public Key can be generated by using the .Net Framework tool (SN.EXE).

The key pair generated can be used for different assembly
The Strong name solves the versioning problem and naming problem
The user can deploy an assembly with the same name and same key pair in the GAC just by changing the version number

The simple syntax to generate strong name
Go to visual studio 2003 Command prompt and type the following command to generate the Key pay

Sn – K C:\Strongname.snk
When you type enter the strong name file will be generated in the specified location
To export the key from 1 file format to another
Sn – o C:\Strongname.snk C:\Strongname.txt
Sn – p C:\Strongname.snk C:\Strongname.txt

To Verify
Sn – v Sample.dll
It will verify for the strong name signature in the assembly if you put –vf instead of –v it’s a force verification

2007-08-08T20:44:00.000-07:00

Hi,
If you want to disable the right click option in the browser, include the following lines of code in the header portion of the page.
<SCRIPT>
function noRightClick()
{

if (event.button == 2)
{
alert("Right Click Not Allowed!");
return false;
}

}
document.onmousedown = noRightClick
</SCRIPT>

Regards,
Sasikumar

2007-08-08T01:12:00.000-07:00

Protecting your SAM Database

How to I protect my system. How to make my PC more secure on windows environment there are few common way we can protect our PC

By setting the BIOS password.
By Setting Windows password
By using system Hardware key

By using SYSKEY Utility.

I know most of will know the first 3 way of protecting and the fourth is quite different. Even thought SYSKEY Utility. is part of our OS we are not used to it . Let me explain about it .first we will know where this SYSKEY Utility resides inside our OS it’s in C:\WINDOWS\system32 folder. This utility is used to protect the System Account Manager Database (SAM) to run this utility go to run and type syskey

Fig1
The SYSKEY Utility will open now

Fig 2

Ok what is SAM what it does, this is the place where the OS will maintain the system username and password in encrypted format, now what the SYSKEY utility will do . it will move the decryption key to the floppy disk so that if you put the Floppy disk, only the system will open . Lets explain what’s there in the fig 2 here we have the Encryption Disabled and Encryption Enabled.

When you select the Encryption Disabled it will not encrypt the syskey if you select Encryption Enabled it will encrypt. After that clink the update button

Fig 3
In this screen we have the two options first the password setup which the user can give for their own or else we can select the system generated password. Again here we have the two way of storing the password. When you select the store startup key on floppy disk. The encrypted key will be stored in the floppy or if you select the store startup key locally it will be stored in the local system itself. This one of the most secure way to protect your system the data.

2007-07-18T08:25:00.000-07:00

Trciks to play Minesweeper Game.

Press X, Y, Z, Z, Y, Shift +Enter, Enter

Now open the Minesweeper and watch the Top Left Corner of the screen and move your mouse cursor over the mine in the game. If there is no boom the Top Left Corner pixel will be set to 1 or else it will be set to 0 so you can see the difference in the Top Left Corner pixel. Based on this you can easily finish the game

2007-07-16T00:09:00.000-07:00

Enabling Arabic in SQL server /Arabic is not recognized in SQL server it displays as “???????”.i had seen may query like this in many discussion group and I had also faced the same problem .These are the few tips which I had followed to solve the problem

Solution 1:
Set the collation for the field to Arabic while creating the table

How do I change the collation for the existing table?

ALTER TABLE #studrelation ALTER COLUMN stu_rela_code
Nvarchar(100) COLLATE Arabic_CI_AS NOT NULL

Here Arabic_CI_AS

Arabic – Language which you need
CI/CS - Case Insensitive / Case Sensitive
AS/KS/WS - Accent sensitivity/ Kana Sensitivity/ Width sensitivity

Solution 2:

Arabic will be recognized only with data type Nvarchar, text if you insert in varchar data type it won’t work.

CREATE TABLE #studrelation
( stud_id int,
stu_rela_code Nvarchar(100)
)
Insert into #studrelation(stud_id,stu_rela_code)values(1,'رسوم كتب')

select * from studrelation where stu_rela_code like N'%رسوم كتب%'

2007-07-13T08:31:00.000-07:00

In this we will learn about the WinCV tool, I am going to give just a short summary about WinCV and its usage and how to use this tool more effectively for the programming

Before learning about the WinCV tool we will learn the real scenario

Many times while programming, will be blinking before the monitor without knowing the proper object or class available , then what’s the next step only Google its it right. How it will be if we have a tool that will allow you search for class the objects in the .net library yes we have the inbuilt tool called WinCV.exe which is available at C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Bin, just you can open the tool and type the class or object which you need to find out it will list out all the content the assembly name, field, Constructors, Properties, Events, Methods

Ok Then what to do if we have our own assembly and how to browse the objects in that .There is a web configuration file called WinCV.exe in the same location you can edit the configuration file and add your assembly in the tag [] then you can browse your assembly.

2007-06-30T22:02:00.000-07:00

This kind of error will occur in crystal report when you export the report to any other format. For example from “.rpt” to “.pdf” /”.doc” like that. The error message will be like this

Problem:

Invalid export DLL or Export Format

Cause /Reason:
The problem is in the export dll used in the crystal report.. since its not properly registered this problem will occur

Solution:
Uninstall the acrobat reader and reinstall it this problem will be solved

2007-06-30T22:01:00.000-07:00

Some time we may face the Error While we load the Crystal report in the application . the error message which we will face is

Problem:
Error : Load Report failed

Cause /Reason:
When the report file (.rpt file) is not in the Specific path which you had mention in the application this error will occur

Solution:
Place the specific .rpt file in the path specified.

2007-06-29T01:21:00.000-07:00

Regional Settings for IIS

Some time we may get problem in language or the numeric/ date time format while you deployed an asp.net application or in the development itself.

Problem:
The problem is in the date time format that your system displays. Actually the date should be in “dd/MM/yyyy” format but it displays as “dd-MM-yyyy” or some other format. Even though you try by setting the regional setting also its wont work. But the same application works in another server / PC with “dd/MM/yyyy” format and the month name is also displaying in Different language .

Cause:

In the Globalization attribute in the machine.config file if the culture if not set this problem arise. You can find the configuration file in “C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG” this location

Solution:

Give the culture name the Globalization attribute

So the asp.net application will take the regional settings from the machine.Config file. Here I had set to US English you can set to any other language format if you need.

Note: This setting is for all the application deployed in that IIS Server

2007-06-07T07:39:00.000-07:00

Weather Microsoft is watching your system. Don’t they have any other work than that. “wpa.dbl “.WPA stands for Windows Product Activation for Windows XP and above version of Microsoft OS is using the wpa.dbl file to activate the product. There are lot of rumours that, by using this file Microsoft is going to watch your activities. Ya its may be true but not all your personal activities ,it will check for the OS license only . Ok how MS is going to check the license, weather they are going to take my H/W info. Yes they are, there are few listed H/W which they are going to check they are

NIC & MAC address
HDD Serial Number
processor number
Display Adapter
SCSI Adapter
IDE Adapter (effectively the motherboard)
RAM Amount Range (i.e., 0-64mb, 64-128mb, etc.)
Processor Type
CD-ROM / CD-RW / DVD-ROM

The “wpa.dbl “ is going to have the info of the above said H/W. Then What its does? Every time you boot you system the OS will check the H/W serial number with the number in the “wpa.dbl “ file, if your version of OS pass 7 checks then only your OS will be considered as licensed one. If else you can all MS through phone and you can activate it

What happen when I change the H/W?
If you change 1 or 2 H/W there is no problem if the OS passes less then 7 checks then you want to reactivate your OS through phone call. So this what “wpa.dbl “file is going to do in your system

2007-05-30T05:15:00.000-07:00

Here is the code to add the controls dynamically to the form and to generate events for the generated controls .the code is an C# code

private void Form1_Load(object sender, System.EventArgs e)
{
int y=16,x=72;
for (int i=1; i<=5;i++) { btn=new Button();
panel1.Controls.Add(btn);
btn.Location=new System.Drawing.Point(x, y);
btn.Text ="Button"+i.ToString();
y=y+30;
btn.Click+=new EventHandler(btn_Click);
}
}
private void btn_Click(object sender, EventArgs e)
{
Button bt=(Button)sender;
MessageBox.Show(bt.Text);

}
Code description

Create a new instance for the button object btn=new Button(); then add the object to the form or panel here I am using panel to place the button control. Then the event is generated in the look it self. The btn_Click event is for the generated buttons.

2007-05-30T04:53:00.000-07:00

The top 10 dead (or dying) computer skills

1. Cobol
2. No relational DBMS
3. Non-IP networks
4. cc: Mail
5. Cold Fusion
6. C programming
7. PowerBuilder
8. Certified NetWare Engineers
9. PC network administrators
10. OS/2

Reference: http://www.computerworld.com/action/article.do?command=printArticleBasic&articleId=9020942

Working with a Database in C#

2007-05-18T23:14:00.001-07:00

PublicJoe's - Sample Chapter - Teach Yourself C# in 24 Hours - Chapter 21 - Working with a Database in C#

Teach Yourself C# in 24 Hours - Chapter 21 - Working with a Database

in C#

By James Foxall and Wendy Haro-Chun.

ISBN: 0-6723-2287-0

You've heard it so many times that it's almost a cliché: This is the information age. Information is data, and managing information means working with databases. Database design is a skill unto itself, and entire books are devoted to database design and management. In this hour, you'll learn the basics of working with a database using ADO.NET, Microsoft's newest database technology. Although high-end solutions are built around advanced database technologies such as Microsoft's SQL Server, the Microsoft Jet database (used by Microsoft Access) is more readily available and easier to learn, so you'll build working examples that use a Jet database.

The highlights of this hour include the following:

l Introduction to ADO.NET
l Connecting to a database
l Understanding DataTables
l Creating a DataAdapter
l Referencing fields in a DataRow
l Navigating records
l Adding, editing, and deleting records
l Building an ADO.NET example

NOTE

You'll learn a lot in this hour, but realize that this material is really the tip of the iceberg. Database programming can be, and often is, very complex. This hour is intended to get you writing database code as

quickly as possible, but if you plan on doing a lot of database programming, you'll want to consult a dedicated book (or two) on the subject. Start by creating a new Windows Application named Database Example. Change the name of the default formto fclsMain and set its Text property to Database Example. Next, click the View Code button on the Solution Explorer window to access the form's code, scroll down and locate the procedure Main(), and change the reference of Form1 to fclsMain. Finally, click the Form1.cs tab to return to the form designer.

Introduction to ADO.NET

ADO.NET is the .NET platform's new database technology, and it builds on ADO (Active Data Objects). ADO. NET defines DataSet and DataTable objects that are optimized for moving disconnected sets of data across intranets and Internets, including through firewalls. At the same time, ADO.NET includes the traditional Connection and Command objects, as well as an object called a DataReader that resembles a forward-only, readonly ADO recordset. Together these objects provide the very best performance and throughput for retrieving

data from a database.

Connecting to a Database

To access data in a database, you must first establish a connection using an ADO.NET connection object. Two connection objects are included in the .NET Framework: the OleDbConnection object, for working with the same OLE DB data providers you would access through traditional ADO, and the SqlConnection object, for optimized access to Microsoft SQL Server. Because these examples connect to the Microsoft Jet Database, you'll be using the OleDbConnection object. To create an object variable of type OleDbConnection and

initialize the variable to a new connection, you could use a statement such as the following:

OleDbConnection cnADONetConnection = new OleDbConnection();

To use ADO.NET, the first step that you need to take is to add the proper Namespace to your project. Doubleclick the form now to access its events. Scroll to the top of the class and add the following using statement on the line below the other using statements:

using System.Data.OleDb;

You're going to create a module-level variable to hold the connection, so place the cursor below the left bracket ({) that follows the statement public class fclsMain : System.Windows.Forms.Form and

press Enter to create a new line. Enter the following statement:

OleDbConnection m_cnADONetConnection = new OleDbConnection();

Before using this connection, you must specify the data source to which you want to connect. This is done through the ConnectionString property of the ADO.NET connection object. The ConnectionString

contains connection information such as the name of the provider, username, and password. The ConnectionString might contain many connection parameters; the set of parameters available varies

depending on the source of data that you are connecting to. Some of the parameters used in the OLE DB ConnectionString are listed in Table 21.1. If you specify multiple parameters, separate them with a

semicolon.

Table 21.1 - Possible Parameters for ConnectionString

Parameter Description

Provider The name of the data provider (Jet, SQL, and so on) to use.

Data Source= The name of the data source (database) to connect to.

UID= A valid username to use when connecting to the data source.

PWD= A password to use when connecting to the data source.

DRIVER= The name of the database driver to use. This isn't required if a DSN is specified.

SERVER= The network name of the data source server.

The Provider= parameter is one of the most important at this point and is governed by the type of database you're accessing. For example, when accessing a SQL database, you specify the provider information for SQL; when accessing a Jet database, you specify the provider for Jet. In this example, you'll be accessing a Jet (Microsoft Access) database, so you'll use the provider information for Jet.In addition to specifying the provider, you're also going to specify the database. I've provided a sample database at the Web site for this book. This code assumes that you've placed the database in a folder called C: \Temp. If you are using a different folder, you'll need to change the code accordingly.

To specify the ConnectionString property of your ADO.NET connection, place the following statement in the Load event of your form:

m_cnADONetConnection.ConnectionString =

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\contacts.mdb";

After the connection string is defined, a connection to a data source is established by using the Open()method of the connection object. The Open() method has the following syntax:

objectvariable.Open();

NOTE

Refer to the online documentation for information on the connection strings for providers other than Jet.When you attach to an unsecured Jet database, it's not necessary to provide a username and password. When attaching to a secured Jet database, however, you'll have to provide a username and a password. This is done by passing the username and password as parameters in the ConnectionString property. The sample database I've provided isn't secured, so it's not necessary to provide a username and password.

Closing a Connection to a Data Source

You should always explicitly close a connection to a data source. This means that you should not rely on a variable going out of scope to close a connection, but you should force an explicit disconnect via code. This is

accomplished by calling the Close() method of the connection object.

You're now going to write code to explicitly close the connection when the form is closed. Start by clicking the Form1.cs tab to return to the form designer. Next, click the Events button on the Properties window (the lightening bolt) to access the list of events for the form. Double-click the Closed event to create a new event handler. Enter the following statement in the Closed event:

m_cnADONetConnection.Close();

Manipulating Data

The easiest way to manipulate data using ADO.NET is to create a DataTable object containing the resultset of a table, query, or stored procedure. Using a DataTable, you can add, edit, delete, find, and navigate records. The following sections explain how to use DataTables.

Understanding DataTables

DataTables contain a snapshot of the data in the data source. You generally start by filling a DataTable, and then you manipulate the results of the DataTable before finally sending the changes back to the data source.The DataTable is populated using the Fill() method of a DataAdapter object, and changes are sent back to the database using the Update() method of a DataAdapter. Any changes made to the DataTable appear only in the local copy of the data until you call the Update() method. Having a local copy of the data reduces contention by preventing users from blocking others from reading the data while it is being viewed. This is similar to the Optimistic Batch Client Cursor in ADO.

Creating a DataAdapter

To populate a DataTable, you need to create a DataAdapter, an object that provides a set of properties and methods to retrieve and save data between a DataSet and its source data. The DataAdapter you're going to create will use the connection you've already defined to connect to the data source and will then execute a query you'll provide. The results of that query will be pushed into a DataTable. Just as two ADO.NET connection objects are in the .NET Framework, there are two ADO.NET DataAdapter Objects as well: the OleDbDataAdapter and the SqlDataAdapter. Again, you'll be using the

OleDbDataAdapter because you aren't connecting to Microsoft SQL Server. The constructor for the DataAdapter optionally takes the command to execute when filling a DataTable or DataSet, as well as a connection specifying the data source. (You could have multiple nnections open in a single project.) This constructor has the following syntax:

OleDbDataAdapter cnADONetAdapter = new

OleDbDataAdapter([CommandText],[Connection]);

To add the DataAdapter to your project, first add the following statement immediately below the statement you entered to declare the m_cnADONewConnection object.

OleDbDataAdapter m_daDataAdapter = new OleDbDataAdapter();

Next, add the following statement to the Load event of the form, immediately following the statement that creates the connection:

_daDataAdapter =

new OleDbDataAdapter("Select * From Contacts",m_cnADONetConnection);

Because you're going to use the DataAdapter to update the original data source, you need to specify the insert, update, and delete statements to use to submit changes from the DataTable to the data source. ADO. NET lets you customize how updates are submitted by allowing you to manually specify these statements as database commands or stored procedures. In this case, you're going to have ADO.NET automatically generate these statements for you by creating a CommandBuilder object. Enter the following statement to create the

CommandBuilder.

OleDbCommandBuilder m_cbCommandBuilder =

new OleDbCommandBuilder(m_daDataAdapter);

When you create the CommandBuilder, you pass into the constructor the DataAdapter that you want the CommandBuilder to work with. The CommandBuilder then registers for update events on the DataAdapter

and provides the insert, update, and delete commands as needed. You don't need to do anything further with the CommandBuilder.

NOTE

When using a Jet database, the CommandBuilder object can create the dynamic SQL code only if the table in question has a primary key defined.

Creating and Populating DataTables

You're going to create a module-level DataTable in your project. First, create the DataTable variable by adding the following statement on the line below the statement you entered previously to declare a new modulelevel m_daDataAdapter object:

DataTable m_dtContacts = new DataTable();

You are going to use an integer variable to keep track of the user's current position within the DataTable. To do this, add the following statement immediately below the statement you just entered to declare the new DataTable object:

int m_rowPosition = 0;

Next, add the following statement to the Load event of the form, immediately following the statement that creates the CommandBuilder:

m_daDataAdapter.Fill(m_dtContacts);

NOTE

Because the DataTable doesn't hold a connection to the data source, it's not necessary to close it when you're finished.

Your class should now look like the one in

Figure 21.1.

Figure 21.1 - This code accesses a database and creates a DataTable that can be used anywhere in the class.

Referencing Columns in a DataRow

DataTables contain a collection of DataRows. To access a row within the DataTable, you specify the ordinal of that DataRow. For example, you could access the first row of your DataTable like this:

DataRow m_rwContact = m_dtContacts.Rows[0];

Data elements in a DataRow are called columns. For example, two olumns, ContactName and State, are in the Contacts table I've created. To reference the value of a column, you can pass the column name to the DataRow like this:

m_rwContact["ContactName"] = "Bob Brown";

Debug.WriteLine(m_rwContact["ContactName"]);

NOTE

If you spell a column name incorrectly, an exception occurs when the statement executes at runtime. You're now going to create a procedure that is used to display the current record in the database. To display

the data, you need to add a few controls to the form. Create a new text box and set its properties as follows (you'll probably need to click the Properties button on the Properties window to view the text box's properties rather than its events):

Property Value

Name txtContactName

Text (make blank)

Location 48, 112

Size 112, 20

Add a second text box to the form and set its properties according to the following table:

Property Value

Name txtState

Text (make blank)

Location 168, 112

Size 80, 20

Next, click the Form1.cs tab in the IDE to return to the code window. Position the cursor after the right bracket that ends the fclsMain_Closed() event and press Enter a few times to create some blank lines. Next, enter the following procedure in its entirety:

private void ShowCurrentRecord()

{

if( m_dtContacts.Rows.Count == 0 )

{

txtContactName.Text = "";

txtState.Text = "";

return;

}

txtContactName.Text =

m_dtContacts.Rows[m_rowPosition]["ContactName"].ToString();

txtState.Text = m_dtContacts.Rows[m_rowPosition]["State"].ToString();

}

Ensure that the first record is shown when the form loads by adding the following statement to the Load event, after the statement that fills the DataTable: this.ShowCurrentRecord();

You've now ensured that the first record in the DataTable is shown when the form first loads. Next, you'll learn how to navigate and modify records in a DataTable.

Navigating and Modifying Records

The ADO.NET DataTable object supports a number of methods that can be used to access its DataRows. The simplest of these is the ordinal accessor that you used in your ShowCurrentRecord() method. Because the DataTable has no dependency on the source of the data, this same functionality is available regardless of where the data came from.

You're now going to create buttons that the user can click to navigate the DataTable. The first button is used to move to the first record in the DataTable. Add a new button to the form and set its properties as follows:

Property Value

Name btnMoveFirst

Text <<

Location 16, 152

Size 32, 23

Double-click the button and add the following code to its Click event:

m_rowPosition = 0;

this.ShowCurrentRecord();

A second button is used to move to the previous record in the DataTable. Add another button to the form and set its properties as shown in the following table:

Property Value

Name btnMovePrevious

Text <

Location 56, 152

Size 32, 23

Double-click the button and add the following code to its Click event:

if( m_rowPosition > 0 )

{

m_rowPosition = m_rowPosition - 1;

this.ShowCurrentRecord();

}

A third button is used to move to the next record in the DataTable. Add a third button to the form and set its properties as shown in the following table:

Property Value

Name btnMoveNext

Text >

Location 96, 152

Size 32, 23

Double-click the button and add the following code to its Click event:

if( m_rowPosition < m_dtContacts.Rows.Count - 1 )

{

m_rowPosition = m_rowPosition + 1;

this.ShowCurrentRecord();

}

A fourth button is used to move to the last record in the DataTable. Add yet another button to the form and set its properties as shown in the following table:

Property Value

Name btnMoveLast

Text >>

Location 136, 152

Size 32, 23

Double-click the button and add the following code to its Click event:

if( m_dtContacts.Rows.Count != 0 )

{

m_rowPosition = m_dtContacts.Rows.Count - 1;

this.ShowCurrentRecord();

}

Editing Records

To edit records in a DataTable, simply change the value of a particular column in the desired DataRow. Remember, however, that changes are not made to the original data source until you call Update() on the

DataAdapter, passing in the DataTable containing the changes.

You're now going to add a button that the user can click to update the current record. Add a new button to the form now and set its properties as follows:

Property Value

Name btnSave

Text Save

Location 176, 152

Size 40, 23

Double-click the Save button and add the following code to its Click event:

if( m_dtContacts.Rows.Count != 0 )

{

m_dtContacts.Rows[m_rowPosition]["ContactName"] = txtContactName.Text;

m_dtContacts.Rows[m_rowPosition]["State"] = txtState.Text;

m_daDataAdapter.Update(m_dtContacts);

}

Creating New Records

Adding records to a DataTable is performed very much like editing records. However, to create a new row in the DataTable, you must first call the NewRow() method. After creating the new row, you can set its column values. The row isn't actually added to the DataTable, however, until you call the Add() method on the DataTable's RowCollection.

You're now going to modify your interface so that the user can add new records. You'll use one text box for the contact name and a second text box for the state. When the user clicks a button you'll provide, the values in these text boxes will be written to the Contacts table as a new record. Start by adding a group box to the form and set its properties as shown in the following table:

Property Value

Name grpNewRecord

Text New Contact

Location 16, 192

Size 264, 64

Next, add a new text box to the group box and set its properties as follows:

Property Value

Name txtNewContactName

Text (make blank)

Location 8, 24

Size 112, 20

Add a second text box to the group box and set its properties as shown:

Property Value

Name txtNewState

Text (make blank)

Location 126, 24

Size 80, 20

Finally, add a button to the group box and set its properties as follows:

Property Value

Name btnAddNew

Text Add

Location 214, 24

Size 40, 23

Double-click the Add button and add the following code to its Click event:

DataRow drNewRow = m_dtContacts.NewRow();

drNewRow["ContactName"] = txtNewContactName.Text;

drNewRow["State"] = txtNewState.Text;

m_dtContacts.Rows.Add(drNewRow);

m_daDataAdapter.Update(m_dtContacts);

m_rowPosition = m_dtContacts.Rows.Count - 1;

this.ShowCurrentRecord();

Notice that after the new record is added, the position is set to the last row and the ShowCurrentRecord() procedure is called. This causes the new record to appear in the text boxes you created earlier.

Deleting Records

To delete a record from a DataTable, you call the Delete() method on the DataRow to be deleted. Add a new button to your form (not to the group box) and set its properties as shown in the following table.

Property Value

Name btnDelete

Text Delete

Location 224, 152

Size 56, 23

Double-click the Delete button and add the following code to its Click event:

if( m_dtContacts.Rows.Count != 0 )

{

m_dtContacts.Rows[m_rowPosition].Delete();

m_daDataAdapter.Update(m_dtContacts);

m_rowPosition = 0;

this.ShowCurrentRecord();

}

Your form should now look like that in Figure 21.2.

Figure 21.2 - A basic data-entry form.

Running the Database Example

Press F5 to run the project. If you entered all the code correctly, and you placed the Contacts database into the C:\Temp folder (or modified the path used in code), the form should display without errors, and the first record in the database will appear. Click the navigation buttons to move forward and backward. Feel free to change the information of a contact, click the Save button, and your changes will be made to the underlying database. Next, enter your name and state into the New Contact section of the form and click Add. Your name will be added to the database and displayed in the appropriate text boxes.

Using the Data Form Wizard

Visual Basic .NET includes a tool to help introduce you to ADO.NET - the Data Form Wizard. In this section, you're going to use the Data Form Wizard to create a form that is bound to the same database you used in the previous example. Start by creating a new Windows Application titled Data Form Example. The Data Form Wizard is run by adding it to your project as a form template. Choose Add Windows Form from the Project menu to display the Add New Item dialog box, click the Data Form Wizard icon, change the name to fclsDataForm.cs (see Figure 21.3), and click Open to start the wizard.

Figure 21.3 - The Data Form Wizard as a form template.

The first page of the wizard is simply an introduction. Click Next to get to the first "real" page. This next page is used to choose the dataset you want to bind to the form. ADO.NET datasets hold a collection of

DataTables. Enter AllContacts into the text box (see Figure 21.4) and click Next to continue.

Figure 21.4 - A DataTable is similar to an ADO recordset.

The next page of the wizard is used to specify a connection to a data source (see Figure 21.5). Note: Because you haven't previously defined a connection to the Contacts database, your drop-down list will be empty. Click the New Connection button to display the Data Link Properties dialog box. Notice that this dialog box opens with the Connection page visible. Click the Provider tab to see the list of installed providers on your computer (see Figure 21.6), choose Microsoft Jet 4.0 OLE DB Provider to select it, and then click the Connection tab once more.

Figure 21.5 - Use this page to specify a data source.

Figure 21.6 - You must specify the appropriate provider for the type of data source to which you are connecting. Now that you've selected the provider, you need to locate and select the data source (your Jet database). Click the build button next to the database name text box, and then locate and select the contacts.mdb database. Next, click Test Connection to make sure the information you have supplied creates a valid connection to the database. If the test succeeded, click OK to close the Data Link Properties dialog box. The database should

now appear in the Connection drop-down list. Click Next to continue.

The next step in completing the wizard is to choose the table or tables you want to use (see Figure 21.7). The tables you choose here will be used to supply the data that is bound to your form. Double-click the Contacts table to add it to the Selected Items list and click Next to continue.

Figure 21.7 - Use this page to choose the data to bind to the form.

This page shown in Figure 21.8 is used to specify the columns that you want bound on the form. The two columns in your Contacts table are already selected by default, so click Next to continue.

Figure 21.8 - You don't have to select all the fields in a table.

The last step of the wizard is specifying the style in which you want the data to appear (see Figure 21.9). Because the previous example had you add individual controls for each column, leave the All Records in a Grid

radio button, selected (this will create a data grid). Click Finish to create your new data form, which will appear in the form designer (see Figure 21.10).

Figure 21.9 - The Data Form Wizard gives you a number of choices for displaying your data.

Figure 21.10 - This bound grid was created by the Data Form Wizard.

To test your form, you'll have to display it. Click Form1.cs to display the designer for the default form in your

project and add a new button to the form. Set the button's properties as follows:

Property Value

Name btnShowDataForm

Text Show Data Form

Location 96, 120

Size 104, 23

Next, double-click the button to access its Click event and add the following code:

fclsDataForm objDataForm = new fclsDataForm ();

objDataForm.Show();

Press F5 to run the project, and then click the button and your bound form will appear. To load the grid with records, click the Load button (see Figure 21.11). Figure 21.11 - This grid is bound to the record source. Stop the running project, click fclsDataForm.cs in the Solution Explorer, and then click the View Code button on the Solution Explorer to view the class. Notice that the Data Form Wizard created all the ADO.NET code for you, and even included rudimentary error handling. The Data Form Wizard is a great way to get started with ADO.NET, but it will take you only so far. To create robust ADO.NET applications, you will need to find one or more dedicated resources that focus on the intricacies of ADO.NET.

Summary

Most commercial applications use some sort of database. Becoming a good database programmer requires extending your skills beyond being just a good programmer. There is so much to know about optimizing database and database code, creating usable database interfaces, creating a database scheme - the list goes on. However, writing any database application begins with the basic skills you learned in this hour. You learned how to connect to a database, create and populate a DataTable, and navigate the records in the DataTable. In addition, you learned how to edit records and how to add and delete reco rds. Finally, you learned how to use the Data Form Wizard to create a basic ADO.NET bound form. You are now prepared to write simple, yet

functional, database applications.

Samiyappan Prabakar ,Mobile : +971 50 9042741

Need a vacation? Get great deals to amazing places on Yahoo! Travel.

2007-05-05T11:21:00.000-07:00

Error Message: Could not copy temporary files to the output directory.
Or
Cannot copy sample.dll to D:\Prabakar\Sharpurdotnet\...

We may receive this error message many time while your build your application or the specific project. I too had this problem many time and the reason for the error and the solution is here.

Reason:

Check the property of the output weather the COPY LOCAL property is false
May be all of your output path may refer a single folder.
Solution:

Change the output folder
And set the COPY LOCAL Property to true
Delete the bin and obj folder and rebuild the project

2007-05-03T10:13:00.000-07:00

Using IIS 7 for visual studio 2003 in Microsoft Vista. We can have both VS2003 and VS2005 in the single system and for VS2005 the default Server is IIS 7 ,since the IIS 6 and IIS 7 can not run in single system the IIS 7 manager will disable the II6, So we can make the IIS 7 as comparable to VS2003 by enabling the Compatibility option in the control panel

Click the Turn Windows features on or off then in the popup window check the IIS 6 Management compatibility

Now run your VS2003 web application in admin mode ,this process will enable the VS2003 to use IIS 7

Disable Back Button in the browser

2007-05-03T04:07:00.000-07:00

Hi guys,

If you want to disable back button in web browser, include the following JavaScript code inside the <head> portion of the HTML,

Regards,

Sasikumar

----------------------------------------------------------------DISCLAIMER---------------------------------------------------------
Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com
and delete this EMAIL including any attachments

2007-04-18T12:44:00.001-07:00

Nice Link for web services which we can use for our line application .For example they have the currency converted web services which will have the running dollars rates so u will get the exact rate as of now

http://www.webservicex.net/WCF/default.aspx

They have different services like this just go and check

2007-04-04T02:05:00.000-07:00

Mono .net only alternative for MS .net, Which runs on windows, Linux and Solaris and Mac OS ,Article tells more about more and its usage .Link.

2007-04-02T06:36:00.000-07:00

It’s a Real Great News from Yahoo that it had announced to given access to the web services through SOAP .Here is the article link http://developer.yahoo.net/blog/archives/2007/03/mail.html

2007-04-02T01:21:00.000-07:00

Decompiler are very useful when you don’t have your source and if you have only the assembly (dll).at this time we can decompiler and get the source .there are different decompiler available but most of them are too costly .in our .net framework itself we have decompiler Ildasm.exe but the output will be in MSIL, Hence we are going for third party decompiler. In that way reflector is very useful and freeware .few of the articles which I gone through are http://aspnet.4guysfromrolla.com/articles/080404-1.aspx

FTP for E-BOOKS

2007-03-29T00:40:00.001-07:00

ftp://ftp.uar.net/pub/e-books/ ftp with lot of ebooks download ASAP

Samiyappan Prabakar ,Mobile : +971 50 9042741

Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.

2007-03-28T05:10:00.000-07:00

Query Engine Error: 'D:\IIMS\Finance\Reports\RptWorkOrderEmployee.rpt'
Description: An unhandled exception occurred during the execution of the current web request। Please review the stack trace for more information about the error and where it originated in the code

Exception Details: CrystalDecisions।CrystalReports।Engine.DataSourceException: Query Engine Error: 'D:\IIMS\Finance\Reports\RptWorkOrderEmployee.rpt'

Reason:

When there is the difference in the Field in the report and the dataset which you bind to the report file, Check the data type of the fields name then the number of fields in the report and the dataset

Normalization

2007-03-22T22:43:00.001-07:00

First normal form (1NF) sets the very basic rules for an organized database:

Eliminate duplicative columns from the same table.
Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key).

Second normal form (2NF) further addresses the concept of removing duplicative data:

Meet all the requirements of the first normal form.
Remove subsets of data that apply to multiple rows of a table and place them in separate tables.
Create relationships between these new tables and their predecessors through the use of foreign keys.

Third normal form (3NF) goes one large step further:

Meet all the requirements of the second normal form.
Remove columns that are not dependent upon the primary key.

Finally, fourth normal form (4NF) has one additional requirement:

Meet all the requirements of the third normal form.
A relation is in 4NF if it has no multi-valued dependencies.

Remember, these normalization guidelines are cumulative. For a database to be in 2NF, it must first fulfill all the criteria of a 1NF database.

Regards,

Sasikumar

Error in Crystal Report While Exporting

2007-03-21T02:07:00.001-07:00

Error in Crystal Report While Exporting

"Missing parameter field current value" this error occurs while exporting the crystal report to PDF /word/excel. I had found the query regarding this error in many pages that's the reason I had posed it

Reason:

Due to the parameter mismatch in the report file and the assigned parameter

Solution:

1. Check weather all the parameter is passed or not

2. Verify database of the report to update the table

Samiyappan Prabakar ,Mobile : +971 50 9042741

We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.