autogenerated number in a format

===create a cls file and paste these codes===

//here we establish a sql database connection
public clsDataware()
 {
        InitDB();
        sqlCon =new SqlConnection();
      
        sqlCon.ConnectionString = "Data Source=" + DBSource + ";Initial Catalog=" + DBName + ";Integrated Security=True";
        sqlCon.Open();
 }

    private void InitDB()
    {
      
        DBName = "URDatabasename";
        DBSource = "URDBSourcename";
    }
   
//here it create a empty table and assign a table value through marked query

    public  DataTable CreateDatatable(string SqlQuery, string strTable)
    {
        SqlDataAdapter sqlAdapter=new SqlDataAdapter();
        DataTable dt=new DataTable ();
        SqlCommand cmd = new SqlCommand(SqlQuery, sqlCon);
        sqlAdapter.SelectCommand = cmd;
        dt.TableName = strTable;
        sqlAdapter.Fill(dt);
        return dt;
    }

//here we found a maximum id from our table and increment by 1

public long Getcode(string sqlQuery)
    {
        DataTable dt=new DataTable();
        dt = CreateDatatable(sqlQuery,"ID");

        if (!DBNull.Value.Equals(dt.DefaultView[0].Row["id"]))
        {
            return (int.Parse(dt.DefaultView[0].Row["id"].ToString()) + 1);

        }
        else
        {
            return 1;
        }
    }
=== cls ends here===

===paste this code in ur code behind page i.e wr u pin ur insert code===
//here we creating object for class

 private clsDataware mDataware;

long hotelid= mDataware.GetCode("Select max(id) from URTABLENAME")
string autogen="IND-DEL-"+ hotelid +""

Here the 3rd part will be automatically generated.

Hope its helpfull. Post ur comment.