先写好数据库查询语句 string sql_insert = "insert into Shipping_Agency_BaseInfo(CompanyName,Fax,Contact_Person,Contact_Person_Tel) " + "values('" + companyname + "','" + fax + "','" + contactperson + "','" + contactpersontel + "') "+ "set @returnID= IDENT_CURRENT('Shipping_Agency_BaseInfo') "+ "select @returnID"; int ID = db.GetInsertID(sql_insert); 以下是database类中的方法 public int GetInsertID(String sql_insert) { int ID = -1; SqlCommand cmd = new SqlCommand(sql_insert, Connection); cmd.Parameters.Add("@returnID", SqlDbType.Int); cmd.Parameters["@returnID"].Direction = ParameterDirection.Output; Open(); try { cmd.ExecuteNonQuery(); ID = Convert.ToInt32(cmd.Parameters["@returnID"].Value); } catch { ID = -1; } finally { Close(); } return ID; }