public ActionResult Ad_Seach_Prac(FormCollection formdata) { using (var Context = new ddc_login2Entities()) { Binddropdowndata(); //var data= Context.search_pract("", "", "", "", "1351").ToList(); var data = Context.search_pract(Convert.ToString(formdata["fname"]), Convert.ToString(formdata["lname"]), Convert.ToString(formdata["RegistrationNumber"]), Convert.ToString(formdata["Residential"]), Convert.ToString(formdata["ProfessionalCity"])).ToList(); return(View(data)); } }
public ActionResult Getexcelreport(FormCollection formdata) { Binddropdowndata(); using (var Context = new ddc_login2Entities()) { //var data= Context.search_pract("", "", "", "", "1351").ToList(); var data = Context.search_pract(Convert.ToString(formdata["fname"]), Convert.ToString(formdata["lname"]), Convert.ToString(formdata["RegistrationNumber"]), Convert.ToString(formdata["Residential"]), Convert.ToString(formdata["ProfessionalCity"])).ToList(); var gv = new GridView(); gv.DataSource = data;//this.GetEmployeeList(); gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls"); Response.ContentType = "application/ms-excel"; Response.Charset = ""; StringWriter objStringWriter = new StringWriter(); HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter); gv.RenderControl(objHtmlTextWriter); Response.Output.Write(objStringWriter.ToString()); Response.Flush(); Response.End(); return(View("Ad_Seach_Prac")); } }