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?
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...
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 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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.