May be this Link helps u a bit: http://www.xmlforasp.net/CodeBank.aspx?codeType=xml[^] Amit Agarwal

John Sundar wrote: once if its go for "CATCH" block, how it can proceed others? i.e, if record 2 fails, will it proceed other records and complete the whole FOR loop???? The try/catch block is within the body of the loop. If an error occurs during one iteration of the loop, it will be caught and the code will proceed to subsequent iterations. John Sundar wrote: i tried.. but getting error... You need to post details of the error if you want help. We're not mindreaders. John Sundar wrote: how to achieve it? Post details of your error, and maybe you'll get some help. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

once if its go for "CATCH" block, how it can proceed others? i.e, if record 2 fails, will it proceed other records and complete the whole FOR loop???? i tried.. but getting error... how to achieve it? thanks in advance and understanding....

I found the answer in query itself sandeep... just refer it SELECT REPLACE(CONVERT(VARCHAR, column_name, 106), ' ', '-') as "column 1" from tbl_name :) Take care...

This seems incredibly nasty, but I'd say if you need to do this, your best bet is to set what path leads to a particular control, in your resources, and swap resource files as needed. As someone else said, odds are you need to name the classes the same if you want to be able to use them when you swap them out like this. OR a better idea again is to simply define an interface that the controls you're using will have in common and access them via that interface. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

John Sundar wrote: the record is to store in a log file (.txt). how to implement.? Try Googling log4net led mike

Hi, I think u have to use dream weaver for that. I don't know exactly but It is possible. so just go thru it. best of luck Rana Krishnraj

S laddie

You can never do that. They are client side events.

John Sundar wrote: ITS URGENT! How impolite :| "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

thanks bright :-D

thanks navaneeth

thanks a lot krish-KP... can i have it for DATETIME field also? i.e.. when the DATETIME field is EMPTY or 1/1/1900, it should be of . how to achieve it? - KARAN

If you have full control of the application's source code, a better solution than a Trigger would be to check the value in the application code for 1/1/1900. If it matches 1/1/1900, then set the parameter value for your SqlParameter object to DbNull.Value instead of the actual datatime value. If you aren't using SqlParameter objects (which you should be) then set the value of the string to "NULL". Example 1: using(SqlCommand cmd = new SqlCommand(.. set ctor arguments ..)){ // setup cmd object cmd.Properties.Add("@date", SqlDbType.DateTime); if(myDateVariable.ToShortDateString() == "1/1/1900") cmd.Properties["@date"] = DbNull.Value; else cmd.Properties["@date"] = myDateVariable; } Example 2: StringBuilder sql = new StringBuilder("INSERT INTO myTable(dateColumn) VALUES("); if(myDateVariable.ToShortDateString() == "1/1/1900") sql.Append("NULL"); else sql.Append(String.Format("'{0}'", myDateVariable)); NOTE: The second example will expose you to Sql Injection attacks if the value you are concatenating to your SQL statement is a String variable, so I recommend the first method for all SQL statements. Mark's blog: developMENTALmadness.blogspot.com

No pals here to answer this question in this site? :laugh:

No pals here to answer this question in this site? :laugh: :-D

That is the problem with some questions here, not giving all the information at first. First it was an autonumber problem, then adding text, now we have years and a set range. Use a singleton object to access the database and assign numbers. Unless there are still more requirements that you have yet devulge. only two letters away from being an asset

Simply incrrease th z-index of the menu items in the style attribute, or decrease the z-index of the textbox or other form items that troubles u for overlapping. Bijay Bhaskar Deo Thanks & Regard

I know you don't care about the 1 voters, but I hate seeing a decent response in grey.. voted 5 to even the score!