Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wooody1245
  • Content: Threads
  • Order by date
  1. wooody1245

    Editable DataGrid

    I have an application with several DataGrids. The grids are populated from DataSets returned from a webservice. I would like to allow the users to edit/add the data within the grid and then apply those changes to the database. What is the best way to approach this?
  2. wooody1245

    HCFA 1500 Form

    Has anyone ever designed a crystal report to mimic a HCFA 1500 form? Do you know where I can download a crystal reports version of the HCFA 1500 form?
  3. wooody1245

    Does OR effect index

    I have a store procedure to pull data from two different tables. This is a simplified version of the stored procedure: select t1.fname, t1.lname, address from table1 t1 inner join table2 t2 on t1.member_id = t2.member_id where (table1.fname like @fname or table2.fname like @fname) and...
  4. wooody1245

    Slow Stored Procedure (sometimes)

    I've got a stored procedure that feeds a Crystal Report that is sometimes very slow and sometimes very fast. When I run the stored procedure using Query Analyzer, it only takes about 10 seconds to return 7 to 10 thousand records. When I run the Crystal Report, it takes about 5 minutes to get...
  5. wooody1245

    DataGridView date format

    I have a DataGridView that gets its data from a DataSet. Everything looks great except for the dates. All dates are formatted like this 2007-06-08T09:58:46.33-05:00. I would like to display the date like this: 06/08/2007 09:58 AM. I've tried formatting the datetime within the SQL query but I'm...
  6. wooody1245

    Web services not working on Vista

    I have a C# application that consumes a web service. It works great on Win 2000 or XP, but not on Vista. Some calls to the web service will work. But when the web service function returns a DataSet it will not work. I eventually get a timeout error. If the function returns an empty DataSet...
  7. wooody1245

    Crystal Reports Web Service

    I have an ASP.NET web service project that consists of a bunch of Crystal Reports. Everything works perfectly, but when I modify one of the reports I am forced to remove the old report, add in the new one and recompile. Is there a setting or modification to the project that I can do that will...
  8. wooody1245

    select top @variable

    Is there a way that I can use a variable in a select top statement like the one below? select top @max_results from my_table where column1 = @variable I'm passing @max_results to a stored procedure to limit the number of rows returned.
  9. wooody1245

    stored procedure time out

    I have a fairly simple stored procedure. It does a select count(*) and based on the count it inserts a record into one of two tables. The problem is the procedure takes one and a half minutes to run causing my program to issue a time-out error. It used to only take 1 to 2 seconds. After the...

Part and Inventory Search

Back
Top