Thanks for that RobyV. However, I prefer to abstract DB functions from the UI. One reason is for reusability, another is for the performance of stored procedures. So this implementation would not work for me.
Thanks again for the time spent answering though!
cbellew
Last Activity: Jun 7 '10, 04:50 AM
Joined: Sep 13 '07
Location:
-
ExecuteNonQuery always 0 :(
Hi guys,
I have a weird problem - I wonder if someone could spare a second for me. I have posted this exact question in the SQL Server forum but was advised to post it here instead.
I am running a DELETE statement inside a T-SQL Stored Procedure (for my C# .NET application). It's as simple as they get.
...Code:DELETE FROM groupPromotionRequests WHERE groupPromotionRequestId = @requestId;
Last edited by tlhintoq; Feb 10 '10, 12:36 PM. Reason: [CODE] ...Your code goes between code tags [/CODE] -
OK, thanks for your help - i'll post it over there.
I'm not totally convinced you are correct in saying it is an error code. Please see these two pages.
http://technet.microsoft.com/en-us/l.../ms187316.aspx
http://msdn.microsoft.com/en-us/libr...enonquery.aspx...Leave a comment:
-
Sorry for not being so clear in the question and its title.
I am really asking for why ExecuteNonQuery () returns 0. I have run the procedure in Management Studio and have got the message '1 row affected' (this indicates that @@ROWCOUNT is indeed working). Then when I replace the single row that was deleted and try with ExecuteNonQuery (), the return is 0.Leave a comment:
-
@@ROWCOUNT always 0 :(
Hi guys,
I have a weird problem - I wonder if someone could spare a second for me.
I am running a DELETE statement inside a T-SQL Stored Procedure (for my C# .NET application). It's as simple as they get.
DELETE
FROM groupPromotionR equests
WHERE groupPromotionR equestId = @requestId;
However, when I call ExecuteNonQuery () I always get back 0. I have tried...... -
Hi ,
Thanks for your posting about the convertion ie site to project
=:)
Rathinakumar B -
Even Better!
Right click on the file and choose "Convert to Web Application" - feel a bit silly now!
ThanksLeave a comment:
-
Sorted.
Turned out i wasn't aware that in "ASP .NET Web Application" projects there needed to be both .cs and .designer for each page. I created a new page by going to add item and the correct .designer page was created, so i copied the code from the old version, deleted the old version and recompiled and it worked!
Thanks anyway :)Leave a comment:
-
Control does not exist in the current context
G'day,
I have encontered what appears to be a common problem, but unfortunately the typical solution i have found has not worked for me.
I have just copied the files from an "ASP .NET Web Site" to an "ASP .NET Web Application" because i have learned about the differences and have decided to move to the latter. I simply copied and pasted all the .aspx (with respective .aspx.cs code-behind files) and some... -
Run master page code from content page
Hello, i wonder if someone can help me with this problem...
I have a master page with some objects and i want to be able to access the objects from a content page. I have set up the Master and MasterType parameters and can see the objects and choose methods when programming in the content page but when the website is built i get an error saying...
Error 20 'System.Web.UI. MasterPage' does not contain a definition for... -
ah, thanks again.
ChrisLeave a comment:
-
OK, i'll take a look - have not heard of them before but sounds like the answer.
ThanksLeave a comment:
-
Run code in included aspx file
Hi there,
I wonder if anyone can help me with my problem...
I have a website in which a "header.asp x" is included the top of all the standard web pages. Inside this header file i would like to include code to manipulate what is shown from inside this "header.asp x" file. Is this possible?
I would like to run the following each time a page is called. The "headermenu " is a div in...Last edited by Frinavale; Apr 21 '09, 01:28 PM. Reason: Added code tags. Please post code in [code] [/code] tags -
Almost answering my own question. For anyone needing this try taking the souce from these two select examples (one is roughly by continent, the other is by country)
http://www.timezonecon verter.com/cgi-bin/tzc.tzc
http://www.timezonecon verter.com/cgi-bin/tzc.tzc?style=2
Any other examples would still be appreciated though. Such as options with (GMT+2) or similar included would be fantastic.
Thanks,...Leave a comment:
-
Looking for a complete HTML SELECT for the PEAR Date Class
Hi Guys,
I've had a good look around but i can't seem to find what I am looking for. It's the HTML code for a SELECT (with all OPTIONs included) for the PEAR "Date" Class. I need it so that my users can select the timezone that they are in from the select and the resulting value would be directly understandable by the Date Class.
It strikes me that displaying time in different locations on web pages must... -
Importing contacts from Hotmail, yahoo etc
Hi guys,
Was wondering if anyone knew of a script or already made classes for the Hotmail Contacts API etc. I have been trying for ages to get it working but i keep getting 400 error codes!
Thanks,
Chris -
FileReference bytesLoaded - incorrect value?
Hi guys, i wonder if anyone could help me with my problem.
Basically, i am creating a file upload tool in as3. I am using a FileReference object, calling browse() and then upload(). I have an event listener catching ProgressEvent.P ROGRESS Events and using ProgressEvent.b ytesLoaded to update a progress bar.
The bar works fine, but i only get expected results when the swf and receiving php script are both local. I.E.... -
Thanks, i thought as much, i will keep trying to figure it out myself.Leave a comment:
-
Two ajax functions on one page? mine are fighting!
Hi guys,
Let me just introduce my problem - i hope someone will be able to help! I have an index page for my site where i want the user to have the choice to view a login form or registration form. I have index.php with two links ("Click to login", "Click to Register"). I want to use ajax so that the user can switch between the forms without having to load the page. At the moment i have the forms stored in seperate... -
Ok, sure, thanks anyway!
I have a main form titled 'Data Entry Form' with EmployeeDetails as the record source. Inside this form i have three subforms; 'Diseases subform', 'MRSA Subform and 'Needle Stick subform' with respective record sources; DiseaseHistory, MRSADetails and NeedleStick. These three tables are all linked to the EmployeeDetails table via one-to-one relationships (for several reasons). They all have the 'ID' field...Leave a comment:
No activity results to display
Leave a comment: