Search results for query: *

Hi All, We are developing an intranet based web application which deals with huge amount of data. To explain it better, the application has a calculation process which adds nearly 30 million rows in a table for a user. There can be multiple users accessing the application and performing similar...

I want to store xml in a table. Let's say I have following xml: <Root> <Row> <Col1>Val1</Col1> <Col2>Val1</Col2> </Row> <Row> <Col1>Val2</Col1> <Col2>Val2</Col2> </Row> </Root> Is it possible to use OpenXML to insert each <Row>...</Row> as a single row in table? In the above example I want to...

Hi, We are working to develop one analysis tool which has reporting capabilities. Reports are developed in HTML. we need to add a feature of export to PDf. since reports provide pagination feature and in the pdf we need to show all pages. What are different options for it? Thanks Varsha

Hi, Is use of typed arraylist versus typed collection is preferred? I'm using for transferring data from one application domain to other. Please clarify. Thanks Varsha

Is there any way to specify any column as encrypted in SQL server 2000? We have the requirement of storing passwords in the table and we want to store enrypted values of the passwords. Any pointers will be appreciated! Thanks Varsha

Hi, We have a batch file which needs to be executed from query analyzer. We are trying to do this using xp_cmdshell. It does not seem to be working. When I run the .bat file through command prompt, it transfers the data and logs the trace in the file, as per expectation. With xp_cmdshell, it is...

Hi All, We have a requirement to change colour of all buttons and controls on the form throughout the application. I know we can easily do this in the web applications using stylesheets. Is there anything similar to stylesheets in desktop applications which can be used to change te colour of the...

Hi All, We are using ExecuteReader method of the SQlCommand object with the option of CommandBehavior.SchemaOnly. It works perfectly fine to get the schema of the columns in the resultset. I am facing problem in fetching schema information of the temp tables(Created using #temp syntax). It...

Hi, How can I find out that a windows PC already has an instance of MSDE? Our requirement is to include setup of MSDE in the application exe and launch the exe if MSDE is not installed. If it is already installed, we need to skip the process of installation of MSDE on the computer. Any...

Hi, We have a requirement of building a standalone desktop application using windows forms. There is another requirement of applying automatic updates of the application(in case there is any change) on the application. We have seen this happening in the windows media player and Windows XP. How...

Suppose I have a table A with two colums - col1 (number) primary key and col2(Varchar(100)). If I insert a row into this table. Can we get value of last inserted value in the column col1 of this table using @@identity. As far as my understantding goes @@identity can be used for identity columns...

Hi, Can anybody tell me advantage of structured error handling using Try Catch block over unstructured exception handling? Thanks Varsha

We are having a table where we are storing some values and an asociated operator with each value. We will be using the value and the operator along with a comparison value and would like to know the result at run time. For e.g. let's say the entry in the table is: 30 >= and the comparison...

Hi, Is there any way of finding out about the free space required in the database? Our production database is facing performance problem when the data grows and it becomes slow till the time we do Shrink database. Our problem is, we need to find out the optimum value of target_size which is...

We are doing migration of an existing asp application to asp.net application. We need to migrate only a portion of the existing application to .net. In one of the migrated pages we need to access value of a session, which is getting set through ASP page. Can anyone tell the way how to get...

We are doing migration for a VB application in which we need to migrate ADO objects to ADO.Net objects. Has anybody used any such wrapper that gives feature of ADO and is implemented in ADO.Net? THanks Varsha

Hi, I've two stylesheets - a.css and b.css. There are some classes like glbLink and glbLinkBold which are present in the both the css files. I've added these two files in the HTML of c.aspx. c.aspx uses glbLink and glbLinkBold in the form. My doubt is, from where it will pick up glbLink and...

Hi, Can anybody suggest different approaches for procedding for ADO to ADO.Net migration? Thanks Varsha

I Have a search page, where user can enter search criteria and based on a specific selection. If user has seleted a particular criteria then I need to process the search criteria selected and open a modal window. Currently I am doing this operation onclick of a button, where I process the search...

If some body has used collections in Stored Procedures Please provide some examples to me. I also require reference materials and examples for exception handling in Bulk processing. Thanks Varsha