public Tablemodel columntypewriter(string tablename, string dbname, string connectionstring) { _dbname = dbname; _tableName = tablename; _conStr = connectionstring; Tablemodel datamodel = new Tablemodel(); datamodel.tablename = tablename; IEnumerable <Tablemodel> col = GetColumnNames(); return(datamodel); }
private List <Tablemodel> GetColumnNames() { List <Tablemodel> model = new List <Tablemodel>(); using (SqlConnection connection = new SqlConnection(_conStr)) { connection.Open(); SqlCommand command = new SqlCommand("use " + _dbname + ";" + "select top 1 * from " + _tableName, connection); SqlDataReader reader = command.ExecuteReader(); int i = 0; while (reader.Read()) { Tablemodel data = new Tablemodel(); data.tablename = _tableName; data.Columnname = reader.GetName(i); data.Datatype = reader.GetFieldType(i); i++; model.Add(data); } } return(model); }