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


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

Calculating Opening and closing balance for the month

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

Hi Team,

 

I need to  calculate the opening  and closing balance for the month  here is the scenario:-

I have a table call Delinquency  for the loan repayment defaulter’s which has an entry for proposalid , compute_date and ODPOS values. The table has proposal ID as its primary key and has an entry for every proposalid for only the last day of every month. April For eg:-

ProposalId

Computedate

ODPOS

1

30-Apr-2011

                      


View Complete Post


More Related Resource Links

How to insert opening and closing tags into an existing XML using C#

  
Hi guys, I have what seems to be an easy task to do but I cannot find a solution to it. I would like to insert an opening and a closing tag into an existing XML file using C# code. The tags of interest are shown in bold below: <AAAAA>     <XXXX text="gggg">         <BBBB>Something</BBBB>         <CCCC>Another thing</CCCC>     </XXXX> </AAAAA> Any assistance is very much appreciated. Patrice

Highlight Opening and Closing Parenthisis in Query Analyzer 2008

  
I'd like to have my parenthisis highlighted when I select either the opening or closing one. How do I turn that ON?

how to write logs without opening and closing the Oracle DB Connection

  

I am developing logging application with asp.net & vb.net & Oracle

At present I'm using this mechanism to write logs

Method1 Connect (
Try{
Conn.open ()
Flag=True}
Catch{
Flag=False}
Finally{
Close () & Dispose ()
 
Method2 WriteLogs (
Call Connect ()
If flag=True
                Write logs into Oracle Database
Else
                Write logs into Text File


 
The problem with above procedure is, I'm using "Method2 WriteLogs" more than 2000 locations in my program. So each time it's opening & closing the DB connections. It's slows the system.
 
I want to use Method2 without using the Method1
 
 Please advice me
 


how to write logs without opening and closing the Oracle DB Connections, so many times?

  

I am developing logging application with asp.net & vb.net & Oracle

At present I'm using this mechanism to write logs

Method1 Connect (
Try{
Conn.open ()
Flag=True}
Catch{
Flag=False}
Finally{
Close () & Dispose ()
 
Method2 WriteLogs (
Call Connect ()
If flag=True
                Write logs into Oracle Database
Else
                Write logs into Text File


 
The problem with above procedure is, I'm using "Method2 WriteLogs" more than 2000 locations in my program. So each time it's opening & closing the DB connections. It's slows the system.
 
I want to use Method2 without using the Method1

is there any solution in MS Enterprise Library to write logs without opening & closing the DB connections, so many times?

Please advice me


Visual Studio closes itself by opening aspx-Page designer after Windows Update

  

Hey Guys,

I've a problem with my Visual Studio.

On the 13th of August 2010 i installed a Windows update on my vista sp2 pc. For this date my Visual Studio 2008 sp 1 always has closed itself by opening an aspx-page in designer view. There is no error message just closing the window. I restored a backup of my windows from the time before updating it and it helped, i could open aspx pages in the design view till the update has been installed again automatically after rebooting the pc. I can't disable windows updates, cause it's my pc at work and safety is very important. I hope you could help me out of this disaster.


Thanks

Nik


ASP.NET Configuration not opening

  

I recently upgraded to VS 2010 and downgraded to SQL Server 2005. Now when I go Website > ASP.NET Configuration nothing happens.

It's likely this has to do with the fact that when I was installing SQL Server I got the 'ASP.net Version Registration requirement' warning, as well as the 'Failed to find the ASP.net Version Registration requirement with MS IIS'.

Anyone know what I need to get ASP.NET Configuration working?


dropdownbox which selects records based on criteria (TODAY, THIS WEEK, THIS MONTH, etc)

  

I have a dropdownbox which I want to use to search records based on a timescale. The gridview populates results based from that search.

So here is how I want to work this;

If a user selects "today" - a list of records input today are populated. If "this week" is selected, a list of all records added within that week from todays date is populated.

I created a forum on this issue previously but to no avail whatsoever. How do I work around this problem?

Help would be much appreciated



Browser window is opening up on the second click with javascript code

  

Hi,

I am trying to set a javascript code to open up a new browser window with this URL that exists like shown below.

On the first click nothing happens but on the second click the browser window is opening up.

 

How is it possible to make it open up on the first click ?

                                <asp:ImageButton ID="ImageButton3" runat="server" Height="84px" 
                                    ImageUrl="~/images/1.jpg" Width="165px" 
                                    onclick="ImageButton3_Click" />

    protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
    {
        String openURL = "javascript:window.open('" + "Folder1/testing.aspx" + "');return false;";
        ImageButton3.OnClientClick = openURL;
    }


 


Closing Javascript Modal dialog window after server side event processing

  

Hello Friends..


Please tell me how to close Javascript ModelDoalog Window.. after Server Side event Processing .

Basically i want close window in  finally Block After sucessfulll Updation.


AMit..... InnocentInnocentInnocentInnocentInnocentInnocentInnocent


Problem opening dotnet 1.1 projet on 2008 web server

  

 We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server.  I can host them and they work.  My problem is that when I try to open one in VS 2003 I get the following error.  I set up the web server the same as my previous one, and I think a long time  ago I got this error when we set up current one but do not remember how to resolve it.  So I moved my project files from the old server to the new server and then I get these errors. 

 

The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error


IE closing when user try to access the document library

  
<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> IE closing (crashing) when user try to access the document library in share point site.  here we are using WSS2.0.  this problem for not accursed all the users , this problem happening on some users. 

Issue with opening SharePoint library in Windows Explorer view

  
I am having trouble opening a document library in Windows Explorer view. The portal is MOSS 2007. I have installed Office 2007 and IE7 on my computer. The error that I get is
"Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server."

Error when opening Infopath Form

  

Background: Created an Infopath 2003 form with 2 views (1 as Read-Only View and another 1 for Submitting content) and published to a Sharepoint 2007 Library.

Working: When a user opens a new form it opens in submit view; once the form has been submitted, when the user tries to open again, the form opens in read-only view.

Error: 99% of the users do not face any issues, however when the the rest 1% of the users try to open a new form; they receive the following error and are unable to open the form.

Form template: _http://server/sites/subsite/library/forms/template.xsn
InfoPath cannot open the following view: Edit_View
The following view file is not valid: view1.xsl
The file is not a valid XML document.

An invalid character was found in text content.

Line 673, Position 12
 </xsl:temp
-----------^

I am not sure what is wrong here (or) from where this error is being generated!


Balaji Baskar [Please mark the post as answer if it answers your question]

Switch views when opening a form depending on submit locations?

  

Hello!

I would like to know it was possible to switch views when opening a form depending on where the form has been submitted.

I am submitting my form to library A and library B and want to be able to open it in view 1 in library A and in view 2 in library B.

Is there a way to set some url conditions in the open behavior rules?

Thanks a lot!


Check-out issue when opening a document from a document library when a read-only copy is open

  
We have an issue when a user has a read-only copy of a document from SharePoint open and then tries to check-out and edit another copy of the document (i.e. from the document library) the checked out copy is not connected to the web server. For the user it will look the same they will make edits, save and then close, but when they do so the document is not updated in SharePoint - it may be saved locally in their SP drafts, but the user will think that they have lost their version. We then get the checked out to another user error and you have to discard changes to get the document working again. Steps to reproduce this issue: * click on the name of a office doc on a Document Library * Make sure "Read Only" is selected and click "ok" * Minimize open document * click on the same file on the Document Library * Make sure "check out and edit" is selected and the "Use my local drafts folder" checkbox is ticked. Select OK. * Edit document and press save. Changes are never saved back in SharePoint, they are only on the local draft. We are using MOSS with SP2. Clients are on Office 2003 and 2007 Is this normal behaviour? Is there anything that can be done to prevent this from happening?
Categories: 
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