Search Result

I have form1 which has 3 types of something called as WO.Now, when I click on a 'closed WO' form2 opens displaying details.And when I click the back button, it takes atleast 2 minutes to go back to form1.However, this is not the case with Overdue and Open WO and the perfomance is good.

• form1 has has queries which are run everytime a WO button is clicked.
• There is more data for Closed WO than that for Open or Overdue WO.
• form2 dispays detail

...

I've been tasked with the following, and am looking for some ideas. Importing Excel Files into SQl Server 2005.
1) The data needs to be harmonized as it is coming from many different branch offices. For example: I will need to truncate fields in Excel, convert different methods of writing currencies (periods instead of commas to denote thousands and millions).

2) I am also interested in getting some feedback report on things that...

Hi I am using these: ASP.Net 2.0 with VB.Net, Visual Studio 2005, SQL Server 2005

I suspect, there is something missing in BLL class.

I created the ASP.Net form also and checked whether it is working or not. When I submit after entering the data, an error comes.



Please help me to solve this problem. Thanks

The details below:

I have created a store procedure...

Hi, I am using these: ASP.Net 2.0, VB.Net, Visual Studio 2005, SQL Server 2005

In a asp.net page, I have two multiview controls each has 2 views & its corresponding 2 menu items named Metric & Imperial. Individually both works fine.

But when I click "Metric", the other "Metric" should also be switched on and vice-versa for Imperial. How to achieve that?

The catch here is, one of the...

Hi, I am using these: ASP.Net 2.0, VB.Net, Visual Studio 2005, SQL Server 2005, Objectdatasourc e using DAL & BLL classes

My objectdatasourc e can produce below output by CategoryID parameter: (stored procedure: GetProductsByCa tegoryID )

CategoryID | CollectionID | ProductID | CategoryName | CollectionName | ProductName | ProductPhoto

1 1 3 XYZ ...

Hi I am using these: ASP.Net 2.0, VB.Net, Visual Studio 2005, SQL Server 2005, Formview controls

In a ASP.Net form I have 20 textboxes and 20 dropdownlists(d dl). All ddl(s) are databound and get the data from a single objectdatasourc e. All textboxes and ddl(s) support null values. Textboxes are for entering numbers and ddl(s) are for selecting the unit (mm, cm, in, m3, oz, qt like these.).

I am using the below code to achieve...

Hi, I am trying the following SQL to fetch the needed data. The query works in query analyzer in SQL Server 2005. But in data adapter in a dataset in Visual Studio 2005, I am getting the data with all other empty cells. What mistake I am doing? The expected result is only a concatenated value (~/images/logos/Somelogo.jpg)

...

[SQLServer]Violation of UNIQUE KEY constraint 'IX_surveyQuest ions'. Cannot insert duplicate key in object 'dbo.surveyQues tions'.

This might seem like a simple matter of trying to insert a row with ID=20 when there's already one with that ID, but the problem is a bit more complicated. The table is supposed to auto-increment the value for the primary key when a new record is inserted. But no matter what I do, I can't seem to insert...