when am inserted my values to database and then i want to get iserted id in c#
In my database My identity column datatypr is "BIGINT"
con.Open();
SqlCommand cmd = new SqlCommand("insert into tbl_task_name (Task_Name,EmployeeiD,Status_) values (@eid,@tn,@Stat);Select Scope_Identity();", con);
cmd.Parameters.AddWithValue("@eid", id);
cmd.Parameters.AddWithValue("@tn", txtTaskName.Text);
cmd.Parameters.AddWithValue("@Stat", "0");
int oid = Convert.ToInt32(cmd.ExecuteScalar());
But it throws an error
Error Converting Dataype nvarchar to bigint