분류 전체보기 (86) 썸네일형 리스트형 [C#] XmlHelper / XML 총정리 1. XML 읽기/쓰기/수정/삭제/정렬/재배치 public class XmlHelper { private static string dirName = Path.Combine(Directory.GetCurrentDirectory(), "XmlData"); private static string fileName = "Device"; static string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; static int uidsIndex = 0; private static string MakeUid() { string result = ""; result = chars[uidsIndex] + DateTime.Now.ToStr.. [C#] XmlString to Object 파싱 [C#] XmlString to Object 1. XML String var xmlString = "" + "a" + "b" + "c" + "d" + "1" + ""; 2. 클래스 생성 public class MessageInfo { public string MyId { get; set; } public string YourId { get; set; } public string Msg1 { get; set; } public string Msg2 { get; set; } public string Msg3 { get; set; } } 3-1. XDocument를 이용한 파싱 var doc = XDocument.Parse(xmlString); var root = doc.Element("datas"); List.. [C#] XML 생성/쓰기 및 노드 추가하기 [C#] XML 생성 및 노드 추가하기 XML 생성 및 노드 추가하기 private void AddXmlElement(string id, int type, int fileType, string fileName, double duration) { if(Directory.Exists(DirName) == false) { Directory.CreateDirectory(DirName); } if (File.Exists(DirName + "/" + FileNameVideoContents1F + ".xml") == false) { // xml 생성 XElement doc = new XElement("Root", new XElement("Contents", new XAttribute("Id", id), new XEl.. [C#] XML 읽기 [C#] ReadXml xml data 샘플 20180615_1820562056 1 0 2 123456789.mp4 40 20180618_1350335033 2 1 1 123456789.mp4 30.116 20180618_1350385038 3 1 1 123333.mp4 107.207 xml 읽기 private List ReadXml() { List list = new List(); try { XElement doc = XElement.Load(DirName + "/" + FileNameVideoContents1F + ".xml"); int index = 0; foreach(XElement element in doc.Elements()) { SampleData data = new SampleData();.. [Unity] Changing Ortho Cam Size according to resolution Changing Ortho Cam Size according to resolution Ortho 카메라 크기를 해상도에 맞춰 바꾸기 public class CameraManager : MonoBehaviour { public float horizontalResolution = 1920; void OnGUI () { float currentAspect = (float) Screen.width / (float) Screen.height; Camera.main.orthographicSize = horizontalResolution / currentAspect / 200; } } [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.. 이전 1 ··· 3 4 5 6 7 8 9 ··· 11 다음