string StrQuery="SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('dbo.DSSB_APPLICANT_INFO')
if (SqlconTemp.State == ConnectionState.Closed)
SqlconTemp.Open();
OdbcCommand SqlCmdTemp = new OdbcCommand(StrQuery, SqlconTemp);
OdbcDataAdapter SqlDATemp = new OdbcDataAdapter(SqlCmdTemp);
this returns error as sys.column doesnot exist. let me know error
Loading
Posted Jul 29, 2013, 7:21 AM
nishant ranjanPosted Jul 29, 2013, 7:43 AM
Iftikar HussainPosted Jul 29, 2013, 7:23 AM
Try like this
string StrQuery="SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'tbl_name'"
Regards,
Iftikar
Posted Jul 29, 2013, 7:22 AM
http://dev.mysql.com/doc/refman/5.0/en/columns-table.html
nishant ranjanPosted Jul 29, 2013, 7:17 AM
Posted Jul 29, 2013, 7:11 AM
It should be syscolumns. Try with syscolumns instead of sys.columns.