Get maxid for different sub models in Asp.Net

Question

Hi All, I have a doubt on Asp.Net How to get MaxId for different sub-models in Asp.Net. Eg. Models Id SubModels --------------------------------------------------- Model-1 1 Model-1.1 Model-1 2 Model-1.2 Model-1 3 Model-1.3 Model-2 1 Model-2.1 Model-2 2 Model-2.2 Model-2 3 Model-2.3 Model-3 1 Model-3.1 Model-3 2 Model-3.2 Model-3 3 Model-3.3 At here id is maxid it should increment based on models. At here I have models in dropdownlist while selecting the "model-1" it should check in database whether that model is there or not. ---If it's not there the particular model-1 id should be incremented as +1 ---If it's there then the particular model-1 last id it should get and increment with +1 it's same for Model-2, Model-3.. If there's any solution please let me know it..

Sourav Kumar Das · Answer

Here is my answer for the above question.. public void getTypeValue() { DataTable dtbl = new DataTable(); string sQuery = string .Empty; string sError = string .Empty; string sSno = string .Empty; try { sQuery = "SELECT * FROM PMS_ConfigurationMaster WHERE Type ='" +ddlConfigType.SelectedValue.Trim()+ "'" ; objHelper.CreateConnection( "Connect" ); if (objHelper.FillDataTableByQueryString( ref dtbl, ref sError, sQuery) == true ) { if (dtbl.Rows.Count > 0) { getTypeId(); } else { getTypeId(); } } else { Page.Controls.Add( new LiteralControl( " alert('" + sError + "'); " )); return ; } } catch (Exception ex) { Page.Controls.Add( new LiteralControl( " alert('" + ex.Message.Replace( "'" , "" ).Replace( "" , "" ).Replace( "
" , "" ) + "'); " )); return ; } } public void getTypeId() { DataTable dtbl = new DataTable(); string sQuery = string .Empty; string sError = string .Empty; string sSno = string .Empty; try { sQuery = "SELECT ISNULL(MAX(Id), 0)+1 'MaxId' FROM PMS_ConfigurationMaster WHERE Type ='" + ddlConfigType.SelectedValue.Trim() + "'" ; objHelper.CreateConnection( "Connect" ); if (objHelper.FillDataTableByQueryString( ref dtbl, ref sError, sQuery) == true ) { if (dtbl.Rows.Count > 0) { txtTypeId.Text = dtbl.Rows[0][ "MaxId" ].ToString(); } } else { Page.Controls.Add( new LiteralControl( " alert('" + sError + "'); " )); return ; } } catch (Exception ex) { Page.Controls.Add( new LiteralControl( " alert('" + ex.Message.Replace( "'" , "" ).Replace( "" , "" ).Replace( "
" , "" ) + "'); " )); return ; } }

Sourav Kumar Das · Answer

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

Sourav Kumar Das · Answer

Hi, I can't get your answer clearly. Please explain me more clearly... @ Faisal Pathan

Faisal Pathan · Answer

you can do one thing here first sort on Models column and then submodels and increment last digit