글

c# Create Zip File Using 7-zip

d:\s 폴더 안에 있는 모든 파일 (서브디렉토리포함) zip파일 형태로 압축하여 d\s.kmz 파일로 떨군다. Creating "d\s.kmz" file from all files including sub folders in "d\s". 7zip Option : -t[Type] public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         private void button1_Click(object sender, EventArgs e)         {             string directoryName = Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().Location);             string processName = Path.Combine( directoryName,"7z.exe");             string argument = " a -tZip \"d:\\s.kmz\" \"d:\\s\\*\"";             Process p = new Process();             p.StartInfo.Arguments = argum...

cmd Key overriding

protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { Keys key = keyData & ~(Keys.Shift Keys.Control); switch (key) { case Keys.D: if ((keyData & Keys.Control) != 0 && (keyData & Keys.Shift) != 0) { if (m_debuggingForm == null) { TPSMessageBox.Show(this, "Debug Mode Activated"); m_debuggingForm = new Debugging_Form(); m_debuggingForm.Show(); m_debuggingForm.SetDesktopLocation(this.Left + (this.Width - m_debuggingForm.Width) / 2, this.Top + (this.Height - m_debuggingForm.Height) / 2); } else if (m_debuggingForm.IsDisposed) { TPSMessageBox.Show(this, "Debug Mode Activated"); m_debuggingForm = new Debugging_Form(); m_debuggingForm.Show(); m_debuggingForm.SetDesktopLocation(this.Left + (this.Width - m_debuggingForm.Width) / 2, this.Top + (this.Height - m_debuggingForm.Height) / 2); } else { m_debuggingForm.BringToFront(); } return true; } break; } return base.ProcessCm...

VSTO 2010 xp Deploy Problem

I tried to deploy Excel 2010 Add-In to XP target machine. But the Add-In didn't work properly which worked well with windows 7. The solution is so simple: Install office 2010PIA on your XP target machine. You can download office 2010PIA in here: http://www.microsoft.com/download/en/details.aspx?id=3508 If you want to make a setup package, you need this bootstrapper, download here : http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18249

웹 디버깅

이미지
옵션 변경 캡션 추가

[MS-SQL] DB의 모든 테이블 정보

select OBJECT_NAME(id) , rows from sysindexes where indid = 1 order by rows desc

When meet "The Module DLL C:\Windows\System32\inetsrv\isapi.dll failed to load. The data is the error." message in event log

이미지
When 503 Sevice unable error occured, check event viewer. If you see "The Module DLL C:\Windows\System32\inetsrv\isapi.dll failed to load.  The data is the error." message, try this one. [Error Message] [solution]

VMware hdd 추가 후 offline상태일 때

CMD창에서 Diskpart 실행후 다음과 같이 입력 DISKPART> SELECT DISK n DISKPART> ATTRIBUTES DISK CLEAR READONLY DISKPART> ONLINE DISK DISKPART> attributes disk clear readonly DISKPART> create partition primary