2010년 3월 2일 화요일

ASP.NET SP호출

public DataSet GetDefaultApprovalLineMody(string stridx)
{
DataSet ds = new DataSet();

SqlConnection objCon = null;
SqlCommand objCmd = null;
SqlDataAdapter objAdpt = null;

try
{
objCon = new SqlConnection(strConnection);
objCon.Open();

objCmd = objCon.CreateCommand();
objCmd.CommandText = "sp_get_approval_line";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(new SqlParameter("@idn", stridx));
objCmd.Parameters.Add(new SqlParameter("@LoginID", txtLoginUser.Text));
objCmd.Parameters.Add(new SqlParameter("@circuit_seq", txtCircuitSeq.Text));

objAdpt = new SqlDataAdapter();
objAdpt.SelectCommand = objCmd;

objAdpt.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objCmd != null)
{
objCmd.Dispose();
}

if (objCon != null)
{
if (objCon.State != ConnectionState.Closed) objCon.Close();
objCon.Dispose();
}
}

return ds;
}

댓글 없음:

댓글 쓰기