SQL Server :: Set A Flag On Successful Update Of A Record?
Nov 9, 2010
I am having a problem with setting a flag on sucessful completion of a record in a stored proc. I am using following code. stored proc: Update where condition.
if @@RowCount=1
update table
set ItemReviewed=1
where condition.....
select @Count=@@rowcount
here the problem is i do have 2 update statments in a single proc..if one is sucessful then its setting if others failed...I want to check both are sucessful. @count will return the bool to my code where i can move on to the next record. if some testing @@rowcount is not feasible one to use...Itemreviewed is bit field.
I have the query to retrieve selected record in textbox. How to use this query to update record: I want when I enter sumit in textbox1 and click submit button then the record with ID 1 will be updated to name sumit
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True") Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT TOP 1 Name FROM Table1 Order by Id DESC", SQLData) SQLData.Open() Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader() If dtrReader.HasRows Then While dtrReader.Read() TextBox1.Text = dtrReader("Name") End While Else Response.Write("No customer found for the supplied ID.") End If dtrReader.Close() SQLData.Close()
I am getting the following error when I try to update my record in a GridView. I am using a DataObjectSource and its grabbing the update from a DAL. This is the error:Index (zero based) must be greater than or equal to zero and less than the size of the argument list.This is my code where it says the error is:
I can't for the life of me remember how to do this and I'm sure someone will answer this pretty quickly. I need to insert or update a record based on if it exists so in the SP I need to do:
SELECT * FROM table1 WHERE LinkedID = @ID Then I need to check if any rows were returned and apply it to an if statement which is where my mind is blocked.
I'm having trouble with an SQL statement. I want to have one statement that checks to see if it a record exists. If it does, then update it and if it doesnt then insert a new one in the server. Here is what I have so far:
public int InsertCompanyDetailsInformation(int companyId, int bankId, int accountNo, string accountType) { int rowsAffected = -1; int returnValue; try { SqlConnection con = DBProvider.GetDbConnection(); using (con) { con.Open(); SqlCommand objCmd = new SqlCommand("dbo.sp_InsertCompanyDetailsInformation", con); objCmd.CommandType = CommandType.StoredProcedure; objCmd.Parameters.AddWithValue("@companyId", companyId); objCmd.Parameters.AddWithValue("@bankId", bankId); objCmd.Parameters.AddWithValue("@accountNo", accountNo); objCmd.Parameters.AddWithValue("@accountType", accountType); rowsAffected = objCmd.ExecuteNonQuery(); SqlParameter sqlParam = objCmd.Parameters.Add("@insert_flag", SqlDbType.Int); objCmd.Parameters["@insert_flag"].Direction = ParameterDirection.ReturnValue; returnValue = int.Parse(objCmd.Parameters["@insert_flag"].Value.ToString()); con.Close(); } } catch (Exception ex) { throw ex; } return rowsAffected; } and stored procedure USE [SGTime_Development] GO /****** Object: StoredProcedure [dbo].[sp_InsertCompanyDetailsInformation] Script Date: 01/04/2011 14:31:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_InsertCompanyDetailsInformation] ( @companyId int, @bankId int, @accountNo int, @accountType varchar(50)) AS BEGIN SET NOCOUNT ON; declare @insert_flag int; if not exists(select AccountNo from [Company_Account_Details] where AccountNo=@accountNo) begin INSERT INTO [Company_Account_Details] ( Company_Id, BankID, AccountNo, AccountType) values (@companyId, @bankId, @accountNo, @accountType) set @insert_flag=1; END else begin set @insert_flag=-1; end return @insert_flag; end
I am getting error in the code i want return returnValue in InsertCompanyDetailsInformation. how we can return returnValue
I have a strange issue with the FormView. After working through some issues getting the update to work (as this is my first experience with FormViews) I now have a new issue. After I perform an update, and the FormView updates and returns to read mode, if I hit F5 (refresh) the FormView performs another update to the datasource, despite the fact it is read-only mode and none of the fields on the screen are editable.
I would think that a refresh in read mode for the FormView after an edit would simply refresh the data from the database, not perform another update. Again, the FormView is in Read Only Mode, but a refresh is creating another Update event (which I can debug and see if I break in the ItemUpdating event). This only happens after I perform an edit, not when the page initially loads.
I have never created my own solution before now. I have always modified existing solutions and know how to do it. For some reason, this new solution isn't connecting to my SQL server correctly.
I am using VWD 2008 Express Edition.
I have MSSQL 2008 Developer Edition.
I have used aspnet_regsql.exe to create the tables in my SQL DB.
I have added the following to my webconfig:
[Code]....
But for some reason, when I try to use the Web Site Administration Tool it thinks it is not setup.
I have a website where i already have User / Roles mechanism. What i am after is the if user update certain record i will include his username against that record thats easy enough. But if that row have multiple coulmns i want to save which coulmn he/she updated?How can i compare old and new data have save this information?
I have written a script to write several values to an Access Database Table, but I need to ammend i so it checks for two values (Asset and LName) to see if they match if they do it updates the record if not it writes a new record, my script so far is as follows :
[Code]....
I'm just stuck as I can't work out the best way to do it,
I have read alots of articles from fourms such as belowhttp://forums.asp.net/t/1346690.aspxhttp://forums.asp.net/t/1489818.aspxhttp://forums.asp.net/p/1426153/3189859.aspx#3189859
i've currently got a registration form that works fully however i've run into a problem getting the validation text to appear. basically i want the form to present the following message "Congrats you are now registered and can login using the login page" only if all the fields in it are filled in. However with what i have coded below it always presents the message, i am using asp.net 2.0 with webmatrix.
I use the following coding to show a form for receiving the original record and it works:
[Code]....
And then I set the controller for edit page as the following:
[Code]....
Although it does not show any error and return to the index page, it cannot update the record because I can see the original record in the index page. Is there any mistakes I made?
I have tested the record insertion and it works. Therefore, I think it is not the problem on the database write permission.
I've been playing around with MVC lately, and was wondering how you could do this:
I have a view that displays a list of products, and against each product is a list of categories (in a combobox). I'm trying to find out how you can update a product's category when you select a category in the list. I know you could do something fairly simple with jQuery, but I'm trying to understand how submitting forms works with MVC.
Here's what I currently have:
[Code]....
But I'm not sure how to tell the controller what product needs to be updated when the form is submitted.
I clicked the edit link button the "test" will shown in the textbox.I am change to "testing" and i will click the Update button.But it store in test.i update datetime also.The datetime has been updated..How to i update the record?..
Reason: The Form again post.So i enter with the "state=edit" and the data retrieve from the DB i will shown in the Field.After the Updation function is working.So the textbox value set into the DB value.
We have a simple SQL Server database with an ASP.NET front end.
I can easily update a record from my browser.
Another person cannot: he edits the field and hits the "update" button, but the change is not propagated to the database. The old value remains. He is using Internet Explorer. I checked the database, and his change is not propagated. There is no error thrown.
He WAS able to edit in May. Today he can't. but I can.
I can even update it with the Google Chrome browser.
I have seen that when some one posts a message on my facebook wall, I get a mail and I can reply to that wall post by just replying that email and my wall gets updated. I want to implement this feature in an ASP.Net website of mine but don't know how can I accomplish this task.
