Get maxid for different sub models in Asp.Net

Sourav Kumar Das

7y728.NET

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..

4 Replies

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

Sourav Kumar Das7y ago
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(""));
                return;
            }
        }
        catch (Exception ex)
        {
            Page.Controls.Add(new LiteralControl(""));
            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(""));
                return;
            }
        }
        catch (Exception ex)
        {
            Page.Controls.Add(new LiteralControl(""));
            return;
        }
    }
Sourav Kumar Das7y ago
Hi,

If there's any solution for please let me know it.
Sourav Kumar Das7y ago
Hi,
I can't get your answer clearly.
Please explain me more clearly...

@ Faisal Pathan
Faisal Pathan7y ago
you can do one thing here first sort on Models column and then submodels and increment last digit