Get Maximum Value of maxid from database in MVC

Sourav Kumar Das

7y5.9k.NET

How to get maximum value of 'max id' from database in Asp.Net MVC?

Sample Reference Code:

In Controller:

public ActionResult getClientId()
{
ClientMaster objCliMas = new ClientMaster();
DataSet ds = new DataSet();
string sQuery = " SELECT ISNULL(MAX(ClientId), 0)+1 'MaxClientId' FROM PMS_ClientMaster ";
SqlDataAdapter da = new SqlDataAdapter(sQuery, con);
con.Open();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
objCliMas.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["MaxClientId"].ToString());
}
return View(objCliMas);
}

In View:

@Html.EditorFor(model => model.Id, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Id, "", new { @class = "text-danger" })

At here in the view it's not displaying the maxid value.

If there's any solution please let me know it.

4 Replies

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

Sourav Kumar Das7y ago
Please give me some more sample in receiving the id value.

@ Salman Beg
Salman Beg7y ago
Hi. If you are getting the max value then it should display those value in view. If that is the case then you need to check in View. Thanks
Sourav Kumar Das7y ago
Hi,
I am getting the value of it.
objCliMas.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["MaxClientId"].ToString());
@Salman Beg
Salman Beg7y ago
Hi.
First of all, you check in this line objCliMas.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["MaxClientId"].ToString()); whether you are getting data or not.
Thanks.