C#/DB (5) 썸네일형 리스트형 [C#] Mssql Parameter [C#] Mssql Parameter MSSQL 파라미터 만들기, 값 가져와서 파싱하기 public static class DBCommon { public static SqlParameter MakeParam(string name, int value) { var paramName = new SqlParameter(); paramName.ParameterName = name; paramName.Value = value; return paramName; } public static SqlParameter MakeParam(string name, DBNull value) { var paramName = new SqlParameter(); paramName.ParameterName = name; paramNam.. [C#] Mssql Select [C#] Mssql Select public async Task SelectContents(int id) { var datas = new List(); try { using (SqlConnection con = new SqlConnection(Startup.DBConnectionString)) { //계정정보를 가져온다 SqlCommand cmd = new SqlCommand("SELECT_AdvertiserInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DBCommon.MakeParam("@ID", id)); con.Open(); SqlDataReader rdr = await cmd.ExecuteReaderAs.. [C#] MSSQL Update [C#] MSSQL Update mssql 프로시저 Update 사용법입니다. public async Task UpdateContents(AdvertiserModel model) { try { using (SqlConnection con = new SqlConnection(Startup.DBConnectionString)) { SqlCommand cmd = new SqlCommand("UPDATE_AdvertiserInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DBCommon.MakeParam("@ID", model.ID)); cmd.Parameters.Add(DBCommon.MakeParam("@Corpora.. [C#] MSSQL Delete [C#] MSSQL Delete mssql 프로시저 Delete 사용법입니다. public async Task DeleteContents(AdvertiserModel model) { try { using (SqlConnection con = new SqlConnection(Startup.DBConnectionString)) { SqlCommand cmd = new SqlCommand("Delete_AdvertiserInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DBCommon.MakeParam("@ID", model.ID)); cmd.Parameters.Add(DBCommon.MakeParam("@UserID".. [C#] MSSQL Insert [C#] MSSQL Insert public async Task InsertContents(AdvertiserModel model) { try { using (SqlConnection con = new SqlConnection(Startup.DBConnectionString)) { SqlCommand cmd = new SqlCommand("INSERT_AdvertiserInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DBCommon.MakeParam("@CorporateRegistrationNumber", model.CorporateRegistrationNumber)); cmd.Parameters.Add(DBCo.. 이전 1 다음