Inserting records into a database table using a stored procedure and ADO.NET

you can write stoprocedure for insert, delete,update on sqlserver and in visual C#, you use sqlcommand with commandType is CommandType.Procedure. But you must know storeprocedure. ex: create proc spdelete as declare @masv varchar(5) delete tblNhanVien where manv = @manv and visual C#. sqlcommand cmd = new sqlcommand(spdelete,con); cmd.commandtype = commandtype.procedure; cmd.parametr.add(@manv,sqltype.varchar(5)).value = txtManv.text.Trim(); cmd.executenonquery();