i want my id as output when i submit the record i want to see the ID of that record
i m trying this i am not getting any thing
ALTER PROCEDURE [dbo].[Tech_sup]
(
@Build_name varchar(max),
@Dept varchar(max),
@Floor_no varchar(50),
@Call_recvd varchar (max),
@Ext_no int ,
@Caller_name varchar(max) ,
@Call_assign varchar(max),
@problem varchar(max),
@ip varchar(20) ,
@Rec_Status int,
@prob_type varchar(50),
@id int output
)
AS
BEGIN
INSERT INTO dbo.Tech_data (Build_name,Dept,Floor_no,Call_recvd,Ext_no,Caller_name,Call_assign,problem,ip,date_time,Rec_Status,prob_type)values (@Build_name,@Dept,@Floor_no,@Call_recvd,@Ext_no,@Caller_name,@Call_assign,@problem,@ip,getdate(),1,@prob_type)
return @id
END
c# code
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Tech_sup";
cmd.Parameters.AddWithValue("@Build_name", Build.Text);
cmd.Parameters.AddWithValue("@Dept", DropDownList2.Text);
cmd.Parameters.AddWithValue("@Floor_no", Floor.Text);
cmd.Parameters.AddWithValue("@Ext_no", Ext.Text);
cmd.Parameters.AddWithValue("@Call_recvd",DropDownList4.Text);
cmd.Parameters.AddWithValue("@Call_assign", DropDownList1.Text);
cmd.Parameters.AddWithValue("@Caller_name", Caller_Nm.Text);
cmd.Parameters.AddWithValue("@problem", Prob.Text);
cmd.Parameters.AddWithValue("@Rec_Status", SqlDbType.Bit);
cmd.Parameters.AddWithValue("@prob_type", DropDownList3.Text);
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
if (string.IsNullOrEmpty(Ip.Text))
{
cmd.Parameters.Add(new SqlParameter("@ip", DBNull.Value.ToString()));
}
else
{
cmd.Parameters.Add(new SqlParameter("@ip", Ip.Text));
}
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
TextBox1.Text = cmd.Parameters["@id"].Value.ToString();
ClientScriptManager cs = Page.ClientScript;
cs.RegisterStartupScript(this.GetType(), "id", "alert(" + cmd.Parameters["@id"].Value.ToString() + "');", true);