hi, Can anyone let me know whether, I can manually compile an entire asp.net project or solution to give a single DLL, without vs.net? Which normally vs.net does, when the project is compiled to give a single DLL. Thanks in Advance, Murugavel S :)

Instead of selecting @@Identity use SCOPE_IDENTITY(). Eventhough, it returns values inserted into IDENTITY columns, SCOPE_IDENTITY will return the value of scope on which executed. For further reference, Visit SQL books online on MSDN Cheers ;)

pls provide info n whether u r using a Recordset object or command object. Or tell me using which object you are inserting the recors. Cheers ;)

DataRow represents a single row of a datatable. i.e to display / insert a single row of a datatable. DataColumn represents a single column of a datatable. A new column can be created in the datatable in otherwords to create the schema of Datatable. You can set Constraints, Identity, Null/Not Null. Now, datarow can be used to create a new row in a datacolumn. Basically, think the above two as equivalent to the action that you carry out in your database server. Cheers ;)

It is always safe to destroy an object, which you do not need them any more. Moreover, the new keyword with Dim statements will initialize the associated object immediately and it will reside in the memory as long as the sub/function/module or project's scope. Cheers ;)

Use System.IO.Directory and its "Move" method to move the entire contents. If you are specific about the file types use "Getfiles" method and get them into a string array and copy them. Cheers ;)

Create the DB manually. Use sql files to create tables, sp's, Udd's and functions. Now, write these sql file names in a batch(*.bat) file with isql utility(not isqlw) and with connection parameters as specified by MSDN (refer SQL Server Books Online). Double click this batch program to do your setup program. Cheers;)

use "runat=server" for the text1 control to get the value in the codebehind file Cheers;)

If you have a tab order problem then set the tabindex property. For those control for which u do not want the control to go, set its tabindex property to -1 Moreover, just make sure that in your HTML design, all the controls are set one next to another accordingly. Ensuring this, you need not have to tabindex property. Hope this solves your problem. Cheers;)

Add the following javascript function to your .aspx page. In the textbox control add onkeypress="return Textbox1KeyPress(event)" in .aspx file. function Textbox1KeyPress(event) { var Decimal = 46 var DeciPlaces = 4 var AllowNegative = false var myString = new String(event.srcElement.value); var pntPos = myString.indexOf(String.fromCharCode(Decimal)); var keyChar = window.event.keyCode; if ((keyChar < 48) || (keyChar > 57)) { if (keyChar == Decimal) { if ((pntPos != -1) || (DeciPlaces < 1)) { return false; } return true; } else if (((keyChar == 45) && (!AllowNegative || myString.length != 0)) || (keyChar != 45)) {return false;} } return true; } This is a multipurpose function and will check for decimal places and negative values. Set the maxlength attribute to limit the input values for the textbox. Cheers;) </x-turndown>

Thanks for the reply I accept this, but i found this being changed for a textbox or asp:label or asp validators. It should be noted that, these are not implemented with any datagrid or related controls. Thanks in advance :)

try implementing with clientside events. Organizing the code in such a way to handle few issues in client and then to server. Hope this will be useful Do you have any specific requirements on this ? :)

Write an sp to return multiple recordsets-> this avoids multiple roundtrips asp.net page to database(if you have followed this way). Try to filter the records returned as much as possible or limit the no of records to be displayed.

Can any one let me know how the server control ID is prefixed with "_ctl0_". Any settings are required in asp.net? I am curious about this, as i found this to be useful and planning to implement in my application Thanks in Advance :)