날자별

2014 10월
 12345
6789101112
13141516171819
20212223242526
2728293031  

storedprocedure call

[csharp]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(); [/csharp]