Search results for query: *

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.

Take the code inside the click event function and put it into its own function. Then call this function whenever you need it.

You could just pull out the value from the dataset. Like this: textBox1.Text = ds.Tables[0].Rows[0] I always assign the tables a name when using da.fill. da.Fill(ds,"table_name"); This allows you to access the tables by name.

Is Session_ID an integer? Maybe you should try using sessionReader.GetValue(0) instead of sessionReader.GetInt32(0);

I'm guessing that dsfiles is a DataSet? You could run a for loop like this: for(int i = 0; i < dsfiles.Tables["files"].Rows.Count; i++){ dsfiles.Tables["files"].Rows[i]["column name"].ToString(); } You would need to plug in your column instead of "column name"].

I'm working on getting sp_help on the tables and posting the procedure. I just noticed another thing with this database. When I add or modify a stored procedure, it takes 1:50 seconds to complete. This is almost exactly the same time it takes my problematic stored procedure to complete. This...