MVC

Question

Hi Guys In my view there is Four text box SID StudentName Address PhoneNumber I should implement Two Buttons 1)Save 2)Next Buttons If i click Save the record should be updated If I click Next Button It should fetch next record from database and should be displayed How to implement this Can anyone help me in code Please

Bharath Peggem · Answer

ohh same error ok.. am not unable to test in my system. See this example and try that ok var query = ( from c in ctx . Cities join s in ctx . States on c . StateId equals s . StateId where c . Pincode == iPincode select new { s . StateName  c . CityName  c . Area }). First (). SingleOrDefault (); if ( query != null ) { cboState . SelectedItem . Text = query . State ; cboCity . SelectedItem . Text = query . CityName ; txtArea . Text = query . Area ; } but it is currect abhi try that one it get out will meet tomorrow

Bharath Peggem · Answer

Hi abhi Try this one. Jquery function :- $(#nextbtn).click(function() { var stdnextid = $(#stid).val(); if(stdnextid == '') { stdnextid = 1; } $.getJSON('/Home/getnextrecord?id=' + stdnextid  function (result) { $(#stid).val(result.sid); $(#stname).val(result.sname); }); }); public JsonResult Nextstudent(int id) { var sID = null; var sname = null; using (SqlConnection connection = new SqlConnection(Data Source=(local);Initial Catalog=databasename;Integrated Security=SSPI)) using (SqlCommand cmd = new SqlCommand(SELECT ID  FirstName FROM studentdata WHERE id=id connection)) { connection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Check is the reader has any rows at all before starting to read. if (reader.HasRows) { // Read advances to the next row. while (reader.Read()) { // To avoid unexpected bugs access columns by name. sID = reader.GetInt32(reader.GetOrdinal(ID)); sname = reader.GetString(reader.GetOrdinal(FirstName)); } } } } return Json(new { sid = sID sname = sname } JsonRequestBehavior.AllowGet); } if it is usefull accept my answer

Bharath Peggem · Answer

Hi Abhilash you can use jquery function its comfort for use. Id : Name : in jquery function : $(#savebtn ).click(function(){ $.ajax({ url : '/Home/save' method: POST data: $('# myform ').serialize()  success: function (data) { if (data.data.length > 0) { if (data.data[0] > 0) { msg = Data Stored Successfully  ; result = 1; } else { msg = Data Not Stored Successfully  ; result = 0; } }); }); In controller write save operation : public JsonResult save(student smodel) { // write the save code and get one resulte value return json(new { data= // write your output resultvalue }JsonRequestBehavior.AllowGet);) } Same as write Next student data feach : $(#nextbtn ).click(function(){ var stdnextid = $(# txtsid ).val() + 1; $.getJSON('/Home/getnextrecord?id=' + stdnextid  function (result) { $(# txtsid ).val(result.id); $(# txtsname ).val(result.name); }); In controller write down the next operation : public JsonResult Nextstudent(int id) { // get the data from data base based on the id and put the data in list var getstdModel = new student // this is the model var list = getdata.tolist(); return Json(new { sid = list.id sname = list.name } JsonRequestBehavior.AllowGet); } Thats it fine.. Happy codeing if it is helpfull please accept my answer.

Manas Mohapatra · Answer

Option 1 View using (Html.BeginForm(Create Home FormMethod.Post new { id = submitForm })) { @Html.TextBoxFor(m => m.Name new { maxlength = 50 }) Save Next } Controller public ActionResult Create(YourModel objstring command) { //from here you can get the value of button you click if(command=Save) { // Update your Data } else if(command==Next) { // Fetch next records } return View(); } Option 2: Send different ajax request and update your view page. Means you need to send one ajax request to server to update and for Next button you need to fetch data and bind it to UI.

abhi lash · Answer

same error Bharath

Bharath Peggem · Answer

try this one var result = from std in db.Student where std.id == getid select new{std.idstd.name}; foreach (Student sted in result) { var id = result.Id; var name = result.name; }

abhi lash · Answer

public JsonResult getnextrecord(int getid) { var sid = ; var sname = ; var fname = ; var mname = ; var pno=; var add = ; if (ModelState.IsValid) { var result = from std in db.Students where std.SID == getid select new { std.SIDstd.Father_Name std.StudentName std.MotherName std.PhoneNumber std.Address }; sid = result.SID; sname = result.StudentName; fname= result.Father_Name; mname = result.MotherName; pno = result.PhoneNumber; add = result.Address; } return Json(new { stdid = sid stdname = snameffname=fnamemmname=mnameppno=pnoaadd=add } JsonRequestBehavior.AllowGet); } There is error like Severity Code Description Project File Line Error CS1061 'IQueryable >' does not contain a definition for 'SID' and no extension method 'SID' accepting a first argument of type 'IQueryable >' could be found (are you missing a using directive or an assembly reference?) StudentNext C:\Users\abhil_000\Documents\Visual Studio 2015\Projects\StudentNext\StudentNext\Controllers\StudentsController.cs 147

abhi lash · Answer

public JsonResult getnextrecord(int getid) { var sid = ; var sname = ; if (ModelState.IsValid) { var result = from std in db.Students where std.SID == getid select new { std.SID std.StudentNamestd.Father_Namestd.MotherNamestd.PhoneNumberstd.Address }; sid = result.SID; sname = result.name; } return Json(new { stdid = sid stdname = sname } JsonRequestBehavior.AllowGet); }

Bharath Peggem · Answer

Hi No no abhi am just am using result.sid but data faching to result its conform ok ok try this one var result = from std in db.Student where std.id == getid select new{std.idstd.name}; foreach ( Student sted in result) { var id = result.Id; var name = result.name; }

abhi lash · Answer

Severity Code Description Project File Line Error CS1061 'IQueryable >' does not contain a definition for 'SID' and no extension method 'SID' accepting a first argument of type 'IQueryable >' could be found (are you missing a using directive or an assembly reference?) StudentNext C:\Users\abhil_000\Documents\Visual Studio 2015\Projects\StudentNext\StudentNext\Controllers\StudentsController.cs 144

abhi lash · Answer

sid = result.SID; sname = result.StudentName; here i am getting error some Iqueryable error

abhi lash · Answer

sid = result.SID; sname = result.StudentName; here i am getting error some Iqueryable error

Bharath Peggem · Answer

Good abhi thats it. try this one. public JsonResult getnextrecord(int getid) { var sid = ; var sname = ; if(ModelState.IsValid) { var result = from std in db.student where std.id = getid select new { std.id std name }; sid = result.id; sname = result.name; } return Json(new { stdid =sid stdname=sname } JsonRequestBehavior.AllowGet); }

abhi lash · Answer

Yes Exactly i want Entity frame work here we should use LINQ Query only

Bharath Peggem · Answer

hi are you using Entiry framwork. so in that entity framwork you get db.student in that db.student you want linq statement based on the db.student is it right. and next record also you want

abhi lash · Answer

Bharath here i am using ADO.Net so i need Linq Query please help me

Bharath Peggem · Answer

hi i understood your problem in your code what is the exact problem u have rised. and where you struck the place i copyed u r code and i tested. tell me u where u r struck. $(#nextbtn).click(function () { var stdnextid = $(#sid).val() + 1; $.getJSON('/Home/ getnextrecord ?id=' + stdnextid function (result) { $(#sid ).val(result.id); $(#sname ).val(result.name); $(#fname ).val(result.name); $(#mname ).val(result.name); $(#add ).val(result.name); $(#pno ).val(result.name); }); }); Note : your missing getnextrecord where is the controller. see the my posts and follow that one write down the code in controller ok public JsonResult getnextrecord (int id) { var sID = null; var sname = null; using (SqlConnection connection = new SqlConnection(Data Source=(local);Initial Catalog=databasename;Integrated Security=SSPI)) using (SqlCommand cmd = new SqlCommand(SELECT ID  FirstName FROM studentdata WHERE id=id connection)) { connection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Check is the reader has any rows at all before starting to read. if (reader.HasRows) { // Read advances to the next row. while (reader.Read()) { // To avoid unexpected bugs access columns by name. sID = reader.GetInt32(reader.GetOrdinal(ID)); sname = reader.GetString(reader.GetOrdinal(FirstName)); } } } } return Json(new { sid = sID sname = sname } JsonRequestBehavior.AllowGet); }

abhi lash · Answer

Edit View @model StudentNext.Models.Student @{ ViewBag.Title = Edit; } Edit @using (Html.BeginForm()) { @Html.AntiForgeryToken() Student @Html.ValidationSummary(true  new { @class = text-danger }) @Html.HiddenFor(model => model.SID) @Html.LabelFor(model => model.SID htmlAttributes: new { @class = control-label col-md-2 }) @Html.EditorFor(model => model.SID new { htmlAttributes = new { @class = form-control@id=sid } }) @Html.ValidationMessageFor(model => model.SID  new { @class = text-danger }) @Html.LabelFor(model => model.StudentName htmlAttributes: new { @class = control-label col-md-2 }) @Html.EditorFor(model => model.StudentName new { htmlAttributes = new { @class = form-control@id = sname } }) @Html.ValidationMessageFor(model => model.StudentName  new { @class = text-danger }) @Html.LabelFor(model => model.Father_Name htmlAttributes: new { @class = control-label col-md-2 }) @Html.EditorFor(model => model.Father_Name new { htmlAttributes = new { @class = form-control @id = fname } }) @Html.ValidationMessageFor(model => model.Father_Name  new { @class = text-danger }) @Html.LabelFor(model => model.MotherName htmlAttributes: new { @class = control-label col-md-2 }) @Html.EditorFor(model => model.MotherName new { htmlAttributes = new { @class = form-control @id = mname } }) @Html.ValidationMessageFor(model => model.MotherName  new { @class = text-danger }) @Html.LabelFor(model => model.Address htmlAttributes: new { @class = control-label col-md-2 }) @Html.EditorFor(model => model.Address new { htmlAttributes = new { @class = form-control @id = add } }) @Html.ValidationMessageFor(model => model.Address  new { @class = text-danger }) @Html.LabelFor(model => model.PhoneNumber htmlAttributes: new { @class = control-label col-md-2 }) @Html.EditorFor(model => model.PhoneNumber new { htmlAttributes = new { @class = form-control @id = pno } }) @Html.ValidationMessageFor(model => model.PhoneNumber  new { @class = text-danger }) } @Html.ActionLink(Back to List Index) $(#nextbtn).click(function () { var stdnextid = $(#sid).val() + 1; $.getJSON('/Home/getnextrecord?id=' + stdnextid function (result) { $(#sid ).val(result.id); $(#sname ).val(result.name); $(#fname ).val(result.name); $(#mname ).val(result.name); $(#add ).val(result.name); $(#pno ).val(result.name); }); }); My Edit Controler // GET: Students/Edit/5 public ActionResult Edit(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Student student = db.Students.Find(id); if (student == null) { return HttpNotFound(); } return View(student); } // POST: Students/Edit/5 // To protect from overposting attacks please enable the specific properties you want to bind to for // more details see http://go.microsoft.com/fwlink/?LinkId=317598. [HttpPost] [ValidateAntiForgeryToken] public ActionResult Edit([Bind(Include = SIDStudentNameFather_NameMotherNameAddressPhoneNumber)] Student student) { if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction(Index); } return View(student); }

abhi lash · Answer

Soory Bharath now i will tell my requirement; i have Four coloumns in database 1) SID Identity 2)Studentname 3)Address 4)PhoneNumber these are there in my database I created my Edit view in that i have save button also so now i want next button in the same view how to do that please help me

Bharath Peggem · Answer

what is the exact quation abi. give me a clarity and type that one

abhi lash · Answer

Thanks Bharath after that linq query what should i do in json code

abhi lash · Answer

Thanks Bharath after that linq query what should i do in json code

Bharath Peggem · Answer

like..you want students data linq statement var data = from s studentdata where s.id=1 select new {s.ids.name} ; see the below link it is usefull : https://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b http://www.codeproject.com/Articles/19154/Understanding-LINQ-C

abhi lash · Answer

same sql query in linq query

Bharath Peggem · Answer

hi plz its helpfull abow code accept the answer what type of linq u want Mr.abhi..

Bhushan Bhasme · Answer

Linq Query Of What??

abhi lash · Answer

Thanks Bharath can you please send linq query

abhi lash · Answer

Ok Thank You @Bharath i want only next button implementation i did save button

Bharath Peggem · Answer

Good abhi..then i will give you clarity and code ok right now there is no code but i will give you . dont worry ask me feel free

abhi lash · Answer

i want to implement next button in edit view if i click next button it should fetch next record details and display in same fields

Bharath Peggem · Answer

hi axactly what you want right now i thing u want next record code right

abhi lash · Answer

i am using Ado.net @Bharath can you please send me that code

abhi lash · Answer

i am using Ado.net @Bharath can you please send me that code

Bharath Peggem · Answer

readonly string connSTR = ConfigurationManager.ConnectionStrings[DBconn].ToString(); public JsonResult Nextstudent(int id) { var dbmgr = new DBManagerWeb(connSTR); DataSet matadata; using (var command = (SqlCommand)dbmgr.GetCommandObj()) //use your command coding format { command.CommandText = getstddataSotreproc; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(@Id SqlDbType.Int).Value = id; // pass the id value from our text box matadata = dbmgr.ExecuteQryStoredProc(); } in this matadata dataset next it is convert to list. Note : dataset not converted direct list using convertion code. see the link : http://stackoverflow.com/questions/17107220/convert-dataset-to-list var list = matadata.tolist(); return Json(new { sid = list.id sname = list.name } JsonRequestBehavior.AllowGet); }

abhi lash · Answer

Guys Reply Me

abhi lash · Answer

@Manas can you send the code please

abhi lash · Answer

Actually i have save button in edit view there only i want to implement next buton can you help me

abhi lash · Answer

How to get data based on id please send that code i am new to mvc