public List <ClsDBTablesAttributes> GetAllTablesNPrimaryColumns(string tblName) { DbWrapper objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); DataSet ds = new DataSet(); List <ClsDBTablesAttributes> _objListClsDBTablesAttributes = new List <ClsDBTablesAttributes>(); objDataWrapper.AddParameter("@tblName", tblName); ds = objDataWrapper.ExecuteDataSet("Aj_Proc_GetAllTables"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ClsDBTablesAttributes _objClsDBTablesAttributes = new ClsDBTablesAttributes(); _objClsDBTablesAttributes.PropTABLENAME = ds.Tables[0].Rows[i]["TABLE_NAME"].ToString(); _objClsDBTablesAttributes.PropPK_COLUMNNAME = ds.Tables[0].Rows[i]["COLUMN_NAME"].ToString(); _objListClsDBTablesAttributes.Add(_objClsDBTablesAttributes); } return(_objListClsDBTablesAttributes); }
public List <ClsDBTablesAttributes> GetAllColumnsOfTable(string _strTableName, string AutoIncrementedColumnName) { DbWrapper objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); DataSet ds = new DataSet(); List <ClsDBTablesAttributes> _objListClsDBTables = new List <ClsDBTablesAttributes>(); objDataWrapper.AddParameter("@TableName", _strTableName); objDataWrapper.AddParameter("@AutoIncrementedColumnName", AutoIncrementedColumnName); ds = objDataWrapper.ExecuteDataSet("Aj_Proc_GetColumnsOfTable"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ClsDBTablesAttributes _objClsDBTablesAttributes = new ClsDBTablesAttributes(); _objClsDBTablesAttributes.PropColumnName = ds.Tables[0].Rows[i]["column_name"].ToString(); _objClsDBTablesAttributes.PropDataType = ds.Tables[0].Rows[i]["data_type"].ToString(); _objClsDBTablesAttributes.PropColumnDTCharLength = ds.Tables[0].Rows[i]["charLength"].ToString(); _objListClsDBTables.Add(_objClsDBTablesAttributes); } return(_objListClsDBTables); }