Amr Saafan

How to: Completely Disable Viewstate in ASP.NET

2011-11-09T00:47:00.000+02:00

I tried to disbale Viewstate of a website by set EnableViewState Page directive to false. But when I get the Page HTML Source I found the following line:  1: <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" 2: value="/wEPDwUKMTY1NDU2MTA1MmRk7eWz8DBE7zF7MW8sS4wNndKCr5gBJPZZ/LOS1KIbBo4=" /> In order to solve this issue

Difference between Inner and Outer Join in SQL

2011-11-01T12:19:00.000+02:00

Joins are used to combine the data from two tables, with the result being a new, temporary table. The temporary table is created based on column(s) that the two tables share, which represent meaningful column(s) of comparison. The goal is to extract meaningful data from the resulting temporary table. Joins are performed based on something called a predicate, which specifies the condition to use

How to: Copy some rows from a GridView to another in ASP.NET

2011-10-19T01:04:00.000+02:00

A junior developer asked me can I select some rows from a GridView and copy them to another GridView? I told him sure all you have to do is to create a DataTable and the columns that will be added to it. Now you will loop for each row in the first GridView then add the selected rows to the DataTable. Set the DataSource of the other GirdView to DataTable. Here is the code that would do the trick

Two Databound Fields in Gridview column

2011-10-03T14:48:00.000+02:00

Boundfields are great in the Gridview, but they do have their limitations. One is that it only has room for one bound field. So, what do you do when you want two or data fields. For example, First and Last names returned to the same column. Turn the BoundField into a TemplateField, with a label in it: 1: <asp:templatefield> 2: <itemtemplate> 3: <asp:label id="

Select Drop Down List Item After Declarative Databinding

2011-09-01T19:28:00.000+02:00

The new declarative controls of ASP.NET 2.0 are really great. However, there are some times, when it may not seem so. Let's say you have a DropDownList which is bound by a DataSource control. Also, you have other pages hitting this page, with querystrings, and based on the item in the querystring, you'd like the to select that item. In ASP.NET 1.1, you'd just code it, and select it after the

How to: Turn on/off tracing for entire ASP.NET Site or Application

2010-01-01T18:40:00.000+02:00

Open up your web.config file - then, somewhere in the system.web section, put this : 1: <trace enabled="true" localonly="false" pageoutput="true"></trace> Set it to 'false' if you don't want it to show up.

XML Data and Document Storage in SQL Server 2005

2009-11-29T23:41:00.018+02:00

XML is a platform-independent data representation format based originally on SGML. Since its popularization, it is becoming used as a data storage format. It has its own type system, based on the XML Schema Definition language (XSD). Both XML and XSD are W3C standards at the Recommendation level. An XML schema defines the format of an XML document as a SQL Server schema defines the layout of a

What is the Web 2.0 term means?

2009-08-17T22:00:00.000+03:00

The term “Web 2.0” defines a set of principles and practices for web applications, which, when followed, entitle a web application to wear the Web 2.0 crown.A web site can claim to be a Web 2.0 site if it:Allows users to control data presented on the web sitePresents a platform that enables the mixing (or mash-up) of technologies and dataEnables services to be consumed that are beyond the

What is a Web Portal?

2009-08-13T15:06:00.000+03:00

A web portal is a page that allows a user to customize his homepage by dragging and dropping widgets onto it.This approach gives the user complete control over what content he sees on his home page, where on the page he wants to see it, and how he wants to interact with it.A widget is a discrete piece on a web page that performs a particular function and comes with its own UI and set of

What is the difference between Convert.ToInt32(string) and Int32.Parse

2009-08-11T12:01:00.003+03:00

Convert.ToInt32(string); and Int32.Parse(string); produce the same results except when the string is actually a null. In this case, Int32.Parse(null) throws an ArgumentNullException, but Convert.ToInt32(null) returns a zero. So which one is better to use? Waiting for your comments...

How to: Create a GroupBox in ASP.NET

2009-08-05T19:28:00.000+03:00

Simple just use an ASP.NET Panel Control and use the Grouping Text Property. 1: <asp:panel id="Panel1" runat="server" groupingtext="Group 1" height="355px">

ASP.NET State Management

2009-08-01T15:13:00.000+03:00

In an ASP.NET Web application, information about the current user, his preferences, and the application's current configuration are stored as values of global variables. This information is also stored as controls and properties of objects in memory to be used by the application until it is released or terminated. Such information is collectively referred to as the state of a Web page. To

SQL Server as a Runtime Host Part 3

2009-06-13T10:10:00.000+03:00

There are three categories of access security for managed code.These are SAFE, EXTERNAL_ACCESS, and UNSAFE, which we mentioned previously with respect to class loading.This allows the DBA to determine if an assembly should be permitted certain privileges while knowing the risks.These categories equate to SQL Server–specific permission sets using code access security concepts.Having stated this,

SQL Server as a Runtime Host Part 2

2009-06-09T23:58:00.000+03:00

Since in SQL Server users are not allowed to run arbitrary programs for reliability reasons, code (an assembly) is loaded a little differently than in other runtime hosts.The user or DBA must preload the code into the database and define which portions are invocable from Transact-SQL.Preloading and defining code uses ordinary SQL Server Data Definition Language (DDL).Loading code as a stream of

SQL Server as a Runtime Host Part 1

2009-06-07T21:37:00.000+03:00

If you are a SQL Server developer or database administrator, you might just be inclined to use the new Common Language Runtime (CLR) hosting feature to write stored procedures in C# or VB.NET without knowing how it works.But you should care. SQL Server is an enterprise application, perhaps one of the most important in your organization. When the CLR was added to SQL Server, there were three goals

System Metadata Tables and INFORMATION_SCHEMA in SQL Server 2005

2009-06-01T00:48:00.000+03:00

Information about assemblies as well as the assembly code itself and the dependencies is stored in the system metadata tables, which, in general, store information about SQL Server database objects, such as tables and indexes. Some metadata tables store information for the entire database instance and exist only in the MASTER database; some are replicated in every database, user databases as

Visual Studio 2005/2008 on Vista Internet Explorer cannot display the webpage

2009-03-23T11:28:00.000+02:00

I faced a strange problem with Visual Studio 2005 and Visual Studio 2008 which is I have several ASP.NET Projects some of them using .NET 2.0 or Visual Studio 2005 and the other is using .NET 3.5 or Visual Studio 2008.The problem was when I try to run the Web Application I got this error:Internet Explorer cannot display the webpageI am not using IIS for these Web Application.I have tryied the

Establishing a Formal Programmers Syndicate in Egypt

2009-03-03T19:50:00.005+02:00

In this post we will discuss everything about establishing a Formal Syndicate or Union for Programmers in Egypt. Please start to leave comments.

Where is the best place to store the connection string?

2009-02-09T19:53:00.000+02:00

I think the best place to store the connection string is the Web.Config File if you are developing a Web Application or the App.Config File if you are developing a Windows Application.You have another opinion? Leave a comment.

How to: Access controls on Master Pages from Content Pages in ASP .NET

2009-02-03T15:05:00.001+02:00

We will assume that we have a Label control called "Label1" on your Master Page, you might want to change the text of that Label. To do that write this code in your content page: 1: Label lbl = new Label(); 2: lbl = (Label)Master.FindControl("Label1"); 3: lbl.Text = "Text"; of course, this is all assuming the label is OUTSIDE the ContentPlaceHolder

How to: Secure Session State in ASP.NET

2009-02-01T11:39:00.002+02:00

The information in session state is very secure, because it is stored exclusively on the server. However,the cookie with the session ID can easily become compromised. This means an eavesdropper could steal the cookie and assume the session on another computer. Several workarounds address this problem. One common approach is to use a custom session module that checks for changes in the client’s

Encryption in C# .NET

2009-01-29T10:42:00.000+02:00

This class uses a symmetric key algorithm (Rijndael/AES) to encrypt and decrypt data. As long as encryption and decryption routines use the same parameters to generate the keys, the keys are guaranteed to be the same. In a real-life application, this may not be the most efficient way of handling encryption, so as soon as you feel comfortable with it you may want to redesign this class. 1:

Cross Page postback in ASP.NET

2009-01-27T01:08:00.000+02:00

This is a new feature in ASP .NET 2.0. The IButtonControl Interface contains a new property called PostBackUrl which points to the page to which the current page will postback, Button, ImageButton and LinkButton implements this interface and exposes the cross page postback functionality. When user clicks the button in the current page will postback to the specified page which can access the

Ajax Modal popup Extender - Infinite Scroll bar in ASP.NET 3.5

2009-01-25T22:25:00.000+02:00

I was using Ajax Modal popup Extender in a Page that uses Master Page in a Web Application I am working on it.After Modal popup extender comes up, an infinite scroll bar is appearing, and a black box appears and when I tried to scroll down the scroll bar, the background becomes editable.It was a very strange problem for me but I was able to fix it and here is the solution:Make sure in your

The permissions granted to user 'Domain\UserName' are insufficient for performing this operation

2009-01-23T11:00:00.000+02:00

I have faced a problem when I tried to open the Reporting Service Web Site for SQL Server 2005 running on Vista Ultimate. As you can see from the title of the post the error was "The permissions granted to user 'Domain\UserName' are insufficient for performing this operation"I have installed SQL Server 2005 Service Pack 2 and grant the user the Administrator permissions and I still got this