Karatas, FERHAT

301 Redirect

Tue, 08 Sep 2009 12:08:59 GMT

301 redirect is the most efficient and Search Engine Friendly method for webpage redirection. It's not that hard to implement and it should preserve your search engine rankings for that particular page. If you have to change file names or move pages around, it's the safest option. The code "301" is interpreted as "moved permanently".

Domain aliases is usually considered spamming to the search engines because the domain name DUPLICATES the content on your primary domain and in turn, masks the domain name under the secondary domain. They may feel you are trying to trick them when you use a domain alias. Because what they see when they crawl an aliased domain is a website domain that has exactly the same content as the primary domain.

You can Test your redirection with Search Engine Friendly Redirect Checker

Below are a Couple of methods to implement URL Redirection

IIS Redirect

    * In internet services manager, right click on the file or folder you wish to redirect
    * Select the radio titled "a redirection to a URL".
    * Enter the redirection page
    * Check "The exact url entered above" and the "A permanent redirection for this resource"
    * Click on 'Apply'

ColdFusion Redirect
<.cfheader statuscode="301" statustext="Moved permanently">
<.cfheader name="Location" value="http://www.new-url.com">

PHP Redirect
<?
Header( "HTTP/1.1 301 Moved Permanently" );
Header( "Location: http://www.new-url.com" );
?>

ASP Redirect
<%@ Language=VBScript %>
<%
Response.Status="301 Moved Permanently"
Response.AddHeader "Location","http://www.new-url.com/"
%>

ASP .NET Redirect
<script runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
Response.Status = "301 Moved Permanently";
Response.AddHeader("Location","http://www.new-url.com");
}
</script>

JSP (Java) Redirect
<%
response.setStatus(301);
response.setHeader( "Location", "http://www.new-url.com/" );
response.setHeader( "Connection", "close" );
%>

CGI PERL Redirect
$q = new CGI;
print $q->redirect("http://www.new-url.com/");

Ruby on Rails Redirect
def old_action
headers["Status"] = "301 Moved Permanently"
redirect_to "http://www.new-url.com/"
end

Keywords : 301 redirect is the most efficient and Search Engine Friendly method for webpage redirection. Do not use "domain alias" for URL redirection.

Delay redirect in javascript

Mon, 07 Sep 2009 10:45:31 GMT

Gmail apps for Email hosting

Sun, 06 Sep 2009 12:14:08 GMT

I'll show you how to tranfser your mail server (MX) to Google Apps.

Step 1/2 : Changing MX records (with plesk panel)
- Select your domain
- Select "DNS Settings" in Services section
- You will see 12 records. Delete only this record :
yourdomain.com.   MX (10)       mail.yourdomain.com.
- Add these records.(with Record Type = MX)
Note : "Enter mail domain" is blank

Enter mail exchanger       Specify priority of mail exchange server
ASPMX.L.GOOGLE.COM.        10
ALT1.ASPMX.L.GOOGLE.COM.    20
ALT2.ASPMX.L.GOOGLE.COM.    20
ASPMX2.GOOGLEMAIL.COM.    30
ASPMX3.GOOGLEMAIL.COM.    30
ASPMX4.GOOGLEMAIL.COM.    30
ASPMX5.GOOGLEMAIL.COM.    30

Step 2/2 : Sign-up google apps
You should create your account with this url : http://www.google.com/apps/intl/en/group/index.html
Confirm your membership with mail that sent by goggle apps.

Optional :
Configuration for Outlook :
incoming : pop.gmail.com
smtp     : smtp.gmail.com
More settings :
Outgoing Server - My outgoing server(SMTP) requires authentication
Advanced - Incoming server (POP3) : 995
This server requires an encrypted connection (SSL)
Outgoing server (SMTP) : 465
Use the following type of encrypted connection : SSL

Note : You can access your inbox at http://mail.google.com/a/yourdomain.com

Keywords : Gmail apps configuration/implementation/installation

ChangePassword control with Gmail Apps

Sat, 05 Sep 2009 18:07:08 GMT

BUG: ASP.net 2.0 PasswordRecovery/ChangePassword Web Control cannot send emails to SSL enabled SMTP Servers

This is a known issue or you can also call it as product limitation. PasswordRecovery or ChangePassword control read most of the settings from web.config file. Internally it uses System.Net.Mail to send out email, which does not support reading EnableSSL setting from web.config. This bring us into a situation where PasswordRecovery control cannot send emails to SSL enabled smtp servers.

So when a user tries to send a email to SSL enable server using PasswordRecovery or ChangePassword control, he get the following error.

Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. 32sm15616652wfa.13

Cause :
There is no setting in Web.Config for System.Net.Mail (.net 2.0) that maps to EnableSSL property of System.Net.Mail.SmtpClient.

Resolution :
Step 1 : Add SendingMail event to control;

<asp:ChangePassword ID="ChangePassword1" runat="server" onsendingmail = "ChangePassword1_SendingMail">

Step 2 : Add codebehind codes;
protected void ChangePassword1_SendingMail(object sender, MailMessageEventArgs e)
        {
            e.Message.Body.SendMail(e.Message.To[0].ToString(), e.Message.Subject.ToString(), string.Empty);
            e.Cancel = true;
        }

Step 3 : SendMail (extention) method;
public static void SendMail(this string body, string to, string subject, string attachFilename)
        {
            Configuration configurationFile = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
            MailSettingsSectionGroup mailSettings = configurationFile.GetSectionGroup("system.net/mailSettings") as MailSettingsSectionGroup;
            string from = mailSettings.Smtp.From;

            MailMessage message = new MailMessage();
            message.Priority = MailPriority.Normal;
            message.From = new MailAddress(from, ConfigurationManager.AppSettings["SiteName"]);
            message.To.Add(new MailAddress(to));
            message.Subject = subject;
            message.IsBodyHtml = true;
            message.SubjectEncoding = Encoding.UTF8;
            message.BodyEncoding = Encoding.UTF8;
            message.Body = body + "<br><br>" + ConfigurationManager.AppSettings["SiteDomain"] + "<br>" + DateTime.Now.ToString();

            if (attachFilename != string.Empty)
            {
                message.Attachments.Add(new Attachment(attachFilename));
            }

            SmtpClient client = new SmtpClient();
            client.EnableSsl = true;
            client.Send(message);
        }

Step 4 : Add smtp node to web.config;
<system.net>
<mailSettings>
    <smtp from="sample@yourdomain.com" deliveryMethod="Network">
   <network host="smtp.gmail.com" port="587" userName="sample@yourdomain.com" password="xxxx" defaultCredentials="false"/>
    </smtp>
</mailSettings>
</system.net>
<system.web>...

Keywords : Gmail apps with ChangePassword control in asp.net

Property IsLocked is not available

Fri, 04 Sep 2009 10:40:49 GMT

Property IsLocked is not available for Login '[DBName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Solution 1 : Restart computer

Solution 2 :
I ran into the same issue today when I installed an instance of SQL 2005 using Windows Auth. mode. After the install I switched the server over to SQL and Windows Auth mode and ran into the 'sa' problem. I ran the following command and then could see the properties of 'sa' within management studio.

alter login sa
with password = 'yourpwd' unlock,
check_policy = off,
check_expiration = off

Keywords : Sql login, islocked, insufficient

X-UA-Compatible

Sun, 30 Aug 2009 16:43:40 GMT

Implementing the HTTP header is beneficial if a site owner wants most of their site to render as it did in IE7 or if there are no plans to update site content. Inclusion of this header honors any Quirks mode pages that belong to the site. Use below statement at top of your page :

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />

or use it in web.config :

<system.webServer>
    <httpProtocol>
        <customHeaders>
            <add name="X-UA-Compatible" value="IE=EmulateIE7" />
        </customHeaders>
    </httpProtocol>
</system.webServer>

Using the meta-tag on a per-page basis is beneficial when the publisher wants to opt-in specific pages to render as they did in IE7.

NOTE: The X-UA-Compatible tag and header override any existing DOCTYPE. Also, the mode specified by the page takes precedent over the HTTP header. For example, you could add the EmulateIE7 HTTP header to a site, and set specific pages to display in IE8 mode (by using the meta-tag with content="IE8").

Using the IE=EmulateIE7 compatibility tag is a simple way for users to continue their current experience when browsing your site until you can update with more standards-compliant content. Although adding this tag will prevent most display issues, you may also need to update your site to properly detect IE8.

Keywords : Emulate IE7

No buffer space available Fix

Sat, 29 Aug 2009 12:08:04 GMT

Error : An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full xxxx.xxxx.xxxx:80

Solution 1 :

I think I've found a reason for it: My anti-virus scanner, NOD32 v2.51.12 x64, with enabled HTTP scanning. If the HTTP scanning on port 80,8080,3128 and "Auto Detect HTTP communication on other ports" is enabled, both versions will crash. After I disabled the IMON (Internet Monitor) and EMON (MS Outlook E-Mail Monitor) features in NOD32 everything seems to work fine.

Solution 2 :

Editting the registry is not for beginners, if you don't know what you're doing I suggest you don't try this, basically it's use at your own risk. Anytime you want to edit the registry it is a good idea to back it up first..

If you are using Windows 95/98/Me follow these steps:

First step is to launch the registry editor. To do this go to Start, Run and type regedit. In the left pane navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\VxD\MSTCP once there, look for an entry called MaxConnections. If it exists highlight it by clicking it and then right click it and select modify. Increase the value (recommended value is to double the current value).

If the MaxConnections entry does not exist you must create it. To do this, right click in the right pane and choose new from the menu and select String Value. Give it the name MaxConnections. Then right click it and select modify and enter a value of 800.

Restart your computer, if all goes well then you fixed the problem, if not, revert the changes by restoring the registry. (You may have to reboot to safe mode to do this).

If you are running Windows NT/2000/XP follow these steps:
First step is to launch the registry editor. To do this go to Start, Run and type regedit. In the left pane navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters once there, you must create the entry TcpNumConnections. To do this, right click in the right pane and choose new from the menu and select DWORD Value. Give it the name TcpNumConnections. Then right click it and select modify and enter a value of 800.

Restart your computer, if all goes well then you fixed the problem, if not, revert the changes by restoring the registry. (You may have to reboot to safe mode to do this).

Consideration :

TIP 1 : I have seen NOD32 cause WSAENOBUFS (10055) on many systems. They seem to do something which lowers the resources available to networking applications.
TIP 2 : Problem is caused by a recent windows patch. If you remove patch KB948609 the client side deserialization will except large datasets again.
TIP 3 : If an application performs many network connections simultaneously or within a short window of time, the application developer might need to increase this number and reduce the TcpTimedWaitDelay value to avoid receiving a WSAENOBUFS (10055) error: "An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full." (http://msdn.microsoft.com/en-us/library/ms819739.aspx)

Keywords : WSAENOBUFS, 10055

Activate current link in master page

Tue, 14 Jul 2009 13:21:42 GMT

Step 1 :
<ul>
<li id="<%=current("/Index.aspx,/Contact.aspx") %>">
<a href="/Public/CustomerCare/Index.aspx"><span>Customer</span></a></li>
<li id="<%=current("/Contact.aspx") %>">
<a href="/Public/CustomerCare/Contact.aspx"><span>Iletisim</span></a></li>
</ul>

Step 2 :
protected string current(string currentpage)
{
   // activate current link
   string pname = Request.ServerVariables["SCRIPT_NAME"];

   string result = pname.Substring(pname.LastIndexOf("/"), pname.Length - pname.LastIndexOf("/"));

   if (currentpage.IndexOf(result)>=0)
   {
     result = "current";
   }

   return result;
}

Keywords : CSS, activate current page, asp.net

Sorenson Squeeze for reducing .flv files

Sat, 27 Jun 2009 22:32:09 GMT

For starters, Sorenson Media has been the global leader in video encoding and compression technology for nearly a decade and a half.

What does that mean? It means that every day thousands of people rely on Sorenson Media for all their video encoding, publishing and delivery needs. So then the question becomes: Why wouldn't you?

When quality counts, turn to the company you can trust, turn to Sorenson Media.

Raw, uncompressed video is a huge beast. Traditionally, getting it online meant sending any large, foreboding video to the unknown server in the sky so they can encode and deliver to you when they got around to it. This takes up resources, bandwidth and most importantly time. Oh yeah, and it can cost a lot of money.

Utilizing Sorenson's desktop and web-based applications you can compress that video down to a manageable size, upload it to the web and publish to your site in a matter of minutes.

This is my experience steps for reducing size of flv file :

- Get .flv file with "Import File"
- Select "Format Sort" in "Audience presents"
- Select "Adobe Flash Video (.flv)" at line third
- You can choose "F8_256K" to best performance (according to my experience)
- Click "Apply" button to apply filter
- Click "Squeeze it!" at right bottom side of screen to start conversion.
- You can access converted file at directory that original file already located.

Keywords : Reducing .flv video file without loss of quality. Sorenson Squeeze v5.0

Configuring Awstats for Mulitple web sites

Fri, 26 Jun 2009 14:44:33 GMT

I explained something about installation Awstats log analyzer tool before. I list all required steps to implement much more web site to use Awstats report. Here we go :

1. Configure W3SVC log format in IIS (in Website tab)

   You should delete all previos log file in Log files directory (ex: C:\WINDOWS\system32\LogFiles\W3SVC129507843) If you can not delete anything in that folder, please try to stop website and delete it again. Then set these properties to enable.

   - Date (date)
   - Time (time)
   - Client IP Address (c-ip)
   - Username (cs-username)
   - Method (cs-method)
   - URI Stem (cs-uri-stem)
   - URI Query (cs-uri-query)
   - Protocol Status (sc-status)
   - Bytes Sent (sc-bytes)
   - Protocol Version (cs-version)
   - User Agent (cs(User-Agent))
   - Referrer (cs(Referrer))

2. Access to web site with Internet explorer/firefox to create sample log file in server's LogFiles directory.

3. Create configuration file in "C:\perl\wwwroot\cgi-bin" (ex : awstats.www.sampledomain.com.tr.conf)

4. Update 3 parameters according to new site.

   - LogFile="C:\WINDOWS\system32\LogFiles\W3SVC129507843\ex%YY-24%MM-24%DD-24.log"
   - SiteDomain="www.sampledomain.com.tr"
   - HostAliases="sampledomain.com.tr www.sampledomain.com.tr"

5. Copy icon folder in "C:\perl\wwwroot\icon" to your root website directory (ex: C:\Inetpub\wwwroot\sampledomain\sampledomain)

6. Create stats folder in web root to publish report (ex : C:\Inetpub\wwwroot\sampledomain\sampledomain\stats)

7. Right click on the stats folder in IIS and select properties, then click documents tab and add default html page name (ex : awstats.www.sampledomain.com.tr.html) Then, move it to first line.

6. Create batch file with following lines (ex : AwstatsService.bat)

C:\Perl\wwwroot\cgi-bin\awstats.pl -config=www.sampledomain.com.tr -update
C:\Perl\tools\awstats_buildstaticpages.pl -config=www.sampledomain.com.tr -update -lang=en -dir="C:\Inetpub\wwwroot\sampledomain\sampledomain\stats" -awstatsprog="C:\Perl\wwwroot\cgi-bin\awstats.pl"

Hint : This batch file use previous day log records. see 9th line below if you want to see current traffic.

7. Create scheduled task in Control Panel for batch file (AwstatsService.bat) to run it in anytime.

8. You can access report by http://www.sampledomain.com.tr/stats/

9. Use this batch file (ex : AwstatsCurrent.bat) if you want to see current usage in traffic report.

   C:\Perl\wwwroot\cgi-bin\awstats.pl -config=www.sampledomain.com.tr -update -logfile="C:\WINDOWS\system32\LogFiles\sampledomain\W3SVC1370046439\ex090620.log"
   C:\Perl\tools\awstats_buildstaticpages.pl -config=www.sampledomain.com.tr -update -lang=en -dir="C:\Inetpub\wwwroot\sampledomain\sampledomain\stats" -awstatsprog="C:\Perl\wwwroot\cgi-bin\awstats.pl"

   Because AwstatsService.bat (in 6th item) use previous day log records.
   Note : You should change logfile name that end of first line everyday. (ex090620.log)

10. Note : Don't run batch file (ex : AwstatsCurrent.bat) in 2 minutes again.

Keywords : Awstats configuration for multiple web sites.

Flash Player Detection Kit

Thu, 25 Jun 2009 10:51:57 GMT

The Flash Player Detection Kit helps developers implement robust player detection for a variety of deployment environments by providing a set of templates and techniques to successfully detect the version of Flash Player installed on a user's computer, and, if needed, to then install the latest version of Flash Player. The kit also includes a detailed explanation and sample files for implementing the new, player-based Flash Player Express Install experience. The scripts in the Flash Player Detection Kit are also incorporated into Flash Professional 8.

Please click here to download Client-side/Javascript Detection samples.

More detail : http://www.adobe.com/products/flashplayer/download/detection_kit/

Keywords : Flash version detection, javascript

The remote certificate is invalid

Wed, 24 Jun 2009 22:54:49 GMT

If I enable EnableSsl for smtpclient am getting an exception: "The remote certificate is invalid according to the validation procedure."

It means the server certificate isn't valid by regular validation rules. You can simply use this snippet to by-pass it:

public static bool AcceptAllCertificatePolicy(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors)
{ return true; }

public static void SendMail(string body, string to, string subject, string attachFilename)
{
MailMessage message = new MailMessage();
message.Priority = MailPriority.Normal;
message.To.Add(new MailAddress(to));
message.Subject = subject;
message.IsBodyHtml = true;
message.BodyEncoding = System.Text.Encoding.GetEncoding("ISO-8859-9");
message.Body = body;

if (attachFilename != string.Empty)
{
message.Attachments.Add(new Attachment(attachFilename));
}

ServicePointManager.ServerCertificateValidationCallback = AcceptAllCertificatePolicy;
SmtpClient client = new SmtpClient();
client.EnableSsl = true;
client.Send(message);
}

Keywords : Smtpclient, asp.net, system.net.mail, EnableSSL, validation.

ASP.NET GridView Paging Style

Tue, 23 Jun 2009 10:05:07 GMT

Tip 1: Change the style of the selected page or highlight the current page in the GridView Pager control
A simple way is to use CSS as shown below. The <PagerStyle> is set to a css class which modifies the style of the pager:
<head runat="server">
    <title></title>
       <style type="text/css">
              .cssPager span { background-color:#4f6b72; font-size:18px;}
        </style>
</head>
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" AutoGenerateColumns="false" DataKeyNames="ProductID" DataSourceID="SqlDataSource1">
    <PagerStyle CssClass="cssPager" />
...
The output is as shown below, with the style set for the current page.

Tip 2: How to increase the spacing between the ASP.NET GridView Pager Numbers
One simple way is to use CSS again. Observe how we have set a cssClass to the PagerStyle, similar to what we saw in Tip 1, and are increasing the padding for the <td>:
<head runat="server">
    <title></title>
       <style type="text/css">
            .cssPager td
            {
                  padding-left: 4px;
                  padding-right: 4px;
             }
        </style>
</head>
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" AutoGenerateColumns="false" DataKeyNames="ProductID" DataSourceID="SqlDataSource1">
    <PagerStyle CssClass="cssPager" />
...
The output looks similar to the following with the increased space between the page number display.

Keywords : Some Tips and Tricks while Using ASP.NET GridView Paging

Classic ASP Error Messages in IIS 7.5

Mon, 22 Jun 2009 13:39:56 GMT

In earlier versions of IIS, error messages from classic ASP scripts were sent to a Web browser, by default. Because these error messages might reveal sensitive information to malicious users, IIS 7.0 disables this feature by default. When your classic ASP scripts encounter an error in IIS 7.0, you receive the following error message by default:

An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.

You can customize the ASP script error message, and also determine whether to return the script errors to a Web browser. Note: As a best practice for security, you should only enable sending ASP script error messages to a Web browser on a development or test computer; returning script error messages to a Web browser can unintentionally expose more information than you intended to show. Customizing Classic ASP Error Messages
The configuration settings that you use to customize these settings are in the following list:

scriptErrorMessage
This is an optional string attribute that specifies the error message that will be sent to the browser when specific debugging errors are not sent to the client.
scriptErrorSentToBrowser
This is an optional Boolean attribute that specifies whether the writing of debugging specifics to the client browser is enabled
You can configure these settings by using IIS Manager. To do so, open IIS Manager and navigate to the site or application where you want to enable or disable script messages, and then double-click the ASPfeature.

In the list of ASP features, configure the Script Error Message and Send Errors To Browser options.

Keywords : Classic ASP script error messages are no longer shown in a Web browser by default.

Installing Classic ASP on Windows 7

Mon, 22 Jun 2009 13:17:58 GMT

1. Click Start, and then click Control Panel.
2. In Control Panel, click Programs and Features, and then click Turn Windows Features on or off.
3. Expand Internet Information Services, then World Wide Web Services, then Application Development Features.
4. Select ASP, and then click OK.

Keywords : Classic ASP is not installed by default on IIS 7.0 and IIS 7.5

Character convertion in FCK Editor

Fri, 19 Jun 2009 22:55:21 GMT

Question :
When I write "�" character (ASCII 252 code), FCEditor convert this character to "ü". How do I stop this?

Answer :
Do these changes step by step

1. \FCKEditor\fckconfig.js:
FCKConfig.IncludeLatinEntities = false ;

2. \FCKEditor\editor\source\internals\fckxhtmlentities.js:
Change the content of "FCKConfig.IncludeLatinEntities" variable. Or delete related character line.

3. Very important: After change, clear the browser cache. And use Ctrl+F5 to refresh page.

Keywords : FCKEditor, asp.net, FredCK.FCKeditorV2.dll

Lambda Expression

Sat, 23 May 2009 13:39:41 GMT

Lambda Expressions provide a more concise, functional syntax for writing anonymous methods.  They end up being super useful when writing LINQ query expressions - since they provide a very compact and type-safe way to write functions that can be passed as arguments for subsequent evaluation.

Example:
Sample 1 :
public class Person
{
  public string FirstName;
  public string LastName;
  public int Age;
}

List<person> people = new List<person>
{
  new Person{FirstName = "Ferhat", LastName = "Karatas", Age=10},
  new Person{FirstName = "Elif", LastName = "Sila", Age=5},
  new Person{FirstName = "Sevim", LastName = "Karatas", Age=15}
};

// return all Karatas

IEnumerable<person> results = people.Where(p => p.LastName == "Karatas");

double averageAge = people.Average(p => p.Age);
Label1.Text = results.Count().ToString() + "-" + averageAge.ToString();

Sample 2 :
var numbers = new List<int>() { 1, 2, 3, 4, 5, 6, 7, 8, 9 };

var evennumber = numbers.FindAll(p => p % 2 == 0);

foreach (int item in evennumber)
{
Label1.Text += item + "-";
}

The p => expressions highlighted above in red are Lambda expressions. In the sample above I'm using the first lambda to specify the filter to use when retrieving people, and the second lambda to specify the value from the Person object to use when computing the average.

Keywords : Linq, lambda expression

AWstats Installation - Best IIS Log Analyzer

Tue, 19 May 2009 21:57:37 GMT

AWStats is a free powerful and featureful tool that generates advanced web, streaming, ftp or mail server statistics, graphically. This log analyzer works as a CGI or from command line and shows you all possible information your log contains, in few graphical web pages. It uses a partial information file to be able to process large log files, often and quickly. It can analyze log files from all major server tools like Apache log files (NCSA combined/XLF/ELF log format or common/CLF log format), WebStar, IIS (W3C log format) and a lot of other web, proxy, wap, streaming servers, mail servers and some ftp servers.

AWStats is such a great statistical tracking program to use, but there seems to be a lack of easy-to- follow documentation available for installing AWStats on IIS. This document covers the basic setup process and will certainly get you started tracking statistics for your websites. If anyone is having troubles getting AWStats to work with IIS 6.0 (or IIS 5.1) after following this documentation please write to me and I will do my best to respond.

Installation guide for English

Installation guide for Turkish

Troubleshooting :
When you trying to install AWstats after Perl, you may encounter this error : "The installer did not find any PERL interpreter in your PATH"

Resolution :
      1] In Windows Explorer, right click on "My Computer" then goto properties.
      2] Click the Advanced tab
      3] Down the bottom click "Enviroment Variables"
      4] Click to New under the "User variables for .." Variable name : pl Variable Value : c:\perl (perl root directory)
      5] Click ok on all open windows

Keywords : AWStats, best IIS log analyzer

EXCEPT and INTERSECT (Transact-SQL)

Sat, 16 May 2009 12:25:57 GMT

The INTERSECT keyword returns a combined result set that consists of all of the rows that exist in both result sets.

Suppose you want to find a list of employee numbers that includes:

People in department D11

People whose assignments include projects MA2112, MA2113, and AD3111

INTERSECT returns the all of the employee numbers that exist in both result sets. In other words, this query returns all of the people in department D11 who are also working on projects MA2112, MA2113, and AD3111.

To do this, specify:

SELECT EMPNO FROM CORPDATA.EMPLOYEE WHERE WORKDEPT = 'D11' INTERSECT SELECT EMPNO FROM CORPDATA.EMPPROJACT WHERE PROJNO = 'MA2112' OR PROJNO = 'MA2113' OR PROJNO = 'AD3111' ORDER BY EMPNO

EXCEPT returns any distinct values from the left query that are not also found on the right query.

Keywords : Intersect and Except in Sql Server

'System.web.extensions' is already defined.

Sun, 08 Feb 2009 20:28:33 GMT

Error : Section or group name 'system.web.extensions' is already defined. Updates to this may only occur at the configuration level where it is defined.

I have a web application project which developed under 3.5 .net framework. Also there is a virtual directory under the project that developed in previous framework. These two sections belongs to their web.config file.

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

Virtual Directory's config : <sectionGroup name="system.web.extensions" type= "System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">

Solution : <configuration> <configSections> <sectionGroup name="system.web.extensions2". I changed the "name" attribute of the sectionGroup of the Virtual Directory. Site and everything seems to be working now.

Keywords : sectionGroup inheritance issue, ajax migration, system.web.extension.

SQL Function

Sat, 07 Feb 2009 22:09:58 GMT

CREATE FUNCTION Hesapla (@Fiyat int)
RETURNS int
AS
BEGIN
    DECLARE @donenDeger int
    SET @donenDeger = @Fiyat * 1.18
    RETURN @donenDeger
END

-- to call
select dbo.Hesapla(30)

Keywords : Create sql function in MS SQL

Large File Uploading in ASP.NET

Fri, 17 Oct 2008 09:40:28 GMT

In your web.config, add a line under your system.web <httpRuntime executionTimeout="54000" maxRequestLength="512000" /> where execution timeout is in seconds, and maxRequestLength is in KB. executionTimeout, is basically the amount of time a thread will continue to run, and accept data by IIS/.NET. maxRequestLength, is the total amount of data that can be sent through HTTP Post to the server. The default is 4MB (4096)...and is generally set low so that your server will not be overwhelmed by possible DoS attacks.

Memory deallocation is a major issue, that has no current solution. Whenever you upload files via HTTP Post, the file is stored in the memory of the aspnet_wp.exe process, and never deallocates completely (if your lucky a few MB gets released). One of the config settings for .NET processes, allows them to utilize 60% of physical memory on the server, at which point the process is recycled and all execution is stopped. Whenever a new upload is started, though, some memory is de-allocated, but not enough compared to memory that was used in prior uploads.

Microsoft is aware of this problem, and has assured us that it will be fixed with some upcoming releases of the .NET framework. Some solutions that they suggested to us, was to use Classic ASP, Third Party Components, or Custom Built ISAPI filters.

NeatUpload
The NeatUpload T ASP.NET component allows developers to stream uploaded files to storage (filesystem or database) and allows users to monitor upload progress. It is open source and works under Mono's XSP/mod_mono as well as Microsoft's ASP.NET implementation.

Streams uploads directly to storage. This conserves server memory, allows larger uploads, and helps prevent Denial of Service attacks.

It features 2 custom controls: InputFile allows the user to select a file to upload, and ProgressBar displays the upload progress either inline or in a popup. ProgressBar uses AJAX-style refreshless updates on modern browsers when JavaScript is available, but also allows users without JavaScript to see upload progress.

http://www.brettle.com/neatupload

Keywords : NeatUpload, Large File Upload, maxRequestLength, executionTimeout.

Inherit the parent's HttpHandlers and HttpModules

Wed, 15 Oct 2008 23:01:00 GMT

IIS virtual directories inherit the parent's HttpHandlers and HttpModules. Basically copying the dlls into the virtual directory is solve problem.

If there is no httpModules in virtual directory then you have another option.

<httpModules>
<clear />
</httpModules>

That's a feature, not a bug! All the configs are nested from machine.config -> root web.config -> virtual web.config -> folder web.config.

Since configuration settings are inheritable, the child directories inherit configuration settings of the parent directory. As a consequence, child directories might inherit some unwanted HTTP modules as part of the parent configuration; therefore, we need a way to remove those unwanted modules. We can use the <remove> node for this.

If we want to remove all of the inherited HTTP modules from our application, we can use the <clear/> node.

The following is a generic example of adding an HTTP module:

<httpModules>
<add type="classname, assemblyname" name="modulename" />
<httpModules>

The following is a generic example of removing an HTTP module from your application.

<httpModules>
<remove name="modulename" />
<httpModules>

Keywords : IIS, inherit, HttpHandlers and HttpModules, <remove>, <clear>

Regular Expressions Usage

Mon, 13 Oct 2008 19:51:23 GMT

The source code shows how to use Regular Expressions in C#.

public static bool IsEmail(string strEmail)
{
string regex_Email = @"^[A-Za-z0-9](([_\.\-]?[a-zA-Z0-9]+)*)@([A-Za-z0-9]+)(([\.\-]?[a-zA-Z0-9]+)*)\.([A-Za-z]{2,})$";
Regex re = new Regex(regex_Email);
return re.IsMatch(strEmail) ? true : false;
}

Keywords : Regular Expression

Ajax Control Toolkit-Framework3.5 SP1 - Version 3.

Sun, 28 Sep 2008 14:26:58 GMT

Release Notes - Version 3.0.20820
2008-08-20 release of the AJAX Control Toolkit targets the official release of .NET Framework 3.5 SP1 and Visual Studio 2008 SP1.

To download :
http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=16488

How To Implement :

Download source version. (AjaxControlToolkit-Framework3.5SP1.zip)
Extract it to C:\Program Files\Ajax Control Toolkit (create directory)
Copy content of C:\Program Files\Ajax Control Toolkit\SampleWebSite\Bin to C:\Program Files\Ajax Control Toolkit\Binaries
In VS2008 toolbox. Add tab - Choose items
Select C:\Program Files\Ajax Control Toolkit\Binaries\AjaxControlToolkit.dll

Keywords : Ajax Toolkit 3.0, Updates for .NET Framework 3.5 SP1 and Visual Studio 2008 SP1

HOW TO: Dynamically Create Controls in ASP.NET

Wed, 24 Sep 2008 10:07:17 GMT

This article demonstrates how to dynamically create/handle a control for an .aspx page.

<form id="form1" runat="server">
        <div>
            <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
                <asp:ListItem>1</asp:ListItem>
                <asp:ListItem>2</asp:ListItem>
                <asp:ListItem>3</asp:ListItem>
                <asp:ListItem>4</asp:ListItem>
                <asp:ListItem>5</asp:ListItem>
                <asp:ListItem>6</asp:ListItem>
                <asp:ListItem></asp:ListItem>
            </asp:DropDownList>
            <asp:Label ID="Label1" runat="server"></asp:Label><br />
            <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
            <br />
            <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Read" />
        </div>
    </form>

        protected void Page_Load(object sender, EventArgs e)
        {
            CreateTextBox(Int32.Parse(DropDownList1.SelectedItem.Value));
        }

        void CreateTextBox(int Total)
        {
            for (int i = 0; i < Total; i++)
            {
                TextBox TextBox1 = new TextBox();
                TextBox1.ID = "TextBox1" + i.ToString();
                TextBox1.TextChanged += new EventHandler(TextBox_TextChanged);
                PlaceHolder1.Controls.Add(TextBox1);
            }
        }

        void TextBox_TextChanged(object sender, EventArgs e)
        {
            TextBox txtBoxSender = (TextBox)sender;
            Label1.Text += txtBoxSender.Text +"-";
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            // Todo : other operation
        }

Another example : http://support.microsoft.com/kb/317794

Keywords : Create and handle dynamic controls.

VS 2008 and .NET Framework 3.5 SP1

Mon, 25 Aug 2008 10:56:50 GMT

Microsoft .NET Framework 3.5 Service Pack 1
Microsoft .NET Framework 3.5 Service Pack 1 is a full cumulative update that contains many new features building incrementally upon .NET Framework 2.0, 3.0, 3.5, and includes cumulative servicing updates to the .NET Framework 2.0 and .NET Framework 3.0 subcomponents.

Download: http://www.microsoft.com/downloads/details.aspx?FamilyId=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en

Microsoft Visual Studio 2008 Service Pack 1
Improved WPF designers, SQL Server 2008 support, ADO.NET Entity Designer,Richer JavaScript support, enhanced AJAX and data tools, and Web site deployment improvements and so on.

Download: http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en

For more details : http://msdn.microsoft.com/en-us/vstudio/products/cc533447.aspx

Keywords : Service Packs, VS 2008 SP1, .NET Framework SP1

Asp.net menu in Safari

Wed, 06 Aug 2008 15:59:18 GMT

Asp.Net 2.0 Menu Control is not working with Mac Safari browser properly. The mouseovers simply do not work, and when you click on one of the links, the menu disappears completely. This is a known issue. First off, Safari gets served the menu adaptor which is fully functional but does not support the dynamic fly-outs.

Use below code to your page_load event and see the magic.

if (Request.UserAgent.IndexOf("AppleWebKit") > 0)
{
Request.Browser.Adapters.Clear();
}

If you are using Master page then paste this code into master page code behind page.

Keywords : Mac Safari, asp.net, hack

IE Tab for Firefox

Tue, 05 Aug 2008 07:40:33 GMT

IE Tab - an extension from Taiwan, features: Embedding Internet Explorer in tabs of Mozilla/Firefox.

It's useful for all developers to test their website.

Click here to download and install.

Keywords : IE Tab, add-ons, firefox

Check if a object already exists in arraylist

Thu, 10 Jul 2008 10:50:44 GMT

DataView dv = new DataView(dt, "oyverdimi is null", "altkategoriID Asc", DataViewRowState.CurrentRows);

ArrayList arr = new ArrayList();

for (int i = 0; i < dv.Count; i++)
{
    if (!arr.Contains(dv[i]["KategoriAdi"].ToString()))
    {
          arr.Add(dv[i]["KategoriAdi"].ToString());
    }
}

Keywords : Arraylist, contains, add unique item to arraylist.

Get the UserID of the User

Mon, 07 Jul 2008 18:19:43 GMT

If you use the new comfortable Login Controls of ASP.NET v2, here is how you resolve the UserID of the currently logged in user:

MembershipUser myObject = Membership.GetUser();
string UserID = myObject.ProviderUserKey.ToString();

PS. You should GUID for UserID if you use SQL Server as a DB

MembershipUser myObject = System.Web.Security.Membership.GetUser();
Guid UserID = new Guid(myObject.ProviderUserKey.ToString());

Keywords :Asp.net, Membership framework

Find a control in masterpage (contentplaceholder)

Fri, 11 Jan 2008 11:30:36 GMT

// to call :
CheckCheckBoxes(Page);

// function :

private string CheckCheckBoxes(Control oControl)
{
    string str = string.Empty;

foreach (Control c in oControl.Controls)
    {
        if (c is CheckBox)
        {
             CheckBox chk = (CheckBox)c.FindControl(c.ID);
             if (chk.Checked)
             {
                 str += chk.ID;
             }
        }

        if (c.HasControls())
        {
            CheckCheckBoxes(c);
        }
    }

    return str;
}

Keywords : Loop in controls.

What's next?

Mon, 17 Dec 2007 13:40:05 GMT

The year 2007 was a good one. The IT job market was stable. Mankind got an iPhone. While there were not any revolutionary changes in the way software was developed, I believe that this was a year of rich Internet applications and Web 2.0. YouTube became a part of the lives of millions of people around the world. A large portion of the population visits use MySpace and Facebook daily. What's next? What language/tool/technique to learn? What's the next big thing in IT? In my opinion.

1. Java will remain strong in large enterprises, but will continue losing ground as a development platform for small businesses. J2EE is way too heavy, and scripting languages and frameworks offer an alternative and productive way of software development when the cost of development is more important than performance and scalability. The LAMP platform will remain a preferable way to develop applications for small to medium businesses.

2. AJAX popularity may go downhill. Since the first day this acronym was created I've been writing that it's not a good choice for developing enterprise applications. But the vast majority of the software world was (and still is) marching the AJAX way. This time it's more of a hope than a prediction that in 2008 people will realize that AJAX should serve the same goal as JavaScript - making your Web pages a little prettier. Expect to see the re-branding of some of the AJAX frameworks into RIA or Web 2.0 solutions.

3. Speaking of Web 2.0. Even though Web 2.0 was not officially defined, I think it's all about giving more control to the users of the Web sites. The more interactive a Web site is, the higher the number people will put in front of the zero - 3.0, 4.0, and so on. Some people say that Web 3.0 is about Semantic Web. If you bought a grill on Amazon.com, they can guess with high probability that you might be shopping for rib-eye steaks. Check it out the next time you visit the site. It's all about control. From the user's side and from the vendor's side. We'll see more and more interactive sites next year. While some people are planning to write next-generation sophisticated software, others will come up with a very simple, easy-to-implement but appealing business idea, and the next 20-year billionaire is born.

4. Flash Player will remain the best deployment platform for rich Internet applications. While Microsoft is trying to come up with a competitive delivering platform for RIA, it's not going to happen in 2008. Silverlight 1.0 is a good start, the next version (1.1) will be even better, but it'll take time to release a product that can do more than streaming multimedia.

5. Ruby on Rails will take a small share of the market of small non-mission-critical Web applications. Convention over configuration. Speed of development over performance. While Ruby on Rails will not become a framework of choice, it has achieved a very positive result - people have started to realize that not every project has to be developed in either Java or .NET. Besides, RoR is a well-designed framework that will become a good design sample for the new frameworks of the future.
6. Internet video will be booming and I'm not talking about YouTube. Internet Video will start being a part of a number of enterprise applications. This process won't be fast, and you have an opportunity to be among the early adopters in this sector.

7. Outsourcing will gain more and more ground despite the fact that it's very expensive and the project failure rate is high. The reason is that the U.S. has almost stopped producing software engineers. It's just a matter of time before everyone gets used to the fact that business software is made in India, just like we all know that all toys (with or without lead) are made in China. But innovation in software will still be happening in America. I guess, there's something in the air here. Re-read an old but valid article by Paul Graham about why Silicon Valley can't be exported.

8. Apple - next year I'll finally purchase a MacBook Pro for myself. if my Sony Vaio will die. Even if it won't die, having a two-year-old machine is a good excuse for submitting a purchase order to my wife for approval. Peer pressure, a cool design and the ability to run Windows (plan B),will force me to ignore the high price.

9. Adobe Flex and AIR - Flex will become the #1 tool for developing enterprise rich Internet applications, and I'll be seeing 10% fewer raised hands when asking an audience, "Raise your hand if you do not know what Flex is?" Adobe AIR's adoption will be slow though. Or course, the shops that are already sold on Flex will use it, and some AJAX developers will realize that it may become a lifesaver for their applications, but that's about it. While being a well-designed and very promising technology (Flex, Flash Player, HTML, JavaScript, PDF, SQLLite DBMS, an ability to work in a disconnected mode, and full access to your PC's resources), it may be perceived as yet another Web browser, which is a tough sell in the enterprises. At least, become an early adopter. I will.

10. Telephony. If 2007 was the year of Skype, we'll see some interesting development in this area. Skype is a great product, but it requires you to download and install software. In the era of RIA, things can be done without it. Watch the Ribbit phone software that will allow you to make calls and receive e-mails just from your Web browser.

11. IT job market in the USA. While we've enjoyed a stable demand for IT professionals in 2007, it won't last and next year we'll see project freezes and even layoffs. The reason is the burst of the real estate bubble. This will affect not only those simple people who were brainwashed and decided that they could have afforded an American dream. CEOs of major Wall Street corporations are being fired after drowning their companies by getting into bad mortgage debt. Among other things, the IT budget will be severely cut. As you know, today on Wall Street, is tomorrow on Main street. Use the training budget of your employer now if it's not too late. Keep your skills up to date.

12. The hottest IT skills of 2008. When the job market is tight, recruiters immediately increase the list of skill requirements for job opennings. You'll see job postings that expect you to know a number of programming languages ranging from Cobol to C++. Knowing just one hot tool does not cut it anymore. But if you have limited time and need money, start by learning tools for developing rich Internet applications. The skillset of a highly paid Web developer, at a minimum, has to include the following skills: HTML,CSS, JavaScript, J2EE or.NET, Flex or Silverlight, AJAX, and good communication skills. You do not have to really learn AJAX, but must add AJAX keyword to your resume, otherwise you may not even get a job interview.

13. The next big thing. Software development will change to a wider use of code generators. Forget about heavy frameworks, regardless of what programming language you use. In a simple case, use some XML style sheets combined with the metadata that describes your application objects to automatically generate the code for these objects. On a larger scale, the entire application may be described using metadata and XML, and an appropriate code generator will do the job. So programming will change from writing tedious code that requires lots of coders to describing the metadata and writing custom code generators.

Happy New Year!

http://flex.sys-con.com/read/471820.htm

About Yakov Fain :
Yakov Fain, editor-in-chief of Flex Developer's Journal (http://flex.sys-con.com), is a managing principal of Farata Systems, consulting, training and product company. He has authored several Java books, dozens of technical articles. SYS-CON Books released his latest book, "Rich Internet Applications with Adobe Flex and Java: Secrets of the Masters" in Spring 2007. Sun Microsystems has nominated and awarded Yakov with the title Java Champion. He leads the Princeton Java Users Group. Yakov teaches Java and Flex 2 part time at New York University. He is an Adobe Certified Flex Instructor.

Keywords : Next language/tool/technique

Escape Characters

Tue, 13 Nov 2007 22:24:48 GMT

When you want to put a line return, or a single or double quote into a string. The C# processor throws an error. So you have to use escape characters to let the processor know what you are doing.

Writing double quote :

builder = "<div id=\"dropmsg" + i + "\" class=\"dropcontent\" subject=\"" + var.contentheader + "\">";

Keywords : Escape characters, writing double quote

Running 1.1 and 2.0 framework at the same machine

Fri, 09 Nov 2007 15:25:07 GMT

You can run 2.0 and 1.1 at the same time,

but they need different Application Pools.

Under IIS you have Application Pools. Create another one call it "ASP.Net 2.0" and base it on the DefaultAppPool

Then on your virtual directory properties. On the ASP.NET tab you can select 2.0 for a 2.0 application and on the Virtual directory tab the bottom drop down you can select the new Application Pool you just created "ASP.Net 2.0"

Keywords : Work with two framework (2.0 and 1.1) at same machine

Using CommandArgument and OnClientClick

Wed, 05 Sep 2007 16:52:09 GMT

The CommandArgument can contain any string set by the programmer.

Design :
...
<asp:TemplateField HeaderText="Approve">
<ItemTemplate>
     <asp:LinkButton OnClientClick="return confirm('Are you sure ?');" ID="LinkButton1" runat="server"
     CausesValidation="False" CommandName="Approve"
     CommandArgument='<%# Bind("ApprovalID") %>'
     Text="<img src='/Images/System/icon_select.gif' border='0' title='Approve' alt='Approve'>">
     </asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
...

Codebehind :
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
Literal1.Text = e.CommandArgument.ToString();
}

Keywords : CommandArgument, OnClientClick

Resetting Password with ASP.NET 2.0 Membership

Mon, 03 Sep 2007 20:49:36 GMT

If you ever have wanted to be able to programmatically change (reset) a users password while at the same time continuing to be able to use the question and answer feature, this post is for you. The problem is that if you use code like this:

string username = "user";
string password = "pass@word";
MembershipUser mu = Membership.GetUser(username);
mu.ChangePassword(mu.ResetPassword(), password);

PS :You will find that if you have in your web.config requiresQuestionAnswer="true", you will get an error when you try and reset the password.

Keywords : reset password, membershipuser, change password

AJAX Control Toolkit - Setup your environment

Sat, 04 Aug 2007 18:49:25 GMT

Install binaries

Install the latest ASP.NET AJAX Extensions 1.0 package
Unpack the AJAX Control Toolkit into a folder on your computer

Configure Visual Studio 2005 or Visual Web Developer

Create a new web site from the ASP.NET AJAX web site template by opening the "File" menu, clicking "New", "Web Site...", and picking "ASP.NET AJAX Web Site" under "My Templates"
Right-click on the Toolbox and select "Add Tab", and add a tab called "AJAX Control Toolkit"
Inside that tab, right-click on the Toolbox and select "Choose Items..."
When the "Choose Toolbox Items" dialog appears, click the "Browse..." button. Navigate to the folder where you installed the ASP.NET AJAX Control Toolkit package. You will find a folder called "SampleWebSite", and under that another folder called "bin". Inside that folder, select "AjaxControlToolkit.dll" and click OK. Click OK again to close the Choose Items Dialog.
You can now use the included sample controls in your web sites!

Note 1 : Add 3 dll to your reference from "C:\Program Files\Microsoft ASP.NET\ASP.NET 2.0 AJAX Extensions\v1.0.61025". And set it's "Copy Local" property to "True". These operation provide you to add related dll to bin directory instead of using GAC.

Havent you seen "Copy Local" property ? May be you do not know "Web Application Project". Web Application Project Model is a new web project option for Visual Studio 2005 that provides the same conceptual web project approach as VS 2003 (a project file based structure where all code in the project is compiled into a single assembly) but with all the new features of VS 2005 (refactoring, class diagrams, test development, generics, etc) and ASP.NET 2.0 (master pages, data controls, membership/login, role management, Web Parts, personalization, site navigation, themes, etc).

Note 2 : You should have these record at web.config
<system.web>
<httpHandlers>
<add verb="GET,HEAD" path="ScriptResource.axd"
type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>

Keywords : AJAX Control Toolkit setup, AJAXExtensionsToolbox.dll, System.Web.Extensions.Design.dll, System.Web.Extensions.dll

Forms Authentication timeout default in ASP.NET 2

Thu, 02 Aug 2007 12:15:41 GMT

One thing to be aware of when upgrading from ASP.NET V1.1 to V2.0 is that the forms authentication timeout value has changed to be 30 minutes by default. This means that after 30 minutes of inactivity, a user will be prompted to login again (note: everytime they hit the site the 30 minute window clock gets reset -- so it is only if they are idle that it will timeout).

If you want to change the timeout value to be longer, you can easily change the timeout value in your local web.config file (the timeout value is in minutes):

<system.web>
    <authentication mode="Forms">
          <forms timeout="60"/>
    </authentication>
</system.web>

Keywords : Forms timeout default value, web.config

How to retrieve the hidden cell value in gridView

Fri, 13 Jul 2007 19:30:38 GMT

Problem is when i am accessing through the code, getting cell value as blank. The solution is :

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow
|| e.Row.RowType == DataControlRowType.Header)
{

e.Row.Cells[2].Visible = false;

}
}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{

GridViewRow row =
(GridViewRow)((Control)(e.CommandSource)).NamingContainer;
string friendid = ((DataControlFieldCell)row.Cells[2]).Text;

}

Keywords : Hidden cell value, gridview, RowDataBound,RowCommand

Change Style Sheets On-The-Fly

Fri, 06 Jul 2007 12:56:14 GMT

Use this script to allow visitors to change a page style sheet on-the-fly, by clicking on a link in the page. The script works by switching the active style sheets. You can use any number of style sheets, which are automatically detected by the script. Optional alerts are included. Setup is easy and straightforward.

Step 1 : Setting up the Style Sheets...

Make up your style sheets and set the link rel='s up to load them, as shown below. These belong in the <head> of the page.

What you name the style sheet files does not matter (so long as the extension is .css) since the script references them only by a number, not the file name.

We show four different style sheets used; but you can use fewer or more as needed. The script will automatically detect the number of style sheets in use.

Note the order of the style sheets. The *last* sheet loaded is the one the browser will use initially. One trick to avoid confusion is shown below, where we load the first sheet an additional time at the end of the list.

<link rel="stylesheet" href="style_1.css">
<link rel="stylesheet" href="style_2.css">
<link rel="stylesheet" href="style_3.css">
<link rel="stylesheet" href="style_4.css">
<link rel="stylesheet" href="style_5.css">

Step 2 : Setting Up the JavaScript

Insert the follwing script in the <head> of the page, usually right after the link rel='s. Set doAlerts=false; to shut off the alert boxes when changing styles.

<script language="JavaScript">

</script>

Step 3 : Calling the JavaScript to Change Style Sheets

A simple JavaScript call to the changeSheets() function enables the desired style sheet. We've adjusted the call so you start at 1 for the first sheet, 2 for the second sheet, 3 for the third, etc., in the same order they are listed in your link rel='s above.

<a href="JavaScript:changeSheets(1)">Style One</a>
<a href="JavaScript:changeSheets(2)">Style Two</a>
<a href="JavaScript:changeSheets(3)">Style Three</a>
<a href="JavaScript:changeSheets(4)">Style Four</a>

Keywords : StyleSheet, on-the-fly changing

DefaultButton in a Page Based on a Master Page

Tue, 03 Jul 2007 11:29:38 GMT

You may be aware of the new DefaultButton and DefaultFocus properties that a few ASP.NET 2.0 controls, including the HtmlForm have. These properties allow you to determine which button gets "clicked" when you hit enter on the page, and which form control gets the focus when the page loads.

Your first attempt may be to add the following code in the Page_Load event of the Content page:

Page.Form.DefaultFocus = "TextBox1"
Page.Form.DefaultButton = "Button1"

However, as soon as you run this code, you'll get the following error:

Server Error in '/MyApplication' Application.
The DefaultButton of 'form1' must be the ID of a control of type IButtonControl.
Exception Details: System.InvalidOperationException: The DefaultButton of 'form1' must be the ID of a control of type IButtonControl.

Because the page is based on a Master Page, the HTML name and id attributes have been prefixed with the names of their naming container, the ContentPlaceHolder1 in this case.

Now how do you get the correct client id inside the call to WebForm_AutoFocus? The trick here is to use the controls ClientID property that returns its long client name. If you change the code in the code behind to the following, the DefaultFocus will work:

Page.Form.DefaultFocus = TextBox1.ClientID

You can apply the same technique to set the DefaultButton but then you should use its UniqueID property:

Page.Form.DefaultButton = Button1.UniqueID

This way, you end up with a form that has the focus on the TextBox1 by default and when you press Enter, the form will post back to the server and the code in the event handler for Button1.Click will fire.

Keywords : DefaultButton, DefaultFocus, Master Page, asp.net 2.0

Invalid postback or callback argument.

Sun, 01 Jul 2007 14:44:45 GMT

I'm encountering with this error when i migrate my project (1.1 framework) to 2.0 with master page implementation.

The error is ;
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentException: Invalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.

Resolution : Remove the <form> tag in body element that page is implemented master page. So, master page is also have <form> tag. The two <form> tag makes an error.

Keywords : Postback or callback, form tag, master page

LINQ Installation

Mon, 05 Mar 2007 15:55:21 GMT

The extensibility of the query architecture is used in the LINQ project itself to provide implementations that work over both XML and SQL data. The query operators over XML (XLinq) use an efficient, easy-to-use in-memory XML facility to provide XPath/XQuery functionality in the host programming language. The query operators over relational data (DLinq) build on the integration of SQL-based schema definitions into the CLR type system. This integration provides strong typing over relational data while retaining the expressive power of the relational model and the performance of query evaluation directly in the underlying store.

You can download latest version (May 2006 CTP) of LINQ here

You can open LINQ project after install downloaded files as below:
File - New - Project - LINQ Preview (under Visual C# tab)

Also you can find the technical article about C# 3.0 here and download the word document here.

Keywords : LINQ, XLinq, DLinq, C# 3.0, May 2006 CTP

"Orcas" - March 2007 CTP

Fri, 02 Mar 2007 10:21:40 GMT

Both the new Visual Studio "Orcas" and Enterprise Library 3.0 CTPs are released !

Enterprise Library got some fixes and the new Policy Injection Application Block is now included. Go read the info at Tom Hollander's blog or download it here.

About the new "Orcas" CTP you're best of with a lot of download links at Guy Burstein's blog, or a quick link to the download here.

Improvements for web development in this CTP include:

New ASP.NET WebForms design-surface with advanced XHTML and CSS features
JScript intellisense for ASP.NET AJAX and browser DOM
Multi-targetting for .NET Framework 2.0, 3.0, and 3.5 in websites and web applications
LINQ to SQL designer integration in websites and web applicationsWeb

Keywords : Orcas March CTP, Enterprise Library 3.0 CTP

Abstract Classes versus Interfaces

Wed, 28 Feb 2007 11:59:11 GMT

Unlike interfaces, abstract classes can contain fields that are not static and final, and they can contain implemented methods. Such abstract classes are similar to interfaces, except that they provide a partial implementation, leaving it to subclasses to complete the implementation.

If an abstract class contains only abstract method declarations, it should be declared as an interface instead.

Multiple interfaces can be implemented by classes anywhere in the class hierarchy, whether or not they are related to one another in any way.

Keywords : Abstract classes are similar to interfaces, except that they provide a partial implementation.

Defining an Interface

Wed, 28 Feb 2007 11:53:37 GMT

An interface declaration consists of modifiers, the keyword interface, the interface name, a comma-separated list of parent interfaces (if any), and the interface body. For example:

public interface GroupedInterface extends Interface1,Interface2, Interface3 {
       // constant declarations
       double E = 2.718282; // base of natural logarithms

       // method signatures
       void doSomething (int i, double x);
       int doSomethingElse(String s);
}

The public access specifier indicates that the interface can be used by any class in any package. If you do not specify that the interface is public, your interface will be accessible only to classes defined in the same package as the interface.

An interface can extend other interfaces, just as a class can extend or subclass another class.

However, whereas a class can extend only one other class, an interface can extend any number of interfaces.

The interface declaration includes a comma-separated list of all the interfaces that it extends.

The interface body contains method declarations for all the methods included in the interface. A method declaration within an interface is followed by a semicolon, but no braces, because an interface does not provide implementations for the methods declared within it. All methods declared in an interface are implicitly public, so the public modifier can be omitted.

An interface can contain constant declarations in addition to method declarations. All constant values defined in an interface are implicitly public, static, and final. Once again, these modifiers can be omitted.

Keywords : Interface; can extend other interfaces, does not provide implementations, a class that implements an interface must implement all the methods declared in the interface.

Abstract Methods and Classes

Wed, 28 Feb 2007 11:09:49 GMT

An abstract class is a class that is declared abstract-it may or may not include abstract methods. Abstract classes cannot be instantiated, but they can be subclassed.

An abstract method is a method that is declared without an implementation (without braces, and followed by a semicolon), like this:

abstract void moveTo(double deltaX, double deltaY);

If a class includes abstract methods, the class itself must be declared abstract, as in:

public abstract class GraphicObject {
       // declare fields
       // declare non-abstract methods
       abstract void draw();
    }

When an abstract class is subclassed, the subclass provides implementations for all of the abstract methods in its parent class. However, if it does not, the subclass must also be declared abstract.

Note: All of the methods in an interface are implicitly abstract, so the abstract modifier is not used with interface methods (it could be-it's just not necessary).

Example :

abstract class myBase{
    //A Non abstract method
    int AddTwoNumbers(int Num1, int Num2)
    {
        return Num1 + Num2;
    }

    //An abstract method, to be overridden in derived class
    abstract int MultiplyTwoNumbers(int Num1, int Num2);
}

class myBusiness extends myBase {

    /** Creates a new instance of myBusiness */
    myBusiness() {
    }

    //implementing the abstract method MultiplyTwoNumbers
    int MultiplyTwoNumbers(int Num1, int Num2)
    {
        return Num1 * Num2;
    }
}

public class myStart {

    /** Creates a new instance of myStart */
    public myStart() {
    }

    public static void main (String args[]){
       //You can create an instance of the derived class

       myBusiness calculate = new myBusiness();
       int added = calculate.AddTwoNumbers(10,20);
       int multiplied = calculate.MultiplyTwoNumbers(10,20);
       System.out.println( "Added :" + added + " Multiplied :" + multiplied);
    }
}

Keywords : Abstract class cannot be instantiated. And subclass provides implementations for all of the abstract methods in its parent class.

Web.sitemap file in the root of your web app.

Tue, 27 Feb 2007 11:59:52 GMT

The most common case when the "The file web.sitemap required by XmlSiteMapProvider does not exist" error is received is when a SiteMap control was added to a WebForm.

However you don't have a mandatory Web.sitemap file in the root of your web application.

To fix this error, make sure you have this file in the root directory, and that it is a valid XML file that has the website's sitemap defined. An example Web.sitemap file can be seen below:

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
    <siteMapNode url="Default.aspx" title="Home" description="Home Page">
        <siteMapNode url="Register.aspx" title="Registration" description="Registration" />
        <siteMapNode url="SignIn.aspx" title="Sign-In" description="Sign-in" />
    </siteMapNode>
</siteMap>

Related Terminology : Sitemap, root of your web application.

Could not load file or assembly

Sun, 18 Feb 2007 13:38:32 GMT

I have install asp.net ajax extensions and ajax control toolkit. Web site works on local machine fine but after uploading on server it gives error like this.

Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken = 31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Solution :
Copying the dll files AjaxExtensionsToolbox.dll, System.Web.Extensions.Dll and System.Web.Extensions.Design.dll to the bin folder of your website. You will find the dll files in the folder Program files/Microsoft asp.net/Asp.net 2.0 Ajax extensions/v1.0.61025
Or download it from here

Related Terminology : Asp.net Ajax 1.0, GAC, web server deployment

Element "ScriptManager" is not a known element.

Tue, 13 Feb 2007 11:45:34 GMT

If you moved from Ajax Beta2 to RC1 you might encounter that kind of problem, all other controls are affected as well like Element 'UpdatePanel' is not a known element.
Element "ScriptManager" is not a known element. This can occur if there is a compilation error in the website.

Your form.designer.cs is no longer code generating anything, and you are using a master page - then you can probably fix it by doing the following:

Open your master page in the designer by double clicking it in visual studio.
Open your suspect .aspx file
Right click on the toolbox in visual studio and click 'Reset Toolbox'
Wait for this to complete
Delete the "script manager" or "update panel" that you dropped before (if it exist)
Switch to "Design Mode", and drop a new script manager from the ajax extensions group onto the page.
Check that your designer is now regenerating code.
And build your project

Hope this helps.

Related Terminology : Asp.net Ajax 1.0 RC1 migration

Accessing Superclass Members

Mon, 12 Feb 2007 11:33:48 GMT

If your method overrides one of its superclass's methods, you can invoke the overridden method through the use of the keyword super. You can also use super to refer to a hidden field (although hiding fields is discouraged). Consider this class, Superclass:

public class Superclass {
        public void printMethod() {
            System.out.println("Printed in Superclass.");
        }
}

Here is a subclass, called Subclass, that overrides printMethod():

public class Subclass extends Superclass {

        public void printMethod() { //overrides printMethod
            super.printMethod();
            System.out.println("Printed in Subclass");
        }
        public static void main(String[] args) {
        Subclass s = new Subclass();
        s.printMethod();
        }
   }

Within Subclass, the simple name printMethod() refers to the one declared in Subclass, which overrides the one in Superclass. So, to refer to printMethod() inherited from Superclass, Subclass must use a qualified name, using super as shown. Compiling and executing Subclass prints the following:

Printed in Superclass.
Printed in Subclass

Subclass Constructors
The following example illustrates how to use the super keyword to invoke a superclass's constructor. Here is the MountainBike (subclass) constructor that calls the superclass constructor and then adds initialization code of its own:

public MountainBike(int startHeight, int startCadence, int startSpeed, int startGear) {
super(startCadence, startSpeed, startGear);
seatHeight = startHeight;
}

Invocation of a superclass constructor must be the first line in the subclass constructor.

The syntax for calling a superclass constructor is

super();
--or--
super(parameter list);

With super(), the superclass no-argument constructor is called. With super(parameter list), the superclass constructor with a matching parameter list is called.

Note: If a constructor does not explicitly invoke a superclass constructor, the Java compiler automatically inserts a call to the no-argument constructor of the superclass. If the super class does not have a no-argument constructor, you will get a compile-time error. Object does have such a constructor, so if Object is the only superclass, there is no problem.

If a subclass constructor invokes a constructor of its superclass, either explicitly or implicitly, you might think that there will be a whole chain of constructors called, all the way back to the constructor of Object. In fact, this is the case. It is called constructor chaining, and you need to be aware of it when there is a long line of class descent.

Related Terminology : "Base" keyword in C#

Using MissingSchemaAction.AddWithKey

Thu, 25 Jan 2007 17:28:09 GMT

Adding schema information to a DataSet before filling it with data ensures that primary key constraints are included with the DataTable objects in the DataSet. As a result, when additional calls to fill the DataSet are made, the primary key column information is used to match new rows from the data source with current rows in each DataTable, and current data in the tables is overwritten with data from the data source.

Without the schema information, the new rows from the data source are appended to the DataSet, resulting in duplicate rows.

Example :
DataSet custDataSet = new DataSet();
custAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
custAdapter.Fill(custDataSet, "Customers");

Using FillSchema or setting the MissingSchemaAction to AddWithKey requires extra processing at the data source to determine primary key column information. This additional processing can hinder performance. If you know the primary key information at design time, we recommend that you explicitly specify the primary key column or columns in order to achieve optimal performance.

PS : You should use AddWithKey option if you want to handle "Constraint Exception". I use it in my little replication engine program like this ;

using (OracleCommand command = new OracleCommand())
{
    command.CommandText = "SELECT * FROM " + tableName + " WHERE " + primaryKeyField + "=" + drow[primaryKeyField];
    command.Connection = connection;

    adapter.SelectCommand = command;
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    DataTable dt = new DataTable();
    adapter.Fill(dt);

    // Commandbuilder
    using (OracleCommandBuilder builder = new OracleCommandBuilder())
    {
        builder.DataAdapter = adapter;

        // INSERT
        DataRow dr = dt.NewRow();
        foreach (DataColumn dc in dt.Columns)
        {
            dr[dc.ColumnName] = drow[dc.ColumnName];
        }

        try
        {
            dt.Rows.Add(dr);
        }

        catch (ConstraintException)
        {
            // UPDATE
            DataRow row = dt.Rows[0];
            foreach (DataColumn dc in dt.Columns)
            {
                row[dc.ColumnName] = drow[dc.ColumnName];
            }
        }
        adapter.Update(dt);
    }
}

Related Terminology : MissingSchemaAction.AddWithKey, Primary Key, Constraint Exception

Server Application Unavailable

Wed, 24 Jan 2007 21:34:35 GMT

The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

The application log (Start | Control Panel | Administrative Tools | Event Viewer) also shows two errors.

Event ID 1000: aspnet_wp.exe (PID: 2564) stopped unexpectedly.
Event ID 1089: Failed to execute the request because the ASP.NET process identity does not have read permissions to the global assembly cache. Error: 0x80131902

There are several possible causes for this error message. Here are a few ways to fix the problem. You may even want to try multiple ways.

By default, IIS uses the ASPNET user account to run applications. Sometimes, this still needs some further configuration.
Locate the machine.config file from the configuration folder of the intended .Net Framework (e.g., C:\WINNT\Microsoft.NET\Framework\v2.0.50727\CONFIG). Make a backup of this file. Open the original in a text editor. Search for the following line:
<processModel autoConfig="true"/> Change it to the following:
<processModel userName="system" password="AutoGenerate" />
Restart IIS.

a. Start | Control Panel | Administrative Tools | Internet Services Manager
b. Right-click on the machine name and select Restart IIS

Click here to read more detail

Related Terminology : Asp.net 2.0 installation and troubleshooting

ASP.NET AJAX 1.0 Released !

Wed, 24 Jan 2007 11:09:40 GMT

ASP.NET AJAX 1.0 delivers a rich client-side AJAX library that provides cross platform, cross browser support for a core JavaScript type-system, JSON-based network serialization stack, JavaScript component/control model, as well as common client JavaScript helper classes. ASP.NET AJAX also delivers a rich server-side library that integrates AJAX functionality within ASP.NET, and enables developers to easily AJAX-enable existing ASP.NET 2.0 sites with minimal effort.

ASP.NET AJAX is a free framework for quickly creating a new generation of more efficient, more interactive and highly-personalized Web experiences that work across all the most popular browsers.

ASP.NET AJAX is available for free, and can be used with ASP.NET 2.0 and VS 2005. It is a fully supported Microsoft product, and is backed by a standard 10 year Microsoft support license (with Microsoft Product Support available via phone 24 hours a day x 7 days a week).

ASP.NET AJAX Control Toolkit

In addition to the fully-supported ASP.NET AJAX 1.0 release, you can use the more than 30 free ASP.NET AJAX enabled controls available within the ASP.NET AJAX Control Toolkit. The control toolkit is a shared-source collaborative project built together by a team containing both Microsoft and non-Microsoft developers (visit the CodePlex Project to learn more, or volunteer to contribute). All source for the controls is provided completely for free (with full re-use and modification rights).

The majority of controls within the ASP.NET AJAX Control Toolkit leverage the "Control Extender" pattern that the core ASP.NET AJAX library introduces, and which delivers a super powerful way to easily enable specific AJAX scenarios on a site with minimal effort.

http://ajax.asp.net/

Related Terminology : Ajax, JSON-based network serialization stack, core JavaScript type-system

Design Debt

Tue, 23 Jan 2007 16:50:21 GMT

Software development is a big investment, requiring a minimum of six figures and often far more. So why do so many companies throw away their investment? Why do they trash existing software and rewrite it from scratch? Why do they retire useful products?

Companies often make these painful decisions because their software has become too expensive to maintain. Over time, changes become more costly. Eventually, the cost is too high: the company has to retire the product or rewrite it.

Most teams don't think in terms of design debt and don't even try to pay back principle. If you have a project with an aggressive deadline, your team has almost certainly taken on design debt. It's already slowing them down, and in order to avoid missing deadlines, they'll take on more debt. The compound interest will eventually kill your investment.

Avoid the temptation to stop work and refactor for several weeks. Even the most disciplined team inadvertently takes on design debt, so eliminating debt needs to be an ongoing activity. Have your team get used to refactoring as part of their daily work.

Design debt is like credit card debt: it's easy, tempting, and leads to ruin if not paid off. Nearly every team can go faster by reducing design debt. Demand continuous design improvement from your teams. Support it by reducing schedule pressure and training your teams in advanced code-quality practices. The extra effort now will safeguard your investment for the future

http://www.jamesshore.com/Articles/Business/
Software%20Profitability%20Newsletter/Design%20Debt.html

Related Terminology : Design debt, successful sofware

Add your own (custom) prerequisite to "ClickOnce"

Fri, 29 Dec 2006 14:48:41 GMT

Remember we can only add those prerequisite through "ClickOnce" which are by default in prerequisite list while publishing.

To add our own prerequisite you need to have boot strapper package. Once created boot strapper package then it will automatically included into prerequisite list.

To generate boot strapper can use "Bootstrapper Manifest Generator" tool. Follow the steps given below to add own boot strapper using "Bootstrapper Manifest Generator" tool.

Download "Bootstrapper Manifest Generator" (http://www.davidguyer.us/bmg/publish.htm)
Install "Bootstrapper Manifest Generator".
Open BMG (Bootstrapper Manifest Generator).
Select File-New will see following screen.
Select "Package Manifest" and click on OK.
Type project name and click on "Add Installer File" icon at top left .
Browse for file, you wish to add into prerequisite, as I added exe as prerequisite you can choose as per your requirement. Set display name as "Test".
Click on Ok you will see following screen.
Type display name and click on "Build" icon top left.
Your prerequisite is been created, can see in prerequisite list.
All set select "Test" as prerequisite from above list and publish application.

http://www.codeproject.com/useritems/Add_Custom_Prerequisite.asp

Related Terminology : Click Once, Bootstrapper, Custom Prerequisite

How to auto Update&Restart ClickOnce Application

Thu, 28 Dec 2006 17:38:19 GMT

In Solution Explorer, right click project - properties - publish - updates
Check "The application should check for updates"
Select "Before the application starts"

PS : If you don't use "The application should check for updates" then "UpdateCompleted" event doesnt works properly.

public partial class Form1 : Form
{
        System.Timers.Timer tmr = new System.Timers.Timer();

        public Form1()
        {
            InitializeComponent();

            tmr.Elapsed += new System.Timers.ElapsedEventHandler(tmr_Elapsed);
            tmr.Interval = 15000; // 15 sec.
            tmr.Start();

            if (ApplicationDeployment.IsNetworkDeployed)
            {
                ApplicationDeployment.CurrentDeployment.UpdateCompleted += new AsyncCompletedEventHandler(CurrentDeployment_UpdateCompleted);
            }
        }

        void CurrentDeployment_UpdateCompleted(object sender, AsyncCompletedEventArgs e)
        {
            Application.Restart();
        }

        void tmr_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
        {
            if (ApplicationDeployment.IsNetworkDeployed)
            {
                if (ApplicationDeployment.CurrentDeployment.CheckForUpdate())
                {
                    tmr.Stop();
                    ApplicationDeployment.CurrentDeployment.UpdateAsync();

                    StartOperation();
                }
            }
        }

        void StartOperation()
        {
           // operations that you want
        }
}

Related Terminology : Click Once, ApplicationDeployment class

System.Security.Permission.FileIOPermission

Wed, 27 Dec 2006 11:34:51 GMT

The error is :
"Request for permission of type
"'System.Security.Permission.FileIOPermission. mscorlib.
"Version = 2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'"

When you run in from the network, from a command line or explorer shell, the .NET Frameworks runtime is applying the Code Acess Security (CAS) policy based on it's location, i.e. it get's Intranet permissions.

Copying the exe to your local drive, ClickOnce publishing and then installing the application.

Related Terminology : Click once deployment, Code Access Security

Web Services - HTTP GET and HTTP POST Are Disabled

Wed, 27 Dec 2006 08:53:06 GMT

The .NET-connected Web services support HTTP GET, HTTP POST and SOAP protocols. By default, in .NET Framework 1.0, all three protocols are enabled. By default, in .NET Framework 1.1, HTTP GET and HTTP POST are both disabled. This is for security reasons.

The .NET Framework 1.1 defines a new protocol that is named HttpPostLocalhost. By default, this new protocol is enabled. This protocol permits invoking Web services that use HTTP POST requests from applications on the same computer. This is true provided the POST URL uses http://localhost, not http://hostname. This permits Web service developers to use the HTML-based test form to invoke the Web service from the same computer where the Web service resides.

When you try to access the Web service from a remote computer you do not see the Invoke button. And, you receive the following error message:

The test form is only available for requests from the local machine

HTTP GET and HTTP POST may be enabled by editing the Web.config file for the vroot where the Web service resides. The following configuration enables both HTTP GET and HTTP POST:

<configuration>
    <system.web>
    <webServices>
        <protocols>
            <add name="HttpGet"/>
            <add name="HttpPost"/>
        </protocols>
    </webServices>
    </system.web>
</configuration>

http://support.microsoft.com/kb/819267

Related Terminology : Web Service, HTTP GET, HTTP POST, Invoke

E-Mail Delivery in Reporting Services

Sat, 28 Oct 2006 09:18:35 GMT

To distribute or receive a report by e-mail, you define either a standard subscription or a data-driven subscription. You can subscribe to or distribute only one report at a time. You cannot create a subscription that delivers multiple reports in a single e-mail message.

Reporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups. The e-mail delivery extension is configured through the Reporting Services Configuration tool and by editing the Reporting Services configuration files.

E-Mail Delivery Options
Report server e-mail delivery can deliver reports in the following ways:

Send a notification and a hyperlink to the generated report.
Send a notification in the Subject: line of an e-mail message. By default, the Subject: line in the subscription definition includes the following variables that are replaced by report-specific information when the subscription is processed:
@ReportName specifies the name of the report.
@ExecutionTime specifies when the report was executed.
You can combine these variables with static text or modify the text in the Subject: line for each subscription.
Send an embedded or attached report. The rendering format and browser determine whether the report is embedded or attached.
If your browser supports HTML 4.0 and MHTML, and you choose the Web archive rendering format, the report is embedded as part of the message. All other rendering formats (CSV, PDF, and so on) deliver reports as attachments. You can disable this functionality in the RSReportServer configuration file.
Reporting Services does not check the size of the attachment or message before sending the report. If the attachment or message exceeds the maximum limit allowed by your mail server, the report will not be delivered. Choose one of the other delivery options (such as URL or notification) if for large reports.

To create an e-mail subscription

In Report Manager, on the Contents page, navigate to the report you want to subscribe to. Click the report to open it.
Click the Subscriptions tab, and then click New Subscription.
For the method of delivery, select Report Server E-Mail from the Delivered by list box.
In the To text box, type the e-mail address you want the report delivered to. To specify multiple e-mail addresses, separate them with a semicolon (;). You can also type additional e-mail addresses in the Cc, Bcc, and Reply-To text boxes.
Select the delivery options as follows:
- To embed or attach a copy of the report, select Include Report. The format of the report is determined by the rendering format you select below. Do not choose this option if you think the report size will exceed the limit defined for your e-mail system.
- To include a URL link to the report in the body of the e-mail message, select Include Link.
Choose a rendering format from the Render Format list box. This option is available if you select Include Report to embed or attach a copy of the report.
- To embed the report in the body of the e-mail message, select Web archive.
- To send the report as an attachment, choose any of the other rendering formats.
Select a priority from the Priority list box. In Microsoft Exchange, this setting sets a flag for the importance level of the e-mail message.
Specify when you want the report delivered:
- To specify a delivery schedule, click When the scheduled report run is complete and click Select Schedule. A schedule page opens for you.
- To deliver the report when a report snapshot is updated with a newer version, click When the report content is refreshed. The schedule used to update a report snapshot determines when your subscription is processed.
For parameterized reports, specify parameters to use for the report for this subscription. The parameters that you specify can be different from those used to run the report on demand or in other scheduled operations.

http://msdn2.microsoft.com/en-us/library/ms160334.aspx
http://msdn2.microsoft.com/en-us/library/ms157386.aspx

Related Terminology : Reporting services, e-mail delivery options

Windows Installer service could not be accessed

Wed, 18 Oct 2006 17:40:34 GMT

"Error 1719: The Windows Installer service could not be accessed" error message when you try to add or remove a program

When I try to install .NET Framework 2.0 to Win2000 operation system the error is occured. So, as you know 98 or Win2000 operating system requires Windows Installer 3.0 before attempting to install .NET Framework 2.0.

Cause : The Windows Installer files that are on your hard disk are damaged or are missing.

Resolution : Reinstall the windows installer
To reinstall the Windows Installer, rename the damaged Windows Installer files, and then reinstall the Windows Installer. To do so:
1. Click Start, and then click Run.
2. In the Open box, type cmd, and then click OK.
3. At the command prompt, type the following line, and then press ENTER, where Drive is the drive where Windows is installed and where %Windir% is the folder where Windows is installed:
attrib -r -s -h drive:\%Windir%\system32\dllcache
For example, type
attrib -r -s -h c:\windows\system32\dllcache
Note If you are using Windows 98, type system instead of system32.
4. At the command prompt, type the following lines, pressing ENTER after each line:
ren msi.dll msi.old
ren msiexec.exe msiexec.old
ren msihnd.dll msihnd.old
5. At the command prompt, type exit, and then press ENTER.
6. Restart your computer.

and re-try to install .NET Framework

http://support.microsoft.com/?scid=kb%3Ben-us%3B315346&x=11&y=5

Related Terminology : Installing .NET Framework 2.0, Windows Installer 3.0

ORA-01843: not a valid month

Fri, 06 Oct 2006 15:35:50 GMT

"ORA-01843: not a valid month" or
"ORA-01830: date format picture ends before converting entire input string"

This error means that a date was used in the SQL but that Oracle did not consider the month to be a valid month.

False ;
AUDIT_MODIFY_DATE >= to_date('9/19/2006 3:13:10 PM','DD/MM/YYYY HH24:MI:SS')

True ;
AUDIT_MODIFY_DATE >= to_date('19/9/2006 3:13:10 PM','DD/MM/YYYY HH24:MI:SS')

when you use casting operation at datetime data like this:

DateTime lastActionDate = DateTime.Now;
lastActionDate = (DateTime)ds.Tables[0].Rows[0]["CREATEDATE"];

you may set your regional settings for datetime pattern at codebehind.

DateTimeFormatInfo.ShortDatePattern Property gets or sets the format pattern for a short date value.

At this time you can use below statements at top of your method :

CultureInfo c = new CultureInfo("tr-TR") ;
System.Threading.Thread.CurrentThread.CurrentCulture = c;
System.Threading.Thread.CurrentThread.CurrentUICulture = c;
System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat.
ShortDatePattern = "dd/MM/yyyy";

Related Terminology : Oracle datetime problem, CurrentCulture, CurrentUICulture

To start Extreme Programming (XP)

Wed, 04 Oct 2006 10:05:13 GMT

The most obvious way to start extreme programming (XP) is with a new project. Start out collecting user stories and conducting spike solutions for things that seem risky. Spend only a few weeks doing this. Then schedule a release planning meeting. Invite customers, developers, and managers to create a schedule that everyone agrees on. Begin your iterative development with an iteration planning meeting. Now you're started.

Usually projects come looking for a new methodology like XP only after the project is in trouble. In this case the best way to start XP is to take a good long look at your current software methodology and figure out what is slowing you down. Add XP to this problem first.

For example, if you find that 25% of the way through your development process your requirements specification becomes completely useless, then get together with your customers and write user stories instead.

If you are having a chronic problem with changing requirements causing you to frequently recreate your schedule, then try a simpler and easier release planning meeting every few iterations. (You will need user stories first though.) Try an iterative style of development and the just in time style of planning of programming tasks.

If your biggest problem is the number of bugs in production, then try automated acceptance tests. Use this test suite for regression and validation testing.

If your biggest problem is integration bugs then try automated unit tests. Require all unit tests to pass (100%) before any new code is released into the code repository.

Related Terminology : Agile methodologies, XP

SQL SELECT TOP N equivalent in ORACLE

Mon, 04 Sep 2006 01:38:58 GMT

SQL Server:
SELECT TOP 10 product, descr, email FROM products

Oracle:

SELECT product, descr, email FROM products WHERE ROWNUM <= 10

Actually the code for Oracle only works if you do not ORDER BY. Let's say you have lots of records and you want to sort them by "product" and getting just the top 10 records. You can't do it by just:
"SELECT product, descr, email FROM products WHERE ROWNUM <= 10 ORDER BY product" The result is not what you wanted.

What "ROWNUM <= 10" does is simply return you top 10 record in the table.. if you try the ORDER BY code, it will simply extract the top 10 records in the table then ORDER it instead of ORDERING them then select the top 10.

Doesnt work :
SELECT product, descr, email FROM products WHERE ROWNUM <= 10 ORDER BY product

It works :

SELECT product, descr, email FROM (select product, descr, email from products order by product )
WHERE ROWNUM <= 10

Related Terminology : Select TOP and Order By statement in Oracle

Batch Updates in ADO.NET 2.0

Wed, 30 Aug 2006 01:11:49 GMT

ADO.NET 2.0 has introduced the concept of Batch Updates, which allows you to designate the number of commands sent to the database at a given time. If used correctly, this can increase the performance of your data access layer by reducing the number of roundtrips to the database.

When you updated a database using the DataAdapter in .NET 1.1 each command was sent to the database one at a time. This caused a lot of roundtrips to the database.

The DataAdapter has an UpdateBatchSize Property that allows you to set the number of commands that will be sent to the database with each request.

UpdateBatchSize = 1, disables batch updates
UpdateBatchSize = X where X > 1, sends x statements to the database at a time
UpdateBatchSize = 0, sends the maximum number of statements at a time allowed by the server

...
using (OracleCommandBuilder cm = new OracleCommandBuilder(da))
{
da.UpdateBatchSize = 0;
da.Update(dt);
}

PS. Oracle supports this features in Oracle Data Provider for .NET 10.2.0.2.20 Production

Related Terminology : Batch Update, ADO.NET 2.0, ODP.NET Release

ORA-01000: maximum open cursors exceeded

Mon, 28 Aug 2006 09:37:21 GMT

ExecuteNonQuery does not return any row, but it can open a cursor for an output parameter of a stored procedure if the output parameter is defined as a ref cursor. In this case, you should cast the OracleParameter into an OracleDataReader and call Close on the OracleDataReader when you're done with the cursor.The following bits of SQL should help you track down which cursors are causing the problem :

select user_name, status, osuser, machine, a.sql_text from v$session b, v$open_cursor a where a.sid = b.sid

So, this error means that somewhere cursors aren't being closed when opened. They will stay open until the database user is disconnected, which is probably why you're being forced to close the objects (reader).

Related Terminology : ExecuteNonQuery, ExecuteScalar, Open Cursors in Oracle

Using LiteralControl Class

Thu, 24 Aug 2006 17:24:53 GMT

Represents HTML elements, text, and any other strings in an ASP.NET page that do not require processing on the server

...
HyperLink hyp = new HyperLink();
foreach (DataSetNews.tbl_NewsRow drow in dtable)
{
hyp = new HyperLink();
hyp.Text = drow.newsTR;
hyp.NavigateUrl = "javascript:openwin(" + drow.newsTRID + ")";
Panel1.Controls.Add(new LiteralControl("<img src='arrow.gif'>"));
Panel1.Controls.Add(hyp);
Panel1.Controls.Add(new LiteralControl("<br>"));
}

Related Terminology : Asp.net, Panel, Literal Control

View Oracle GUID in .NET

Wed, 23 Aug 2006 10:08:14 GMT

Oracle GUID appearance is different in .NET. But in action this conversation implemented automatically. If you want to see oracle GUID (as you can see in oracle) regularly you should use a function like this.

public string ByteToRawString (byte [] byteArray)
        {
            string str="" ;
            for (int i = 0; i < byteArray.Length   ; i++)
            {
                str+=String.Format("{0:x2}", byteArray[i]);
            }
            return str.ToUpper();
        }

Related Terminology : GUID, Byte Array, Oracle, .NET

Name is already used by an existing object

Wed, 23 Aug 2006 09:57:09 GMT

You tried to create a table, view, index, synonym or other object with a name that is already in use. For a listing of objects with a particular name, you can run the following query:

SELECT * FROM all_objects WHERE object_name = 'NAME';

Action: The options to resolve this Oracle error are:

1. Rename your object that you are trying to create so that it is unique.
2. Drop the existing object and create the new object.

Related Terminology : ORA-00955

Requested Registry Access Is Not Allowed

Wed, 23 Aug 2006 09:20:17 GMT

"Requested Registry Access Is Not Allowed" Error Message When ASP.NET Application Tries to Write New EventSource in the EventLog.

This problem occurs because the user account that you used to log on does not have sufficient permissions.

If you log on to a computer as a regular user, and if you try to use Microsoft Visual Studio .NET to create a custom event log to register events, you may receive the following error message:
An unhandled exception of type 'System.Security.SecurityException' occurred in mscorlib.dll
Additional information: Requested registry access is not allowed.

Grant permission to create a custom event log
1. Log on to the computer as an administrator.
2. Click Start, click Run, type regedit in the Open box, and then click OK. The Registry Editor window appears.
3. Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog
4. Right-click Eventlog, and then click Permissions. The Permissions for Eventlog dialog box appears.
5. Click Advanced. The Advanced Security Settings for Eventlog dialog box appears.
6. In the Name column, double-click the Users group. The Permission Entry for Eventlog dialog box appears.
7. Select the Set Value check box, select the Create Subkey check box, and then click OK.
8. Quit Registry Editor, and then log off from the administrator account.
9. Log on to the computer as a regular user.
10. Try to create a custom event log by using Visual Studio .NET, and then try to write to this event log by using an application that is built on Visual Studio .NET.

http://support.microsoft.com/?id=842795

Related Terminology : Event Logging, Asp.net, Web Service

Memo field truncated

Wed, 23 Aug 2006 06:38:41 GMT

In any Memo field that contains more than 1024 characters is truncated to 1024 characters when you insert some text to MS Access via web user interface.

Please check your dataset desinger file (ie. DatasetProducts.Designer.cs)

this._adapter.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Content", System.Data.OleDb.OleDbType.WChar, 1024,
System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)),
"Content", System.Data.DataRowVersion.Current, false, null));

and replace 1024 to what you want (ie. 536870910)

Related Terminology : MS Access, TableAdapters, Insert Command, Update Command

System.ArgumentException

Wed, 23 Aug 2006 05:38:58 GMT

System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values.

This exception occurs if your lookup query does not return all the values that are used in the master-table. Some developers suggest that you enable referential integrity (ie, add a relation) in the database betweeen the lookup table and the master table; but this shouldnt prevent this scenario.

When I set "createConstraints" parameter to "false" then the error is disappeared.

ds.Relations.Add("myrelation", ds.Tables[0].Columns["ArticleID"], ds.Tables[1].Columns["ArticleID"],false);

Because, the exception is not related to Access. Remember the DataSet is disconnected and is independent from Access. This error can occur when a parent-child relationship is created and then children are loaded into the DataSet without the parent existing (whether or not the parent exists in the database is irrelevant - it has to exist in the DataSet as well because the DataSet is disconnected from the database)

Related Terminology : MS Access, Repeater, Dataset Relation