Displaying leading/trailing zero in text box
Hi, I have many text boxes to input numeric values in the form. The problem is when my text box lost its focus , if any numeric value entered in text box without any dismal place will automatically display 2 dismal zero. Else if no values entered in the text box it should display 0.00 value in it ....
What is diffrence between debug.Trace and trace.Write?Where is the information of debug stored?
Debug and Trace both are used to display messages. However Debug won't work in Release mode.
Debug information stores in .pdb file.
PDB stands for Project DataBase.
Debug.write is not compiled and they are meant only for debug builds.
Trace.write is compiled and can be used in Debug and Release builds of the Applications
Explain about rowstate in a dataset table?
contd...A newly created DataRow has its RowState set to Detached until it is added to the DataRowCollection via the DataRowcollection::Add method. The RowState is initialized to Added until ...
It is the current state of the row w.r.t. its relationship to the DataRowCollection.THe value of Rowstate is dependent on the method DataRow.AcceptChanges
What is meant my datarow versioning in ADO.Net. Where it is used?
Read Best Answer
Editorial / Best Answer
Answered by: Lavanyaaru
View all questions by Lavanyaaru View all answers by Lavanyaaru
Member Since Jan-2008 | Answered On : Jan 29th, 2008
There are 3 versions for each DataRow object.
1.Original
2.Current
3.Proposed
The HasVersion( ) method of the DataRow can determine whether a specific version of the row exists. If the version exists, column values for it can be retrieved using one of the three overloads of the DataRow indexer
The Original version contains the values that were loaded into the row.
The Current version contains the latest version of the data, including the changes made since the data was originally loaded. The Original version isn't available for newly created rows.
A Proposed row version is made available while the row is in edit mode and contains the changes that have been made to the row while it was in edit mode
If CancelEdit( ) , RejectChanges() methods are called, the values in the Proposed version are simply discarded
There are 3 versions for each DataRow object.1.Original2.Current3.ProposedThe HasVersion( ) method of the DataRow can determine whether a specific version of the row exists. If the version e...
How many records can take clustured index in SQL server
Read Best Answer
Editorial / Best Answer
Answered by: vvijaychandra
Answered On : Jun 22nd, 2006a clustered index is a special type of index that reorders the way the records in the table are physically stored . therefore the table can have only one clustered index.
FYI..Clustered index is something that deals with the columns but not the records.These define the physical sorting of the rows in the database in the storage media.A database table can have utmost on...
A clustered index is a special type of index that reorders the way records in the table are physically stored. Clustered index is created by default when we create a primary key on a column.Everyone k...
What is the difference between excute query and excute nonquery.?
: execute query is used for DDL commands whereas execute nonquery for DML.
In ADO.net for Command Object you have 3 methods
1.ExecuteReader - Select statements
2.ExecuteNonQuery - DML statements(Insert,Update and Delete) - Returns Number of rows affected
3.ExecuteScalar - Returns a single value from Aggregate functions like SUM,AVG,COUNT etc
Name some of the asp components?
• ad rotator component – a way to manage advertisements on the web site. • content linker component – a technique to direct users through a set of pages on a web site by creating a list of urls and description of the next and previous pages. • browser capabilities component – allows to customize the...
Content RotatorThe ASP Content Rotator component creates a ContentRotator object that displays a different HTML content string each time a user enters or refreshes a page. A text file, called the Cont...
What type of recordsets are available in ADO?
Dynaset
Snapshot
Dynamic
Table type
Forward only
dynaset
Snapshot
dynamic
table type
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
Write the below code in the lost focus event
text1,text = format(val(text1.text), "0.00")