Comments by Shaddow>dark (Top 20 by date)

thank you mr CHilll your good man <3

am i noising you ?? :)
i'm here for guys like you help us i mean fresh people in codes and you are here to help i think but thank you for your replay it was pleasure to Talk to you mr F :)

ALTER PROCEDURE [dbo].[insert_dept]

@dept_id INT = NULL,
@debt_name NVARCHAR(50) = NULL,
@debt_emp NUMERIC(18) = NULL

AS
BEGIN

IF NOT EXISTS(SELECT 1 FROM Department WHERE dept_id = @dept_id)
BEGIN
INSERT INTO dbo.Department (dept_id ,debt_name ,debt_emp )
VALUES (@dept_id ,@debt_name ,@debt_emp )
END
ELSE
BEGIN

UPDATE dbo.Department
SET debt_name=@debt_name ,debt_emp=@debt_emp
WHERE dept_id=@dept_id

END

END

Thank You Very Much For Your Answer it's Very useful and your Good Dude i like it all of it Btw i can debugging but my problem is how to find the Error and the problem i'm just new in the company and its the first time i work my study was very different from the work i'm trying the best to know how to code in my company no one helps me i'm on my self it's hard to do such a thing without somebody help u and update you and learn you how to work in every code solve another problem shows up and that's blowing up my mind what should i do ?????
your professional and i'm just like your student

ALTER PROCEDURE [dbo].[insert_emp]
@EMP_NUM numeric(18) = null,
@DEBT_NUM numeric(18) ,
@EMP_NAME varchar(150) =null,
@EMP_P_DATE smalldatetime =null,
@EMP_WORK_DATE smalldatetime =null,
@EMP_SAL NUMERIC(18) =null,
@EMP_DESC VARCHAR(250) =null,
@DEBT_NAME VARCHAR(150) =null
AS
BEGIN
IF NOT EXISTS(SELECT 1 FROM Employee WHERE EMP_NUM = @EMP_NUM )
BEGIN
INSERT INTO DBO.EMPLOYEE ( DEPT_NUM ,EMP_NAME ,EMP_P_DATE ,EMP_WORK_DATE ,EMP_SAL ,EMP_DESC,DEBT_NAME )
VALUES (@DEBT_NUM,@EMP_NAME,@EMP_P_DATE,@EMP_WORK_DATE,@EMP_SAL,@EMP_DESC,@DEBT_NAME )
END
ELSE
BEGIN
UPDATE dbo.Employee
SET emp_num =@EMP_NUM ,dept_num =@DEBT_NUM ,emp_name =@EMP_NAME ,emp_p_date =@EMP_P_DATE ,emp_work_date =@EMP_WORK_DATE ,emp_sal =@EMP_SAL ,emp_desc =@EMP_DESC ,debt_name =@DEBT_NAME
WHERE emp_num =@EMP_NUM

END

ALTER PROCEDURE [dbo].[insert_emp]
@EMP_NUM numeric(18) = null,
@DEBT_NUM numeric(18) ,
@EMP_NAME varchar(150) =null,
@EMP_P_DATE smalldatetime =null,
@EMP_WORK_DATE smalldatetime =null,
@EMP_SAL NUMERIC(18) =null,
@EMP_DESC VARCHAR(250) =null,
@DEBT_NAME VARCHAR(150) =null
AS
BEGIN
IF NOT EXISTS(SELECT 1 FROM Employee WHERE EMP_NUM = @EMP_NUM )
BEGIN
INSERT INTO DBO.EMPLOYEE ( DEPT_NUM ,EMP_NAME ,EMP_P_DATE ,EMP_WORK_DATE ,EMP_SAL ,EMP_DESC,DEBT_NAME )
VALUES (@DEBT_NUM,@EMP_NAME,@EMP_P_DATE,@EMP_WORK_DATE,@EMP_SAL,@EMP_DESC,@DEBT_NAME )
END
ELSE
BEGIN
UPDATE dbo.Employee
SET emp_num =@EMP_NUM ,dept_num =@DEBT_NUM ,emp_name =@EMP_NAME ,emp_p_date =@EMP_P_DATE ,emp_work_date =@EMP_WORK_DATE ,emp_sal =@EMP_SAL ,emp_desc =@EMP_DESC ,debt_name =@DEBT_NAME
WHERE emp_num =@EMP_NUM

END

in your opinion whats the best way to do ???

???????????????????????????????????

Private Sub ComboBox2_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox8.KeyDown, TextBox6.KeyDown, TextBox5.KeyDown, TextBox3.KeyDown, TextBox2.KeyDown, DateTimePicker2.KeyDown, DateTimePicker1.KeyDown, ComboBox2.KeyDown
If (e.KeyCode = Keys.Enter) Then

End If
If (Me.GetNextControl(ActiveControl, True) <> Nothing) Then

e.Handled = True
Me.GetNextControl(ActiveControl, True).Focus()
End If

Error 1 Operator '<>' is not defined for types 'System.Windows.Forms.Control' and 'System.Windows.Forms.Control'.

My new Error after update ???

Are you here for help or what ???\

???

1 _ i wanna make it give me the details when i insert the department id give me all details in the other text boxes >>>>>>>

2 _ i wanna prevent the duplicate in department id when i insert the department id got it ???

in that code i have 3 text boxes and i have button with a grid view and i activated the max number for department text box what im gonna say know that what i want i want when i insert number of the department i want it to give all details about it in the other text boxes and i want to I also want to prevent repetition in
department id ?>>>??>> that's it

TY can u replay the correct solution for this ill be thankful