Cannot add duplicate collection entry of type 'add' with unique key attribute 'name' set to 'RewriteModule' - HTTP Error 500.19 - Internal Server Err

When I uploaded the site to the server, I got an HTTP Error 500.19 - Internal Server Error which says "Cannot add duplicate collection entry of type 'add' with unique key attribute 'name' set to 'RewriteModule'". Error was in the following line in web.config

I got the solution to change the application config file from the following link:
http://support.microsoft.com/kb/942055

But, hosting providers won't allow that on server.

I added the following under  where the RewriteModule is added

Also, there were some virtual directory issues. Hosting provider
changed that. Now it is working.

Read More

Issue when using AsyncFileUpload control

I tried to use AsyncFileUpload control in a page. The AsyncFileUpload control was placed inside the first view of a multiview control. The page required a querystring parameter, and if the parameter is not present, the second view of the multiviewcontrol will be shown. This check is made on the Page Load event. This causes issue on the fileupload process. It was giving error, since on the postback, it gets another view. So, I did like this.

on the event "OnClientUploadStarted", I gave a value to a hidden element, and on page load, a checking is made, to see, if the value is given for the hidden element. If the value is given, the view1 itself will be shown without checking the availability of querystring parameter.

Don't know if that is the correct method. Anyhow, it worked.

Read More

Germans also are gone :-(

My two favorite teams are out from WorldCup 2010, Germany and Argentina. :-( Spain really deserve that victory over Germany.

I know, it is bit late. But, I just came to a contribution from Microsoft for World Cup. So, I thought, I should share with you.

Track world cup scores with excel.

Read More

Generate sql script with data from database

How can we copy data as well the structure and schema as sql query? We need database publishing wizard for that.

Download the database publishing wizard.
It will be installed at following location : C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\

run the exe and you can get the sql file with all the data, schema and structure of the database you select.

Read More

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same

When this error comes, put enableViewStateMac="false" in the tag either in the web.config or in the page where you get this error.

Read More

System.Net.Mail.SmtpFailedRecipientException: Mailbox unavailable. The server response was: 5.7.1 Unable to relay

I have got this issue many times, when I try to send email using smtp. There can be several causes for this. You have to allow relay for mail to be sent to outside servers like gmail.com. For sending mail within your server you don't have to do this. You can find some helps from the following links:
Help1
Help2
Help3

The code I have used is given below:

using System.Net.Mail;


SmtpClient smtpClient = new SmtpClient();
MailMessage message = new MailMessage();
smtpClient.Port = 25;
smtpClient.Host = "smtp.domain.com";
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new System.Net.NetworkCredential("webmail username", "webmail password");
message.From = new MailAddress("webmail username");
message.To.Add("test@gmail.com");
string emailBody = "Hi,

Welcome

";
message.Body = emailBody;
message.Subject = "testing";
message.IsBodyHtml = true;
smtpClient.Send(message);

But, after making the changes on the server, as specified on the above links, I was still getting the same error. Then I added the following line in between the above code.
smtpClient.DeliveryMethod = SmtpDeliveryMethod.PickupDirectoryFromIis;

Then the error was gone.

Read More

Login failed for user ‘IIS APPPOOL\DefaultAppPool’

I got this issue in my system using Windows 7 Ultimate when trying to run a site which is configured to run in IIS. You can get the solution for this from the following link

Read More

Read More

Grouping Gridview

Some times we want to group gridview. ZNet is a good control for this use.
ZNet
We can use this for grouping and also for the comparison.

Read More

specifying ValidationGroup in Page_ClientValidate function

Hi,

We know that, Page_ClientValidate function tests if all controls meet asp.net validation criteria. This function is provided by asp.net. But, if we use more than, one validation group in the page, we may have to specify the validation group, we want to validate. For that, give like given below:
Page_ClientValidate('ValGroupName')

Then, it will validate only for that validation group

Read More

The Controls collection cannot be modified because the control contains code blocks

This is a common error. It occurs when we use <%= %> tag inside the head tag with runat="server" given. You can get rid of the error by removing the runat="server" from the head tag. But, sometimes, we want to keep that. We can use <%# %> instead of <%= %>. But, then, the value may not get bound and we may not get the value of the expression. So, when we use <%# %>, we have to add Page.Header.DataBind(); in the Page Load event.
More Info

Read More

To access control of a User Control from an aspx page

Whenever you want to access the controls of an usercontrol, create public properties for those controls in your usercontrols and you could easily access them in your .aspx page.

Here it goes how...
UserControl.

1 public partial class WebUserControl : System.Web.UI.UserControl
2 {
3 public string TextBoxValue {
4 get { return TextBox1.Text; }
5 set { TextBox1.Text = value; }
6 }
7 protected void Page_Load(object sender, EventArgs e) {
8
9 }
10 }

In your .aspx page you can access it either html or code
<%@ Register TagPrefix="DS" TagName="TB" Src="~/WebUserControl.ascx" %>




or

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
myTB1.TextBoxValue = "Sample Text";
}
}

Read More

DateTime.ToString formats

From the following link, you can see all types of formats we can get using DateTime.ToString() method.
More Info

Read More

Converting DateTime to ShortDate in SQL

When you need to get datetime field value in short date, use the following:

To get today's date in YYYYMMDD format:
SELECT CONVERT(CHAR(8), GETDATE(), 112)

To get today's date in mm/dd/yyyy:
CONVERT(VARCHAR(10), GETDATE(), 101)

Helpful Link

Read More

Showing JavaScript confirmation after Client Validation

Some time we use javascript to display alert or confirmation box on button click. But, if we are using ajax validation on that page, that will work only after post back if we click ok on the confirmation box. So, to display the confirmation box, only if the page is valid, Check this link

Read More

Finding the Public Key Token of dll

You have to add assembly to web.config like the following

How to get the public token of a dll to add it to web.config?
Learn More

Read More

Calling method of a usercontrol from another usercontrol

I need to call the method in a usercontrol from another usercontrol. Both controls are placed in same page.
If it is a web application, both controls will be in same namespace. So, we can get their names in the codebehind.

for eg.
if control1 is to be found from control2.
both control1 and control2 are in folder controls. webapplication name is test. So the namespace would be test.control2. Since, both these controls are under the same namespace, we can find the control2 in control1 and vice versa directly.
control2 2 = control1.FindControl("control21") as control2;

But, if this is a website, no namespace. So, we have to add a reference.
Add reference in control1 to find control2.
<%@ Reference Control="~/controls/control2" %>
then, in codebehind,
ASP.controls_control2 2 = this.FindControl("control21") as ASP.controls_control2;

Read More

Finding Controls

Check the name of the control in the rendered html. For eg.
I need to find gridview "grdwSelectedCandidates" in usercontrol "SelectedCandidates.ascx" which is inside the ajax tabpanel inside ajax tabcontainer.
I need to find this from another control which is placed in another tabpanel in the same container.
The rendered name is "ctl00_ContentPlaceHolder1_TabContainer1_TabPanel6_SelectedCandidates1_grdwSelectedCandidates"
So, I have to first find content place holder, then, tabcontainer, then, tabpanel, then, control and then gridview.

Read More

For using excel file as database

For reading Excel files and getting the data
string FilePath = Server.MapPath("exmaple.xls");

DataSet myDataset = new DataSet();
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + @";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable DTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
//here the code will read sheet from spreadsheet with any name --generic
OleDbDataAdapter myData = new OleDbDataAdapter
(@"SELECT * FROM [" +
DTable.Rows[0]["TABLE_NAME"].ToString() + "]", conn);
//
myData.Fill(myDataset);

Read More

Firebug Extensions

Firebug is the most usefult addon tool for web development. It can help us to find the issues in css, ajax requests etc and many features. There are some other addons which can help to improve the utility of firebug.
Learn More

Read More

6-Hour Work At Home Video Certification Course

This Video Course Teaches How To Work From Home With Fortune 500 Companies. Great help for those like me who want to earn by working from home.
Learn More

Read More

Read More

Ajax and UpdatePanel performance improvement

Most of the newbie programmers like me are ajaxifying a site by putting updatepanels all over the site. Now, I came to know that, putting updatepanel will not help you to improve your site's speed. We are using it, since it is very easy. You can understand why ajax updatenpanels should be avoided from the following link

Why UpdatePanel Dangerous



If you still want to use updatepanel, check the following link to speed up the updatepanel performance.

Speeding up UpdatePanel



Also, you can use a dll, scriptreferenceprofiler, to find the ajax scripts used in a page and combine them, so that, only that script requests will be used in that specific page, which reduces the loading time. You can understand how to use it from the following msdn video.

Script Combining

You can download ScriptReferenceProfile from the following url
Download

Use them as follows

Add reference to the dll.
<%@ Register Assembly="ScriptReferenceProfiler" Namespace="ScriptReferenceProfiler" TagPrefix="cc1" %>

Read More

Top Money giving Paid To Click site

Its an off topic. I just came to know about this site. They are giving the maximum for click. 50 cents for just clicking banners and 1 USD for reading their emails. Also, referral bonus is there.

payingptr.com

Read More

Know the control which caused the postback

I got this from some site. It can be used to know the control which caused the postback.

 public static Control GetPostBackControl(Page thePage)
    {
        Control myControl = null;
        string ctrlName = thePage.Request.Params.Get("__EVENTTARGET");
        if (((ctrlName != null) & (ctrlName != string.Empty)))
        {
            myControl = thePage.FindControl(ctrlName);
        }
        else
        {
            foreach (string Item in thePage.Request.Form)
            {
                Control c = thePage.FindControl(Item);
                if (((c) is System.Web.UI.WebControls.Button))
                {
                    myControl = c;
                }
            }

        }
        return myControl;
    }

Read More

Limit in Argument size for functions

I was trying to insert data to a sql table from code behind.  But, when I tried to see the values using break point, I was not able to see the values. The following link shows the cause and reason.
Help Link

Read More

How to Register User Controls and Custom Controls in Web.config

If we register controls in the web.config, we don't have to register the control on each page. This is useful, if we have to use the same control on several pages.

Help Link

Read More

Display updateprogress in the clicked position

On the following example, progress bar(UpdateProgress1) is displayed on the position of the button which got clicked


function pageLoad()

     {     

           var manager = Sys.WebForms.PageRequestManager.getInstance();
   
          
       manager.add_beginRequest(OnBeginRequest);
   
    }

    function OnBeginRequest(sender, args)
    {
 
          var postBackElement = args.get_postBackElement();
          var position = $("#"+postBackElement.id).offset();
         
         
          $("#<%=UpdateProgress1.ClientID%>").css({'position' : 'absolute', 'z-index' : '1002', 'overflow' : 'auto','top' : position.top,'left' : position.left}).fadeIn(100);

}

Read More

JQuery default functions

Following is the jquery default function that is run. we can use this to get the ajaxrequests
function pageLoad() {
            if (!Sys.WebForms.PageRequestManager.getInstance().get_isInAsyncPostBack()) {
                Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(AjaxBegin);      
                Sys.WebForms.PageRequestManager.getInstance().add_endRequest(AjaxEnd);      

            }
        }

Read More

Use ScriptManager.RegisterStartupScript, when using ajax updatepanel to add javascript from codebehind.
for eg. just showing a message box, on of a button in updatepanel
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "scriptname", "var position=$('#" + Btn.ClientID + "').offset();$('#').html('Button clicked').css(position).fadeIn(2000).fadeOut(2000);", true);

can get position using position method of jquery

Read More

First Post

My First Post. Hope this blog will help me and others too.

I am going to post all the new things I am learning everyday regarding programming. Hope it helps somebody.

Read More