Hi,
> You may want to check out sqlalchemy they provide a pretty good documentation > on what you are aftering For my understanding, why are you suggesting to use SQLAlchemy while Django provides an ORM out of the box ? SQLAlchemy is required for frameworks such as Flask, which do nothing with respect to the data layer, but it's not clear which benefit it could bring here. Best regards Eric ________________________________ From: django-users@googlegroups.com <django-users@googlegroups.com> on behalf of sum abiut <suab...@gmail.com> Sent: Monday, February 12, 2018 10:24:07 PM To: django-users@googlegroups.com Subject: Re: How to fetch data from sql server and display on django web pages You may want to check out sqlalchemy they provide a pretty good documentation on what you are aftering http://docs.sqlalchemy.org/en/latest/dialects/mssql.html >From you view you can defile a function like so. view.py from sqlalchemy import* from django.shortcuts import render def connectto_db(request): engine=create_engine('mssql+pymssql://username:password@servername /Ddabname') connection=engine.connect() metadata=MetaData() table=Table('tablename',metadata,autoload=True,autoload_with=engine) stmt='SELECT * FROM table' results=connection.execute(stmt).fetchall() return render(request,'template.html',locals()) then you can pass the results to your template.html Hope this helps. Cheers On Sun, Feb 11, 2018 at 4:37 PM, Amit Kadivar <amit.kadiv...@gmail.com<mailto:amit.kadiv...@gmail.com>> wrote: Please Help me. How to fetch data from sql server and display them on django web pages through nginx web server.. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>. To post to this group, send email to django-users@googlegroups.com<mailto:django-users@googlegroups.com>. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com<https://groups.google.com/d/msgid/django-users/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>. To post to this group, send email to django-users@googlegroups.com<mailto:django-users@googlegroups.com>. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5CZ-HAUSbGkTWKe23CfuCMWozoLqL85V52924NpDwd-A%40mail.gmail.com<https://groups.google.com/d/msgid/django-users/CAPCf-y5CZ-HAUSbGkTWKe23CfuCMWozoLqL85V52924NpDwd-A%40mail.gmail.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/AM5P193MB008317CB26D147DD042FD98A8CF70%40AM5P193MB0083.EURP193.PROD.OUTLOOK.COM. For more options, visit https://groups.google.com/d/optout.
