You can use a static field to keep track of the window state. When the window opens set the field to true. When the window closes set it to false. Check the field before trying to show another copy. Another way is to just to use ShowDialog() I don't know if that works for you.

Sreeji, Thank you very much. I appreciate your help. :) ====== code proj. rocks!

You could add another SQL task to your DTS package which would execute a "TRUNCATE TABLE " before your datapump step.

After doing try catch within the error block I caught such exception: System.Data.SqlClient.SqlException: @dtExpireDate is not a parameter for procedure pr_EditTreatInstrument. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at.... so on and when I excluded @dtExpireDate, then I see exception like System.Data.SqlClient.SqlException: Procedure 'pr_EditTreatInstrument' excepts parameter '@dtExpireDate', which was not supplied. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at... so on Thank you, Sudee ====== You need a head to program. Cool, fast and sharp.

Yes, plenty. 1. It's pointless. All you're doing is printing a string. Why not just generate the string at the caller? 2. variable @sql is not needed. you could just "print 'insert into ... " 3. It won't work. You need to CONVERT(varchar(10),@intid) before you can use it as a varchar. 4. You're mixing nvarchar and varchar. and implicitly casting nvarchar to varchar, thus negating the whole point of using nvarchar in the first place. 5. I think hungarian notation in a database is evil. 6. The main point of stored procedures is that they're compiled and hence more efficient. You're not leveraging that efficiency at all here. jon #include <beer.h>

Are you getting an exception? Do you have a comboBox2.DataBind() anywhere in there?

sorry! ====== You need a head to program. Cool, fast and sharp.

Our solution is to use an abstract or relative drive letter. We either map or 'subst' a drive letter to a development folder. In our case the root of all development is called 'Home', and we 'subst' S: (as in 'source') to a sub-directory of \Home (this allows for different technologies to all be under \Home). You always work relative from S:. You add files to projects from S:, and you check in and out of CVS or VSS from S: You will always find project, solution, and build files etc. reference S: (relative) and never ever reference C: or D: (absolute).

You can do like this dt = new DateTime(dt.Year, dt.Month, dt.Day, 5, 0, 0);

umm. I guess it's a browser problem. someday suggest me abt IFrame technique. let me first try that if not then pop-up window is a go. thnks again. Some dudes gotta know how to develop a prg. and some dudes just never get it at all.

thanks Andy, Some dudes gotta know how to develop a prg. and some dudes just never get it at all.