Search results for query: *

Here is my requirement: 1. I have a text box (lets say txtStore), which accepts some integer values. This is a mandatory field. User can just enter an number and if he/she hits enter we need to retrieve some values and display it. 2. Screen also has some other fields, which are mandatory when...

Can some one advise which of the below queries should be prefered over the other and why? Select ItemCode from dbo.ItemStoreAd Where DATEDIFF (D,getdate(),AdEffectiveDate) = 0 Select ItemCode from dbo.ItemStoreAd Where AdEffectiveDate between '2003-07-15' and '2003-07-15 23:59:00'

I have a table, which is build using the databinding. We need to move a row from a particular position to the new position. To acheive this I am using moveRow() method, but it doesn't seem to be working. Wheras if I use this method for a normal table(not build using databinding), things work...

Is there a way to pause the script execution for a specified interval of time.

We have a requirement where we need to display, 3 type of information, which are not related to each other in such a way that the user is able to navigate(first page of the other section) to another set by clicking some link or something. We decided to acheive this in following way: 1. Create 3...

We have a table, which uses data binding to generate the contents of the table. Initially there will be one blak row in the table, which is acheived by binding to a blank xml string(xml schema is same but no values). Later on when the user does something we get the actual xml string and uses it...

I have a DTS package, which has some tasks. Each task is suppose to copy the data from an excel sheet to a table in the database. In case we encounter any error in the execution of any step all the data copied in the previous tasks in already populated. We want to commit the changes only when...

I have a class which have lot of enum defined in it. This class along with other classes(have some functionality) have been packaged in a project and I have created a dll for the project. There is another project where I need to call different methods and need to access the different enumerated...

I have couple of questions regarding the listbox which has the multiselect property = true 1. How do I access all the selected items in the list box. 2. Assume that an item is already selected. Now the user presses the shift key and then click on an item. I should be able to select all the items...

I have 2 tables which have 2 columns in common. I want to get the rows from table 1 for which the combination of 2 columns does not exist in the other table. For e.g: TAB 1 Col1 Col2 1 2 1 3 2 1 2 2 TAB 2 Col1 Col2 1 2 1...

I have to fetch the details of a user whose alias(cdoPR_ACCOUNT) is known. I wrote som code where I used a filter to get only the details of the user for which the alias is known. Instead of exact search the results are fetched like a partial search(if I have passed "pet" I am getting...

what are the guidelines which should be followed while deciding whether to register a dll inside MTS or not. I am looking any gains or loses which could happen if we add or don't add a dll inside MTS.

Can any one provide a list of scenarios when the binary compatibility of a dll is broken. Also if some dlls are refering this dll(binary compatibility is broken) then when they should be recompiled.

We have a requirement where we need to display some excel and word documents on browser. Everything worked perfectly fine untill we started testing the code at client side. At client side the Word/Excel documents are opened as a separate application and are not displayed on the browser. Moreover...

Is there a by which the recompilation of a set of dlls in particular order can be automated. For e.g. I have 3 dlls. 2nd dll has a reference to the 1st dll and the 3rd dll has the reference of both 1st and 2nd. Any change in dll 1 which needs recompilation of dll 1(may be due to code change or...

We are generating some excel and word documents through the VB code and saving them to the hard disk. But when we observed the Task Manager we found many instances of WinWord.exe and Excel.exe running. Can any body tell what are the possible reasons for this problem.

I have 3 classes: Class 1(Not an MTS Object) Class 2(Requires Transaction) Class 3(Supports Transaction) All the three are part of one dll which is registered under MTS. I have to test a simple roll back functionality, In which My class 3 is updating a database table and the class 2 should...

I have a Stored Procedure which uses dynamic query. The query is build based on the parameters passed to the SP. The Sp expects 10 parameters and based on the values the query is build. I wanted to know if there is a way by which I can automate the testing of this SP, i.e. to say that I specify...

Is there a way by which I can find when a particular Stored Procedure is modified?

I have to call an exe with parameters in the VBScript, How do i do that???