Click here to Skip to main content
15,914,327 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Cross browser Pin
Gandalf_TheWhite21-Dec-07 0:42
professionalGandalf_TheWhite21-Dec-07 0:42 
QuestionHow to print in asp.net Pin
Deepthy.P.M20-Dec-07 21:49
Deepthy.P.M20-Dec-07 21:49 
AnswerRe: How to print in asp.net Pin
Abhijit Jana20-Dec-07 21:55
professionalAbhijit Jana20-Dec-07 21:55 
Generalmove Folder Pin
AnhTin20-Dec-07 20:01
AnhTin20-Dec-07 20:01 
GeneralRe: move Folder Pin
Christian Graus20-Dec-07 20:21
protectorChristian Graus20-Dec-07 20:21 
GeneralRe: move Folder Pin
Abhijit Jana20-Dec-07 20:59
professionalAbhijit Jana20-Dec-07 20:59 
GeneralRe: move Folder Pin
AnhTin20-Dec-07 21:48
AnhTin20-Dec-07 21:48 
Generaltriggers in .net Pin
Member 387988120-Dec-07 19:56
Member 387988120-Dec-07 19:56 
Hi using triggers i try to insert some values in to my 2 tables:
But its showing teh error as "The request for procedure 'Triginsert123s' failed because 'Triginsert123s' is a trigger object."
This is my code in back end:

sqlcon.Open()
Dim cmd As New SqlCommand("Triginsert123s '" & txtID.Text & "','" & txtName.Text & "','" & txtRole.Text & "','" & txtDep.Text & "'", sqlcon)
cmd.ExecuteNonQuery()
sqlcon.Close()

My trigger is:
CREATE TRIGGER Triginsert123s ON [dbo].[EmpRole]
FOR INSERT
AS
declare
@Eid as tinyint,
@Ename as varchar(50),
@Role as char(10)

Insert into Emprole(Eid,Ename,Role) values(@Eid,@Ename,@Role)
insert into empdep(eid,dep) values(@eid,@Role)


Whats the probs?,
Plz i am new to triggers help me,
Thanks & Regards,
Mageshh,
please don't forget to vote on the post

GeneralRe: triggers in .net Pin
Christian Graus20-Dec-07 20:30
protectorChristian Graus20-Dec-07 20:30 
GeneralRe: triggers in .net Pin
Christian Graus20-Dec-07 20:30
protectorChristian Graus20-Dec-07 20:30 
GeneralRe: triggers in .net Pin
Venkatesh Mookkan20-Dec-07 21:19
Venkatesh Mookkan20-Dec-07 21:19 
Questioncompare validator Pin
KarthickRamalingam20-Dec-07 19:39
KarthickRamalingam20-Dec-07 19:39 
GeneralRe: compare validator Pin
Christian Graus20-Dec-07 20:33
protectorChristian Graus20-Dec-07 20:33 
GeneralRe: compare validator Pin
Sun Rays20-Dec-07 21:42
Sun Rays20-Dec-07 21:42 
GeneralDynamic Table in Javascript Pin
rajanandal20-Dec-07 19:06
rajanandal20-Dec-07 19:06 
Questionhow to show the values that are invisible in the grid view Pin
jagan12320-Dec-07 19:00
jagan12320-Dec-07 19:00 
AnswerRe: how to show the values that are invisible in the grid view Pin
Member 387988120-Dec-07 20:01
Member 387988120-Dec-07 20:01 
Generalsession between pages Pin
Sunil Wise20-Dec-07 18:50
professionalSunil Wise20-Dec-07 18:50 
GeneralRe: session between pages Pin
Sun Rays20-Dec-07 21:20
Sun Rays20-Dec-07 21:20 
GeneralRe: session between pages Pin
Venkatesh Mookkan20-Dec-07 21:33
Venkatesh Mookkan20-Dec-07 21:33 
QuestionRetrive System Unique details?? Pin
Soumya Mathew20-Dec-07 17:47
Soumya Mathew20-Dec-07 17:47 
AnswerRe: Retrive System Unique details?? Pin
Christian Graus20-Dec-07 18:29
protectorChristian Graus20-Dec-07 18:29 
AnswerRe: Retrive System Unique details?? Pin
Abhijit Jana20-Dec-07 19:25
professionalAbhijit Jana20-Dec-07 19:25 
GeneralCheckboxlist pbm Pin
SreejithAchutan20-Dec-07 17:43
SreejithAchutan20-Dec-07 17:43 
GeneralRe: Checkboxlist pbm Pin
Neeraj Jain20-Dec-07 17:52
Neeraj Jain20-Dec-07 17:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.