Monday, 28 April 2014

Popup Message in asp.net

public static void DisplayAJAXMessage(Control page, string msg)
    {
        string myScript = String.Format("alert('{0}');", msg);
        ScriptManager.RegisterStartupScript(page, page.GetType(), "MyScript", myScript, true);
    }



 DisplayAJAXMessage(btnsave, "Please Do Not Enter Diplicate Department Name ");

How to implement ajax Auto Complete in asp.net


////////////////////////////////////////////////////////
<script type="text/javascript">
        function DepartmentsSelected(sender, e) {
            var values = e.get_value().split(":");
            var LeaveRecommendAuthirty = values[1];
            var LeaveSanctionAuthority = values[2];
            if (LeaveRecommendAuthirty != '') {
                $('#dropleaverecommend').val(LeaveRecommendAuthirty);
            }
            else {
                $('#dropleaverecommend').val('0');
            }
            if (LeaveSanctionAuthority != '') {
                $('#dropsanctionauthority').val(LeaveSanctionAuthority);
            }
            else {
                $('#dropsanctionauthority').val('0');
            }
            return false;
        }


///////////////////////////////////////////////////

<td>Department Name
            <br />
            <asp:TextBox ID="txtdepartment" CssClass="text" runat="server" ClientIDMode="Static"></asp:TextBox>
            <cc1:AutoCompleteExtender ID="txtdepartment_AutoCompleteExtender" runat="server" DelimiterCharacters="" Enabled="True"
             MinimumPrefixLength="2" OnClientItemSelected="DepartmentsSelected"
             ServiceMethod="DisplayDepartments" TargetControlID="txtdepartment" UseContextKey="True">
             </cc1:AutoCompleteExtender>
             </td>



//////////////////////////////////////////////////



 [System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
     public static List<String> DisplayDepartments(string prefixText)
     {
         Department ob = new Department();
         DataSet ds = ob.DisplayDepartments(prefixText);
         List<String> Departments = new List<String>();
         Int32 i = -1;
         foreach (DataRow row in ds.Tables[0].Rows)
         {
             String item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(row["Name"].ToString(), row["ID"].ToString() + ":" + row["LeaveRecommendAuthirty"].ToString() + ":" + row["LeaveSanctionAuthority"].ToString());
             Departments.Add(item);
         }
         return Departments;
     }

///////////////////////////////////////////////////

ALTER PROC [dbo].[pDisplayDepartment]
    @Department VARCHAR(50)
AS
    BEGIN
   
        SELECT  Name,Id,ISNULL(LeaveRecommendAuthirty,'') AS LeaveRecommendAuthirty,ISNULL(LeaveSanctionAuthority,'') AS LeaveSanctionAuthority
        FROM    dbo.Department
        WHERE   Name LIKE '%' + @Department + '%' AND isActive=1
    END


///////////////////////////////////////////////////