tag:blogger.com,1999:blog-6082652835152798567.post3175229649994040430..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Part 62 - Implementing search functionality in asp.net mvcUnknownnoreply@blogger.comBlogger10125tag:blogger.com,1999:blog-6082652835152798567.post-83285553143850314252019-06-03T09:20:31.265-07:002019-06-03T09:20:31.265-07:00public ActionResult Index(string searchBy, string ... public ActionResult Index(string searchBy, string search)<br /> {<br /><br /> if (searchBy == "Gender")<br /> {<br /> var _model = (_db.Gender(search));<br /> return View(_model);<br /> }<br /> else<br /> {<br /> var _model = (_db.StartsWith(search));<br /> return View(_model);<br /> }<br /><br /> }<br /><br /><br />ServiceEmployee<br /><br /> internal object StartsWith(string search)<br /> {<br /> using (var db = new BlogContext())<br /> {<br /> return db.Employee.Where(x => x.Name.StartsWith(search) || search == null).ToList();<br /> }<br /> }<br /><br /> internal object Gender(string search)<br /> {<br /> using (var db = new BlogContext())<br /> {<br /> return db.Employee.Where(x => x.Gender == search || search == null).ToList();<br /> }<br /> }<br /><br /><br />DbContext<br /><br />//executar Package Manager Console --> Update-Database -verbose<br /><br /> public PROYEC_Context() :base("DATABASESQL")<br /> {<br /><br /> }<br /><br />public DbSet Employee { get; set; }<br /><br /><br />come on !! dry ....<br /><br />fernando yeveneshttps://www.blogger.com/profile/13957708453457100494noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-41381926578005000832019-04-26T14:21:21.503-07:002019-04-26T14:21:21.503-07:00when to use form tag in mvc razor view
and when no...when to use form tag in mvc razor view<br />and when not necessary to use form tagtesthttps://www.blogger.com/profile/01505477560048064269noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-71362791913660760442018-07-03T09:40:13.618-07:002018-07-03T09:40:13.618-07:00Hi, thanks for this video. I want to do a slight v...Hi, thanks for this video. I want to do a slight variation. I have a large table of "store locations" and I want the user to search by city. I'd like to display ONLY the text box and Search button on page load, so that the user does not see locations from other cities. When he enters the city name in the text box, I'd like the "Search" button to call my stored proc to load the table based on the Search Term, like "Denver" or "Memphis" etc. [I actually have a ZipCode table that pulls all locs by city/metro area]<br />My question: should the "Search" button redirect to another view, call a partial view, etc? Do you have a video that can help me with that type of action/response?<br />Thanks again!Reid Corcoran, Jr.https://www.blogger.com/profile/00581963314374668801noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-51759856285157220572016-06-02T22:48:21.512-07:002016-06-02T22:48:21.512-07:00Venkat Sir, I want to implement just like a Make M...Venkat Sir, I want to implement just like a Make My Trip Search function pls help me Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-87272366241386161552015-03-29T22:19:53.279-07:002015-03-29T22:19:53.279-07:00how can we search with all 3 parameters "Name...how can we search with all 3 parameters "Name", "Gender", "email". ramhttps://www.blogger.com/profile/15755990028749964165noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-78592477439514652922014-07-07T02:49:49.333-07:002014-07-07T02:49:49.333-07:00How to Search Based On ID Sir
Please Help meHow to Search Based On ID Sir<br />Please Help meAnonymoushttps://www.blogger.com/profile/10038426174068108961noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-18879672849073039152013-10-07T06:07:59.397-07:002013-10-07T06:07:59.397-07:00Actually what i am doing here is,
I want search f...Actually what i am doing here is,<br /><br />I want search functionality in MVC4 with database<br /><br />Tagno-----int<br /><br />StockNo----Varchar in my database<br /><br />I want to search data from database using Tagno or StokeNo <br />CONTROLLER:<br />public ActionResult Sss(string searchBy,int search)<br /> {<br /> if (searchBy == "Gender")<br /> return View(db.ProductsHondaofConyers.Where(x => x.TagNo == search || search == null).ToList());<br /> else<br /> return View(db.ProductsHondaofConyers.Where(x => x.StockNo.StartsWith(search) || search == null).ToList());<br />}<br /><br />Helphttps://www.blogger.com/profile/15960854165055348594noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-30401172743128944572013-09-19T05:33:33.721-07:002013-09-19T05:33:33.721-07:00Sir i am Fresher Guy and currently i am working in...Sir i am Fresher Guy and currently i am working in MVC its only because of u sir......<br />i have never seen such kind of MVC videos before sir...<br />Thank u very much...gr8 work sir keep it up..<br />Maheshhttps://www.blogger.com/profile/03884687575319171079noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-79664602759773293522013-09-09T12:23:47.917-07:002013-09-09T12:23:47.917-07:00I got the answer from your tutorial. Thank you.I got the answer from your tutorial. Thank you.MVShttps://www.blogger.com/profile/09105269977539218145noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-76377948501957144762013-09-08T09:54:19.435-07:002013-09-08T09:54:19.435-07:00Hello Venkat.
Your videos are awesome.
I have a q...Hello Venkat. <br />Your videos are awesome.<br />I have a question. In your above example you are searching with name or gender. Instead of that how can we search with all 3 parameters "Name", "Gender", "email". And if I know only 1 parameter out of three and how can we search by leaving other two parameters empty.<br /><br />Thank you in advance.<br /><br />Regards,<br />MVS.MVShttps://www.blogger.com/profile/09105269977539218145noreply@blogger.com