Recent content by wooody1245

I have spent hours searching online but most of the sites are discussing the ASP DataGrid. I need to do this inside of an application. I have yet to find a decent way to accomplish this within an application. I was hoping to find someone who had actually done this before.

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?

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?

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...

SQLSister, thanks for pointing me to George's comments about parameter sniffing. George, you are a genius. I googled parameter sniffing and found this article http://omnibuzz-sql.blogspot.com/2006/11/parameter-sniffing-stored-procedures.html I created local variables and assigned the input...

I'm not concerned at all about the stored procedure taking 10 seconds to complete. I'm much more concerned about the 5 minutes it takes to run when called from Crystal Reports. I would be grateful if it only took 30 seconds to complete. I would post the stored procedure but it is fairly long...

I tried updating the statistics and the crystal report ran perfectly for about an hour. Now it's back to taking 5 minutes to run. I updated the statistics again but it did not help at all this time. Any other ideas?

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...

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...

I finally found a solution. I changed the autotuning feature in vista and my programs work perfectly. From an administrator command prompt type: netsh int tcp set global autotuninglevel=highlyrestricted Here are a couple of links about this new feature...

Ok, I've done some more testing and discovered a few things. The web service will work correctly if the dataset only contains one table with a few rows (2 or 3 rows). I also changed the function to return an XML string. If the string is very short, it will work properly. But a longer string...

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...

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...

I used bboffin's solution, but if I had it to do again I would use mrdenny's solution. It took me a while to get the string formatted properly. Thanks for the suggestions!

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.