MSSQL 테이블명, 컬럼명 검색

-- 테이블명 검색

SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME = '테이블명'

-- 컬럼명 검색

SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME = '컬럼명'

-- PK 검색

SELECT * FROM information_schema.KEY_COLUMN_USAGE

Visual Studio 2013 클래스뷰, 리소스뷰 가 보이지 않을때

Visual Studio 종료시 에러 메세지의 지시대로

Microsoft SQL Server Compact 4.0 을 설치하면 정상적으로 작동된다.

Redis Client Connect Test

CLIENT LIST

The CLIENT LIST command returns information and statistics about the client connections server in a mostly human readable format.

Return value

Bulk string reply: a unique string, formatted as follows:

• One client connection per line (separated by LF)
• Each line is composed of a succession of property=value fields separated by a space character.

Here is the meaning of the fields:

• id: an unique 64-bit client ID (introduced in Redis 2.8.12).
• addr: address/port of the client
• fd: file descriptor corresponding to the socket
• age: total duration of the connection in seconds
• idle: idle time of the connection in seconds
• flags: client flags (see below)
• db: current database ID
• sub: number of channel subscriptions
• psub: number of pattern matching subscriptions
• multi: number of commands in a MULTI/EXEC context
• qbuf: query buffer length (0 means no query pending)
• qbuf-free: free space of the query buffer (0 means the buffer is full)
• obl: output buffer length
• oll: output list length (replies are queued in this list when the buffer is full)
• omem: output buffer memory usage
• events: file descriptor events (see below)
• cmd: last command played

The client flags can be a combination of:

O: the client is a slave in MONITOR mode
S: the client is a normal slave server
M: the client is a master
x: the client is in a MULTI/EXEC context
b: the client is waiting in a blocking operation
i: the client is waiting for a VM I/O (deprecated)
d: a watched keys has been modified - EXEC will fail
c: connection to be closed after writing entire reply
u: the client is unblocked
U: the client is connected via a Unix domain socket
r: the client is in readonly mode against a cluster node
A: connection to be closed ASAP
N: no specific flag set

The file descriptor events can be:

r: the client socket is readable (event loop)
w: the client socket is writable (event loop)

MFCGridCtrl OnEraseBkgnd ScrollBar Redraw

MFC Dialog Color 를 바꾸기 위해

OnEraseBkgnd 을 오버라이딩하여 사용하면

Dialog 를 새로 그리게 되는데

이때 CGridCtrl 의 스크롤바 영역도 같이 새로 그리게 된다.

그래서 스크롤바가 존재하지만 안보이는 경우가 발생한다.

그럴때는 OnEraseBkgnd 에서 Dialog 를 새로그린 다음

m_Grid.SetRedraw(true, true);

Redraw 를 하면

스크롤 바를 새로 그린다.

CEdit control의 font 바꾸기

BOOL CMyDlg::OnInitDialog() 
{
LOGFONT lf;

memset(&lf, 0, sizeof(LOGFONT));
lf.lfCharSet = 0x81;			// 한글 Character Set
lf.lfHeight = 20;			// 20 point 크기
strcpy(lf.lfFaceName, "궁서체"); 	// 궁서체로 font setting
m_font.CreateFontIndirect(&lf);	

CEdit* pCtlEdit = (CEdit*) GetDlgItem(IDC_EDIT1); // edit control의 
                                                  // pointer를 가져옴
pCtlEdit->SetFont((CFont*)&m_font, TRUE);

return TRUE;
}
					

출처 : https://support.microsoft.com/ko-kr/kb/600665

추가로 CFont m_font; 선언 필요.

CTextProgressCtrl hide Edge

void CTextProgressCtrl::OnPaint()

{

......

DrawEdge(dc, ClientRect, EDGE_SUNKEN, BF_ADJUST | BF_RECT | BF_FLAT);

......

}

if you want to hide CTextProgressCtrl's Edge,

add "//"

void CTextProgressCtrl::OnPaint()

{

......

// DrawEdge(dc, ClientRect, EDGE_SUNKEN, BF_ADJUST | BF_RECT | BF_FLAT);

......

}

MFCGridCtrl CGridCtrl ScrollBar Visible

If you change Dialog color used by OnEraseBkgnd();

you can't see CGridCtrl's ScrollBar

in that case, you should add m_Grid.SetRedraw(true, true); to OnEraseBkgnd();

BOOL CMyDialog::OnEraseBkgnd(CDC* pDC)
{
	// TODO: 여기에 메시지 처리기 코드를 추가 및/또는 기본값을 호출합니다.

	CRect rect;

	GetClientRect(&rect);

	CBrush myBrush(RGB(255, 255, 255));    // dialog background color <- 요기 바꾸면 됨.
	
	CBrush *pOld = pDC->SelectObject(&myBrush);

	BOOL bRes = pDC->PatBlt(0, 0, rect.Width(), rect.Height(), PATCOPY);

	pDC->SelectObject(pOld);    // restore old brush

	m_Grid.SetRedraw(true, true);

	return bRes;                       // 	return CDialog::OnEraseBkgnd(pDC);
}

MFC CGridCtrl Color Change

COLORREF ItemBkColour = RGB(255,255,255);

m_Grid.SetItemBkColour(0, 0, ItemBkColour);

m_Grid.SetItemBkColour(0, 1, ItemBkColour);

m_Grid.SetItemBkColour(0, 2, ItemBkColour);

m_Grid.SetItemBkColour(0, 3, ItemBkColour);

m_Grid.SetBkColor(RGB(255, 0, 0)); 

MFC CWnd Control Border Color Change

CWnd::OnNcPaint

다른 버전

afx_msg void OnNcPaint( );

The default implementation paints the window frame.

An application can override this call and paint its own custom window frame. The clipping region is always rectangular, even if the shape of the frame is altered.

기본 구현에서는 창 프레임을 그립니다.

응용 프로그램이이 호출을 무시 하 고 자체 사용자 지정 창 프레임을 페인트할 수 있습니다. 클리핑 영역은 프레임의 모양을 변경 하는 경우에 항상 사각형입니다.

void CDerivedEdit::OnNcPaint() 
{
		CDC* pDC = GetWindowDC( );
		
		//work out the coordinates of the window rectangle,
		CRect rect;
		GetWindowRect( &rect);
		rect.OffsetRect( -rect.left, -rect.top);
		
		//Draw a single line around the outside
		CBrush brush( RGB( 255, 0, 0));
		pDC->FrameRect( &rect, &brush);
		ReleaseDC( pDC);
}

      BOOL bCheck = IsDlgButtonChecked(IDC_CHECK);

      //MFC CheckBox 컨트롤의 현재 상태를 얻어오는 예제입니다.

      //    bCheck 변수가 1 이면 현재 체크박스가 체크되어 있는 상태를 의미하며 반대로 0이면 체크해제되어 있는 상태입니다.

      CheckDlgButton(IDC_CHECK, TRUE);

      // MFC CheckBox 컨트롤을 체크 및 체크해제 하는 예제입니다.

      //    두번째 매개변수가 TRUE일 경우 해당 체크박스에 체크되며 FALSE일 경우에는 체크가 해제됩니다.

       if (!IsDlgButtonChecked(IDC_TIME_CHECK))

      {

            return;

      }