C#

ALTER PROCEDURE programservice.insert_job
(
@JobID int output,
@CustomerID char(20),
@Date datetime
)
AS
SET NOCOUNT OFF
INSERT INTO dbo.table_job(CustomerID, Date) VALUES (@CustomerID, @Date);
SET @JobID = SCOPE_IDENTITY()
SELECT JobID, CustomerID, Date FROM dbo.tabel_job WHERE (JobID = @JobID)

<br />
using System;<br />
using System.Drawing;<br />
using System.Collections;<br />
using System.ComponentModel;<br />
using System.Windows.Forms;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
<br />
namespace Program_Service<br />
{<br />
<br />
public class frm_tandaterima_baru : System.Windows.Forms.Form<br />
{<br />
	/// <summary><br />
	/// Required designer variable.<br />
	/// </summary><br />
	private System.ComponentModel.Container components = null;<br />
	private System.Windows.Forms.Label lbl_customerID;<br />
	private System.Windows.Forms.Label lbl_description;<br />
	private System.Windows.Forms.TextBox txt_description;<br />
	private System.Windows.Forms.ComboBox cmb_cust;<br />
	private System.Windows.Forms.Button btn_save;<br />
	private System.Windows.Forms.Button btn_newjob;<br />
	private System.Windows.Forms.Button btn_exit;<br />
	private System.Data.SqlClient.SqlDataAdapter jobDA;<br />
	private System.Data.SqlClient.SqlCommand select_job;<br />
	private System.Data.SqlClient.SqlCommand update_job;<br />
	private System.Data.SqlClient.SqlCommand insert_job;<br />
	private System.Data.SqlClient.SqlCommand delete_job;<br />
	private Program_Service.ds_parent jobDS;<br />
	private System.Data.SqlClient.SqlDataAdapter custDA;<br />
	private System.Data.SqlClient.SqlCommand sqlSelectCommand1;<br />
	private System.Data.SqlClient.SqlCommand sqlInsertCommand1;<br />
	private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;<br />
	private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;<br />
<br />
public frm_newjob()<br />
{<br />
	//<br />
	// Required for Windows Form Designer support<br />
	//<br />
	InitializeComponent();<br />
	//<br />
	// TODO: Add any constructor code after InitializeComponent call<br />
	//<br />
}<br />
protected override void Dispose( bool disposing )<br />
{<br />
	if( disposing )<br />
	{<br />
		if(components != null)<br />
		{<br />
			components.Dispose();<br />
		}<br />
	}<br />
	base.Dispose( disposing );<br />
}<br />
<br />
private void frm_newjob_Activated(object sender, System.EventArgs e)<br />
{<br />
	// Fill DataSet with all data needed<br />
	custDA.Fill(jobDS, "table_cust");<br />
	// Set the focus on activated<br />
	this.cmb_cust.Focus();<br />
}<br />
private void btn_save_Click(object sender, System.EventArgs e)<br />
{<br />
        jobDA.Fill(jobDS, "table_job");<br />
<br />
        DataRow job = jobDS.Tables["table_job"].NewRow();<br />
        job["CustomerID"] = cmb_cust.ValueMember;<br />
        job["Date"] = date.Value;<br />
        job["Description"] = txt_description.Text;<br />
        jobDS.Tables["table_job"].Rows.Add(job);<br />
        jobDA.Update(jobDS, "table_job");<br />
}<br />
<br />
private void btn_newjob_Click(object sender, System.EventArgs e)<br />
{<br />
	// Clear all text box for new data<br />
	this.txt_description.Clear();<br />
}<br />
<br />
private void btn_exit_Click(object sender, System.EventArgs e)<br />
{<br />
	this.Close();<br />
}<br />
}<br />
}<br />

<br />
ALTER PROCEDURE programservice.insert_job<br />
(<br />
@JobID int output,<br />
@CustomerID char(20),<br />
@Date datetime<br />
)<br />
AS<br />
SET NOCOUNT OFF;<br />
INSERT INTO dbo.table_job(CustomerID, Date) VALUES (@CustomerID, @Date);<br />
SELECT JobID, CustomerID, Date FROM dbo.tabel_job WHERE (JobID = @JobID)<br />
SET @JobID = SCOPE_IDENTITY()<br />

ALTER PROCEDURE programservice.insert_job(
    @JobID int output,
    @CustomerID char(20),
    @Date datetime
) AS
SET NOCOUNT ON
INSERT INTO dbo.table_job(CustomerID, Date) VALUES (@CustomerID, @Date);
SET @JobID = SCOPE_IDENTITY()
SELECT JobID, CustomerID, Date FROM dbo.tabel_job WHERE (JobID = @JobID)