천사주니의 개발노트

C# 네트워크 연결 유무 확인하기

프로그래밍/C# 2018. 3. 16. 09:16

     
    if (NetworkInterface.GetIsNetworkAvailable())
         MessageBox.Show("네트워크 연결 O");
     else
         MessageBox.Show("네트워크 연결 X");

저작자표시

'프로그래밍 > C# ' 카테고리의 다른 글

C# 숫자만 입력 하기 (0)	2016.06.20
C# Window Service 실행 (0)	2016.03.31
C# 시스템 시간 바꾸기 (0)	2016.03.31
간단한 스케쥴러 URL (0)	2014.08.29
DataTable Xml로 쓰기 (0)	2014.06.30

Posted by 천사주니

,

테이블이 쓰이는 Procedure 찾기

프로그래밍/Ms-Sql 2016. 8. 11. 18:40

SELECT
    DISTINCT O.NAME
FROM
    SYSDEPENDS AS D
INNER JOIN
    SYSOBJECTS AS O 
ON
    D.ID = O.ID
WHERE
    O.XTYPE = 'P'
    AND D.DEPID = 
        (
            SELECT
                ID 
            FROM
                SYSOBJECTS 
            WHERE
                NAME = '테이블명'
        )

저작자표시

'프로그래밍 > Ms-Sql' 카테고리의 다른 글

오늘 날자 가지고 오기 (0)	2013.09.11
Table PrimaryKey 알아내기 (0)	2013.07.16
Table Column 정보 알아내기 (0)	2013.07.16

Posted by 천사주니

,

UltraGrid DropDownList 사용 방법

프로그래밍/C# Infragistics2 2016. 8. 9. 20:57

     

        private void Form1_Load(object sender, EventArgs e)
        {
            InitGridTop();

        }

        private void InitGridTop()
        {
            ugGridTop.DataBind();

            DataTable dt = new DataTable();
            dt.Columns.Add("CalculatedColumn");
            dt.Columns.Add("CalculatedColumn1");

            DataRow dr1 = dt.NewRow();
            dr1[0] = "AAAA";
            dr1[1] = "A";

            DataRow dr2 = dt.NewRow();
            dr2[0] = "BBBB";
            dr2[1] = "B";

            DataRow dr3 = dt.NewRow();
            dr3[0] = "CCCC";
            dr3[1] = "C";

            DataRow dr4 = dt.NewRow();
            dr4[0] = "DDDD";
            dr4[1] = "D";

            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            dt.Rows.Add(dr4);
            
            try
            {

                this.ugGridTop.DisplayLayout.Bands[0].Columns.Add("CalculatedColumn", "Calculated Value").CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                this.ugGridTop.DisplayLayout.Bands[0].Columns.Add("CalculatedColumn1", "Calculated Value1").CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                this.ugGridTop.DisplayLayout.Bands[0].Columns.Add("CalculatedColumn2", "Calculated Value2").CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                this.ugGridTop.DisplayLayout.Bands[0].Columns.Add("CalculatedColumn3", "Calculated Value3").CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                this.ugGridTop.DisplayLayout.Bands[0].Columns[1].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ugGridTop.DataSource = dt;

                Infragistics.Win.ValueList objValue = new Infragistics.Win.ValueList();
                objValue.ValueListItems.Add("A", "AA");
                objValue.ValueListItems.Add("B", "BB");
                objValue.ValueListItems.Add("C", "CC");
                objValue.ValueListItems.Add("D", "DD");
                this.ugGridTop.DisplayLayout.Bands[0].Columns[1].ValueList = objValue;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }

        /// 
        /// DropDownList 선택
        /// 
        /// 
        /// 
        private void ugGridTop_CellListSelect(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (null != e.Cell.Column.ValueList)
            {
                int itemIdex = e.Cell.Column.ValueList.SelectedItemIndex;
                string SelectedText = string.Format("Value : {0} Text : {1} ", e.Cell.Column.ValueList.GetValue(itemIdex), e.Cell.Column.ValueList.GetText(itemIdex));
                MessageBox.Show(SelectedText);
            }
        }