Friday, 20 December 2013

password auto off

 txtPassword.Attributes["AUTOCOMPLETE"] = "off";

Viewstate entity

 //view state declaration
    List<CheckVoucher> viewStateCheckVoucher
    {
        get { return (List<CheckVoucher>)ViewState["CheckVoucher"]; }
        set { ViewState["CheckVoucher"] = value; }
    }

in page load initialize
 if (viewStateCheckVoucher == null) viewStateCheckVoucher = new List<CheckVoucher>();//view state initialisation

Thursday, 19 December 2013

Date Time Format

INSERT TIME

 RegisteredOn = DateTime.ParseExact(txtRegisteredOn.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture),

RETRIVE TIME

txtRegisteredOn.Text = company.RegisteredOn.ToString("dd-MM-yyyy");

Wednesday, 6 November 2013

Messagebox yes no

 if (MessageBox.Show("Do you want to make it Primary Key?", "Confirm", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                        return;

Tuesday, 29 October 2013

Hash Table

 public IList<DynamicForm_Data> GetAllDynamicFormDatasControlDetailsByFormId(int formId)
        {
            DynamicForm_Data dynamicForm_Data = new DynamicForm_Data();
            IList<DynamicForm_Data> dynamicForm_Datas = new List<DynamicForm_Data>();
            try
            {
                List<string> columnNames = new List<string>();
                //List<string> columnValues = new List<string>();

                List<Hashtable> ColumnValuesInHashtable = new List<Hashtable>();

                string queryForColumns = "SELECT ControlName, ControlCaption, ControlTypeId, IsPrimaryKey FROM dbo.DynamicForm_Controls WHERE (FormId = " + formId + ") AND (ControlCaption <> 'AutogeneratedPrimaryKey')";

                SqlCommand sqlcommandForColumn = new SqlCommand(queryForColumns);
                IDataReader dataReaderForColumn = objDataAccess.ExecuteReader(sqlcommandForColumn);
                while (dataReaderForColumn.Read())
                {  
                   if(dataReaderForColumn["IsPrimaryKey"].ToString() == "True")
                    columnNames.Add(dataReaderForColumn["ControlCaption"].ToString()+" (PK)");
                    else
                       columnNames.Add(dataReaderForColumn["ControlCaption"].ToString());
                }
                dataReaderForColumn.Close();
                sqlcommandForColumn.Dispose();

                string query = "SELECT dbo.DynamicForm_Controls.ControlName,dbo.DynamicForm_Controls.ControlCaption, dbo.DynamicFormDatas.ControlValue, dbo.DynamicForm_Controls.ControlTypeId, dbo.DynamicFormDatas.ControlId, dbo.DynamicFormDatas.GroupId FROM  dbo.DynamicFormDatas LEFT OUTER JOIN dbo.DynamicForm_Controls ON dbo.DynamicFormDatas.ControlId = dbo.DynamicForm_Controls.Id WHERE (dbo.DynamicFormDatas.FormId = " + formId + ")";

                SqlCommand sqlCommand = new SqlCommand(query);
                IDataReader dataReader = objDataAccess.ExecuteReader(sqlCommand);
                while (dataReader.Read())
                {
                    //string value = dataReader["ControlValue"].ToString();
                    //columnValues.Add(value);
                    Hashtable hashtable = new Hashtable();
                    hashtable.Add(dataReader["GroupId"].ToString(), dataReader["ControlValue"].ToString());
                    ColumnValuesInHashtable.Add(hashtable);
                }

                dataReader.Close();
                sqlCommand.Dispose();
                dynamicForm_Data.DynamicForm_DataColumnName = columnNames;
                //dynamicForm_Data.DynamicForm_DataColumnValue = columnValues;
                dynamicForm_Data.DynamicForm_DataColumnValueInHashtable = ColumnValuesInHashtable;
                dynamicForm_Datas.Add(dynamicForm_Data);
            }
            catch (Exception exception)
            {
                throw new Exception(exception.Message, exception);
            }
            return dynamicForm_Datas;
        }

Split Function

string[] separateDataTypeAndPrecision = (((UltraTextEditor)sender).Tag.ToString()).Split(',');

Dictionary

 Dictionary<int, string> moduleDetailInfo = new Dictionary<int, string>();

            IList<DynamicFormApplicationDataSource> moduleDetails = new DynamicFormApplicationDataSourceManager().GetModulesByModuleId(Convert.ToInt32(cmbModuleName.Value)).ToList();
            foreach (var moduleDetail in moduleDetails)
            {
                if (moduleDetail.IsPk)
                {
                    txtKeyField.Text = moduleDetail.Name;
                    txtKeyField.Tag = moduleDetail.Id;
                }
                else if (moduleDetail.DataType == "varchar")
                    moduleDetailInfo.Add(moduleDetail.Id, moduleDetail.Name);
            }
            cmbValueField.DataSource = new BindingSource(moduleDetailInfo, null);
            cmbValueField.ValueMember = "Key";
            cmbValueField.DisplayMember = "Value";

Monday, 12 August 2013

Responce.Redirect

 one page
protected void lbtnSearch_Click(object sender, EventArgs e)
    {
        Response.Redirect(String.Format("GetAddressList.aspx?CityName={0}&AreaName={1}&AddressName={2}", CityName, AreaName, AddressName));
        CityName = AreaName = AddressName = string.Empty;
    }

Access value in other page
public partial class GetAddressList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string cityName = Request.QueryString["CityName"].ToString();
        string areaName = Request.QueryString["AreaName"].ToString();
        string addressName = Request.QueryString["AddressName"].ToString();

        rptrGetAddressList.DataSource = new AddressManager().GetAddressesByCityNameByAreaNameByAddressName(cityName, areaName, addressName);
        rptrGetAddressList.DataBind();       
    }
  }

Auto Complete Text Box



Html:
<tr>
            <td>
                City
            </td>
            <td>
                :
            </td>
            <td>
                <asp:TextBox ID="txtCitySearch" runat="server" AutoCompleteType="DisplayName" OnTextChanged="txtCitySearch_TextChanged"
                    AutoPostBack="true"></asp:TextBox>
                <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" ServiceMethod="GetCities"
                    MinimumPrefixLength="2" CompletionInterval="100" CompletionSetCount="10" EnableCaching="false"
                    TargetControlID="txtCitySearch" FirstRowSelected="false" UseContextKey="True"
                    CompletionListElementID="autocompleteDropDownPanel">
                </asp:AutoCompleteExtender>
            </td>
        </tr>
C#

[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
    public static string[] GetCities(string prefixText, int count)
    {
        var citySearchKey = from city in new CityManager().GetAllCities().GroupBy(city => city.Name).Select(city => city.First()).ToList()
                            where city.Name.ToLower().StartsWith(prefixText.ToLower().Trim())
                                   || city.Name.ToLower().Contains(prefixText.ToString().ToLower().Trim())
                            select city.Name;

        return citySearchKey.ToArray();
    }

Thursday, 8 August 2013

update panel(ajax):

<%@ Page Title="Address Master" Language="C#" MasterPageFile="~/AdminZone/AdminMasterPage.master"
    AutoEventWireup="true" CodeFile="AddressMaster.aspx.cs" Inherits="AdminZone_AddressMaster" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
                <div style="max-height: 420px; overflow: auto;">
                    <asp:UpdatePanel ID="updatePanelAddress" runat="server">
                        <ContentTemplate>
                            <table width="100%" cellpadding="0" cellspacing="5">
                                <tr>
                                    <td class="caption">
                                        Auto Id
                                    </td>
                                    <td class="captionSplitter">
                                        :
                                    </td>
                                    <td>
                                        <asp:Label ID="lblAutoId" runat="server" Text="Auto Generated"></asp:Label>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Address Type
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="ddlAddressType" class="caption" runat="server" CssClass="caption"
                                            OnSelectedIndexChanged="ddlAddressType_SelectedIndexChanged" AutoPostBack="True">
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator SetFocusOnError="true" ID="RequiredFieldValidator1" Display="Static"
                                            ValidationGroup="AddressValidationGroup" runat="server" ControlToValidate="ddlAddressType"
                                            ForeColor="Red" InitialValue="0" Text="*"></asp:RequiredFieldValidator>
                                    </td>
                                </tr>
                                <tr id="trAddressTitle" runat="server">
                                    <td>
                                        Address Title
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtAddressTitle" CssClass="largeText" runat="server"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Building Name
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtBuildingName" CssClass="largeText" runat="server"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        House Number
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtHouseNumber" CssClass="smallText" runat="server"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Plot Number
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtPlotNumber" CssClass="smallText" runat="server"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Street
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtStreet" runat="server" CssClass="largeText"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        LandMark1
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtLandMark1" runat="server" CssClass="largeText"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        LandMark2
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:TextBox ID="txtLandMark2" runat="server" CssClass="largeText"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="3">
                                        Approach Detail
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="3">
                                        <asp:TextBox ID="txtApproachDetail" TextMode="MultiLine" runat="server"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Country
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="ddlCountry" class="caption" runat="server" AutoPostBack="True"
                                            CssClass="caption" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged">
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator SetFocusOnError="true" ID="RequiredFieldValidator7" Display="Static"
                                            ValidationGroup="AddressValidationGroup" runat="server" ControlToValidate="ddlCountry"
                                            ForeColor="Red" InitialValue="0" Text="*"></asp:RequiredFieldValidator>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        State
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="ddlState" class="caption" runat="server" OnSelectedIndexChanged="ddlState_SelectedIndexChanged"
                                            AutoPostBack="True" CssClass="caption">
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator SetFocusOnError="true" ID="RequiredFieldValidator6" Display="Static"
                                            ValidationGroup="AddressValidationGroup" runat="server" ControlToValidate="ddlState"
                                            ForeColor="Red" InitialValue="0" Text="*"></asp:RequiredFieldValidator>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        District
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="ddlDistrict" class="caption" runat="server" AutoPostBack="True"
                                            CssClass="caption" OnSelectedIndexChanged="ddlDistrict_SelectedIndexChanged">
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator SetFocusOnError="true" ID="RequiredFieldValidator5" Display="Static"
                                            ValidationGroup="AddressValidationGroup" runat="server" ControlToValidate="ddlDistrict"
                                            ForeColor="Red" InitialValue="0" Text="*"></asp:RequiredFieldValidator>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        City
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="ddlCity" class="caption" runat="server" OnSelectedIndexChanged="ddlCity_SelectedIndexChanged"
                                            AutoPostBack="True" CssClass="caption">
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator SetFocusOnError="true" ID="RequiredFieldValidator4" Display="Static"
                                            ValidationGroup="AddressValidationGroup" runat="server" ControlToValidate="ddlCity"
                                            ForeColor="Red" InitialValue="0" Text="*"></asp:RequiredFieldValidator>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Area
                                    </td>
                                    <td>
                                        :
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="ddlArea" class="caption" runat="server" OnSelectedIndexChanged="ddlArea_SelectedIndexChanged"
                                            AutoPostBack="True" CssClass="caption">
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator SetFocusOnError="true" ID="RequiredFieldValidator3" Display="Static"
                                            ValidationGroup="AddressValidationGroup" runat="server" ControlToValidate="ddlArea"
                                            ForeColor="Red" InitialValue="0" Text="*"></asp:RequiredFieldValidator>
                                    </td>
                                </tr>
                                 </table>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </div>

</asp:Content>

Wednesday, 7 August 2013

lable(show for 5 seconds) in c# code and asp .net

 ClientScript.RegisterStartupScript(this.GetType(), "HideLabel",
            "<script type=\"text/javascript\">setTimeout(\"document.getElementById('" +
            lblErrorMessage.ClientID + "').style.display='none'\",5000)</script>");

Thursday, 25 July 2013

Linq ('not in' query use)

var result = from d in new ForumManager().GetForumsByPostedBy(GlobalVariables.MembershipId.Value)
                     let expensiveEmployeeIds = (from data in forumIds
                                                 select data.ForumId)
                     where !expensiveEmployeeIds.Contains(d.Id)
                     select d;

Saturday, 20 July 2013

Anchor tag with redirect an aspx page with id value(Eval("ID"))

 <a id="forumDetail" runat="server" class="button" href='<%#Eval("Id","ForumDetail.aspx?
Id={0}")%>'>View</a>

Wednesday, 10 July 2013

Text Box(multiple checked checkbox value displayed at a time in text box)



HTML:


for popup extender control paste this after <%@page....%>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
and
paste this inside contentplaceholder1
<asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>

 <div>
                                <asp:TextBox ID="txtGuest" runat="server"></asp:TextBox>
                                <asp:PopupControlExtender ID="txtGuest_PopupControlExtender" runat="server" DynamicServicePath=""
                                    Enabled="True" ExtenderControlID="" TargetControlID="txtGuest" PopupControlID="Panel1"
                                    OffsetY="22">
                                </asp:PopupControlExtender>
                                <asp:Panel ID="Panel1" runat="server" Style="display: none; background-color: #F2F2F2;
                                    border-style: solid; border-width: 1px; overflow: auto; top: 0; visibility: visible;
                                    width: 306px; z-index: 1000;">
                                    <asp:CheckBoxList ID="chkLGuest" runat="server" DataTextField="Name" DataValueField="Id"
                                        AutoPostBack="True" OnSelectedIndexChanged="chkLGuest_SelectedIndexChanged">
                                    </asp:CheckBoxList>
                                </asp:Panel>
                            </div>


c# code:

load check box :
chkLGuest.DataSource = new GuestManager().GetAllGuests();
        chkLGuest.DataBind();

protected void chkLGuest_SelectedIndexChanged(object sender, EventArgs e)
    {
        string name = "";
        for (int i = 0; i < chkLGuest.Items.Count; i++)
        {
            if (chkLGuest.Items[i].Selected)
            {
                name += chkLGuest.Items[i].Text + ",";
            }
        }
        txtGuest.Text = name;
    }


similarly for guestId we use item.selected.

Directory(Get all folders and files from a directory)

//this code written if image or any path file from database is not present in Repository(or any folder it will match) folder of application
            if (!string.IsNullOrEmpty(eventinfo.ImagePath))
            {
                ArrayList files = new ArrayList();
                String[] fileNameFromRepository = Directory.GetFiles("" + Server.MapPath(@"~/Repository/EventGallery/ImageGallery") + @"\" + eventinfo.Id +  "\\Images");
                for (int iFile = 0; iFile < fileNameFromRepository.Length; iFile++)
                    files.Add(new FileInfo(fileNameFromRepository[iFile]).Name);
                int countImage = 0;
                foreach (var FileName in fileNameFromRepository)
                {
                    if (new FileInfo(eventinfo.ImagePath).Name == new FileInfo(FileName).Name)
                        countImage++;
                }
                if (countImage == 0)
                    imgLogo.ImageUrl = "~/Images/NoImage.jpg";
            }