پیدا کردن idرکورد در asp.net [بایگانی]

fakhravari

چهارشنبه 22 شهریور 1391, 21:45 عصر

ساختار یک sp و متدش

ALTER PROCEDURE [dbo].[News_Cities_Insert]

(
@ID bigint output,
@ProvinceID bigint,
@CityName nvarchar(50),
@CityNameEn nvarchar(50)=null
)

AS
INSERT INTO News_Cities (CityName, ProvinceID,CityNameEn) VALUES (@CityName, @ProvinceID,@CityNameEn)

set @ID = @@Identity

public Int64 Citie_Insert()
{
Int64 RecordAffected = 0;
SqlConnection connection = new SqlConnection(DAL.Config.Connection);
SqlCommand command = new SqlCommand("News_Cities_Insert", connection);
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 100000000;
command.Parameters.Add("@CityName", SqlDbType.NVarChar).Value = cityName;
command.Parameters.Add("@CityNameEn", SqlDbType.NVarChar).Value = cityNameEn;
command.Parameters.Add("@ProvinceID", SqlDbType.BigInt).Value = provinceID;
command.Parameters.Add("@ID", SqlDbType.BigInt).Direction = ParameterDirection.Output;
try
{
if (connection.State == ConnectionState.Closed)
{ connection.Open(); }
command.ExecuteNonQuery();
RecordAffected = Convert.ToInt64(command.Parameters["@ID"].Value);
}
catch { RecordAffected = 0; throw new Exception("Citie_Insert()"); }
finally { connection.Close(); }
return RecordAffected;
}