2014 10월 « 어느용

storedprocedure call

SqlConnection conn = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_getdata", conn);

cmd.Parameters.Add("@userIndex", SqlDbType.Int).Value = MemberNo;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())
{
    Fee = Convert.ToInt32(reader["Fee"].ToString());
}

conn.Close();

SqlConnection conn = new SqlConnection(conStr);

SqlCommand cmd = new SqlCommand("sp_getdata", conn);

cmd.Parameters.Add("@userIndex", SqlDbType.Int).Value = MemberNo;

cmd.CommandType = CommandType.StoredProcedure;

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())

{

Fee = Convert.ToInt32(reader["Fee"].ToString());

}

conn.Close();

어느용

참고자료

보관함

storedprocedure call

최신 글

메타

태그