how to fetch the data from SQL

Question

Can i fetch data from one controller to in another controller

Puneet Kankar · Answer

Hello Dattatray, You can use given below techniques for the pass data one controller to another, More details go through links. TempData dictionary Session variable Query string parameters http://www.binaryintellect.net/articles/8e64d05b-ab2e-45f6-b7f5-b8a90168915e.aspx https://www.dotnetcurry.com/aspnet-mvc/1074/aspnet-mvc-pass-values-temp-data-session-request

Suraj Kumar · Answer

Yes, you can use Session, TempData or url to transfer data from one controller to another controller.

Sonu Gupta · Answer

Hi, Try This - // Contoller 1 public class MyFirstController : Controller { public ActionResult IndexFirst() { TempData[ "Msg" ] = "Hello This is IndexFirst" ; return new RedirectResult ( @"~\Second\" ); } } // Contoller 2 public class SecondController : Controller { public ActionResult IndexSecond() { return View(); } } // View for second contoller div > @ TempData[ " Msg " ]; div >

Bhuban Magar · Answer

Hi, you can use TempData for fetching data from one contoller to another controller in MVC. Session is also another option for this.

Junaid Shahid · Answer

In c# You have different options. TempData is best option for you, it's dictionary type. Other then this you can user Sessions to maintain your data globally for application scope, you can Also you Application Variable to enhance the scope of your data to access them anywhere in application. You can also you Static variable to access value.

Chittaranjan Swain · Answer

Hi Dattatray, Defer below links, https://www.w3schools.com/sql/sql_select.asp https://www.lifewire.com/introducing-the-select-statement-4091916 https://kb.iu.edu/d/ahux

how to fetch the data from SQL

Answers (6)