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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Financial application serial number

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :ASP.Net
 

We have developed a financial solution. This solution is a web based asp.net using C#. we use oracle as database. 10+ user use the solution from different location. In this solution we need some serial number like sales entry. In each sales entry make a sequential serial number like 1,2,3.Currently we use oracle sequencer to maintain the serial number. In our code we get the sequence number from oracle database then insert the sales information in the database. But the problem is if there is any error in insert the insert method is role back and the sequence is missed. At the end of the day we get some of the number is not present in the database. Like if there is 1000 sales in the day, sequence goes to 1003. We need such a solution that solves my problem. Please help us.



Regards,




View Complete Post


More Related Resource Links

Analysis of number of objects in a SharePoint application

  
How can I quickly find the following with no custom coding? Number of documents in a SharePoint Applications? Number of lists & libraries?

how to generate a Serial number dynamically in listview

  

hi,

my listview having 3 columns:SI.No,HallticketNo,Name.

I bind data to listview but the "SI.No" column in listview showing Empty data.

So,how to generate serial number in listview ?

pls tell me very urgent.


Many thanks in advance.






Gridview: How to create a column that will autogenerate the serial number of each row

  

Hi all,

I have a gridview and I want to autopopulate the serial number columns. For eg, the gridview has 10 rows. The user deleted the first row. I want the gridview serial number to automatically shift down by one. Ie., 10-->9, 9-->8 and so on.

Can this be done? Any help is much appreciated!


Faulting application , version ,faulting module kernel32.dll

  

Hi, I have one windows application built using C# and .net framework 2.0 and its installed on Windows Server 2003.

I have tested application on my machine and it works perfectly on my machine. Only difference between two machines is that, my machine has Windows Vista OS and machine on which error occured has Windows Server 2003 OS.

When I start application, it works correctly for some time but then gives one error as

Faulting application , version ,faulting module kernel32.dll,version 5.2.3790.4480, stamp , debug? 0. fault address 0x000bef7.

Source : .NET Runtime 2.0 Error Category : None Event ID : 1000

Does anyone knows why this error is coming? I googled for this error but most of the solutions were for either explorer.exe or internet explorer.


Thanks and Regards, Chandrashekhar

How to get the number of running application instances?

  

I need a query that provides the current number of running instances of a client application.
The application is developed on VS2008 (.NET3.5, VB.NET) and accesses an Oracle 10g database via System.Data.OracleClient 2.0.0.0. Here the view SYS.V_$SESSION yields all I need to get the current number of running applications (which is the same as the number of users logged in on each application instance).

I extended the application in order to access the database alternatively hosted on Sql Server 2008 R2 using System.Data.SqlClient 2.0.0.0. The view sys.dm_exec_sessions seems to be an equivalent to Oracles SYS.V_$SESSION but actually it is not!:

  1. Instead of the application name, sys.dm_exec_sessions.program_name yields ".Net SqlClient Data Provider" which is useless information.
  2. After a while all session information is gone although the application is still running.

Serial Port Application Leaks Handle After Exit Forcing Reboot to Clear

  

The application (C# .Net 3.5) available at www.redondowa.com/porttest demonstrates a problem encountered with a Sony VAIO multimedia laptop related to use of its serial modem port.  A discussion with MS support is included in a doc with the VS solution.

If the base stream or port is not closed before nulling the port, the port cannot be recreated and the application leaves the port inaccessible.  The machine requires a reboot to clear the error.  Other machines clear the error without requiring a reboot.

<!-- /* Font Definitions */ @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:"Arial Unicode MS"; mso-font-charset:134; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:1 135135232 16 0 262144 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:"\@SimSun"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:134; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch

would want Serial Number to be given with grouping in Report Viewer

  

I have 2 Grouping levels in my Rdlc file  and i would want the first gorup to be as following

sno  Groupedcolum1 Groupedcolumn2 column3

1              A                     2d                        10

                                       5e                        20

2               B                    1a                        30

3              C          

.NET bug or my fault?: Serial port fail to open from C# because spoolsv.exe and my application try t

  
Dear all,
after browsing around I could not find any answer to my issue.

I'm writing a program in C# to access a serial device. The serial device comes with a legacy DLL probably written in C++ that provides an OpenDevice (which I call via DLLImport). The device is connected to a USB port via a Prolific USB to serial converter.
My problem is that 1 out of 5 times, the OpenDevice fails when I run my application. I have workaround to call it until it succeeds and it never goes beyond 3 or 4 tries.
By monitoring the serial port with Portmon I noticed that:
1) when running the application in debug mode from Visual studio the Com port is open from my process (MyApplication.EXE)
2) when running from windows the Com port communication belongs to windows print spooler service (spoolsv.exe) but Portmon also tracks an open command from MyApplication.EXE and here the collision happens: I'm suprised to see that the main communication from MyApplication is managed by spoolsv.exe so it is not just spoolsv.exe running in the background: I'm calling it!
3) the demo software from the supplier uses the same DLL but it is written in C++ and when I run it, spoolsv.exe does not show up (and open port never fails!)

I do not understand what is the trigger that makes the calls going through spoolsv.exe or directly to the port and

Serial port open fails because application and spoolsv.exe both try to access: Is this a .NET bug or

  
Dear all,
after browsing around I could not find any answer to my issue.

I'm writing a program in C# to access a serial device. The serial device comes with a legacy DLL probably written in C++ that provides an OpenDevice (which I call via DLLImport). The device is connected to a USB port via a Prolific USB to serial converter.
My problem is that 1 out of 5 times, the OpenDevice fails when I run my application. I have workaround to call it until it succeeds and it never goes beyond 3 or 4 tries.
By monitoring the serial port with Portmon I noticed that:
1) when running the application in debug mode from Visual studio the Com port is open from my process (MyApplication.EXE)
2) when running from command line the Com port communication belongs to windows print spooler service (spoolsv.exe) but Portmon also tracks an open command from MyApplication.EXE and here the collision happens: I'm suprised to see that the main communication is managed by spoolsv.exe so it is not just spoolsv.exe running in the background: I'm calling it!
3) the demo software from the supplier uses the same DLL but it is written in C++ and when I run it spoolsv.exe does not show up

Does anybody have an insight on serial port handling in .NET when a legacy DLL and a serial to USB converter are on the path? I would like to connect directly

Microsoft's Collaborative Application Markup Language (CAML) Loop

  
discovered an interesting error recently while working with Microsoft's Collaborative Application Markup Language (CAML) that, surprisingly, had received no ink. Partly what surprises me about this is that the error may require you to rewrite large sections of your code if you haven't previously considered this SharePoint limitation. I'll start with some context, but first of all the error is:

Integrating a Legacy Web Application in SharePoint

  
This month we will continue with the theme of deploying Microsoft's SharePoint as a company intranet by describing a method for integrating a legacy Web application inside a SharePoint site.

In many companies the intranet site is not just a home page with announcements. It houses Web applications used by many different departments. In last month's article, I built a page to search the employee table in Northwind (the sample database included in Microsoft's SQL Server). This month, I will move the Web pages used to add/remove records from the table into the SharePoint intranet.

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

  
The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

High-Performance .NET Application Development & Architecture

  
It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

Application architecture in asp .net

  
Application Architecture is the most important process of developing a good application. Some people tends to jump into coding without any architecture laid. Later we see those people changing the architecture and finally the application had to be developed from the scratch with the correct architecture.

In this article I will describe some details about how you can improve the architecture of you application. This article is targeted to the beginner's audience.

Improving Application Performance in .Net

  
Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Logic behind N -Tier Application Development

  
In the arena of application development, developers all over the world use various programming languages, technical processes, and technical tools. While using number of technical & non technical elements the processes or methods become complex, for simplification of the application development process, developers use various techniques such as dividing the application architecture into layers or parts. In the professional & technical language this separation or division process is called N-Tier Application Development process, where "N" stands for number and "tire" stands for layers or parts.

How to create 3 tier application using LINQ

  
As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)
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