sql to excel

Question

i want to bind sql data table names to dropdownlistwhen i selected datatable name below in excel sheet the columns of that table has to diaplay ....IN MVC

Pradip Pandey · Answer

Hi 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 select column_name from information_schema.columns where table_name = ' ' Then export it into excel. Hope it will help you.

Jignesh Trivedi · Answer

hi I cannot understand you question. Can you please provide more information?

Sanjay Kumar · Answer

Hi http://www.c-sharpcorner.com/UploadFile/9c6206/import-data-from-excel-file-to-database-table-in-Asp-Net-mvc/