Click here to Skip to main content
15,066,168 members

Comments by Lay_Kay (Top 9 by date)

Lay_Kay 26-Jun-18 21:41pm View
   
Where can I insert a MOVE NEXT statement in the code?
Lay_Kay 25-Jun-18 17:49pm View
   
Can you please provide me a direct coding sample? Thanks!
Lay_Kay 22-Jun-18 16:16pm View
   
Gerry, please advise. I am stuck.
Lay_Kay 22-Jun-18 13:24pm View
   
I see new data being inserted to the database, but not shown in the SENT email.
Lay_Kay 22-Jun-18 13:15pm View
   
I am expecting where the LATEST user selected "YES" to get the record.
Lay_Kay 22-Jun-18 13:13pm View
   
Where (in the script) can I execute the INSERT command? Please advise.
Lay_Kay 22-Jun-18 12:46pm View
   
I also have the following coding:

 con.Open();
 cmd1.ExecuteNonQuery();

 Personel_Grid.DataBind();
 con.Close();

 lbl_Email.Visible = true;
 lbl_Email.Text = "The Personnel Process started.";


 txtFirstName.Text = "";
 txtLastName.Text = "";
 txtTitle.Text = "";
 txtManager.Text = "";
 txtEmail.Text = "";
 txtPhone.Text = "";
 txtEffective_Date.Text = "";
 lbl_Success.Text = "";
}

Lay_Kay 22-Jun-18 12:43pm View
   
Isn't MAX(ID) getting the latest record?


SqlCommand cmd1 = new SqlCommand
(
     "INSERT INTO Users.[Employee] VALUES " + 
     " (@txtFirstName, @txtLastName, @txtTitle, @txtEmail, @txtPhone, 
 @txtEffective_Date, " +
            " @Email_Access_Boolean, @Remote_Access_Boolean, @Employee_Access_Boolean, " +
            " @Parking_Access_Boolean, @Security_Risk_Boolean, @Authorize_Purchase_Boolean, " + 
            " @Point_Contact_ID, @txtManager, @Dept_ID)", 
             con
);


I thought this is already inserting records. Please advise. Thanks!
Lay_Kay 28-Apr-18 13:44pm View
   
Never mind.... I discovered where my problem was.