sql to excel
i want to bind sql data table names to dropdownlist,when i selected datatable name below in excel sheet the columns of that table has to diaplay ....IN MVC
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pradip PandeyPosted Apr 4, 2014, 7:30 AM
To bind Ssl data table name, use this query
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
It will return all tables of the database.
To display columns of the selected table, use this query
Then export it into excel.
Hope it will help you.
Jignesh TrivediPosted Apr 4, 2014, 3:12 AM
I cannot understand you question.
Can you please provide more information?
Sanjay KumarPosted Apr 3, 2014, 3:31 PM
http://www.c-sharpcorner.com/UploadFile/9c6206/import-data-from-excel-file-to-database-table-in-Asp-Net-mvc/