how to show data base data in grid in mvc ?

Anjali Khan

9y825.NET

hi frnds

I created Registration form and save the data in oracle data base .

now i want db data show to gridview or table in mvc?

so how to do this and want to show that grid or table on another view.

here m not using entity framework .

so how to do this ?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anjali Khan9y ago
yes i want to use entity framework.
but here linq problem is getting so here i used procedure
0
Abhilash J A9y ago
Hi,

Okay!

Please look up on it...

http://www.c-sharpcorner.com/uploadfile/mahesh/working-with-oracle-databases-using-ado-net/

http://www.aspsnippets.com/Articles/ASPNet-MVC-ADONet-Tutorial-with-example.aspx

Why don't you use Entity Framework? If you can please refer this also...

https://code.msdn.microsoft.com/windowsdesktop/AspNet-Mvc4-with-Entity-bf84ecbe
+1
Anjali Khan9y ago
hi Abhilash
i want to like this
i have a oracle database with tables.now i want that data display in table or gridview.
how to do this ?
note - here dont want to use entity framework
+1
Abhilash J A9y ago
Hi Anjali,

You can use ADO.NET approach.

Step1) Create stored procedure as select query
Step2) Open
OracleConnection con = new OracleConnection();
, then use OracleCommand, class etc... after using Datatable you can get all data in it. Then bind the data in your data model object as inside View.
Thanks,
Abhilash J A
+1