How to separate int and string values in a table?

Question

Hi,

     I have a  table named Itemdetails. There is a column named ItemCode it is initialised as varchar(50). So I entered both int and string values to the column. Now I need to use auto increment operation for the integer values in the column. So I need to get  max(ItemCode)+1 value. For that I need to seperate string and int values. 

Thanks 

Answer 1

As of now in Controller's Action method I am using the code below to set no of records per page

 

return View(viewModel.ToList().ToPagedList(page ?? 1, 50)); 

Answer 2

How you are getting data from Controller's action: AJAX or direct call to action.

 

Provide some code snippet.