Gridview rowupdating new value 100 online dating site no credit card
Free counters Added on January 19,2012 Follow Me @vmsdurano A bit About Me Disclaimer The opinions expressed herein are my own personal opinions and does not represent the opinions of my employers.
Nor does it represent the opinion of my dog, because I don’t have one.
Here we set ID column Primary Key and Auto Increment by updating the ID column property.
After creating new table create new stored procedure for Insert records, Select records, Update and Delete records.
Stored Procedure for SELECT set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[USERMST_INSERT] @NAME AS NVARCHAR(256), @ADD AS NVARCHAR(256), @CITY AS NVARCHAR(256), @EMAIL AS NVARCHAR(256) AS BEGIN INSERT INTO USERMST VALUES (@NAME,@ADD,@CITY,@EMAIL) END set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[USERMST_UPDATE] @ID AS INT, @NAME AS NVARCHAR(256), @ADD AS NVARCHAR(256), @CITY AS NVARCHAR(256), @EMAIL AS NVARCHAR(256) AS BEGIN UPDATE USERMST SET [email protected], [email protected], [email protected], [email protected] WHERE [email protected] END Now, we all know as write sql connection code in data access layer.
Create SQL Connection We need a connection with a Microsoft SQL Server database so we can access data and perform an operation on it.open visual studio – In above screen we can see, there are five column in User Mst Table in sql.The first column is ID which is identification of user, so it must be unique.The last parameter is a boolean value which tells the method whether to execute an Insert (false) or Update (true). In-order to perform Edit and Update in Grid View we need to use three events ( Grid View_Row Editing, Grid View_Row Canceling Edit , Grid View_Row Updating). For those who do not know on how to generate Events in Grid View you can follow these steps below: I have a project that I coppied the above code into.