[.net] 인서트 후 결과값 리턴쿼리

 
filename.Filename
query = " insert into VV_COUPON ( CPN_NAME, PRICE, CPN_IMAGE, GUBUN, IP ) values ( @CPN_NAME, @PRICE, @CPN_IMAGE, @GUBUN, @IP ) " +
       " set @CPN_SEQ = @@Identity ";
   cmd = new SqlCommand( query, conn );
   cmd.Parameters.AddWithValue( "@CPN_NAME", cpn_name );
   cmd.Parameters.AddWithValue( "@PRICE", price );
   cmd.Parameters.AddWithValue( "@CPN_IMAGE", cpn_image );
   cmd.Parameters.AddWithValue( "@GUBUN", gubun );
   cmd.Parameters.AddWithValue( "@IP", Request.UserHostAddress );
 
   cmd.Parameters.Add( "@CPN_SEQ", SqlDbType.Int );
   cmd.Parameters[ "@CPN_SEQ" ].Direction = ParameterDirection.Output;
 
   cmd.ExecuteNonQuery();
 
   int cpn_seq = Convert.ToInt32( cmd.Parameters[ "@CPN_SEQ" ].Value );
   string dir = SitePath.GetFileDir + "\\coupon\\" + cpn_seq;  //업로드 경로
   Utility.SimpleUpload( dir, filename );