MVC

abhi lash

11y1.4kLearn iOS Programming

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

38 Replies

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

Bharath Peggem11y ago

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

abhi lash11y ago
same error Bharath
Bharath Peggem11y ago
try this one
var result = from std in db.Student
where std.id == getid
select new{std.id,std.name};
foreach (Student sted in result)
{
var id = result.Id;
var name = result.name;
}
abhi lash11y ago
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.SID,std.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 = sname,ffname=fname,mmname=mname,ppno=pno,aadd=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 lash11y ago
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.StudentName,std.Father_Name,std.MotherName,std.PhoneNumber,std.Address }; sid = result.SID; sname = result.name; } return Json(new { stdid = sid, stdname = sname }, JsonRequestBehavior.AllowGet); }
Bharath Peggem11y ago
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.id,std.name};

foreach (Student sted in result)

{
var id = result.Id;
var name = result.name;
}
abhi lash11y ago
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 lash11y ago
sid = result.SID; sname = result.StudentName; here i am getting error some Iqueryable error
abhi lash11y ago
sid = result.SID; sname = result.StudentName; here i am getting error some Iqueryable error
Bharath Peggem11y ago
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 lash11y ago
Yes Exactly i want Entity frame work here we should use LINQ Query only
Bharath Peggem11y ago
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 lash11y ago
Bharath here i am using ADO.Net so i need Linq Query please help me
Bharath Peggem11y ago
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 lash11y ago
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")
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 = "SID,StudentName,Father_Name,MotherName,Address,PhoneNumber")] Student student)
{
if (ModelState.IsValid)
{
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(student);
}
abhi lash11y ago
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 Peggem11y ago
what is the exact quation abi. give me a clarity and type that one
abhi lash11y ago
Thanks Bharath after that linq query what should i do in json code
abhi lash11y ago
Thanks Bharath after that linq query what should i do in json code
Bharath Peggem11y ago
like..you want students data linq statement

var data = from s studentdata
where s.id=1
select new {s.id,s.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 lash11y ago
same sql query in linq query
Bharath Peggem11y ago
hi,

plz its helpfull abow code accept the answer
what type of linq u want Mr.abhi..
Bhushan Bhasme11y ago
Linq Query Of What??
abhi lash11y ago
Thanks Bharath can you please send linq query
Bharath Peggem11y ago
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
abhi lash11y ago
Ok Thank You @Bharath i want only next button implementation i did save button
Bharath Peggem11y ago
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 lash11y ago
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 Peggem11y ago
hi,

axactly what you want right now, i thing u want next record code right
abhi lash11y ago
i am using Ado.net @Bharath can you please send me that code
abhi lash11y ago
i am using Ado.net @Bharath can you please send me that code
Bharath Peggem11y ago
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 lash11y ago
Guys Reply Me
abhi lash11y ago
@Manas can you send the code please
abhi lash11y ago
Actually i have save button in edit view there only i want to implement next buton can you help me
abhi lash11y ago
How to get data based on id please send that code i am new to mvc
Bharath Peggem11y ago
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 Mohapatra11y ago
Option 1

View

using (Html.BeginForm("Create", "Home", FormMethod.Post, new { id = "submitForm" }))
{
@Html.TextBoxFor(m => m.Name, new { maxlength = 50 })

}

Controller

public ActionResult Create(YourModel obj,string 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.

MVC

Edit

Student