Wednesday 30 November 2011

how to find the employee list who has more than one year experiance in c#


       DateTime dtnow = DateTime.Now;
        int day = dtnow.Day;
        int month = dtnow.Month-1 ;
        int year = dtnow.Year - 1;
     
        DateTime dtc = new DateTime(year,month,day);

        DataTable dt = clsCourse.getCourse("select * from emp where djoin<='"+dtc+"'");

database table:
create table emp
(
   empName varchar(100),
   djoin datetime
)

Tuesday 29 November 2011

add rotator example to display rotating image

add rotator:
aspx code
 <asp:UpdatePanel ID="up1" runat="server">
        <Triggers>
            <asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" />
        </Triggers>
        <ContentTemplate>
            <asp:AdRotator
            id="AdRotator1"
            AdvertisementFile="~/admin/XMLFile.xml"
            KeywordFilter="small"
            Runat="server" />
        </ContentTemplate>
    </asp:UpdatePanel>



xml insert code:

 public void xmlinsert()
    {
        XmlDataDocument xmldoc = new XmlDataDocument();
        xmldoc.Load(MapPath("~/admin/XMLFile.xml"));
        XmlElement parentelement = xmldoc.CreateElement("Ad");
        XmlElement imurl = xmldoc.CreateElement("ImageUrl");
        imurl.InnerText = "~/images" + "/" + FileUpload1.FileName;
        parentelement.AppendChild(imurl);
        XmlElement width = xmldoc.CreateElement("Width");
        width.InnerText = "206";
        parentelement.AppendChild(width);
        XmlElement height = xmldoc.CreateElement("Height");
        height.InnerText = "200";
        parentelement.AppendChild(height);


        XmlElement navigate = xmldoc.CreateElement("NavigateUrl");
        navigate.InnerText = "http://labtestdiagnosis.com/index.aspx";
        parentelement.AppendChild(navigate);

        XmlElement imression = xmldoc.CreateElement("Impressions");
        imression.InnerText = "40";
        parentelement.AppendChild(imression);
        XmlElement keyword = xmldoc.CreateElement("Keyword");
        keyword.InnerText = "small";
        parentelement.AppendChild(keyword);
        xmldoc.DocumentElement.AppendChild(parentelement);
        xmldoc.DocumentElement.AppendChild(parentelement);
        xmldoc.DocumentElement.AppendChild(parentelement);
        xmldoc.DocumentElement.AppendChild(parentelement);
        mldoc.DocumentElement.AppendChild(parentelement);
        mldoc.DocumentElement.AppendChild(parentelement);
        xmldoc.Save(Server.MapPath("~/admin/XMLFile.xml"));
    } 


xml file

:
<?xml version="1.0" encoding="utf-8"?>
<Advertisements>
  <Ad>
    <ImageUrl>~/images/5_step.jpg</ImageUrl>
    <Width>206</Width>
    <Height>200</Height>
    <NavigateUrl>http://www.dotnetcurry.com</NavigateUrl>
    <AlternateText>DotNetCurry Home Page</AlternateText>
    <Impressions>40</Impressions>
    <Keyword>small</Keyword>
  </Ad>
  <Ad>
    <ImageUrl>~/images/arrow.jpg</ImageUrl>
    <Width>206</Width>
    <Height>200</Height>
    <NavigateUrl>http://www.sqlservercurry.com</NavigateUrl>
    <AlternateText>SQL Server Curry Home Page</AlternateText>
    <Impressions>20</Impressions>
    <Keyword>small</Keyword>
  </Ad>
  <Ad>
    <ImageUrl>~/images/content_section_bg.jpg</ImageUrl>
    <Width>206</Width>
    <Height>200</Height>
    <NavigateUrl>http://www.dotnetcurry.com/writeforus.aspx</NavigateUrl>
    <AlternateText>dotnetcurry.com Write For Us</AlternateText>
    <Impressions>40</Impressions>
    <Keyword>small</Keyword>
  </Ad>
  <Ad>
    <ImageUrl>~/images/amit.jpg</ImageUrl>
    <Width>206</Width>
    <Height>200</Height>
    <NavigateUrl>http://labtestdiagnosis.com/index.aspx</NavigateUrl>
    <Impressions>40</Impressions>
    <Keyword>small</Keyword>
  </Ad>
</Advertisements>







Tuesday 22 November 2011

SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record


SELECT @@IDENTITY
It returns the last IDENTITY value produced on a connection, regardless of the table that produced the value, and regardless of the scope of the statement that produced the value.
@@IDENTITY will return the last identity value entered into a table in your current session. While @@IDENTITY is limited to the current session, it is not limited to the current scope. If you have a trigger on a table that causes an identity to be created in another table, you will get the identity that was created last, even if it was the trigger that created it.
SELECT SCOPE_IDENTITY()
It returns the last IDENTITY value produced on a connection and by a statement in the same scope, regardless of the table that produced the value.
SCOPE_IDENTITY(), like @@IDENTITY, will return the last identity value created in the current session, but it will also limit it to your current scope as well. In other words, it will return the last identity value that you explicitly created, rather than any identity that was created by a trigger or a user defined function.
SELECT IDENT_CURRENT(‘tablename’)
It returns the last IDENTITY value produced in a table, regardless of the connection that created the value, and regardless of the scope of the statement that produced the value.
IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the identity value generated for a specific table in any session and any scope.
To avoid the potential problems associated with adding a trigger later on, always use SCOPE_IDENTITY() to return the identity of the recently added row in your T SQL Statement or Stored Procedure.


example


insert into tblSessionMaster (courseId,branchId,sessionName) values(@courseId,@branchId,@sessionName)
      declare @id as int
      set @id=IDENT_CURRENT('tblSessionMaster')

Wednesday 16 November 2011

What's New in asp.net 2.0 for validation controls



  • Validation Groups - You can assign a group name to a set of validators to ensure that validation occurs only for controls in the specified group. This enables you to have multiple separately-validated forms on a single page.


  • Set Focus on Error - Using the new Focus API feature in ASP.NET validators can be configured to set focus to their associated control to be validated when a validation error occurs. The first control in the form that has a validation error will receive default focus when the form is submitted.


  • Culture Invariant Values - When doing conversion on a compare validator's non strongly-typed properties (CompareValidator.ValueToCompare, RangeValidator.MaximumValue, RangeValidator.MinimumValue) the validator will use a culture neutral format (Date: YYYY/MM/DD, Double & Currency: US culture format) to do the conversion when CultureInvariantValues is true.


  • Validate Empty Text - The ValidateEmptyText property fixes an issue with CustomValidator. In ASP.NET 1.0 custom validation would not fire if ValidationText was empty. You can set this property to true to cause custom validation to occur for empty input values.

how to find the master page controls on chid page .....

dear friends:

  you can use the code on child page and find the controls on page

Label lblId=Master.FindControl("controls_id") as Label;


i hope it helps you......

Tuesday 15 November 2011

ASP.NET Validation Controls – Important Points, Tips and Tricks


Dear friends.

ASP.NET validation controls provide an easy-to-use but powerful mechanism of ensuring that data is entered correctly on the forms. There are 6 validation controls included in the ASP.NET 2.0 and ASP.NET 3.5 versions. If you are not familiar with Validation Controls in ASP.NET,here’s a recommended read for you.
In this article, let us see some tips and tricks that can be applied to the validation controls. This article is for beginner and intermediate users who have been using validation controls. There is something for everyone!!
Tip 1: Always use Page.IsValid before submitting data. Apart from the other benefits, using it prevents submitting data from old browsers that do not support javascript.
Tip 2: The display property for the ASP.NET validation controls has 3 settings: None, Static(default), and Dynamic. ‘Static outputs HTML code (related to error) at all times even when no error has occurred. So when there is more than one validation control placed next to the field, the first validation control occupies screen space even when there is no error. In case the second validation control fires an error message, the message is pushed away from the control since the first validation control is occupying screen space.
Set the ‘display’ property of a validation control to ‘Dynamic’. This property renders the error message with the attribute display:none; It helps you to display the error message next to the control .
Tip 3: To prevent validation to occur on the click of the Cancel button, set the ‘CausesValidation’ property to false
<asp:Button ID="btnCancel" Runat="server" CausesValidation="False" Text="Cancel" />
Tip 4: Use the ‘InitialValue’ property of the RequiredFieldValidator to validate controls like combobox which have a default value.
For eg: If your combobox has a default item called “--Select --“ and you want that the user should select a value other than the default value before submitting the form, then set the ‘InitialValue’ property of the RequiredFieldValidator to “--Select--“.
<asp:DropDownList ID="DropDownList1" runat="server">
            <asp:ListItem Value="--Select--" />
            <asp:ListItem Value="Item1" />
            <asp:ListItem Value="Item2" />
            <asp:ListItem Value="Item3" />
        </asp:DropDownList>
        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"ErrorMessage="RequiredFieldValidator" ControlToValidate="DropDownList1" InitialValue="--Select--"></asp:RequiredFieldValidator>
Tip 5: A RegularExpressionValidator can be used to handle string patterns. For eg: A Name textbox that should accept a maximum of 30 characters with only alphabets, space, fullstop(.) and a ‘(apostrophe). A regularexpression like ‘^([a-zA-z.'\s]{2,30})$’ does the trick.
However when you are using Localization and using a language like Arabic, you have to often provide for validating characters in a different dialect. You can solve this using the following technique:
- In the Resource.resx file, create a resourcekey called ValidName giving it a value of ^([a-zA-z.'\s]{2,30})$
- In the Resource.ar-EG.resx file, use the same key but with a diff value ^([
\u0600-\u06FF.'\s]{2,30})$
Use it in your page using the following way. Observe the bold text:  <asp:RegularExpressionValidatorID='regEVFname' runat='server'ControlToValidate='txtName'Display='Dynamic'ErrorMessage='Invalid’ValidationExpression='<%$ Resources:Resource, ValidName %>'SetFocusOnError='True'></asp:RegularExpressionValidator>
 
When the user selects English, he can enter only A-Za-z. Similarly for Arabic, he can enter only the Arabic characters and not English.
Tip 6: The validation controls provide both Server and Client Side validation. To turn off client-side validation, set the ‘EnableClientScript = false’
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" Runat="server"
   Text="Error" ControlToValidate="TextBox1" EnableClientScript="false"/>
Tip 7: Use CompareValidator to validate date with format of "dd/MM/yyyy".
The validator uses the CultureInfo object of the thread to determine date format. So what you need to do is to set the desired culture format in the Page directive
 <%@ Page culture="your culture" %>
This tip was shared by PeterBlum in the asp.net forums. By the way, Peter has an amazing suite of data entry and validation controls on his site at a reasonable price.
Tip 8: Instead of the textual error message, you can even add an image or sound to your validator control. The Text and Error Message property accepts HTML tags.
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <br />
<asp:RequiredFieldValidator ControlToValidate="TextBox1" EnableClientScript="false"ID="RequiredFieldValidator1" runat="server" Text="<bgsound src='C:\Windows\Media\Windows Error.wav'>"></asp:RequiredFieldValidator>
Just make sure that the EnableClientScript="false" when you want a sound instead of a text message.
Tip 9: If you have two set of forms (eg: Login and Registration) in a single page and want to keep the validation of the two groups separate, use ‘ValidationGroups’. All you need to do, is to specify a common group name for a set of controls that you want to validate separately.
<div>
            <asp:TextBox ID="TextBox1" ValidationGroup="Group1" runat="server"></asp:TextBox>
            <br />
            <asp:RequiredFieldValidator ControlToValidate="TextBox1" ValidationGroup="Group1"ID="RequiredFieldValidator1" runat="server" Text="Error"></asp:RequiredFieldValidator>
            <asp:Button ID="Button1" runat="server" ValidationGroup="Group1" Text="Button" />
        </div>
        <br />
        <br />
        <div>
            <asp:TextBox ID="TextBox2" ValidationGroup="Group2" runat="server"></asp:TextBox>
            <br />
            <asp:RequiredFieldValidator ControlToValidate="TextBox1" ValidationGroup="Group2"EnableClientScript="false" ID="RequiredFieldValidator2" runat="server" Text="Error"></asp:RequiredFieldValidator>
            <asp:Button ID="Button2" runat="server" ValidationGroup="Group2" Text="Button" />
        </div>       
Tip 10: Other validator controls like CompareValidator, RangeValidator etc. do not provide a way to detect if the field is blank or required. The only way is to do this is to add a RequiredFieldValidator along with the other validator controls.
However one exception being the CustomValidator which provides a property called ‘ValidateEmptyText’. Just set it to true and it validates the field even if the user has kept the field blank.
Tip 11: If you want your validation error message to appear in the ‘ValidationSummary‘ control, then set the ‘ErrorMessage’ property on that validation control. Also, setting 'ShowMessageBox = true' on the ValidationSummary enables you to display a popup alert.
Tip 12: In order to create a CustomValidationControl you have to derive from the 'BaseValidator' class and implement the 'EvaluateIsValid()' method.
Tip 13: In case of an error, the validation controls allow you to set focus on a control in error using the ‘SetFocusOnError’ property.
<asp:RequiredFieldValidator SetFocusOnError="true" ControlToValidate="TextBox1"ID="RequiredFieldValidator1" runat="server" Text="Error!!"></asp:RequiredFieldValidator>
I hope this article was useful and I thank you for viewing it.

How to change the title bar icon in asp.net

Hi Friends,


you can change the title bar icon as you want.
by using simple line of code.

as in aspx page you can use the following line

<head>
  <link rel="SHORTCUT ICON" href="images/pencil.png"/>
    <title>My Application</title>
</head>
Contact Us:

Email:

Vinodkumar434@gmail.com,
vinodtechnosoft@gmail.com

Skype Name:

vinodtechnosoft