Posts

Showing posts from June 7, 2009

Microsoft Confirms Plans to Release Free Anti-Virus Service

Image
If Morro provides good protection, it could "provide a significant value for users." From Microsoft's perspective, Morro, the free anti-virus software could improve user experience with Microsoft-based products and could help them to improve their charged-for enterprise products. As it gets ready to launch a new operating system, Microsoft confirmed Wednesday that it is getting ready to release a free anti-virus service later this year. The new service is currently code-named Morro, apparently after the Morro de Sao Paolo beach area in Brazil. Observers are expecting the free service to compete directly with McAfee and Symantec, two of the leading companies in this field. A Microsoft spokesperson told news media that the software giant is currently internally testing the new software among its employees, and then it will offer a public beta at some unspecified point in 2009. The software is expected to be available for computers running Windows Vista, XP, an

How to Identify and Delete Duplicate SQL Server Records

Recently, I was asked to help someone clean up their database after they had double loaded an import file. The problem they were having in identifying and deleting the duplicate information was the fact that a timestamp is applied to each row of data as it is inserted into the table. While the rest of the row of data was duplicated, the timestamp made the row unique. It was this uniqueness that caused the simple methods of determining and deleting duplicate data to fail. They needed a way to delete data from a table in which they determine the criteria of what made the data duplicate. After helping them out with their problem, I decided to write a short article to show the simple solution I came up with to delete the duplicate data from a table, even if that data is considered unique by SQL Server. I know there are many ways to delete duplicate data, but bear with me as I explain my way. As always, if you have another way, great write it up and let us know about it. If not, look over t

PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication

When you use transaction replication to distribute the data, you may experience the following symptoms:Log Reader Agent does not replicate the data and it displays the following error message: The process could not execute 'sp_replcmds' on servername. The log file contains the following information: Status: 2, code: 0, text: 'The process could not execute 'sp_replcmds' on servername'. The process could not execute 'sp_replcmds' on servername. Status: 2, code: 0, text: 'Timeout expired'. Disconnecting from Publisher servernameThe agent failed with a 'Retry' status. Try to run the agent at a later time. CAUSE: To facilitate transactional replication, Log Reader Agent moves the transactions that are marked for replication from the transaction log on the publisher to the distribution database. You may receive this error message when Log Reader Agent cannot move the transaction log within the time limit that you set in the Log Reader Agent Qu

Differences between DataSet and DataReader

Differences between DataSet and DataReader The DataSet object is central to supporting disconnected, and distributed data scenarios with ADO.NET. The DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source. It can be used with multiple and differing data sources, used with XML data, or used to manage data local to the application. The DataSet represents a complete set of data including related tables, constraints, and relationships among the tables. I think this is something that gives the advantage upon the older ADO. ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application performance and reduce system overhead because only one row at a time is ever in memory. How do I know which one to use? When deciding whether your application should use a DataReader (see Retrieving Data Using the DataReader) or a DataSet (see Creating and

Top Five ASP.NET Web Services Tips

In this article, we explore some tips and tricks for using the Microsoft .NET framework for developing Web services. In the first section, I'll provide a brief comparison between ASP.NET Web services and .NET remoting, and then I'll delve into five tips I've found useful for developing ASP.NET Web services. Before You Build: ASP.NET Web Services Versus .NET Remoting ASP.NET Web services and .NET remoting are two separate paradigms for building distributed applications using Internet-friendly protocols and the .NET framework. Each has its advantages and drawbacks, which are important factors in deciding which one to use for your application. Web services typically use SOAP for the message format and require that you use IIS for the HTTP message transport. This makes Web services good for communication over the Internet, and for communication between non-Windows systems. Web services are a good choice for message-oriented services that must support a wide range of client plat

Web Services with ASP.NET

Web Services are the underpinning of Microsoft's .NET strategy. The concepts and the innovations behind this initiative have struck a chord with developer's building the next generation of Internet applications. In this month's column, we're going to take a look at the features within ASP.NET to enable Web Services. Before we dig into the technical details let's start with an overview of Web Services. Web Services Overview A Web Service is programmable application logic accessible via standard Web protocols. One of these Web protocols is the Simple Object Access Protocol (SOAP). SOAP is a W3C submitted note (as of May 2000) that uses standards based technologies (XML for data description and HTTP for transport) to encode and transmit application data. Consumers of a Web Service do not need to know anything about the platform, object model, or programming language used to implement the service; they only need to understand how to send and receive SOAP messages (HTTP

How to create Progress Bar Using AJAX

The following code shows how to create Progress Bar Using AJAX. There is an UpdatePanel , which has a Button into it. And Place an UpdateProgress which perform the defined progress for the action happens inside the UpdatePanel by any of the controls within it. Since i have an UpdateProgress within the UpdatePanel, and have set the AssociatedUpdatePanelID="UpdatePanel1". The UpdateProgress has the "gif" image which looks like a progress. Place a gif image of a progress bar and impletement the same thing for showing the progress to the user See full detail: http://www.dotnetspider.com/resources/18552-Progress-Bar-Using-AJAX.aspx

FileUpload Control in Update Panel using ASP.NET AJAX

FileUpload control will not work inside an UpdatePanel control for uploading files using Asynchronous postback. This is because, the file uploading and file manipulations is restricted by default in client side for security reasons. Hence it is not possible to upload files using asynchronous postback in UpdatePanel. All file upload controls does not working in any ajax update panel and upload control needs to full page postback. This means if your upload control located in an update panel, control does not post the file. If you look to the posted file property of the control, you will see it null. So, the control always have to post full page postback. To resolve this problem we need to rely upon a standard postback i.e. we need to set the button that is uploading the file to be PostBack trigger instead of AsyncPostBack trigger. This will initiate a normal postback whenever we click the upload button and it is possible to upload the file. You need to create a PostBackTrigger for the

UpdatePanel Control Overview

Introduction ASP.NET UpdatePanel controls enable you to build rich, client-centric Web applications. By using UpdatePanel controls, you can refresh selected parts of the page instead of refreshing the whole page with a postback. This is referred to as performing a partial-page update. A Web page that contains a ScriptManager control and one or more UpdatePanel controls can automatically participate in partial-page updates, without custom client script. This topic contains information about the following: Scenarios Background Code Examples Class Reference Scenarios The UpdatePanel control is a server control that helps you develop Web pages with complex client behavior that makes a Web page appear more interactive to the end user. Coordinating between server and client to update only specified parts of a Web page usually requires in-depth knowledge of ECMAScript (JavaScript). However, by using the UpdatePanel control, you can enable a Web page to participate in partial-page updates

How To Setup ASP.NET AJAX - Looking Ahead at The Final Project

see this vedio : http://www.bukisa.com/videos/106619_how-to-setup-aspnet-ajax-looking-ahead-at-the-final-project

Authentication for Web Services (using SOAP headers)

Introduction I recently put up a few web services for a client of mine, which returned some sensitive data. I needed to find a simple way to authenticate the users of these web services. This is the approach I took. Background I've started using web services fairly often in the applications that I've been developing, in most cases the information they pass is suitable for the public domain. However a recent project forced me to look into different authentication methods. My requirements were that, it had to be simple for the client applications to authenticate, also that the web based administration system had to be used. This prevented me from using the Windows authentication (which is fairly easy to use for the clients of this web service.) By using SOAP headers to pass username and password information, it greatly simplifies any authentication request. Using the code I wanted to make it really easy for the client to understand: See full detail: http://www.codeproject.com/KB/

SoapHeader Class

SOAP headers offer a method for passing data to and from an XML Web service method if the data is not directly related to the XML Web service method's primary functionality. For instance, an XML Web service might contain several XML Web service methods that each require a custom authentication scheme. Instead of adding parameters to each XML Web service method for the custom authentication scheme, a SoapHeaderAttribute , referring to a class deriving from SoapHeader , can be applied to each XML Web service method. The implementation for the class deriving from SoapHeader handles the custom authentication scheme. In this manner, the XML Web service method implements only the functionality specific to it and adds additional functionality using a SOAP header. The following list outlines the basic steps to receiving and processing a SOAP header: Create a class that derives from SoapHeader representing the data passed into the SOAP header. Add a member to the class implementing an XML

10 ASP.NET Performance and Scalability Secrets

Introduction ASP.NET 2.0 has many secrets, which when revealed can give you big performance and scalability boost. For instance, there are secret bottlenecks in Membership and Profile provider which can be solved easily to make authentication and authorization faster. Furthermore, ASP.NET HTTP pipeline can be tweaked to avoid executing unnecessary code that gets hit on each and every request. Not only that, ASP.NET Worker Process can be pushed to its limit to squeeze out every drop of performance out of it. Page fragment output caching on the browser (not on the server) can save significant amount of download time on repeated visits. On demand UI loading can give your site a fast and smooth feeling. Finally, Content Delivery Networks (CDN) and proper use of HTTP Cache headers can make your website screaming fast when implemented properly. In this article, you will learn these techniques that can give your ASP.NET application a big performance and scalability boost and prepare it to per

Webservice return the Image of the Customer in ASP.NET 2.0

Webservice returning image of the customer in ASP.NET 2.0 Now I will explain how to get the images from Oracle database and how to display it on the ASP.NET 2.0 web page. In oracle images are saved as blob data type. In my application I have written one webservice, it will send the signature image of the customer to the other application which is saved in my application database Oracle database. Webservice will provide security for database when one application requires the data from other application. The application which requires the data will send a request to the webservice so the webservice will give the response depending on the customer input. In this way it will provide the security to out database. The webservice code is looking like this: The below webservice will take the Customer ID and return the signature of the customer to the other application which send the request to webservice. This is the working code. See full detail: http://www.c-sharpcorner.com/UploadFile

Faster Performance of Deployed ASP.NET Sites

Few Tips to ensure your deployed ASP.Net always runs with the best possible performance and no security information leakages. 1) In Machine.config introduce the following( if not already there)- Machine.config: See full detail: http://www.c-sharpcorner.com/UploadFile/technoNet/Tips_Faster_Performance_Deployed_Sites05142009091910AM/Tips_Faster_Performance_Deployed_Sites.aspx

Web Paging Navigation Control

Introduction this web paging control for navigation in data list . how to use this control 1-Set Control setting in page load 2-to get page index from this control use PagingControl1_PageIndexClick(object sender, EventArgs e) event Sample for how to use this control see full detail: http://www.c-sharpcorner.com/UploadFile/Nesreeen/WebPagingControl05182009155353PM/WebPagingControl.aspx

C# Code Reviews using StyleCOP

I nstalling and Download StyleCop StyleCop analyzes C# code with a set of rules to check whether the code follows the rules. You can download StyleCop from this link . If you click on the downloads section, you will see three setups, one is the StyleCop setup which actually installs the software and the other two are CHM help files. One help file talks about the rules and the other about the API exposed by StyleCop. Once you install StyleCop, nothing will be seen as in start menu. When you open any project of C# and right click on the project, you should see two menus in the project as shown in the figure below - one which helps us select the rules, i.e. the Stylecop settings menu and the other which runs these rules on the C# Project. see full detail: http://www.c-sharpcorner.com/UploadFile/shivprasadk/StyleCOP03302009022805AM/StyleCOP.aspx

What are Properties in C-sharp and how to use them?

In this article I will explain the property in C# along with practical demonstration which will help you to understand it in a simple way. Properties are used to get or set the value of data members of a class. They are used to implement data security. A property contains two blocks: (i) get and (ii) set. These blocks works on the basis of calling conventions. get and set block is implicit calling of grammar language. Property is define public normally to have get and set control. For each data members we have to create one property. In c-sharp we create indexers in place of parameterized property. (In VB you can have parameterized property). For static data member static properties are used. Difference between Property and Methods Property Property is implicitly called using calling convention Property works on compile and runtime. Method Method is explicitly called Methods works on runtime. Practical: Showing how to use property see full detail: http://www.c-sharpcorner.com/UploadFil

Uploading XL Sheet data into SQL Server 2005 using C#

This example will explain you how to upload the XL Sheet data into SQL Server 2005 using C#. Add on upload control and button control to the ASP.NET 2.0 webform. In button click event paste the following code: see full detail: http://www.c-sharpcorner.com/UploadFile/gnsrinivas1511/UploadingXLSheetdata05192009070247AM/UploadingXLSheetdata.aspx