title: How to fetch data from database and show in table in kivy+python
body: <h2>list.py</h2>
  <pre><code>import kivy
  
  kivy.require('1.9.0')  # replace with your current kivy version !
  import sqlite3 as lite
  from kivy.uix.screenmanager import Screen
  from kivy.app import App
  from kivy.lang import Builder
  from kivy.uix.boxlayout import BoxLayout
  from kivy.core.window import Window
  
  Window.clearcolor = (0, 0.517, 0.705, 1)
  
  Window.size = (500, 330)
  from easygui import msgbox
  
  
  con = lite.connect('demo.db')
  con.text_factory = str
  cur = con.cursor()
  
  class TestScreen(Screen):
      pass
  
      def get_user(self):
  
          cur.execute(&quot;SELECT * FROM `user` order by id asc&quot;)
          self.rows = cur.fetchall()
  
          print(self.rows)
  
  class List(App):
      def build(self):
          self.root = Builder.load_file('list.kv')
          return TestScreen().get_user()
  
  
  
  if __name__ == '__main__':
      List().run()
  </code></pre>
  <p>above code fetch result but i dont know how to list like table</p>
  <p>How to retrieve data from database and list in table like</p>
  <p>id  Name<br/>
  1   abc<br/>
  2   def<br/></p>
  <p>When click on row then it show in new window contain text type with edit value.</p>
  <p>Thanks in advance</p>