c# Programming Glossary: tblquery
How can I determine whether a column exists in a SQL Server CE table with C#? http://stackoverflow.com/questions/15693639/how-can-i-determine-whether-a-column-exists-in-a-sql-server-ce-table-with-c string tableName string fieldName bool retVal string tblQuery string.Format SELECT 0 FROM 1 fieldName tableName checkConnection.. try SqlCeCommand cmd objCon.CreateCommand cmd.CommandText tblQuery object objvalid cmd.ExecuteScalar retVal null objvalid catch.. string tableName string columnName bool retVal string tblQuery string.Format COL_LENGTH 0 1 IS NULL tableName columnName checkConnection..
|
