.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Unable to retrieve it

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


When I run that openquery part from


I've got this

Msg 8115, Level 16, State 2, Line 2

Arithmetic overflow error converting expression to data type datetime.

Many Thanks & Best Regards, HuaMin Chen

View Complete Post

More Related Resource Links

Unable to retrieve large amounts of data?


We're using WCF with 'basicHttpBinding', and have set the maxBufferSize, maxReceivedMessageSize to 99999999. We've also set the ReaderQuota maxArrayLength to 99999999.

The method I'm calling is supposed to return an array of objects with a couple containing a few small strings, and a couple of bools and integers. If the array is less than ~500 elements, I don't have a problem, and I receive all of my data. However if the array is of any meaningful size, then I get the following CommunicationException:

"The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error."

I'm thinking that I might need to retrieve the array's in manageable chunks, but before I start that rewrite process, I'd like to see if there would be a way to get this done.

error : Unable to retrieve folder information from the server. (550).


I now get this message in Visual Studio  2010;


error : Unable to retrieve folder information from the server. (550).


help please

Unable to retrieve Lookup fields or item URL values from Library(Wiki Page Library) item when using



When I execute, "l["Category"].ToString();" and the field is a lookup field it returns, "Microsoft.SharePoint.Client.FieldLookupValue[]", on the other hand when I execute "l["Description"].ToString();" which is a normal string field I get the string(multiline) value back, any idea what could be going on here? I have tried, static/internal/displayname all with the same result(lol moment,

Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more i


I have a project that works fine when I run it locally but when I put it on our new Windows 2008 running IIS 7 I get the following error.  I have done some research and nothing seems to solve my issue.  I am using VS 2010 and the entity framework and the error appears to occur when I am trying to bind data to the view?

Thanks in advance


Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Source Error:

An unhandled exception was generated during the execution of

unable to retrieve All contacts from AD



I need to get All Contacts from a particular OU say "Custom", and need to update thier email address.

To get all the contact I am using the following command in VS 2010 , but getting unspecified COM Exception .

DirectoryEntry de = new DirectoryEntry(ldap, user, pass);

                DirectorySearcher deSearch = new DirectorySearcher();


                deSearch.SearchRoot = de;              

               deSearch.Filter = "(&(objectCategory=person)(objectClass=Contact))";               

                deSearch.SearchScope = SearchScope.Subtree;

                SearchResultCollection results = deSearch.FindAll();

                return results;


Please Correct me if I am wrong or is it a bug with VS2010



Unable to retrieve the date



I've created one view like

 SELECT fld1,
     CONVERT(datetime,test_arrived_date,105) test_arrived_date,
     (SELECT TOP 1 dms_uploaded
     FROM  vw_my_header_table
     WHERE fld7erence = Rtrim(test_fld7)) dms_uploaded,
     (SELECT TOP 1 dms_key_match
     FROM  vw_my_header_table
     WHERE fld7erence = Rtrim(test_fld7)) dms_key_match,
     (SELECT TOP 1 inv_uploaded
     FROM  vw_my_header_table
     WHERE fld7erence = Rtrim(test_fld7)) inv_uploaded,
     (SELECT TOP 1 inv_dms_key_match

unable to retrieve specific section in CDATA part of XML with the help of XPath in XSLT



   I am unable to retrieve specific section in CDATA part of XML with the help of XPath in XSLT. How can i navigate into ?Frown

Textbox in ItemTemplate inside Gridview, unable to get the value


Hi. I have a itemtemplate inside a gridview.

<asp:TemplateField HeaderText="Enter OTP">
                            <asp:Label ID="Label2" runat="server"
                                style="font-family: Arial, Helvetica, sans-serif; font-size: x-small"
                                Text="PIN Num:"></asp:Label>
                            &nbsp;<asp:TextBox ID="txtPIN" runat="server" Height="21px" Width="100px"></asp:TextBox>

How to retrieve data from SqlDataSource and pass to a variable?


Hi there,

I have a page in my website where there is very little code-behind. I only have two lines of code in Page_Load() and the rest of the code is declarative ASP.NET code. I have a FormView control which uses a SqlDataSource to get some order information. The SqlDataSource calls a stored procedure called usp_GetOrderDetails, here's the code for the SqlDataSource:

    <asp:SqlDataSource ID="sdsFormOrderDetails" runat="server" 
ConnectionString="<%$ ConnectionStrings:ForexDB %>"
ProviderName="<%$ ConnectionStrings:ForexDB.ProviderName %>"
SelectCommand="usp_GetOrderDetails" SelectCommandType="StoredProcedure"
UpdateCommand="usp_UpdateOrder" UpdateCommandType="StoredProcedure"
<asp:ControlParameter Name="orderId" ControlID="grdOrders" PropertyName="SelectedDataKey.Value" />
<asp:ControlParameter Name="orderId" ControlID="frmOrderDetails" PropertyName="SelectedValue" />

Unable to make connection to database?


Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

I have database called PhoneDirectory.

It have only one table named Residents.

I have button wiht ID="Button1".

I want when i click this button to see all of my residents. 

I want to see the result in DetailsView and to be able to edin, delete and add new resident.

First try with SqlDataSource so i wrote this:

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" 
              SelectCommand = "SELECT * FROM Resident "

Unable to get all the values from a field


Am reading an XML from web service and storing in  a dataset. 
then in write to a DataTable as follows

 DataTable dtResult1 = dsSearch.Tables["RESULTSET"];    
 DataTable dtHIT = dsSearch.Tables["HIT"];     
 DataTable dtField = dsSearch.Tables["FIELD"]; 

The issue  is  in the DataTable dtField i can only see 3 columns FieldID,Name,HIT_ID

The corresponding values in the dataTable looks like this for the corresponding fileds


I am unable to get the Field Name values 1,8799f4646b6ed9acde142581a84f75a6 ,234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD,Yes...etc

What would be the cause for this...Any Help

Below is the structure of the XML-

- <HIT NO="1" RANK="2955" SITEID="0" MOREHITS="0" FCOCOUNT="0"> 
<FIELD NAME="rank">1</FIELD> 
<FIELD NAME="internalid">8799f4646b6ed9acde142581a84f75a6 </FIELD> 
<FIELD NAME="contentid">234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD</FIELD> 
<FIELD NAME="contentids" /> 
<FIELD NAME="collection&

unable to access control inside webuser control



I have used calender web user control inside my project where i took textbox,button and calender.....but after dragging onto my aspx page....i am unable to access this textbox,calender and button on aspx page...Pls help me to find out the solution.

Win32 Resources: Using C++ to Programmatically Retrieve a Global Cursor's Shape and ID


Getting global cursor information is useful when developing software that drives or gathers information about other UI-based applications, including information about a remote machine. This article describes a way to programmatically identify the current cursor's ID and bitmap at any point in time. The first technique described is based on polling for information and shows how to get the handle of the current global cursor. This handle will then allow you to get information about the cursor. You can also monitor WinEvents for changes to the global cursor.

Dmitri Klementiev

MSDN Magazine October 2001

Unable to cast object of type 'System.Web.Mvc.ValueProviderResult' to type 'System.IConvertible'


 Why am I getting this error on line:

               sp.Price = Convert.ToDecimal(collection.GetValue("Price"));

sp is :
  SPecials_Templates sp = new SPecials_Templates();

SPecials_Templates Defined:

    public partial class SPecials_Templates
        public class SPecials_TemplatesMetaData

            public object Key { get; set; }
            public object Template_Name { get; set; }
            public object Headline { get; set; }

How to retrieve image from DB with Linq and diplay in Image Control


Hi all-


I'm using the file upload to let the user upload a single file.  Here's the code I'm using to then upload to the DB.  How do I reverse this process and dowload the image into the control for it to display on a different page?

Here's my code for the upload - which I think works but can't confirm until I can see the download since all I see in the DB is "binary data"

'update DB with new Image 
        If FileUpload1.HasFile AndAlso FileUpload1.PostedFile.ContentLength > 0 Then
            'Read the file in to a byte Array.
            Dim filebyte As Byte() = FileUpload1.FileBytes
            Dim fileBinary As New System.Data.Linq.Binary(filebyte)
                Dim c3 = (From c In dc.ProductImages _
                          Where c.userID = userGuid _
                          Select c).FirstOrDefault

                c3.productImage = fileBinary

            Catch ex As Exception
                Throw ex
            End Try
Here's my attempt at the retrieval, which isn't working:
                    Dim currentImage = F

How to store and retrieve multiple values in a single session variable .


I want to store employee name,designation and department in session variable and
retrieve in another page how to do this.

unable to attach database, security setting?


Hi folks,

I am using VS 2010 Professional with SQL Server 2008 Developer.  I right click on the App_Data folder in solution explorer and add an existing item, then navigate to the correct database.  However, I receive a pop up that Access is Denied.  How do I fix this? 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend