Starting the SharePoint Central Admin giving runtime Error

When Starting the Share point Central Administration I get Run-time Error.

Follow the steps below

1) Go to IIS
2) Expand the "Sites" folder and select "SharePoint Central Administration v4 " virtual directory
3) In the "Actions" section click Explore
4) The site physical folder will open and contains web.config file.
5) Open web.config file find the "CustomErrors" tag.
6) Set its mode attribute to mode="Remoteonly"
7) Refresh and Re-open the central Administration Site in browser
8) You will Get the following error now

Error: This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products Configuration Wizard, located on the Start menu in Microsoft SharePoint 2010 Products.

Cause: SQL Server for SharePoint services stopped due to restart of my machine

9)  Now Open the Services.msc
10) Restart the "SQL Server(SHAREPOINT)" service
11) Also Enable and Restart the "SQL Server Agent (SHAREPOINT)"
12) Also Enable and Restart "SQL Server Browser" 

PS: I hope this helps. Please drop your comments.

how to use requiredfield validator with dropdownlist

Here is how we can use requiredfieldvalidator with dropdownlist.

Set the below property of the dropdownlist control

AppendDataBoundItems = true

Then Insert a default value in the Page_Load event

ddl.Items.Insert(0, new ListItem("<<-Select-->", "-1"));

Now define the required field validator and set its initialvalue attribute to "-1"

<asp:RequiredFieldValidator ID="reqddl" runat="server" Text="*" ControlToValidate="ddlRole" InitialValue="-1" SetFocusOnError="true" Display="Dynamic" ValidationGroup="Add"></asp:RequiredFieldValidator>

Happy coding :)

Hide and Show div using Jquery

We have a requirement to hide and show our Grid in a div. 

Following is the code to achieve this functionality

Define the first div which shows the caption Show/Hide. Whenever the mouse is over the div "divtoggle1" second div "divOrders" is either shown or hidden

The below <Div> is defined with caption Show/Hide

 <div id="divtoggle1" style="text-align:left;width:250px">
                 Show/Hide
  </div>

The below <Div> contains the GridView which we need to Show/Hide

<div id="divOrders">
 
<asp:GridView ID="grvOrders" runat="server" AutoGenerateColumns="False" >

     <Columns>
          <asp:TemplateField HeaderText="firstcolumn" >
                      <ItemTemplate>
                              <asp:LinkButton ID="lnkName" runat="server" Text='<%#
                                  DataBinder.Eval(Container.DataItem,"Names") %>'                                                                               CommandName="OrderDetail">
                            </asp:LinkButton>
                        </ItemTemplate>
            </asp:TemplateField>
        </Columns>
  </asp:GridView>
</div>  

The Jquery part which toggle the div

we are access the div "divtoggle" with "#" sign because in Jquery when you want to access any element by ID you have to use "#" sign before the name of element.

we call the "divtoggle1" mouseover event and in that event we are checking the second div "divOrders".

 if "#divOrders" visible then hide it or if it is hidden then make it visible. we also added delay function to make the Show/Hide smooth and we used hide argument "slow".

<script type="text/javascript">
    $(document).ready(function () {
        $("#divtoggle1").mouseover(function () {

            if ($('#divOrders').is(':visible')) {
                $("#divOrders").delay(100).hide('slow');
                $("#divtoggle1").text('Show Orders');
            }
            else {
                $("#divOrders").delay(100).show('slow');
                $("#divtoggle1").text('Hide Orders');
            }

        }); // end of mouse over
    });    // end of ready function
 

</script>

Passing-parameter-value-through-a-function-from-anchor-tag-in-a-gridview

We have a requirement where we have to pass Session values and DataBound values to Javascript function using Anchor tag in Gridview.

Following is the Anchor defined in the Gridview where we are passing Session and Eval values as parameter to the Javascript function

OpenAttachmentWindow(roomId,StudentId,Id).

Javascript function description

<script language="javascript" type="text/javascript">

       function OpenAttachmentWindow(roomId, StudentId, Id)
         {
             var ReadOnly = 0;

             window.open('UploadSupplierAttachments.aspx?roomId=' + roomId + '&studentId=' +
             StudentId + '&id=' + Id + '&ReadOnly=' + ReadOnly, '', 'width=700,height=500')
         
          }

   </script>


Gridview Template column

We have anchor html control which will pas the server side arguments to javascript function.

<asp:TemplateField HeaderText="view">

    <ItemTemplate>

           <a  onclick='<%# "OpenAttachmentWindow(" +Session["roomId"] + " , " +        
           Session["StudentId"] + ", " + Eval("Id") +" );" %>'  id="a1" runat="server" >Attachment </a>

    </ItemTemplate>

</asp:TemplateField>

Compare Validator DataTypeCheck

I have been using asp.net Validator controls for quite long. I have come across the unexplored property of Compare Validator which can check input against following types

1) Currency

2) Date

3) Double

4) Integer 

5) String

you can use the Validator by setting the following properties

Operator="DataTypeCheck"

Select any of the below types for data type check

Type= Currency

            Date

            Double

            Integer 

            String

Example:

<asp:CompareValidator ID="CompareValidatorNumber" runat="server" ControlToValidate="txtTelephone" Text="*" Display="Dynamic" ErrorMessage="Please enter numbers only" Operator="DataTypeCheck" Type="String"></asp:CompareValidator>

filling DataSet by calling oracle stored procedure

Use the below code as a reference.

public void GetDatainDataset()
{

 using (OracleConnection conn = new OracleConnection(strConnStr))            {                conn.Open();

                OracleCommand cmdABC = new OracleCommand();

                cmdABC.Connection = conn;

                cmdABC.CommandType = CommandType.StoredProcedure;

                cmdABC.CommandText = Stored Procedure Name;

                cmdABC.Parameters.Add("P_RC", OracleDbType.RefCursor).Direction                 = ParameterDirection.Output;

                DataSet ds = new DataSet();

                OracleDataAdapter adapter = new OracleDataAdapter(cmdPlants);

                adapter.Fill(ds);

                ddlABC.DataSource = ds.Tables[0];

                ddlABC.DataTextField = "A";

                ddlABC.DataValueField = "B";

                ddlABC.DataBind();

                conn.Close();

                conn.Dispose();}

Gadget Enthusiasts pebble dropped price for original pebble and pebble steel

Statement

anxiously waiting for my pebble to connect it to my nexus 4

Generate c# code from *.wsdl file using WSDL Tool

Web Service Descriptor Language Tool

is used to generate the c# code from the *.wsdl file and you can use it as proxy class for prototyping

We have been assigned a small integration project. It is in inception stage so many things are not clear and we have been given one *.wsdl file to study and we tried to generate c# code from it to work on our application prototype

wsdl.exe can be found in Visual Studio 2005 at the following location

C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin

you can use following command to generate the proxy class from command prompt

wsdl /out:C:\Test\out:myProxyClass.cs C:\Test\MyWsdlfile.wsdl

Now you can add the myProcyClass.cs in your project and use its methods. Please don't modify the myProcyClass.cs file as it auto generated.

SQL Query Column values as comma separated

Introduction

I have a table as shown below, which has Country_Code and Cities of the a country.

 I need to retrieve distinct cities in a country based on the Country_Code
column as a comma separated string.

SQL Statement

The following SQL Statement shows how it can be achieved

Begin

declare @str varchar(1000)

SELECT @str= coalesce(@str + ',' , '') + a.CountryLang_Desc 
FROM (SELECT DISTINCT CountryLang_Desc from CountryLanguages where Country_Code='IN') a

print @str 

End

_doPostBack and Browser back button behavior

The odd behavior of Browser Back Button on _doPostBack()

 In one of application developed in Asp.net page is not behaving as desired when browser back button is pressed.

The steps performed in the following order

1) Go to the page
2) Click a link which causes _doPostBack and navigate to new page
3) Press the browser back button
4)click on any button 

This will end up re-executing the _doPostBack() action instead of firing Button click event.

The reason or behavior is as follows

• Back button goes back to the previous page - page is not reloaded from server!
• Browser assigns __EVENTxxx etc. with the previous POST back values
• The server detects the __EVENTxxxx form vars and routes events accordingly (incorrect behavior)

To overcome this behavior i had a simple solution in my mind to expire the page and empty the secure page cache.

It worked for me by introducing following code in page load event and use is at the top not in any checks like IsPostback etc.

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.Cache.SetAllowResponseInBrowserHistory(false);