private void clear()
 {
     txtTitle.Text     = "";
     txtCity.Text      = "";
     txtClubNo.Text    = "";
     txtCountry.Text   = "India";
     txtLandmark.Text  = "";
     txtLatitude.Text  = "";
     txtLongitude.Text = "";
     txtPin.Text       = "";
     txtState.Text     = "Maharashtra";
     txtVenue1.Text    = "";
     txtVenue2.Text    = "";
     //DDLDays.ClearSelection();
     //DDLMonth.ClearSelection();
     //DDLYear.ClearSelection();
     //DDLDays.ClearSelection();
     DDLDay.ClearSelection();
     txtWebsite.Text = "http://www.";
 }
    private void SearchByAlphabet(string name)
    {
        rbtnSearch.SelectedIndex = 0;
        DDLDay.Visible           = false;
        DDLDay.ClearSelection();
        txtName.Visible   = true;
        btnSearch.Visible = true;
        txtName.Text      = "";

        Session["name"]        = null;
        Session["searchField"] = null;
        Session["value"]       = null;



        Session["name"] = name;

        DataTable    dt  = new DataTable();
        DBconnection obj = new DBconnection();

        obj.SetCommandSP = "z_SearchByAlphabetClubs";
        obj.AddParam("@name", name);

        dt = obj.ExecuteTable();

        if (dt.Rows.Count > 0)
        {
            lblMsg.Visible        = false;
            RadGrid1.Visible      = true;
            RadGrid1.DataSourceID = string.Empty;
            RadGrid1.DataSource   = dt;
            // RadGrid1.Rebind();
            RadGrid1.DataBind();
            RadGrid1.CurrentPageIndex = 0;
        }
        else
        {
            lblMsg.Visible   = true;
            RadGrid1.Visible = false;
        }
    }