C# (CSharp) VinaLib SqlDatabaseHelper.GetTableColumn 예제들

예제 #1

        public static bool IsColumnAllowNull(string strTableName, string strColumnName)
        {
            DataSet tableColumn = SqlDatabaseHelper.GetTableColumn(strTableName, strColumnName);

            return(tableColumn.Tables.Count <= 0 || tableColumn.Tables[0].Rows.Count <= 0 || tableColumn.Tables[0].Rows[0]["IS_NULLABLE"].ToString() == "YES");
        }

예제 #2

        public static bool ColumnIsExistInTable(string strTableName, string strColumnName)
        {
            DataSet tableColumn = SqlDatabaseHelper.GetTableColumn(strTableName, strColumnName);

            return(tableColumn.Tables.Count > 0 && tableColumn.Tables[0].Rows.Count > 0);
        }